HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections


  Server Live View

 Server  Address  Map  Played  Players  Kills  Headshots  Hpk
  (Join) 00:00:00 / 0 0 0.0000
 #  Player  Kills  Hs  HS:K  Acc  Lat  Time  +/-  Skill
ERROR
Database Error

Server Address: 46.174.50.4
Server Username: temkqa_hlx

Error Diagnostic:
Bad query.

Server Error: (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 'AND connected >0 GROUP BY team ORDER BY teamkills ) team' at line 32

Last SQL Query:
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 = 
AND connected >0
GROUP BY 
team
ORDER BY 
teamkills
) teaminfo
ON
code = team
AND
hlstats_Teams.game = ''
ORDER BY 
playerlist_index
LIMIT 0 , 30