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

  Sections

  Clan Information

Statistics Summary
Clan: 2
Home Page:
Activity: 57.42% 57.42%
Members: 40 active members (298 total)
Avg. Member Points: 7,049
Total Kills: 45,632
Total Deaths: 43,397
Avg. Kills: 1,141
Kills per Death: 1.05
Kills per Minute: 0.52
Total Connection Time: 61d 09:32:07h
Avg. Connection Time: 1d 12:50:18h
Favorite Server:* GAMER.KG | CS:S Public Classic
Favorite Map:* de_dust2
Favorite Weapon:* Arctic Warfare Magnum (Police)
Player Locations

  Members

Rank Name Points Activity Time Kills sort-descending.gif Clan Kills % Deaths Kpd


Page: 1 2




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 73 times 73
2 Double Kill (2 kills) 30 times 30
3 Pick up the Bomb 29 times 58
4 Drop the Bomb 21 times -42
5 Triple Kill (3 kills) 11 times 22
6 Plant the Bomb 5 times 50
7 Start Defusing the Bomb With a Defuse Kit 2 times 0
8 Rampage (5 kills) 2 times 8
9 Domination (4 kills) 2 times 6




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 76 times 22.96% 22.96%
2 Terrorist 69 times 20.85% 20.85%




  Weapon Usage *

Rank Weapon Points Modifier Kills Percentage of Kills % Headshots sort-descending.gif Percentage of Headshots % Hpk
1 Desert Eagle .50AE 1.20 30 0.07% 0.07% 16 0.08% 0.08% 0.53
2 FN P90 1.20 21 0.05% 0.05% 11 0.05% 0.05% 0.52
3 Arctic Warfare Magnum (Police) 1.00 99 0.22% 0.22% 10 0.05% 0.05% 0.10
4 Kalashnikov AK-47 1.00 19 0.04% 0.04% 10 0.05% 0.05% 0.53
5 Colt M4A1 Carbine 1.00 15 0.03% 0.03% 9 0.04% 0.04% 0.60
6 Sig SG-550 Sniper 0.80 11 0.02% 0.02% 4 0.02% 0.02% 0.36
7 Fusil Automatique 1.00 4 0.01% 0.01% 3 0.01% 0.01% 0.75
8 H&K USP .45 Tactical 1.40 5 0.01% 0.01% 2 0.01% 0.01% 0.40
9 Benelli M3 Super 90 Combat 1.20 4 0.01% 0.01% 2 0.01% 0.01% 0.50
10 Sig Sauer SG-552 Commando 1.00 3 0.01% 0.01% 1 0.00% 0.00% 0.33
11 Steyr Scout 1.10 1 0.00% 0.00% 1 0.00% 0.00% 1.00
12 Sig Sauer P-228 1.50 1 0.00% 0.00% 1 0.00% 0.00% 1.00
13 H&K MP5-Navy 1.20 4 0.01% 0.01% 1 0.00% 0.00% 0.25
14 H&K G3/SG1 Sniper Rifle 0.80 2 0.00% 0.00% 1 0.00% 0.00% 0.50
15 Steyr Aug 1.00 1 0.00% 0.00% 1 0.00% 0.00% 1.00
16 Benelli/H&K M4 Super 90 XM1014 1.10 1 0.00% 0.00% 0 0.00% 0.00% 0.00
17 H&K UMP45 1.20 4 0.01% 0.01% 0 0.00% 0.00% 0.00
18 M249 PARA Light Machine Gun 1.20 1 0.00% 0.00% 0 0.00% 0.00% 0.00
19 Bundeswehr Advanced Combat Knife 2.00 1 0.00% 0.00% 0 0.00% 0.00% 0.00
20 High Explosive Grenade 1.80 2 0.00% 0.00% 0 0.00% 0.00% 0.00
21 Glock 18 Select Fire 1.40 1 0.00% 0.00% 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 / 45632 * 100, 2) AS kpercent,
			ROUND(headshots / 20445 * 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