HLstatsX Community Edition
  • VALVE
  • AG
  • Contents
  • Search
  • Forum
  • Help

  Sections

  Country Information

Statistics Summary
Country:  Russian Federation
Activity: 53.95% 53.95%
Members: 1337 active members
Total Kills: 268,472
Total Deaths: 239,324
Avg. Kills: 201
Kills per Death: 1.12
Kills per Minute: 0.95
Avg. Member Points: 1,036
Avg. Connection Time: 0d 03:32:02h
Total Connection Time: 196d 21:06:33h
RU
ERROR
Database Error

Server Address: localhost
Server Username: website

Error Diagnostic:
Bad query.

Server Error: (3) Error writing file 'C:\Windows\TEMP\MYE371.tmp' (Errcode: 28)

Last SQL Query:
		SELECT
			hlstats_Players.playerId,
			hlstats_Players.lastName,
			hlstats_Players.country,
			hlstats_Players.flag,
			hlstats_Players.skill,
			hlstats_Players.connection_time,
			hlstats_Players.kills,
			hlstats_Players.deaths,
			ROUND(hlstats_Players.kills / IF(hlstats_Players.deaths = 0, 1, hlstats_Players.deaths), 2) AS kpd,
			ROUND(hlstats_Players.kills / IF(268472 = 0, 1, 268472) * 100, 2) AS percent,
			IF(2592000 > (UNIX_TIMESTAMP() - last_event), ((100/2592000) * (2592000 - (UNIX_TIMESTAMP() - last_event))), -1) as activity
		FROM
			hlstats_Players
		WHERE
			flag='RU'
			AND hlstats_Players.hideranking = 0
			AND hlstats_Players.game='ag'      
		GROUP BY
			hlstats_Players.playerId
		HAVING
			activity >= 0
		ORDER BY
			skill desc,
			kpd desc,
			lastName ASC
		LIMIT 0,20