phpBB Forum Mod Installation help!

[Zac3010]

Could someone please help me install this phpBB forum modification: http://forum.phpbb.biz/download.php?id=23948

I'm having problems creating a table for this rank (I have no idea what it means). Anyway, the download is only 9.78 KB, and it only takes 10 min's to install if you know how. Plz help! Thanks for your time!

(IM Me at Zac3010)

[mairving]

Are you running MySQL?

If so, then it would be pretty easy to do so at the mysql prompt like so:
mysql> CREATE TABLE phpbb_whosonline_ranks
(whosonline_rank_id tinyint(4) NOT NULL auto_increment primary key,
whosonline_rank_name varchar(50) NOT NULL default '',
whosonline_rank_color varchar(8) NOT NULL default '');

mysql> ALTER TABLE phpbb_users ADD user_whosonline_color int(11) DEFAULT '0' NOT NULL;


mysql> ALTER TABLE phpbb_groups ADD column group_color VARCHAR( 9 ) DEFAULT '0' NOT NULL ;

mysql> INSERT INTO phpbb_config VALUES ('allow_group_index', '0');

So 4 separate SQL statements. You could also do it in a similar way using PHPMyAdmin.

[MSIuser]

just a little thing to add here incase you arent running the mysql server locally, if your hosting provider offers phpmyadmin, you can just copy and paste those lines (from just after the mysql>) into the mysql query box.