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: 127.0.0.1
Server Username: statsamxban

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