HLstatsX Community Edition (русская версия от MyArena.ru)
  • Содержимое
  • Поиск
  • SourceBans
  • Forum
  • Помощь
Style:

  Разделы


  Наблюдение за сервером

 Сервер  Адрес  Карта  Время  Игроки  Фраги  Хедшоты  Х:Ф
  (войти) 00:00:00 / 0 0 0.0000
 #  Игрок  Фраги  Хедшоты  Х:Ф  Точность  Пинг  Время  +/-  Опыт
ERROR
Database Error

Server Address: 46.174.49.4
Server Username: amasura_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