HLstatsX Community Edition
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: 2
Home Page:
Activity: 57.04% 57.04%
Members: 24 active members (295 total)
Avg. Member Points: 7,285
Total Kills: 20,469
Total Deaths: 23,897
Avg. Kills: 853
Kills per Death: 0.86
Kills per Minute: 0.45
Total Connection Time: 31d 14:53:53h
Avg. Connection Time: 1d 07:37:14h
Favorite Server:* GAMER.KG | CS:S Public Classic
Favorite Map:* awpcup_map2_v2
Favorite Weapon:* Arctic Warfare Magnum (Police)
Player Locations

  Members

Rank Name Points sort-ascending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  No Country(2)NONAME 992 54% 0d 00:26:36h 0 0.00% 0.00% 6 0.00
2  No Country(2)NONAME 996 96% 0d 00:11:45h 0 0.00% 0.00% 2 0.00
3  No Country(2)NONAME 1,000 96% 0d 00:00:37h 0 0.00% 0.00% 0 0.00
4  No Country(2)NONAME 1,000 68% 0d 00:17:47h 0 0.00% 0.00% 0 0.00
5  No Country(2)NONAME 1,000 10% 0d 00:00:28h 0 0.00% 0.00% 0 0.00
6  No Country(2)NONAME 1,000 21% 0d 00:05:58h 0 0.00% 0.00% 0 0.00
7  No Country(2)NONAME 1,000 53% 0d 00:07:02h 0 0.00% 0.00% 0 0.00
8  No Country(2)NONAME 1,001 70% 0d 00:04:43h 0 0.00% 0.00% 2 0.00
9  No Country(2)NONAME 1,002 52% 0d 00:21:17h 1 0.00% 0.00% 2 0.50
10  No Country(2)-7 1,018 20% 0d 00:29:38h 4 0.02% 0.02% 2 2.00
11  No Country(2)NONAME 1,024 26% 0d 01:55:49h 18 0.09% 0.09% 31 0.58
12  No Country(2)NONAME 1,059 96% 0d 02:24:22h 25 0.12% 0.12% 42 0.60
13  No Country(2)NONAME 1,061 75% 0d 02:19:08h 32 0.16% 0.16% 70 0.46
14  No Country(2)NONAME 1,700 54% 0d 05:17:05h 74 0.36% 0.36% 144 0.51
15  No Country(2)NONAME 2,925 74% 0d 07:35:07h 117 0.57% 0.57% 106 1.10
16  No Country(2)NONAME 5,948 11% 0d 14:45:08h 299 1.46% 1.46% 372 0.80
17  No Country(2)NONAME 6,237 88% 0d 22:24:43h 299 1.46% 1.46% 314 0.95
18  No Country(2)NONAME 14,184 68% 3d 05:50:12h 1,161 5.67% 5.67% 2,620 0.44
19  No Country(2)NONAME 16,455 100% 6d 13:34:53h 4,562 22.29% 22.29% 7,066 0.65
20  No Country(2)NONAME 17,741 64% 1d 19:37:29h 1,123 5.49% 5.49% 1,085 1.04


Page: 1 2




  Player Actions *





  Team Selection *

Rank Team Joined sort-ascending.gif Percentage of Times %
1 Terrorist 39 times 20.74% 20.74%
2 Counter-Terrorist 42 times 22.34% 22.34%




  Weapon Usage *

Rank Weapon Points Modifier Kills Percentage of Kills % Headshots sort-descending.gif Percentage of Headshots % Hpk
1 Desert Eagle .50AE 1.20 26 0.13% 0.13% 15 0.16% 0.16% 0.58
2 Colt M4A1 Carbine 1.00 28 0.14% 0.14% 13 0.14% 0.14% 0.46
3 Arctic Warfare Magnum (Police) 1.00 62 0.30% 0.30% 9 0.10% 0.10% 0.15
4 Kalashnikov AK-47 1.00 24 0.12% 0.12% 7 0.08% 0.08% 0.29
5 FN P90 1.20 8 0.04% 0.04% 5 0.05% 0.05% 0.63
6 H&K UMP45 1.20 1 0.00% 0.00% 1 0.01% 0.01% 1.00
7 Fusil Automatique 1.00 3 0.01% 0.01% 1 0.01% 0.01% 0.33
8 Sig Sauer SG-552 Commando 1.00 1 0.00% 0.00% 0 0.00% 0.00% 0.00
9 Bundeswehr Advanced Combat Knife 2.00 8 0.04% 0.04% 0 0.00% 0.00% 0.00
10 High Explosive Grenade 1.80 4 0.02% 0.02% 0 0.00% 0.00% 0.00




ERROR
Database Error

Server Address: 176.126.167.7
Server Username: mwa

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 / 20469 * 100, 2) AS kpercent,
			ROUND(headshots / 9280 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map desc,
			kills desc