R
redlabour
-
Leute ich brauche dringend mal Hilfe - ich benötige aus folgendem Code nur die mySQL Befehle um die Tabellen zu erstellen !
Aber ich bekomme dauernd SQL Fehler in phpMyAdmin gemeldet ..... das PHP Skript läuft aus div. Gründen nicht.
Aber ich bekomme dauernd SQL Fehler in phpMyAdmin gemeldet ..... das PHP Skript läuft aus div. Gründen nicht.

$sql = "DROP TABLE IF EXISTS ". iNA ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_GAMES ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_SCORES ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_TOP_SCORES ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_BAN ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_CHEAT ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_CAT ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_CAT_DATA ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_CHALLENGE ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_CHALLENGE_USERS ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_TROPHY_COMMENTS ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_SESSIONS ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_LAST_PLAYED ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_GAMBLE ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_GAMBLE_PROGRESS ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_RATING ."";
$result = $db -> sql_query($sql);
$sql = "DROP TABLE IF EXISTS ". iNA_FAVORITES ."";
$result = $db -> sql_query($sql);
}
$sql = "DROP TABLE IF EXISTS ". iNA ."";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_RATING ."` (
`game_id` int(15) NOT NULL default '0',
`rating` int(15) NOT NULL default '0',
`date` int(15) NOT NULL default '0',
`player` int(15) NOT NULL default '0'
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_SESSIONS ."` (
`playing_time` int(15) NOT NULL default '0',
`playing_id` int(10) NOT NULL default '0',
`playing` int(11) NOT NULL default '0'
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_LAST_PLAYED ."` (
`game_id` int(20) default '0',
`user_id` int(11) default '0',
`date` int(20) default NULL
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_GAMBLE ."` (
`game_id` int(20) default '0',
`sender_id` int(11) default '0',
`reciever_id` int(11) default '0',
`amount` int(10) default '0',
`winner_id` int(11) default '0',
`loser_id` int(11) default '0',
`date` int(20) default NULL,
`been_paid` int(11) default '0'
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_GAMBLE_PROGRESS ."` (
`game_id` int(20) default '0',
`sender_id` int(11) default '0',
`reciever_id` int(11) default '0',
`sender_score` int(20) default '0',
`reciever_score` int(20) default '0',
`sender_playing` int(1) NOT NULL default '0',
`reciever_playing` int(1) NOT NULL default '0'
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE ". iNA ." ( version VARCHAR(255) DEFAULT NULL )";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE ". iNA_GAMES ."
(`game_id` mediumint(9) NOT NULL auto_increment,
`game_name` varchar(25) default NULL,
`game_path` varchar(255) default NULL,
`game_desc` varchar(255) default NULL,
`game_charge` int(11) unsigned default '0',
`game_reward` int(11) unsigned NOT NULL default '0',
`game_bonus` smallint(5) unsigned default '0',
`game_use_gl` tinyint(3) unsigned default '0',
`game_flash` tinyint(1) unsigned NOT NULL default '0',
`game_show_score` tinyint(1) NOT NULL default '1',
`win_width` smallint(6) NOT NULL default '0',
`win_height` smallint(6) NOT NULL default '0',
`highscore_limit` varchar(255) default NULL,
`reverse_list` tinyint(1) NOT NULL default '0',
`played` int(10) unsigned NOT NULL default '0',
`instructions` text, PRIMARY KEY (`game_id`) )";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE ". iNA_SCORES ."
(`game_name` varchar(255) default NULL,
`player` varchar(40) default NULL,
`score` int(10) unsigned NOT NULL default '0',
`date` int(11) default NULL )";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_TOP_SCORES ."` (
`game_name` varchar(255) default NULL,
`player` varchar(40) default NULL,
`score` int(10) unsigned NOT NULL default '0',
`date` int(11) default NULL
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_CHALLENGE ."` (
`user` int(10) default '0',
`count` int(25) default '0'
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_CHALLENGE_USERS ."` (
`user_to` int(10) default '0',
`user_from` int(10) default '0',
`count` int(25) default '0'
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_TROPHY_COMMENTS ."` (
`game` varchar(255) NOT NULL default '',
`player` int(10) default NULL,
`comment` text NOT NULL,
`date` int(15) NOT NULL default '0',
`score` int(20) NOT NULL default '0'
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_BAN ."` (
`id` int(10) NOT NULL default '0',
`username` varchar(40) default NULL
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_CHEAT ."` (
`game_id` int(10) NOT NULL default '0',
`player` varchar(40) default NULL,
`game_count` int(100) NOT NULL auto_increment,
PRIMARY KEY (`game_count`)
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);
$sql = "CREATE TABLE `". iNA_CAT ."` (
`cat_id` mediumint(9) NOT NULL auto_increment,
`cat_name` varchar(25) default NULL,
PRIMARY KEY (`cat_id`)
) TYPE=MyISAM;";
$result = $db -> sql_query($sql);