phpBB.de

Code: Alles auswählen

CREATE TABLE `phpbb_bedankomat` ( 
  `thx_id` smallint(11) NOT NULL auto_increment, 
  `user_id` smallint(11) NOT NULL default '0', 
  `topic_id` smallint(11) NOT NULL default '0', 
  PRIMARY KEY  (`thx_id`) 
) TYPE=MyISAM; 

Code: Alles auswählen

<?php 
define('IN_PHPBB', true); 
$phpbb_root_path = './'; 
include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 

$userdata = session_pagestart($user_ip, PAGE_INDEX); 
init_userprefs($userdata); 

if ( $userdata['user_level'] != ADMIN ) 
message_die(GENERAL_ERROR, "You are not authorised to do this."); 

        $sql = "CREATE TABLE " . $table_prefix . "bedankomat ( 
                thx_id smallint(11) NOT NULL auto_increment, 
                user_id smallint(11) NOT NULL default '0', 
                topic_id smallint(11) NOT NULL default '0', 
                PRIMARY KEY  (thx_id))"; 
        if (!$db->sql_query($sql)) 
        { 
                message_die(GENERAL_ERROR, "<font color=\"red\">error inserting table (<b>" . $table_prefix . "bedankomat</b>).</font>", "", __LINE__, __FILE__, $sql); 
        } 
        else 
        { 
                message_die(GENERAL_MESSAGE, "<font color=\"green\">table (<b>" . $table_prefix . "bedankomat</b>) created successfully.</font><br /><br /> <b>Now, delete this file.</b>", "", "", "", ""); 
        } 
?>

Code: Alles auswählen

Fehler

SQL-Befehl :  

* ? phpdefine(

'IN_PHPBB', true
) 

MySQL meldet: 


You have an error in your SQL syntax near '<?php 
define('IN_PHPBB', true)' at line 1
Zurück