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

  Clan Information

Statistics Summary
Clan: Real
Home Page:
Activity: 41.50%
Members: 10 active members (172 total)
Avg. Member Points: 1,961
Total Kills: 6,051
Total Deaths: 9,083
Avg. Kills: 605
Kills per Death: 0.67
Kills per Minute: 0.59
Total Connection Time: 7d 02:06:33h
Avg. Connection Time: 0d 17:00:39h
Favorite Server:* Panda-Community.com US | 2Fort
Favorite Map:* ctf_2fort
Favorite Weapon:* Sniper Rifle
Player Locations

  Members

Rank Name Rank sort-descending.gif Points Activity Time Kills Clan Kills % Deaths Kpd
1  United statesCelebrity (real) elorank 1,146 0d 00:55:51h 49 0.81% 41 1.20
2  United statessex (real) elorank 5,171 1d 02:46:16h 1,998 33.02% 1,839 1.09
3  United statesDoise (Real) elorank 2,433 0d 08:57:55h 345 5.70% 351 0.98
4  United statespyro gaming 4k ultra hd (real) elorank 1,148 0d 03:19:25h 108 1.78% 159 0.68
5  United statesDr.Eggman(Real) elorank 3,290 3d 03:11:17h 2,690 44.46% 4,219 0.64
6  United statesham_ater (real) elorank 1,232 0d 03:57:29h 88 1.45% 141 0.62
7  United statesSanta (real) elorank 993 0d 02:43:33h 97 1.60% 173 0.56
8  New zealandSpace Godzilla (real) elorank 1,060 0d 03:39:11h 92 1.52% 199 0.46
9  United kingdomVash the Stampede (real) elorank 971 0d 02:36:39h 43 0.71% 104 0.41
10  United kingdomkenzo tenma (real) elorank 2,161 1d 17:58:57h 541 8.94% 1,857 0.29




  Player Actions *

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




  Victims of Player-Player Actions *

Rank Action sort-descending.gif Times Victimized Points Bonus
1 Stun 261 times 0
2 Steal Sandvich 17 times -34
3 Revenge 37 times -111
4 Mad Milking a player 28 times 0
5 Jarated player 33 times -33
6 Domination 122 times -610
7 Deflected Rocket 19 times 0
8 Deflected Pipebomb 4 times 0
9 Deflected Flare 4 times 0
10 Deflected Arrow 5 times 0
11 Airblast Player 265 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 53 times 24.77%
2 The BLU 53 times 24.77%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Sniper Sniper 73 times 16.08% 314 379 0.83
2 Heavy Heavy 65 times 14.32% 286 262 1.09
3 Scout Scout 62 times 13.66% 142 228 0.62
4 Soldier Soldier 53 times 11.67% 156 215 0.73
5 Demo Man Demo Man 50 times 11.01% 142 179 0.79
6 Engineer Engineer 41 times 9.03% 123 154 0.80
7 Pyro Pyro 40 times 8.81% 89 125 0.71
8 Medic Medic 37 times 8.15% 40 86 0.47
9 Spy Spy 33 times 7.27% 31 81 0.38




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Sniper Rifle 1.00 160 2.64% 118 14.27% 0.74
2 Tomislav 1.00 149 2.46% 0 0.00% 0.00
3 Minigun (Sasha) 1.00 71 1.17% 0 0.00% 0.00
4 Huntsman 1.00 64 1.06% 40 4.84% 0.63
5 Cow Mangler 5000 1.00 63 1.04% 0 0.00% 0.00
6 Scotsman's Skullcutter 2.00 54 0.89% 0 0.00% 0.00
7 Sentry Gun (Level 3) 1.00 44 0.73% 0 0.00% 0.00
8 Revolver 1.00 33 0.55% 0 0.00% 0.00
9 Baby Face's Blaster 1.00 33 0.55% 0 0.00% 0.00
10 Rocket Launcher 1.00 31 0.51% 0 0.00% 0.00
11 Kukri 2.00 31 0.51% 0 0.00% 0.00
12 World 1.00 27 0.45% 0 0.00% 0.00
13 Machina 2.00 26 0.43% 18 2.18% 0.69
14 Flamethrower 1.00 26 0.43% 0 0.00% 0.00
15 Engy Shotgun 1.00 25 0.41% 0 0.00% 0.00
16 Scatter Gun 1.25 20 0.33% 0 0.00% 0.00
17 Frying Pan 2.00 20 0.33% 0 0.00% 0.00
18 Beggar's Bazooka 1.00 17 0.28% 0 0.00% 0.00
19 Conscientious Objector 2.00 15 0.25% 0 0.00% 0.00
20 Sentry Gun (Mini) 1.00 14 0.23% 0 0.00% 0.00
21 Solemn Vow 2.00 13 0.21% 0 0.00% 0.00
22 Phlogistinator 2.00 12 0.20% 0 0.00% 0.00
23 K.G.B. 2.00 12 0.20% 0 0.00% 0.00
24 Frontier Justice 1.00 11 0.18% 0 0.00% 0.00
25 Grenade Launcher 1.00 9 0.15% 0 0.00% 0.00
26 Eyelander 2.00 9 0.15% 0 0.00% 0.00
27 Original 2.00 9 0.15% 0 0.00% 0.00
28 Bottle 2.00 9 0.15% 0 0.00% 0.00
29 The Loch-n-Load 1.00 8 0.13% 0 0.00% 0.00
30 The Black Box 1.00 8 0.13% 0 0.00% 0.00
31 Wrench 2.00 7 0.12% 0 0.00% 0.00
32 Ubersaw 2.00 7 0.12% 0 0.00% 0.00
33 Soldier Shotgun 1.00 7 0.12% 0 0.00% 0.00
34 Heavy Shotgun 1.00 7 0.12% 0 0.00% 0.00
35 Disciplinary Action 2.00 7 0.12% 0 0.00% 0.00
36 Ambassador 1.00 7 0.12% 2 0.24% 0.29
37 The Sydney Sleeper 1.00 6 0.10% 0 0.00% 0.00
38 Half-Zatoichi 2.00 6 0.10% 0 0.00% 0.00
39 Blutsauger 1.50 6 0.10% 0 0.00% 0.00
40 Bleed Kill 1.80 6 0.10% 0 0.00% 0.00
41 Axtinguisher 2.00 6 0.10% 0 0.00% 0.00
42 The Crusader's Crossbow 1.00 5 0.08% 0 0.00% 0.00
43 The Claidheamohmor 2.00 5 0.08% 0 0.00% 0.00
44 Sentry Gun (Level 2) 1.00 4 0.07% 0 0.00% 0.00
45 Knife 2.00 4 0.07% 0 0.00% 0.00
46 The Degreaser 1.00 4 0.07% 0 0.00% 0.00
47 Deflected Rocket 2.00 4 0.07% 0 0.00% 0.00
48 The Ullapool Caber BOOM 1.20 3 0.05% 0 0.00% 0.00
49 Kamikaze 5.00 3 0.05% 0 0.00% 0.00
50 Spy-cicle 2.00 3 0.05% 0 0.00% 0.00
51 Soda Popper 1.25 3 0.05% 0 0.00% 0.00
52 The Hitman's Heatmaker 1.00 3 0.05% 2 0.24% 0.67
53 The Powerjack 2.00 3 0.05% 0 0.00% 0.00
54 Sentry Gun (Level 1) 1.00 3 0.05% 0 0.00% 0.00
55 Liberty Launcher 1.00 3 0.05% 0 0.00% 0.00
56 The Bushwacka 2.00 3 0.05% 0 0.00% 0.00
57 The Boston Basher 2.00 3 0.05% 0 0.00% 0.00
58 Big Earner 2.00 3 0.05% 0 0.00% 0.00
59 The Warrior's Spirit 2.00 2 0.03% 0 0.00% 0.00
60 Showdown 5.00 2 0.03% 0 0.00% 0.00
61 Pyro Shotgun 1.00 2 0.03% 0 0.00% 0.00
62 Direct Hit 1.00 2 0.03% 0 0.00% 0.00
63 Nessie's Nine Iron 2.00 2 0.03% 0 0.00% 0.00
64 Holiday Punch 2.00 2 0.03% 0 0.00% 0.00
65 Force-A-Nature 1.00 2 0.03% 0 0.00% 0.00
66 Eviction Notice 2.00 2 0.03% 0 0.00% 0.00
67 Your Eternal Reward 2.00 2 0.03% 0 0.00% 0.00
68 Chargin' Targe 2.00 2 0.03% 0 0.00% 0.00
69 Atomizer 2.00 2 0.03% 0 0.00% 0.00
70 The Jag 2.00 1 0.02% 0 0.00% 0.00
71 Stickybomb Launcher 1.00 1 0.02% 0 0.00% 0.00
72 Huntsman (Fire arrow) 1.00 1 0.02% 0 0.00% 0.00
73 Telefrag 2.00 1 0.02% 0 0.00% 0.00
74 Southern Hospitality 2.00 1 0.02% 0 0.00% 0.00
75 Gunslinger 2.00 1 0.02% 0 0.00% 0.00
76 The Cleaner's Carbine 1.00 1 0.02% 0 0.00% 0.00
77 Engy Pistol 1.00 1 0.02% 0 0.00% 0.00
78 Pretty Boy's Pocket Pistol 1.50 1 0.02% 0 0.00% 0.00
79 Market Gardener 2.00 1 0.02% 0 0.00% 0.00
80 Postal Pummeler 2.00 1 0.02% 0 0.00% 0.00
81 Family Business 1.00 1 0.02% 0 0.00% 0.00
82 The Brass Beast 1.00 1 0.02% 0 0.00% 0.00
83 Bazaar Bargain 1.00 1 0.02% 1 0.12% 1.00
84 Baseball 2.50 1 0.02% 0 0.00% 0.00




  Weapon Stats *

Rank Weapon Shots Hits Damage Headshots Kills sort-descending.gif Kills per Death Accuracy Damage per Hit Shots per Kill
1 Engy Shotgun 860 313 8,776 0 25 1.2500 36.4% 28.0 34.4
2 Grenade Launcher 300 155 11,131 0 9 0.1837 51.7% 71.8 33.3
3 Soldier Shotgun 153 88 2,028 0 7 0.7000 57.5% 23.0 21.9
4 Direct Hit 11 8 718 0 3 0.1304 72.7% 89.8 3.7
5 Stickybomb Launcher 223 150 10,089 0 1 0.0417 67.3% 67.3 223.0
6 Scottish Resistance 2 0 0 0 0 0.0000 0.0% 0.0 0.0
7 Deflected Grenade 12 0 0 0 0 0.0000 0.0% 0.0 0.0
8 Blutsauger 1,242 155 1,550 0 0 0.0000 12.5% 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 / 6051 * 100, 2) AS kpercent,
			ROUND(headshots / 827 * 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