deze heb ik gedaan
CREATE TABLE `phpbb_whosonline_ranks` (
`whosonline_rank_id` tinyint(4) NOT NULL auto_increment,
`whosonline_rank_name` varchar(50) NOT NULL default '',
`whosonline_rank_color` varchar(9) NOT NULL default '',
`whosonline_lang_key` smallint(1) unsigned NOT NULL default '0',
`whosonline_rank_order` int(11) NOT NULL default '0',
PRIMARY KEY (`whosonline_rank_id`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;
#
#-----[ SQL ]------------------------------------------
#
INSERT INTO `phpbb_whosonline_ranks` VALUES (1, 'Test', 'red', 0, 10);
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_users ADD user_whosonline_color int(11) DEFAULT '0' NOT NULL;
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE `phpbb_groups` ADD `group_color` smallint(8) DEFAULT '0' NOT NULL ;
#
#-----[ SQL ]------------------------------------------
#
INSERT INTO `phpbb_config` VALUES ('allow_group_index', '0');
en de rest heb ik gedaan zoals het moest
