Top15 stats tinklalapį

[haciawo]

Norėjau pasiteirauti gal kas matet kažkoki php faila ar kažka panasaus kad tarkim tinklalapi rodytu Top15 nu ir aišku jis pastoviai atsinaujintu automatiškai ?

psychostats - no
hlstats - no

[aaarnas]

Yra pluginas alliedmods forume, kuris top15 kelia į duombazę ir php skriptas, kuris atvaizduoja, tik negaliu prisiminti kaip vadinasi.

[haciawo]

Meginsiu ieškoti bet jei rasi rašyk

-- 2014 Vas 21 22:36 --

gal sitas ar ne ?

https://forums.alliedmods.net/showthread.php?t=130417

-- 2014 Vas 21 22:41 --

o gal šitas ?

Gametracker plugina mačiau aliedmodders . Bet jis su jų webu surištas :O tai nelabai lips

[laimiukas3]

https://forums.alliedmods.net/showthread.php?t=70140
http://csextreme.ru/cs16/plugins/2925-top15-mysql.html

mysql

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`));

[haciawo]

O kaip gi be eroru kaip visad

Eroras

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 

Prikabinu sma failiuka ( cvarus naudoju per amx.cfg - ne nesucompilina. )

[laimiukas3]

O kaip gi be eroru kaip visad

Eroras

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    

Prikabinu sma failiuka ( cvarus naudoju per amx.cfg - ne nesucompilina. )

nežinau kur tu ten ka kompiliuoji

amxx.cfg
top15_save 1 nick , 2 - ip , 3 steam_id

sql.cfg
amx_top15_host "host"
amx_top15_user "user"
amx_top15_pass "pass"
amx_top15_db "db"

beto nepamirsk

sql importuoti

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`));