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

  Clan Information

Statistics Summary
Clan: Real
Home Page:
Activity: 67.88%
Members: 9 active members (173 total)
Avg. Member Points: 1,773
Total Kills: 3,803
Total Deaths: 4,992
Avg. Kills: 423
Kills per Death: 0.76
Kills per Minute: 0.76
Total Connection Time: 3d 11:18:20h
Avg. Connection Time: 0d 09:15:22h
Favorite Server:* Panda-Community.com US | 2Fort
Favorite Map:* ctf_2fort
Favorite Weapon:* Huntsman
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United statessex (real) elorank 5,223 1d 02:57:45h 2,020 53.12% 1,847 1.09
2  United statesDoise (Real) elorank 2,433 0d 08:57:55h 345 9.07% 351 0.98
3  PhilippinesDengist Whip Gaming (real) elorank 1,941 0d 07:33:42h 372 9.78% 489 0.76
4  United statesBananaMan (real) elorank 1,923 0d 04:20:58h 284 7.47% 274 1.04
5  New zealandSpace Godzilla (real) elorank 1,152 0d 04:54:46h 144 3.79% 273 0.53
6  United statesGNARPY(real) elorank 1,078 0d 00:55:55h 44 1.16% 44 1.00
7  CanadaKim Jong Un (Real) elorank 1,049 0d 00:22:53h 7 0.18% 1 7.00
8  United statesmugrootbeerandgaming (real) elorank 904 0d 09:43:40h 85 2.24% 285 0.30
9  United statesEngineer_Gaming(REAL) elorank 250 0d 19:30:46h 502 13.20% 1,428 0.35




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Kill Assist 210 times 420
2 Critical Kill 177 times 0
3 Rocket Jump 121 times 0
4 Airblast Player 117 times 0
5 Double Kill (2 kills) 89 times 89
6 Kill Assist - Medic 88 times 264
7 Force Suicide 81 times 0
8 Sticky Jump 66 times 0
9 Airshot Rocket 58 times 0
10 Headshot Kill 56 times 112
11 Triple Kill (3 kills) 52 times 104
12 Stun 48 times 0
13 Ubercharge 43 times 43
14 Built a mini sentry gun 37 times 111
15 Domination 33 times 165
16 Revenge 31 times 93
17 Extinguished Teammate (Medic) 31 times 31
18 Built a dispenser 29 times 87
19 Built a sentry gun 28 times 84
20 Destroyed a sentry gun 25 times 0
21 Teleporter Used (Not Own) 24 times 0
22 Built a teleporter 19 times 38
23 Picked up the flag 18 times 36
24 Domination (4 kills) 18 times 54
25 Destroyed a dispenser 18 times 0
26 Deflected Rocket 15 times 0
27 Removed a Sapper 14 times 14
28 Destroyed a teleporter 13 times 0
29 Destroyed a mini sentry gun 13 times 0
30 Mad Milking a player 12 times 0
31 Dropped the flag (on death) 12 times 0
32 Disassembled a sentry gun 12 times -36
33 Deflected Pipebomb 12 times 0
34 Airshot Arrow 12 times 0
35 Rampage (5 kills) 11 times 44
36 Jarated player 11 times 11
37 Deflected Directhit Rocket 11 times 0
38 Extinguished Teammate (Engineer) 10 times 10
39 Teleporter used 9 times 9
40 Backstab Kill 9 times 18
41 Extinguished Teammate (Pyro) 8 times 8
42 Disassembled a teleporter 8 times -16
43 Defended a Medic 8 times 8
44 Airshot Flare 8 times 0
45 Disassembled a dispenser 7 times -21
46 Deflected Flare 7 times 0
47 Airshot Stun 7 times 0
48 Defended the flag 6 times 6
49 Airshot Pipebomb 6 times 0
50 Teleporter used (self) 5 times 0
51 Ownage (7 kills) 5 times 30
52 Mega Kill (6 kills) 5 times 25
53 Killed charged medic 4 times 4
54 Extinguished Teammate (Scout) 4 times 4
55 Deployed Buff Flag 4 times 4
56 Captured the flag 4 times 20
57 Attached a Sapper 4 times 8
58 Steal Sandvich 3 times 6
59 Ultra Kill (8 kills) 2 times 14
60 Extinguished Teammate (Sniper) 2 times 2
61 Dropped the flag (while alive) 2 times -4
62 Airshot Sticky 2 times 0
63 Deflected Arrow 1 times 0
64 Airshot Headshot 1 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Stun 154 times 0
2 Airblast Player 153 times 0
3 Domination 65 times -325
4 Deflected Rocket 32 times 0
5 Mad Milking a player 29 times 0
6 Jarated player 29 times -29
7 Revenge 18 times -54
8 Deflected Flare 5 times 0
9 Steal Sandvich 3 times -6
10 Deflected Pipebomb 3 times 0
11 Deflected Arrow 3 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The BLU 49 times 25.93%
2 The RED 44 times 23.28%




  Role Selection *

Rank Role Joined % Ratio Kills sort-descending.gif Deaths K:D
1 Pyro Pyro 34 times 11.72% 132 227 0.58
2 Demo Man Demo Man 34 times 11.72% 116 123 0.94
3 Scout Scout 45 times 15.52% 112 142 0.79
4 Heavy Heavy 27 times 9.31% 100 78 1.28
5 Sniper Sniper 36 times 12.41% 99 112 0.88
6 Soldier Soldier 31 times 10.69% 84 92 0.91
7 Engineer Engineer 38 times 13.10% 81 116 0.70
8 Medic Medic 21 times 7.24% 30 48 0.63
9 Spy Spy 24 times 8.28% 21 43 0.49




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Huntsman 1.00 47 1.24% 30 6.44% 0.64
2 Scotsman's Skullcutter 2.00 44 1.16% 0 0.00% 0.00
3 Tomislav 1.00 38 1.00% 0 0.00% 0.00
4 Baby Face's Blaster 1.00 37 0.97% 0 0.00% 0.00
5 Flamethrower 1.00 37 0.97% 0 0.00% 0.00
6 Revolver 1.00 31 0.82% 0 0.00% 0.00
7 Minigun (Sasha) 1.00 30 0.79% 0 0.00% 0.00
8 Rocket Launcher 1.00 27 0.71% 0 0.00% 0.00
9 Machina 2.00 26 0.68% 18 3.86% 0.69
10 Beggar's Bazooka 1.00 25 0.66% 0 0.00% 0.00
11 Frying Pan 2.00 20 0.53% 0 0.00% 0.00
12 Sentry Gun (Level 3) 1.00 16 0.42% 0 0.00% 0.00
13 World 1.00 15 0.39% 0 0.00% 0.00
14 Sentry Gun (Mini) 1.00 15 0.39% 0 0.00% 0.00
15 Axtinguisher 2.00 15 0.39% 0 0.00% 0.00
16 K.G.B. 2.00 13 0.34% 0 0.00% 0.00
17 Frontier Justice 1.00 12 0.32% 0 0.00% 0.00
18 The Degreaser 1.00 11 0.29% 0 0.00% 0.00
19 Eyelander 2.00 10 0.26% 0 0.00% 0.00
20 Conscientious Objector 2.00 10 0.26% 0 0.00% 0.00
21 Ubersaw 2.00 9 0.24% 0 0.00% 0.00
22 Grenade Launcher 1.00 9 0.24% 0 0.00% 0.00
23 Engy Shotgun 1.00 9 0.24% 0 0.00% 0.00
24 Original 2.00 9 0.24% 0 0.00% 0.00
25 The Loch-n-Load 1.00 9 0.24% 0 0.00% 0.00
26 Bottle 2.00 9 0.24% 0 0.00% 0.00
27 Sniper Rifle 1.00 8 0.21% 3 0.64% 0.38
28 The Black Box 1.00 8 0.21% 0 0.00% 0.00
29 Wrench 2.00 7 0.18% 0 0.00% 0.00
30 Scatter Gun 1.25 6 0.16% 0 0.00% 0.00
31 Pyro Shotgun 1.00 5 0.13% 0 0.00% 0.00
32 The Rainblower 1.00 5 0.13% 0 0.00% 0.00
33 Blutsauger 1.50 5 0.13% 0 0.00% 0.00
34 Bleed Kill 1.80 5 0.13% 0 0.00% 0.00
35 Submachine Gun 1.00 4 0.11% 0 0.00% 0.00
36 Sentry Gun (Level 1) 1.00 4 0.11% 0 0.00% 0.00
37 Half-Zatoichi 2.00 4 0.11% 0 0.00% 0.00
38 Deflected Rocket 2.00 4 0.11% 0 0.00% 0.00
39 The Crusader's Crossbow 1.00 4 0.11% 0 0.00% 0.00
40 The Ullapool Caber BOOM 1.20 3 0.08% 0 0.00% 0.00
41 Kamikaze 5.00 3 0.08% 0 0.00% 0.00
42 Spy-cicle 2.00 3 0.08% 0 0.00% 0.00
43 Soda Popper 1.25 3 0.08% 0 0.00% 0.00
44 Direct Hit 1.00 3 0.08% 0 0.00% 0.00
45 Liberty Launcher 1.00 3 0.08% 0 0.00% 0.00
46 Conniver's Kunai 2.00 3 0.08% 0 0.00% 0.00
47 Flaregun 2.00 3 0.08% 0 0.00% 0.00
48 The Bushwacka 2.00 3 0.08% 0 0.00% 0.00
49 Big Earner 2.00 3 0.08% 0 0.00% 0.00
50 The Widowmaker 2.00 2 0.05% 0 0.00% 0.00
51 The Warrior's Spirit 2.00 2 0.05% 0 0.00% 0.00
52 The Escape Plan 1.00 2 0.05% 0 0.00% 0.00
53 Hadouken 5.00 2 0.05% 0 0.00% 0.00
54 Showdown 5.00 2 0.05% 0 0.00% 0.00
55 Nessie's Nine Iron 2.00 2 0.05% 0 0.00% 0.00
56 Holiday Punch 2.00 2 0.05% 0 0.00% 0.00
57 Force-A-Nature 1.00 2 0.05% 0 0.00% 0.00
58 Eviction Notice 2.00 2 0.05% 0 0.00% 0.00
59 Your Eternal Reward 2.00 2 0.05% 0 0.00% 0.00
60 Chargin' Targe 2.00 2 0.05% 0 0.00% 0.00
61 Cow Mangler 5000 1.00 2 0.05% 0 0.00% 0.00
62 The Brass Beast 1.00 2 0.05% 0 0.00% 0.00
63 The Boston Basher 2.00 2 0.05% 0 0.00% 0.00
64 Huntsman (Fire arrow) 1.00 1 0.03% 0 0.00% 0.00
65 Telefrag 2.00 1 0.03% 0 0.00% 0.00
66 Southern Hospitality 2.00 1 0.03% 0 0.00% 0.00
67 Solemn Vow 2.00 1 0.03% 0 0.00% 0.00
68 Gunslinger 2.00 1 0.03% 0 0.00% 0.00
69 The Hitman's Heatmaker 1.00 1 0.03% 1 0.21% 1.00
70 Pomson 6000 2.00 1 0.03% 0 0.00% 0.00
71 Engy Pistol 1.00 1 0.03% 0 0.00% 0.00
72 Pretty Boy's Pocket Pistol 1.50 1 0.03% 0 0.00% 0.00
73 Sentry Gun (Level 2) 1.00 1 0.03% 0 0.00% 0.00
74 Market Gardener 2.00 1 0.03% 0 0.00% 0.00
75 Postal Pummeler 2.00 1 0.03% 0 0.00% 0.00
76 Family Business 1.00 1 0.03% 0 0.00% 0.00
77 Eureka Effect 2.00 1 0.03% 0 0.00% 0.00
78 Disciplinary Action 2.00 1 0.03% 0 0.00% 0.00
79 Detonator 2.00 1 0.03% 0 0.00% 0.00
80 Bazaar Bargain 1.00 1 0.03% 1 0.21% 1.00
81 Baseball 2.50 1 0.03% 0 0.00% 0.00
82 Atomizer 2.00 1 0.03% 0 0.00% 0.00
83 Ambassador 1.00 1 0.03% 1 0.21% 1.00




  Weapon Stats *

Rank Weapon sort-descending.gif Shots Hits Damage Headshots Kills Kills per Death Accuracy Damage per Hit Shots per Kill
1 Stickybomb Launcher 167 138 9,063 0 0 0.0000 82.6% 65.7 0.0
2 Grenade Launcher 288 124 9,655 0 9 0.4500 43.1% 77.9 32.0
3 Scottish Resistance 2 0 0 0 0 0.0000 0.0% 0.0 0.0
4 Soldier Shotgun 9 0 0 0 0 0.0000 0.0% 0.0 0.0
5 Engy Shotgun 711 216 4,963 0 9 0.5294 30.4% 23.0 79.0
6 Direct Hit 36 13 1,191 0 3 0.1765 36.1% 91.6 12.0
7 Deflected Grenade 12 0 0 0 0 0.0000 0.0% 0.0 0.0
8 Blutsauger 2,050 250 2,500 0 0 0.0000 12.2% 10.0 0.0
9 Baseball 15 0 0 0 0 0.0000 0.0% 0.0 0.0




ERROR
Database Error

Server Address: 172.16.217.100
Server Username: hlstats_user

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