HLstatsX Community Edition
  • Contents
  • Search
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: KG
Home Page:
Activity: 72.00% 72.00%
Members: 1 active members (1 total)
Avg. Member Points: 21,637
Total Kills: 5,394
Total Deaths: 4,369
Avg. Kills: 5,394
Kills per Death: 1.23
Kills per Minute: 0.53
Total Connection Time: 7d 00:34:55h
Avg. Connection Time: 7d 00:34:55h
Favorite Server:* Schnullis-Rheumaklinik - WWW.SCHNULLIS-RHEUMAKLINIK.DE
Favorite Map:*
Favorite Weapon:* Colt M4A1 Carbine
Player Locations

  Members

Rank Name Points Activity Time Kills Clan Kills % Deaths sort-descending.gif Kpd
1  No Country| KG | Angry bird | Ʀฬ | 21,637 72% 7d 00:34:55h 5,394 100.00% 100.00% 4,369 1.23




  Player Actions *

Rank Action Achieved Points Bonus sort-ascending.gif
1 Drop the Bomb 57 times -114
2 Kill a Hostage 2 times -30
3 Start Defusing the Bomb With a Defuse Kit 18 times 0
4 Start Defusing the Bomb Without a Defuse Kit 2 times 0
5 Domination (4 kills) 2 times 6
6 Touch a Hostage 9 times 9
7 Rescue a Hostage 2 times 10
8 Triple Kill (3 kills) 32 times 64
9 Double Kill (2 kills) 129 times 129
10 Defuse the Bomb 14 times 140
11 Plant the Bomb 18 times 180
12 Pick up the Bomb 99 times 198
13 Headshot 343 times 343




  Team Selection *

Rank Team sort-descending.gif Joined Percentage of Times %
1 Terrorist 43 times 27.39% 27.39%
2 Counter-Terrorist 37 times 23.57% 23.57%




  Weapon Usage *

Rank Weapon Points Modifier Kills Percentage of Kills % Headshots sort-descending.gif Percentage of Headshots % Hpk
1 Colt M4A1 Carbine 1.00 131 2.43% 2.43% 72 2.94% 2.94% 0.55
2 H&K USP .45 Tactical 1.40 75 1.39% 1.39% 48 1.96% 1.96% 0.64
3 Steyr Scout 1.10 67 1.24% 1.24% 42 1.71% 1.71% 0.63
4 Kalashnikov AK-47 1.00 92 1.71% 1.71% 42 1.71% 1.71% 0.46
5 Desert Eagle .50AE 1.20 57 1.06% 1.06% 31 1.27% 1.27% 0.54
6 FN P90 1.20 36 0.67% 0.67% 21 0.86% 0.86% 0.58
7 Steyr Aug 1.00 26 0.48% 0.48% 17 0.69% 0.69% 0.65
8 Sig Sauer P-228 1.50 25 0.46% 0.46% 15 0.61% 0.61% 0.60
9 Glock 18 Select Fire 1.40 15 0.28% 0.28% 10 0.41% 0.41% 0.67
10 Benelli M3 Super 90 Combat 1.20 19 0.35% 0.35% 9 0.37% 0.37% 0.47
11 Sig Sauer SG-552 Commando 1.00 11 0.20% 0.20% 8 0.33% 0.33% 0.73
12 Dual Beretta 96G Elite 1.40 17 0.32% 0.32% 7 0.29% 0.29% 0.41
13 Ingram MAC-10 1.50 11 0.20% 0.20% 5 0.20% 0.20% 0.45
14 FN Five-Seven 1.50 11 0.20% 0.20% 5 0.20% 0.20% 0.45
15 Fusil Automatique 1.00 8 0.15% 0.15% 5 0.20% 0.20% 0.63
16 H&K MP5-Navy 1.20 5 0.09% 0.09% 4 0.16% 0.16% 0.80
17 Benelli/H&K M4 Super 90 XM1014 1.10 3 0.06% 0.06% 1 0.04% 0.04% 0.33
18 M249 PARA Light Machine Gun 1.20 2 0.04% 0.04% 1 0.04% 0.04% 0.50
19 Bundeswehr Advanced Combat Knife 2.00 39 0.72% 0.72% 0 0.00% 0.00% 0.00
20 High Explosive Grenade 1.80 6 0.11% 0.11% 0 0.00% 0.00% 0.00




ERROR
Database Error

Server Address: localhost
Server Username: kdz_24

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 / 5394 * 100, 2) AS kpercent,
			ROUND(headshots / 2450 * 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