hier die fehlermeldung:
db_connect(); $sql_statements = array(); //> Badwordlist $sql_statements[] = "CREATE TABLE `prefix_bbcode_badword` (`fnBadwordNr` int(10) unsigned NOT NULL auto_increment,`fcBadPatter` varchar(70) NOT NULL default '',`fcBadReplace` varchar(70) NOT NULL default '',PRIMARY KEY (`fnBadwordNr`));"; $sql_statements[] = "INSERT INTO `prefix_bbcode_badword` (`fcBadPatter`,`fcBadReplace`) VALUES ('Idiot', '*peep*');"; $sql_statements[] = "INSERT INTO `prefix_bbcode_badword` (`fcBadPatter`,`fcBadReplace`) VALUES ('Arschloch', '*peep*');"; //> BBCode Buttons $sql_statements[] = "CREATE TABLE `prefix_bbcode_buttons` (`fnButtonNr` int(10) unsigned NOT NULL auto_increment, `fnFormatB` tinyint(1) unsigned NOT NULL default '1', `fnFormatI` tinyint(1) unsigned NOT NULL default '0', `fnFormatU` tinyint(1) unsigned NOT NULL default '0', `fnFormatS` tinyint(1) unsigned NOT NULL default '0', `fnFormatEmph` tinyint(1) unsigned NOT NULL default '0', `fnFormatColor` tinyint(1) unsigned NOT NULL default '0', `fnFormatSize` tinyint(1) unsigned NOT NULL default '0', `fnFormatUrl` tinyint(1) unsigned NOT NULL default '0', `fnFormatUrlAuto` tinyint(1) unsigned NOT NULL default '0', `fnFormatEmail` tinyint(1) unsigned NOT NULL default '0', `fnFormatLeft` tinyint(1) unsigned NOT NULL default '0', `fnFormatCenter` tinyint(1) unsigned NOT NULL default '0', `fnFormatRight` tinyint(1) unsigned NOT NULL default '0', `fnFormatSmilies` tinyint(1) unsigned NOT NULL default '0', `fnFormatList` tinyint(1) unsigned NOT NULL default '0', `fnFormatKtext` tinyint(1) unsigned NOT NULL default '0', `fnFormatImg` tinyint(1) unsigned NOT NULL default '0', `fnFormatScreen` tinyint(1) unsigned NOT NULL default '0', `fnFormatVideo` tinyint(1) unsigned NOT NULL default '0', `fnFormatPhp` tinyint(1) unsigned NOT NULL default '0', `fnFormatCss` tinyint(1) unsigned NOT NULL default '0', `fnFormatHtml` tinyint(1) unsigned NOT NULL default '0', `fnFormatCode` tinyint(1) unsigned NOT NULL default '0', `fnFormatQuote` tinyint(1) unsigned NOT NULL default '0', `fnFormatCountdown` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`fnButtonNr`) );"; $sql_statements[] = "INSERT INTO `prefix_bbcode_buttons` VALUES (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);"; //> BBcode Konfiguration $sql_statements[] = "CREATE TABLE `prefix_bbcode_config` (`fnConfigNr` int(10) unsigned NOT NULL auto_increment, `fnYoutubeBreite` smallint(3) unsigned NOT NULL default '0', `fnYoutubeHoehe` smallint(3) unsigned NOT NULL default '0', `fcYoutubeHintergrundfarbe` varchar(7) NOT NULL default '', `fnGoogleBreite` smallint(3) unsigned NOT NULL default '0', `fnGoogleHoehe` smallint(3) unsigned NOT NULL default '0', `fcGoogleHintergrundfarbe` varchar(7) NOT NULL default '', `fnMyvideoBreite` smallint(3) unsigned NOT NULL default '0', `fnMyvideoHoehe` smallint(3) unsigned NOT NULL default '0', `fcMyvideoHintergrundfarbe` varchar(7) NOT NULL default '', `fnSizeMax` tinyint(2) unsigned NOT NULL default '0', `fnImgMaxBreite` smallint(3) unsigned NOT NULL default '0', `fnImgMaxHoehe` smallint(3) unsigned NOT NULL default '0', `fnScreenMaxBreite` smallint(3) unsigned NOT NULL default '0', `fnScreenMaxHoehe` smallint(3) unsigned NOT NULL default '0', `fnUrlMaxLaenge` smallint(3) unsigned NOT NULL default '0', `fnWortMaxLaenge` smallint(3) unsigned NOT NULL default '0', PRIMARY KEY (`fnConfigNr`) );"; $sql_statements[] = "INSERT INTO `prefix_bbcode_config` VALUES (1, 425, 350, '#000000', 400, 326, '#ffffff', 470, 406, '#ffffff', 20, 500, 500, 150, 150, 60, 70);"; //> BBCode Design $sql_statements[] = "CREATE TABLE `prefix_bbcode_design` (`fnDesignNr` int(10) unsigned NOT NULL auto_increment, `fcQuoteRandFarbe` varchar(7) NOT NULL default '', `fcQuoteTabelleBreite` varchar(7) NOT NULL default '', `fcQuoteSchriftfarbe` varchar(7) NOT NULL default '', `fcQuoteHintergrundfarbe` varchar(7) NOT NULL default '', `fcQuoteHintergrundfarbeIT` varchar(7) NOT NULL default '', `fcQuoteSchriftformatIT` varchar(6) NOT NULL default '', `fcQuoteSchriftfarbeIT` varchar(7) NOT NULL default '', `fcBlockRandFarbe` varchar(7) NOT NULL default '', `fcBlockTabelleBreite` varchar(7) NOT NULL default '', `fcBlockSchriftfarbe` varchar(7) NOT NULL default '', `fcBlockHintergrundfarbe` varchar(7) NOT NULL default '', `fcBlockHintergrundfarbeIT` varchar(7) NOT NULL default '', `fcBlockSchriftfarbeIT` varchar(7) NOT NULL default '', `fcKtextRandFarbe` varchar(7) NOT NULL default '', `fcKtextTabelleBreite` varchar(7) NOT NULL default '', `fcKtextRandFormat` varchar(6) NOT NULL default '', `fcEmphHintergrundfarbe` varchar(7) NOT NULL default '', `fcEmphSchriftfarbe` varchar(7) NOT NULL default '', `fcCountdownRandFarbe` varchar(7) NOT NULL default '', `fcCountdownTabelleBreite` varchar(7) NOT NULL default '', `fcCountdownSchriftfarbe` varchar(7) NOT NULL default '', `fcCountdownSchriftformat` varchar(7) NOT NULL default '', `fnCountdownSchriftsize` smallint(2) unsigned NOT NULL default '0', PRIMARY KEY (`fnDesignNr`) );"; $sql_statements[] = "INSERT INTO `prefix_bbcode_design` VALUES (1, '#f6e79d', '90%', '#666666', '#f6e79d', '#faf7e8', 'italic', '#666666', '#f6e79d', '90%', '#666666', '#f6e79d', '#faf7e8', '#FF0000', '#000000', '90%', 'dotted', '#ffd500', '#000000', '#FF0000', '90%', '#FF0000', 'bold', 10);"; foreach ( $sql_statements as $sql_statement ) { if ( trim($sql_statement) != '' ) { echo ' '.$sql_statement.' '; $e = db_query($sql_statement); if (!$e) { echo 'Es ist ein Fehler aufgetreten, bitte alles auf dieser Seite kopieren und auf ilch.de im Forum fragen...: '. mysql_error().''.$sql_statement.' Es sei denn, es ist ein Fehler mit duplicate entry aufgetreten, das liegt einfach nur daran, dass du die Installdatei mehrmals ausgeführt hast. '; } echo ''; } } echo "Tabellen wurden erfolgreich angelegt. Bitte die Datei Löschen !!!"; db_close(); ?>
danke für eure Hilfe
mfg
MadMaxX/Weylin11
verwendete ilchClan Version: 1.1
betroffene Homepage: externer Link