{ Sections }
{voice_serverlist}
{ Participating servers }| Tracking 259 players (+-1 new players last 24h) with 15453 kills (+-1 last 24h) and 413 headshots (2.67) on 12 servers |
|
|
| { Server } | { Address } | { Map } | { Played } | Players | { Kills } | { Headshots } | { Hsk } |
 TF2 Romania Public (www.tf2.ro)
|
play.tf2.ro(Join) | cp_granary | 0/24 | 15453 | 413 |
|
|
{ Daily awards }
Generated in real-time by HLstatsX Community Edition 1.6.7
All images are copyrighted by their respective owners.
[Admin]
Total Queries: 12All images are copyrighted by their respective owners.
[Admin]
/var/www/includes/class_db.php Line 93: SET NAMES 'utf8'
/var/www/pages/voicecomm_serverlist.php Line 26: SELECT serverId, name, addr, password, descr, queryPort, UDPPort, serverType FROM hlstats_Servers_VoiceComm
/var/www/pages/game.php Line 66: SELECT count(*) FROM hlstats_Players WHERE game='tf'
/var/www/pages/game.php Line 79: SELECT SUM(kills), SUM(headshots), count(serverId) FROM hlstats_Servers WHERE game='tf'
/var/www/includes/class_db.php Line 127: SELECT players, kills FROM hlstats_Trend WHERE game='tf' AND timestamp<=1268432550 ORDER BY timestamp DESC LIMIT 0,1
/var/www/pages/game.php Line 130: SELECT serverId, name, IF(publicaddress != '', publicaddress, concat(address, ':', port) ) AS addr, kills, headshots, act_players, max_players, act_map, map_started, map_ct_wins, map_ts_wins FROM hlstats_Servers WHERE game='tf' ORDER BY sortorder, name, serverId
/var/www/includes/class_db.php Line 127: SELECT SUM(kills), SUM(headshots), count(serverId) FROM hlstats_Servers WHERE serverId='1'
/var/www/pages/livestats.php Line 92: SELECT serverId, name, IF(publicaddress != '', publicaddress, concat(address, ':', port) ) AS addr, statusurl, kills, players, rounds, suicides, headshots, bombs_planted, bombs_defused, ct_wins, ts_wins, ct_shots, ct_hits, ts_shots, ts_hits, act_players, max_players, act_map, map_started, map_ct_wins, map_ts_wins, game FROM hlstats_Servers WHERE serverId='1'
/var/www/pages/livestats.php Line 140: SELECT team, name, teamkills, teamdeaths, teamheadshots, teamping, teamskill, teamshots, teamhits, teamjointime, IFNULL(playerlist_bgcolor,'#D5D5D5') as playerlist_bgcolor, IFNULL(playerlist_color,'#050505') AS playerlist_color, IFNULL( playerlist_index, 99 ) AS playerlist_index FROM hlstats_Teams RIGHT JOIN (SELECT team, sum( kills ) AS teamkills, sum( deaths ) AS teamdeaths, sum( headshots ) AS teamheadshots, avg( ping /2 ) AS teamping, avg( skill ) AS teamskill, sum( shots ) AS teamshots, sum( hits ) AS teamhits, sum( unix_timestamp( NOW( ) ) - connected ) AS teamjointime FROM hlstats_Livestats WHERE server_id = 1 AND connected >0 GROUP BY team ORDER BY teamkills ) teaminfo ON code = team AND hlstats_Teams.game = 'tf' ORDER BY playerlist_index LIMIT 0 , 30
/var/www/pages/game.php Line 194: SELECT hlstats_Awards.awardId, hlstats_Awards.name, hlstats_Awards.verb, hlstats_Awards.d_winner_id, hlstats_Awards.d_winner_count, hlstats_Players.lastName AS d_winner_name, hlstats_Players.flag AS flag, hlstats_Players.country AS country FROM hlstats_Awards LEFT JOIN hlstats_Players ON hlstats_Players.playerId = hlstats_Awards.d_winner_id WHERE hlstats_Awards.game='tf' ORDER BY hlstats_Awards.name
/var/www/pages/game.php Line 209: SELECT DATE_FORMAT(value, '%W %e %b'), DATE_FORMAT( DATE_SUB( value, INTERVAL 1 DAY ) , '%W %e %b' ) FROM hlstats_Options WHERE keyname='awards_d_date'
/var/www/includes/class_hlxce.php Line 206: SELECT game from hlstats_Roles WHERE game='tf' AND hidden = 0