Code: Select all
CREATE TABLE IF NOT EXISTS `players` ( `id` bigint(8) NOT NULL auto_increment, `player_name` varchar(31) NOT NULL, `kills` bigint(8) NOT NULL, `headshot_kills` bigint(8) NOT NULL, `deaths` bigint(8) NOT NULL, `headshot_deaths` bigint(8) NOT NULL, `planted_bombs` bigint(8) NOT NULL, `defused_bombs` bigint(8) NOT NULL, `crnt_kills` mediumint(3) NOT NULL, `crnt_headshot_kills` mediumint(3) NOT NULL, `crnt_deaths` mediumint(3) NOT NULL, `crnt_headshot_deaths` mediumint(3) NOT NULL, `crnt_planted_bombs` int(3) NOT NULL, `crnt_defused_bombs` int(3) NOT NULL, `updated` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`)); CREATE TABLE IF NOT EXISTS `wins` ( `id` bigint(20) NOT NULL auto_increment, `time` int(12) NOT NULL, `team_id` tinyint(1) NOT NULL, `map_name` varchar(20) NOT NULL, `ct_players` int(32) default NULL, `t_players` int(32) default NULL, PRIMARY KEY (`id`));Code: Select all
[[Top15mysql.amxx] Load Query failed. [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 ''[KNS|FTW] ntR'')' at line 1 nežinau kur tu ten ka kompiliuojihaciawo wrote:O kaip gi be eroru kaip visad
ErorasCode: Select all
[[Top15mysql.amxx] Load Query failed. [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 ''[KNS|FTW] ntR'')' at line 1
Prikabinu sma failiuka ( cvarus naudoju per amx.cfg - ne nesucompilina. )
Code: Select all
CREATE TABLE IF NOT EXISTS `players` ( `id` bigint(8) NOT NULL auto_increment, `player_name` varchar(31) NOT NULL, `kills` bigint(8) NOT NULL, `headshot_kills` bigint(8) NOT NULL, `deaths` bigint(8) NOT NULL, `headshot_deaths` bigint(8) NOT NULL, `planted_bombs` bigint(8) NOT NULL, `defused_bombs` bigint(8) NOT NULL, `crnt_kills` mediumint(3) NOT NULL, `crnt_headshot_kills` mediumint(3) NOT NULL, `crnt_deaths` mediumint(3) NOT NULL, `crnt_headshot_deaths` mediumint(3) NOT NULL, `crnt_planted_bombs` int(3) NOT NULL, `crnt_defused_bombs` int(3) NOT NULL, `updated` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`)); CREATE TABLE IF NOT EXISTS `wins` ( `id` bigint(20) NOT NULL auto_increment, `time` int(12) NOT NULL, `team_id` tinyint(1) NOT NULL, `map_name` varchar(20) NOT NULL, `ct_players` int(32) default NULL, `t_players` int(32) default NULL, PRIMARY KEY (`id`));