[Wc3FT] Issue with Mysql database - Page 2

fjollerik · 03-06-2014 , 04:32 Re: [Wc3FT] Issue with Mysql database

YEEEEEEEEEEEEEEEEEEEEEEHHHHHHHHHHHHHAAAAAAAAA AAAAAAAAAAAA!!!!!!!!!!!!!!!!!!!!!!

Thanks Mentors!!! That fixed it all!!!!!

Quote:

[WAR3FT] MySQL X database connection successful
Connection to Steam servers successful.
VAC secure mode is activated.

Fuck mann!! Thanks alot mann!!!!

jingojang · 03-11-2014 , 05:25 Re: [Wc3FT] Issue with Mysql database

I get this syntax

#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 '"CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(

unsigned NOT NULL ' at line 1

DOG09 · 09-01-2014 , 16:02 Re: [Wc3FT] Issue with Mysql database

Quote:

Originally Posted by jingojang

I get this syntax

#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 '"CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(

unsigned NOT NULL ' at line 1

Any solutions for that?

alecsoviki · 06-26-2016 , 06:21 Re: [Wc3FT] Issue with Mysql database

Quote:

Originally Posted by Mentors

PHP Code:


			
"CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KEY `player_ip` (`player_ip`), KEY `player_steamid` (`player_steamid`) )",

    "CREATE TABLE IF NOT EXISTS `wc3_player_extra` ( `player_id` INT( 8 ) UNSIGNED NOT NULL , `player_steamid` VARCHAR( 25 ) NOT NULL , `player_ip` VARCHAR( 20 ) NOT NULL , `player_name` VARCHAR( 35 ) NOT NULL , PRIMARY KEY ( `player_id` ))",

    "CREATE TABLE IF NOT EXISTS `wc3_player_race` ( `player_id` int(8) unsigned NOT NULL default '0', `race_id` tinyint(4) unsigned NOT NULL default '0', `race_xp` int(8) default NULL, PRIMARY KEY  (`player_id`,`race_id`) )",

    "CREATE TABLE IF NOT EXISTS `wc3_player_skill` ( `player_id` int(8) unsigned NOT NULL default '0', `skill_id` tinyint(4) unsigned NOT NULL default '0', `skill_level` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY  (`player_id`,`skill_id`) )",

    "CREATE TABLE IF NOT EXISTS `wc3_web_race` ( `race_id` tinyint(4) unsigned NOT NULL default '0', `race_lang` char(2) NOT NULL default '', `race_name` varchar(100) default NULL, `race_description` text NOT NULL, PRIMARY KEY  (`race_id`,`race_lang`) )",

    "CREATE TABLE IF NOT EXISTS `wc3_web_skill` ( `skill_id` tinyint(4) unsigned NOT NULL default '0', `skill_lang` char(2) NOT NULL default '', `skill_name` varchar(100) default NULL, `skill_description` text NOT NULL, `skill_type` tinyint(4) unsigned NOT NULL default '0', `skill_owner` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY  (`skill_id`,`skill_lang`) )",

    "CREATE TABLE IF NOT EXISTS `wc3_config` ( `config_id` varchar(50) NOT NULL, `config_value` varchar(255) NOT NULL, PRIMARY KEY  (`config_id`) )"

};

edit in db_mysqlx.inl file.

I have make it so, but still:

Code:

L 06/26/2016 - 13:18:35: [war3ft.amxx] [MYSQLX] Error in querying database, location: 2
L 06/26/2016 - 13:18:35: [war3ft.amxx] [MYSQLX] Message: Table 'novanc_cs.wc3_player' doesn't exist (1146)
L 06/26/2016 - 13:18:35: [war3ft.amxx] [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_name` = 'www.Playcs.ro Forum';

alecsoviki · 07-03-2016 , 17:21 Re: [Wc3FT] Issue with Mysql database

Quote:

Originally Posted by alecsoviki

I have make it so, but still:

Code:

L 06/26/2016 - 13:18:35: [war3ft.amxx] [MYSQLX] Error in querying database, location: 2
L 06/26/2016 - 13:18:35: [war3ft.amxx] [MYSQLX] Message: Table 'novanc_cs.wc3_player' doesn't exist (1146)
L 06/26/2016 - 13:18:35: [war3ft.amxx] [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_name` = 'www.Playcs.ro Forum';

Somebody ?