Raised This Month: $9 Target: $400
 2% 

[Wc3FT] Issue with Mysql database


Post New Thread Reply   
 
Thread Tools Display Modes
fjollerik
Member
Join Date: Jul 2007
Location: Denmark
Old 03-06-2014 , 04:32   Re: [Wc3FT] Issue with Mysql database
Reply With Quote #11

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!!!!
fjollerik is offline
jingojang
Senior Member
Join Date: Feb 2010
Location: The Moon
Old 03-11-2014 , 05:25   Re: [Wc3FT] Issue with Mysql database
Reply With Quote #12

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
__________________
jingojang is offline
DOG09
Member
Join Date: Feb 2011
Old 09-01-2014 , 16:02   Re: [Wc3FT] Issue with Mysql database
Reply With Quote #13

Quote:
Originally Posted by jingojang View Post
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?
DOG09 is offline
alecsoviki
Junior Member
Join Date: May 2012
Location: Germany
Old 06-26-2016 , 06:21   Re: [Wc3FT] Issue with Mysql database
Reply With Quote #14

Quote:
Originally Posted by Mentors View Post
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 is offline
alecsoviki
Junior Member
Join Date: May 2012
Location: Germany
Old 07-03-2016 , 17:21   Re: [Wc3FT] Issue with Mysql database
Reply With Quote #15

Quote:
Originally Posted by alecsoviki View Post
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 ?
alecsoviki is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 17:00.


Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Theme made by Freecode