HLstatsX Community Edition
  • Contents
  • Search
  • Forum
  • Help

Banner
  Sections

  Clan Information

Statistics Summary
Clan: 1
Home Page:
Activity: 76.33% 76.33%
Members: 3 active members (1161 total)
Avg. Member Points: 1,790
Total Kills: 5,486
Total Deaths: 8,143
Avg. Kills: 1,829
Kills per Death: 0.67
Kills per Minute: 0.57
Total Connection Time: 6d 16:51:57h
Avg. Connection Time: 2d 05:37:19h
Favorite Server:* zonaZerO | DeathMatch [TOP #3 Admin] | www.clanzonaZerO.com
Favorite Map:* cs_max
Favorite Weapon:*
Player Locations

  Members

Rank Name Points Activity Time Kills sort-ascending.gif Clan Kills % Deaths Kpd
1  Peru(1)(PaQuItO) 1,000 29% 0d 00:02:31h 0 0.00% 0.00% 0 0.00
2  No Country(1)ELPEPE 1,000 100% 0d 00:02:08h 0 0.00% 0.00% 0 0.00
3  Venezuela(1)Player 3,370 100% 6d 16:47:18h 5,486 100.00% 100.00% 8,143 0.67




  Team Selection *

Rank Team sort-ascending.gif Joined Percentage of Times %
1 Counter-Terrorist 2 times 50.00% 50.00%
2 Terrorist 2 times 50.00% 50.00%




  Weapon Usage *

Rank Weapon Points Modifier Kills Percentage of Kills % Headshots sort-ascending.gif Percentage of Headshots % Hpk




ERROR
Database Error

Server Address: 37.187.9.34
Server Username: stats

Error Diagnostic:
Bad query.

Server Error: (1052) Column 'map' in order clause is ambiguous

Last SQL Query:
		SELECT *, 
			IFNULL(kills/deaths, '-') AS kpd,
			IFNULL(headshots / kills, '-') AS hpk,
			ROUND(kills / 5486 * 100, 2) AS kpercent,
			ROUND(headshots / 1581 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map asc,
			kills asc