HLstatsX Community Edition
  • Contents
  • Search
  • Help
Style:

  Clan Information

Statistics Summary
Clan: Her
Home Page:
Activity: 89.33%
Members: 3 active members (5 total)
Avg. Member Points: 1,022
Total Kills: 92
Total Deaths: 169
Avg. Kills: 31
Kills per Death: 0.54
Kills per Minute: 0.31
Total Connection Time: 0d 04:53:26h
Avg. Connection Time: 0d 01:37:49h
Favorite Server:* MicSnobs TF2 24/7 NoCrit Doublecross or Vote!
Favorite Map:* ctf_doublecross
Favorite Weapon:* Sentry Gun (Level 3)
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  .gif♥Cherrie♥ She/Her elorank 1,097 0d 02:00:59h 65 70.65% 113 0.58
2  .gifLuna<3 she/her elorank 1,027 0d 02:18:11h 18 19.57% 19 0.95
3  .gifFloorTheInsaneGirl She/Her elorank 943 0d 00:34:16h 9 9.78% 37 0.24




  Player Actions *

Rank Action sort-descending.gif Achieved Points Bonus
1 Unstoppable (11 kills) 1 times 10
2 Ultra Kill (8 kills) 3 times 21
3 Ubercharge 583 times 1,749
4 Triple Kill (3 kills) 203 times 406
5 Revenge 928 times 2,784
6 Rampage (5 kills) 23 times 92
7 Point Captured 4 times 20
8 Picked up the flag 172 times 172
9 Ownage (7 kills) 2 times 12
10 Mega Kill (6 kills) 8 times 40
11 Killing Spree (9 kills) 4 times 32
12 Killed charged medic 9 times 36
13 Kill Assist - Medic 583 times 1,166
14 Kill Assist 2,064 times 2,064
15 Headshot Kill 146 times 146
16 God Like (12+ kills) 1 times 11
17 Extinguished Teammate (Sniper) 49 times 49
18 Extinguished Teammate (Scout) 11 times 11
19 Extinguished Teammate (Pyro) 19 times 19
20 Extinguished Teammate (Medic) 576 times 1,152
21 Extinguished Teammate (Engineer) 86 times 86
22 Dropped the flag (while alive) 25 times -25
23 Dropped the flag (on death) 68 times 0
24 Double Kill (2 kills) 675 times 675
25 Domination (4 kills) 56 times 168
26 Domination 247 times 1,235
27 Defended the flag 48 times 48
28 Captured the flag 75 times 75




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Domination 1,311 times -6555
2 Revenge 182 times -546




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The BLU 285 times 29.47%
2 The RED 261 times 26.99%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Engineer Engineer 512 times 19.35% 1,657 2,869 0.58
2 Scout Scout 409 times 15.46% 1,003 2,742 0.37
3 Medic Medic 408 times 15.42% 344 1,155 0.30
4 Sniper Sniper 343 times 12.96% 603 1,529 0.39
5 Spy Spy 305 times 11.53% 281 1,033 0.27
6 Soldier Soldier 215 times 8.13% 403 899 0.45
7 Heavy Heavy 168 times 6.35% 158 383 0.41
8 Pyro Pyro 144 times 5.44% 231 535 0.43
9 Demo Man Demo Man 142 times 5.37% 205 426 0.48




  Weapon Usage *

Rank Weapon Points Modifier sort-descending.gif Kills Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Kamikaze 5.00 14 15.22% 0 0.00% 0.00
2 Home Run 5.00 4 4.35% 0 0.00% 0.00
3 Spinal Tap 5.00 22 23.91% 0 0.00% 0.00
4 Showdown 5.00 17 18.48% 0 0.00% 0.00
5 Dischord 5.00 25 27.17% 0 0.00% 0.00
6 Decapitation 5.00 1 1.09% 0 0.00% 0.00
7 Baseball 5.00 3 3.26% 0 0.00% 0.00
8 Fencing 3.00 4 4.35% 0 0.00% 0.00
9 Skewer 3.00 3 3.26% 0 0.00% 0.00
10 Hadouken 3.00 2 2.17% 0 0.00% 0.00
11 The Jag 2.00 3 3.26% 0 0.00% 0.00
12 Wrench 2.00 6 6.52% 0 0.00% 0.00
13 Equalizer 2.00 107 116.30% 0 0.00% 0.00
14 Ubersaw 2.00 63 68.48% 0 0.00% 0.00
15 Tribalman's Shiv 2.00 16 17.39% 0 0.00% 0.00
16 Third Degree 2.00 9 9.78% 0 0.00% 0.00
17 Telefrag 2.00 3 3.26% 0 0.00% 0.00
18 Southern Hospitality 2.00 309 335.87% 0 0.00% 0.00
19 Shovel 2.00 1 1.09% 0 0.00% 0.00
20 Shahanshah 2.00 1 1.09% 0 0.00% 0.00
21 Three-Rune Blade 2.00 1 1.09% 0 0.00% 0.00
22 Scottish Handshake 2.00 1 1.09% 0 0.00% 0.00
23 The Sandman 2.00 49 53.26% 0 0.00% 0.00
24 Gunslinger 2.00 1 1.09% 0 0.00% 0.00
25 Overdose 2.00 6 6.52% 0 0.00% 0.00
26 Conscientious Objector 2.00 52 56.52% 0 0.00% 0.00
27 Sharpened Volcano Fragment 2.00 51 55.43% 0 0.00% 0.00
28 Frying Pan 2.00 10 10.87% 0 0.00% 0.00
29 Fists 2.00 20 21.74% 0 0.00% 0.00
30 Fire Axe 2.00 10 10.87% 0 0.00% 0.00
31 Chargin' Targe 2.00 1 1.09% 0 0.00% 0.00
32 Deflected Rocket 2.00 2 2.17% 0 0.00% 0.00
33 Kukri 2.00 89 96.74% 0 0.00% 0.00
34 The Bushwacka 2.00 9 9.78% 0 0.00% 0.00
35 Bottle 2.00 2 2.17% 0 0.00% 0.00
36 Bone Saw 2.00 47 51.09% 0 0.00% 0.00
37 The Vita-Saw 2.00 4 4.35% 0 0.00% 0.00
38 Bat 2.00 63 68.48% 0 0.00% 0.00
39 The Amputator 2.00 19 20.65% 0 0.00% 0.00
40 Market Gardener 1.50 1 1.09% 0 0.00% 0.00
41 Blutsauger 1.50 141 153.26% 0 0.00% 0.00
42 Bleed Kill 1.50 209 227.17% 0 0.00% 0.00
43 Ambassador 1.50 6 6.52% 2 50.00% 0.33
44 Scottish Resistance 1.25 1 1.09% 0 0.00% 0.00
45 Your Eternal Reward 1.25 8 8.70% 0 0.00% 0.00
46 The Crusader's Crossbow 1.25 50 54.35% 0 0.00% 0.00
47 The Brass Beast 1.25 6 6.52% 0 0.00% 0.00
48 Big Earner 1.25 4 4.35% 0 0.00% 0.00
49 The Ullapool Caber BOOM 1.10 2 2.17% 0 0.00% 0.00
50 Wrangler 1.00 5 5.43% 0 0.00% 0.00
51 World 1.00 274 297.83% 0 0.00% 0.00
52 The Widowmaker 1.00 3 3.26% 0 0.00% 0.00
53 Tomislav 1.00 13 14.13% 0 0.00% 0.00
54 Winger 1.00 8 8.70% 0 0.00% 0.00
55 Rocket Launcher 1.00 182 197.83% 0 0.00% 0.00
56 Stickybomb Launcher 1.00 7 7.61% 0 0.00% 0.00
57 Grenade Launcher 1.00 36 39.13% 0 0.00% 0.00
58 Huntsman 1.00 147 159.78% 71 1,775% 0.48
59 Syringe Gun 1.00 2 2.17% 0 0.00% 0.00
60 The Sydney Sleeper 1.00 129 140.22% 0 0.00% 0.00
61 Eyelander 1.00 17 18.48% 0 0.00% 0.00
62 Soda Popper 1.00 324 352.17% 0 0.00% 0.00
63 Sniper Rifle 1.00 52 56.52% 29 725.00% 0.56
64 Submachine Gun 1.00 3 3.26% 0 0.00% 0.00
65 Soldier Shotgun 1.00 2 2.17% 0 0.00% 0.00
66 Pyro Shotgun 1.00 3 3.26% 0 0.00% 0.00
67 Engy Shotgun 1.00 67 72.83% 0 0.00% 0.00
68 Heavy Shotgun 1.00 8 8.70% 0 0.00% 0.00
69 Scatter Gun 1.00 43 46.74% 0 0.00% 0.00
70 Direct Hit 1.00 25 27.17% 0 0.00% 0.00
71 Revolver 1.00 97 105.43% 0 0.00% 0.00
72 Reserve Shooter 1.00 6 6.52% 0 0.00% 0.00
73 Original 1.00 6 6.52% 0 0.00% 0.00
74 The Cleaner's Carbine 1.00 4 4.35% 0 0.00% 0.00
75 The Hitman's Heatmaker 1.00 11 11.96% 5 125.00% 0.45
76 Engy Pistol 1.00 1 1.09% 0 0.00% 0.00
77 Phlogistinator 1.00 4 4.35% 0 0.00% 0.00
78 Persian Persuader 1.00 14 15.22% 0 0.00% 0.00
79 Baby Face's Blaster 1.00 167 181.52% 0 0.00% 0.00
80 Sentry Gun (Level 3) 1.00 543 590.22% 0 0.00% 0.00
81 Sentry Gun (Level 2) 1.00 152 165.22% 0 0.00% 0.00
82 Sentry Gun (Level 1) 1.00 139 151.09% 0 0.00% 0.00
83 Sentry Gun (Mini) 1.00 12 13.04% 0 0.00% 0.00
84 Nessie's Nine Iron 1.00 2 2.17% 0 0.00% 0.00
85 Minigun (Natascha) 1.00 43 46.74% 0 0.00% 0.00
86 Minigun (Sasha) 1.00 20 21.74% 0 0.00% 0.00
87 Lugermorph 1.00 14 15.22% 0 0.00% 0.00
88 Machina 1.00 13 14.13% 3 75.00% 0.23
89 Liberty Launcher 1.00 28 30.43% 0 0.00% 0.00
90 L'Etranger 1.00 8 8.70% 0 0.00% 0.00
91 Knife 1.00 89 96.74% 0 0.00% 0.00
92 Frontier Justice 1.00 214 232.61% 0 0.00% 0.00
93 Force-A-Nature 1.00 4 4.35% 0 0.00% 0.00
94 Flaregun 1.00 5 5.43% 0 0.00% 0.00
95 Flamethrower 1.00 85 92.39% 0 0.00% 0.00
96 Family Business 1.00 5 5.43% 0 0.00% 0.00
97 Enforcer 1.00 44 47.83% 0 0.00% 0.00
98 Beggar's Bazooka 1.00 1 1.09% 0 0.00% 0.00
99 Detonator 1.00 7 7.61% 0 0.00% 0.00
100 Half-Zatoichi 1.00 48 52.17% 0 0.00% 0.00
101 The Claidheamohmor 1.00 3 3.26% 0 0.00% 0.00
102 The Black Box 1.00 1 1.09% 0 0.00% 0.00
103 Bazaar Bargain 1.00 25 27.17% 14 350.00% 0.56
104 Scotsman's Skullcutter 1.00 12 13.04% 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 / 92 * 100, 2) AS kpercent,
			ROUND(headshots / 4 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map asc,
			kills asc