Toplisten install Problem

[fragz]

Grüße!

Habe meinem Bruder soeben den Toplisten Mod in sein Forum eingebaut!
Sobald ich aber die install.php ausführe bekomme ich folgende Meldung:

Running :: CREATE TABLE phpbb_toplist (id int(255) NOT NULL auto_increment, nam varchar(255) NOT NULL default, inf varchar(255) NOT NULL default, hin int(255) NOT NULL default '0', lin varchar(255) NOT NULL default, out int(255) NOT NULL default '0', img int(255) NOT NULL default '0', ban varchar(255) NOT NULL default 'http://', owner int(255) NOT NULL default '0', tot int(255) NOT NULL default '0', imgfile varchar(50) NOT NULL default 'button1', PRIMARY KEY (id)) TYPE=MyISAM -> FAILED ---> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' inf varchar(255) NOT NULL default, hin int(255) NOT NULL default '0', lin varch' at line 1

Nutze php4 und mysql5

Hier mal der besagte abschnitt

Code: Alles auswählen

$sql_array[] = "CREATE TABLE " . TOPLIST_TABLE . " (id int(255) NOT NULL auto_increment, nam varchar(255) NOT NULL default '', inf varchar(255) NOT NULL default '', " . HIN . " int(255) NOT NULL default '0', lin varchar(255) NOT NULL default '', " . OUT . " int(255) NOT NULL default '0', " . IMG . " int(255) NOT NULL default '0', ban varchar(255) NOT NULL default 'http://', owner int(255) NOT NULL default '0', tot int(255) NOT NULL default '0', imgfile varchar(50) NOT NULL default 'button1', PRIMARY KEY  (id)) TYPE=MyISAM";
}

if(!in_array(TOPLIST_ANTI_FLOOD_TABLE,$table_list))
{
   $sql_array[] = "CREATE TABLE " . TOPLIST_ANTI_FLOOD_TABLE . " (id INT( 255 ) NOT NULL ,ip VARCHAR( 8 ) NOT NULL ,time INT( 11 ) NOT NULL ,type VARCHAR( 3 ) NOT NULL ) TYPE=MyISAM";
}