[Lynne]

Originally Posted by honcho

ok tnahx guys but i think i need someone to help me do this as im pretty lost on these last 2 posts

im ok @ installintg mods ec6te ct but tyhe whole other stuff im lost unfort

You want to go to your Admin CP > Maintenance > Execute SQL Query and input the query in the code box below into the Manual Query field on that page and hit Continue. If you get No Permission, then you will need to go into your config.php file and find the line about which users have permission to perform mysql queries and add your userid into that line. Save/upload, go back and try again.

Originally Posted by Carnage-

To recreate the userlist table:

CREATE TABLE IF NOT EXISTS `phpbb_userlist` (
  `userid` int(10) unsigned NOT NULL default '0',
  `relationid` int(10) unsigned NOT NULL default '0',
  `type` enum('buddy','ignore') NOT NULL default 'buddy',
  `friend` enum('yes','no','pending','denied') NOT NULL default 'no',
  PRIMARY KEY  (`userid`,`relationid`,`type`),
  KEY `userid` (`relationid`),
  KEY `relationid` (`relationid`,`type`,`friend`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;