server und warrules draufballern
doch allerdings bekomme ich diesen fehler
externer Link
MySQL Error: 1064 : 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 'TYPE = myisam' at line 1 in Query: CREATE TABLE `ic1_serverrules` ( `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , `zahl` SMALLINT(6) DEFAULT 0 NOT NULL , `titel` VARCHAR(200) NOT NULL , `text` TEXT NOT NULL , PRIMARY KEY ( `id` ) , FULLTEXT ( `titel` , `text` ) ) TYPE = myisam Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ installswrules.php:29 -- db_query(...) @ index.php:36 -- require_once(...) MySQL Error: 1064 : 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 'TYPE = myisam' at line 1 in Query: CREATE TABLE `ic1_warrules` ( `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , `zahl` SMALLINT(6) DEFAULT 0 NOT NULL , `titel` VARCHAR(200) NOT NULL , `text` TEXT NOT NULL , PRIMARY KEY ( `id` ) , FULLTEXT ( `titel` , `text` ) ) TYPE = myisam Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ installswrules.php:39 -- db_query(...) @ index.php:36 -- require_once(...) Die Server/War Rules wurde erfolgreich installiert Du solltest nun die /include/contents/installswrules.php löschen!
in der datei steht drinne
<?php
defined ('main') or die ( 'no direct access' );
$design = new design ( 'Server/War Rules', 'Server/War Rules');
$design->header();
if ( empty ($_POST['step']) ) {
?>
<form action="index.php?installswrules" method="POST">
<input type="hidden" name="step" value="2" />
<table width="100%" class="border" border="0" cellspacing="1" cellpadding="3" align="center">
<tr class="Chead">
<td colspan="2"><b>Willkommen zur Installation von Server/War Rules</b></td></tr>
<td></td>
<td><input type="submit" value="Weiter ->"></td>
</tr>
</table>
</form>
<?php
} elseif ( $_POST['step'] == 2 ) {
$sql = 'CREATE TABLE `prefix_serverrules` ('
. ' `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , '
. ' `zahl` SMALLINT(6) DEFAULT 0 NOT NULL , '
. ' `titel` VARCHAR(200) NOT NULL , '
. ' `text` TEXT NOT NULL , '
. ' PRIMARY KEY ( `id` ) , '
. ' FULLTEXT ( `titel` , `text` ) '
. ' )'
. ' TYPE = myisam ';
db_query($sql);
$sql = 'CREATE TABLE `prefix_warrules` ('
. ' `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , '
. ' `zahl` SMALLINT(6) DEFAULT 0 NOT NULL , '
. ' `titel` VARCHAR(200) NOT NULL , '
. ' `text` TEXT NOT NULL , '
. ' PRIMARY KEY ( `id` ) , '
. ' FULLTEXT ( `titel` , `text` ) '
. ' )'
. ' TYPE = myisam';
db_query($sql);
db_query("INSERT INTO `prefix_modules`(`url`,`name`,`gshow`,`ashow`,`fright`) VALUES ('ruless','Serverrules', 0, 1, 0)");
db_query("INSERT INTO `prefix_modules`(`url`,`name`,`gshow`,`ashow`,`fright`) VALUES ('rulesw','Warrules', 0, 1, 0)");
?>
<table width="100%" class="border" border="0" cellspacing="1" cellpadding="3" align="center">
<tr class="Chead">
<td colspan="2"><b>Die Server/War Rules wurde erfolgreich installiert</b></td>
</tr>
<tr class="Cnorm">
<td colspan="2"><b>Du solltest nun die /include/contents/installswrules.php löschen!</b></td>
</tr>
</table>
<?php
}
$design->footer();
?>
betroffene Homepage: stshq.de
