HLstatsX Community Edition
  • Contents
  • Search
  • Help
Style:

  Clan Information

Statistics Summary
Clan: 2
Home Page:
Activity: 100.00%
Members: 2 active members (26 total)
Avg. Member Points: 3,839
Total Kills: 12,240
Total Deaths: 7,395
Avg. Kills: 6,120
Kills per Death: 1.66
Kills per Minute: 1.13
Total Connection Time: 7d 12:18:51h
Avg. Connection Time: 3d 18:09:26h
Favorite Server:* MicSnobs TF2 24/7 NoCrit Doublecross or Vote!
Favorite Map:* ctf_doublecross
Favorite Weapon:* Sniper Rifle
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  .gif(2)Aero elorank 6,740 7d 08:25:16h 12,106 98.91% 7,161 1.69
2  .gif(2)cerberus elorank 937 0d 03:53:35h 134 1.09% 234 0.57




  Player Actions *

Rank Action Achieved Points Bonus sort-ascending.gif
1 Dropped the flag (while alive) 5 times -5
2 Dropped the flag (on death) 9 times 0
3 Extinguished Teammate (Engineer) 2 times 2
4 Extinguished Teammate (Pyro) 2 times 2
5 Captured the flag 6 times 6
6 Extinguished Teammate (Medic) 6 times 12
7 Picked up the flag 20 times 20
8 Defended the flag 40 times 40
9 Kill Assist - Medic 21 times 42
10 Ubercharge 18 times 54
11 Monster Kill (10 kills) 7 times 63
12 Killed charged medic 16 times 64
13 Unstoppable (11 kills) 8 times 80
14 Killing Spree (9 kills) 12 times 96
15 Ultra Kill (8 kills) 18 times 126
16 God Like (12+ kills) 14 times 154
17 Ownage (7 kills) 33 times 198
18 Mega Kill (6 kills) 55 times 275
19 Revenge 106 times 318
20 Rampage (5 kills) 92 times 368
21 Double Kill (2 kills) 433 times 433
22 Domination (4 kills) 150 times 450
23 Triple Kill (3 kills) 241 times 482
24 Kill Assist 840 times 840
25 Headshot Kill 1,551 times 1,551
26 Domination 417 times 2,085




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 316 times -948
2 Domination 126 times -630




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 103 times 33.01%
2 The BLU 63 times 20.19%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Sniper Sniper 349 times 44.23% 2,536 1,550 1.64
2 Scout Scout 254 times 32.19% 1,463 771 1.90
3 Soldier Soldier 56 times 7.10% 82 60 1.37
4 Spy Spy 43 times 5.45% 187 144 1.30
5 Pyro Pyro 32 times 4.06% 150 86 1.74
6 Medic Medic 19 times 2.41% 21 20 1.05
7 Engineer Engineer 16 times 2.03% 101 58 1.74
8 Demo Man Demo Man 16 times 2.03% 59 71 0.83
9 Heavy Heavy 4 times 0.51% 4 6 0.67




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Sniper Rifle 1.00 1,803 14.73% 1,425 31.28% 0.79
2 Scatter Gun 1.00 1,187 9.70% 0 0.00% 0.00
3 Submachine Gun 1.00 404 3.30% 0 0.00% 0.00
4 World 1.00 204 1.67% 0 0.00% 0.00
5 Bazaar Bargain 1.00 132 1.08% 102 2.24% 0.77
6 Conscientious Objector 2.00 126 1.03% 0 0.00% 0.00
7 Knife 1.00 111 0.91% 0 0.00% 0.00
8 Revolver 1.00 51 0.42% 0 0.00% 0.00
9 Scout Pistol 1.00 50 0.41% 0 0.00% 0.00
10 Rocket Launcher 1.00 39 0.32% 0 0.00% 0.00
11 Flamethrower 1.00 31 0.25% 0 0.00% 0.00
12 The Rainblower 1.00 19 0.16% 0 0.00% 0.00
13 Gunslinger 2.00 18 0.15% 0 0.00% 0.00
14 Sentry Gun (Mini) 1.00 18 0.15% 0 0.00% 0.00
15 Ubersaw 2.00 17 0.14% 0 0.00% 0.00
16 Frontier Justice 1.00 17 0.14% 0 0.00% 0.00
17 Pyro Shotgun 1.00 15 0.12% 0 0.00% 0.00
18 Flaregun 1.00 13 0.11% 0 0.00% 0.00
19 Grenade Launcher 1.00 12 0.10% 0 0.00% 0.00
20 Sentry Gun (Level 3) 1.00 12 0.10% 0 0.00% 0.00
21 Market Gardener 1.50 11 0.09% 0 0.00% 0.00
22 Force-A-Nature 1.00 11 0.09% 0 0.00% 0.00
23 Spy-cicle 1.00 10 0.08% 0 0.00% 0.00
24 Soldier Shotgun 1.00 10 0.08% 0 0.00% 0.00
25 Axtinguisher 2.25 10 0.08% 0 0.00% 0.00
26 Engy Shotgun 1.00 8 0.07% 0 0.00% 0.00
27 The Crusader's Crossbow 1.25 8 0.07% 0 0.00% 0.00
28 Stickybomb Launcher 1.00 7 0.06% 0 0.00% 0.00
29 The Claidheamohmor 1.00 7 0.06% 0 0.00% 0.00
30 Ambassador 1.50 7 0.06% 2 0.04% 0.29
31 Cow Mangler 5000 1.00 6 0.05% 0 0.00% 0.00
32 Huntsman 1.00 5 0.04% 4 0.09% 0.80
33 Dischord 5.00 4 0.03% 0 0.00% 0.00
34 Deflected Rocket 2.00 4 0.03% 0 0.00% 0.00
35 The Back Scratcher 2.00 4 0.03% 0 0.00% 0.00
36 The Jag 2.00 3 0.02% 0 0.00% 0.00
37 The Ullapool Caber 1.50 3 0.02% 0 0.00% 0.00
38 Minigun (Natascha) 1.00 3 0.02% 0 0.00% 0.00
39 Disciplinary Action 1.50 3 0.02% 0 0.00% 0.00
40 Wrangler 1.00 2 0.02% 0 0.00% 0.00
41 Eyelander 1.00 2 0.02% 0 0.00% 0.00
42 Gunslinger Combo 5.00 2 0.02% 0 0.00% 0.00
43 The Hitman's Heatmaker 1.00 2 0.02% 1 0.02% 0.50
44 Sentry Gun (Level 2) 1.00 2 0.02% 0 0.00% 0.00
45 Sentry Gun (Level 1) 1.00 2 0.02% 0 0.00% 0.00
46 The Diamondback 1.00 2 0.02% 0 0.00% 0.00
47 Half-Zatoichi 1.00 2 0.02% 0 0.00% 0.00
48 Deflected Grenade 2.00 2 0.02% 0 0.00% 0.00
49 The Escape Plan 1.00 1 0.01% 0 0.00% 0.00
50 The Ullapool Caber BOOM 1.10 1 0.01% 0 0.00% 0.00
51 Skewer 3.00 1 0.01% 0 0.00% 0.00
52 Spinal Tap 5.00 1 0.01% 0 0.00% 0.00
53 The Sydney Sleeper 1.00 1 0.01% 0 0.00% 0.00
54 The Powerjack 2.00 1 0.01% 0 0.00% 0.00
55 Phlogistinator 1.00 1 0.01% 0 0.00% 0.00
56 Mantreads 3.00 1 0.01% 0 0.00% 0.00
57 Frying Pan 2.00 1 0.01% 0 0.00% 0.00
58 Fists 2.00 1 0.01% 0 0.00% 0.00
59 Chargin' Targe 2.00 1 0.01% 0 0.00% 0.00
60 Bleed Kill 1.50 1 0.01% 0 0.00% 0.00




ERROR
Database Error

Server Address: localhost
Server Username: hlxuser

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