mySql problem

[ollie]

i used phpbb on some forums i set up for me and my mates to use, however, whilst trying to do something, ive dropped the wrong table from mySql database, the table i dropped was 'phpbb_banlist" And now no-one can view the forums, you just get this when you go on it:

phpBB : Critical Error

Could not obtain ban information

DEBUG MODE

SQL Error : 1146 Table 't0dger_net_1.phpbb_banlist' doesn't exist

SELECT ban_ip, ban_userid, ban_email FROM phpbb_banlist WHERE ban_ip IN ('acc92f9d', 'acc92fff', 'acc9ffff', 'acffffff') OR ban_userid = -1

Line : 160
File : sessions.php

How do i re-add the table without messing up other stuff, i know you can import the full *.sql file like you do when you first install it, but wont that reset all the data in the current tables?

Thanks in advance for any help

 

[ollie]

oh, and i know next to nothing about mysql

 

[Nightfire]

Here ya go

CREATE TABLE `phpbb_banlist` (
  `ban_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ban_userid` mediumint(8) NOT NULL default '0',
  `ban_ip` varchar(8) NOT NULL default '',
  `ban_email` varchar(255) default NULL,
  PRIMARY KEY  (`ban_id`),
  KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

 

[ollie]

yay, thanks a lot mate, legend