HLstatsX Community Edition
  • Contents
  • Search
  • Help
Style:

  Clan Information

Statistics Summary
Clan: real
Home Page:
Activity: 91.45%
Members: 11 active members (52 total)
Avg. Member Points: 1,262
Total Kills: 1,114
Total Deaths: 910
Avg. Kills: 101
Kills per Death: 1.22
Kills per Minute: 0.68
Total Connection Time: 1d 03:25:05h
Avg. Connection Time: 0d 02:29:33h
Favorite Server:* MicSnobs TF2 24/7 NoCrit Doublecross or Vote!
Favorite Map:* plr_hightower
Favorite Weapon:* Scatter Gun
Player Locations

  Members

Rank Name Rank Points sort-ascending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  .gifsmiling character (real) elorank 968 0d 00:31:34h 16 1.44% 33 0.48
2  .gifking of pan (real) elorank 991 0d 00:22:10h 6 0.54% 10 0.60
3  .gifbob_(real) elorank 995 0d 00:12:59h 8 0.72% 12 0.67
4  .gifPootis Engage Heavy (REAL) elorank 999 0d 02:37:44h 68 6.10% 166 0.41
5  .gifGooeygooey(real) elorank 1,000 0d 00:00:14h 0 0.00% 0 0.00
6  .gifMeowskulls (REAL) elorank 1,001 0d 00:05:18h 0 0.00% 2 0.00
7  .gifguy on fire (real) elorank 1,015 0d 00:59:30h 40 3.59% 50 0.80
8  .gifsex (real) elorank 1,027 0d 00:43:36h 38 3.41% 40 0.95
9  .gifWAGR L class (real) elorank 1,190 0d 04:45:39h 80 7.18% 167 0.48
10  .gifcancer (real) elorank 1,637 0d 02:19:11h 108 9.69% 85 1.27
11  .giffemale (real) elorank 3,062 0d 14:47:10h 750 67.32% 345 2.17




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Kill Assist 89 times 89
2 Double Kill (2 kills) 52 times 52
3 Domination 38 times 190
4 Kill Assist - Medic 29 times 58
5 Headshot Kill 27 times 27
6 Revenge 20 times 60
7 Triple Kill (3 kills) 17 times 34
8 Extinguished Teammate (Medic) 14 times 28
9 Domination (4 kills) 13 times 39
10 Ubercharge 9 times 27
11 Picked up the flag 8 times 8
12 Rampage (5 kills) 4 times 16
13 Dropped the flag (while alive) 4 times -4
14 Ultra Kill (8 kills) 3 times 21
15 Mega Kill (6 kills) 3 times 15
16 Dropped the flag (on death) 3 times 0
17 Extinguished Teammate (Sniper) 2 times 2
18 Captured the flag 2 times 2
19 Unstoppable (11 kills) 1 times 10
20 Ownage (7 kills) 1 times 6
21 Killing Spree (9 kills) 1 times 8
22 Killed charged medic 1 times 4
23 God Like (12+ kills) 1 times 11




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 31 times -93
2 Domination 31 times -155




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The BLU 23 times 30.67%
2 The RED 19 times 25.33%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Soldier Soldier 30 times 22.22% 89 94 0.95
2 Scout Scout 22 times 16.30% 101 92 1.10
3 Sniper Sniper 19 times 14.07% 60 85 0.71
4 Medic Medic 13 times 9.63% 26 19 1.37
5 Heavy Heavy 13 times 9.63% 43 35 1.23
6 Pyro Pyro 11 times 8.15% 41 45 0.91
7 Spy Spy 10 times 7.41% 8 14 0.57
8 Engineer Engineer 9 times 6.67% 18 20 0.90
9 Demo Man Demo Man 8 times 5.93% 41 62 0.66




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-ascending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Scotsman's Skullcutter 1.00 1 0.09% 0 0.00% 0.00
2 Bleed Kill 1.50 1 0.09% 0 0.00% 0.00
3 The Boston Basher 2.00 1 0.09% 0 0.00% 0.00
4 Bottle 2.00 1 0.09% 0 0.00% 0.00
5 Half-Zatoichi 1.00 1 0.09% 0 0.00% 0.00
6 Detonator 1.00 1 0.09% 0 0.00% 0.00
7 Force-A-Nature 1.00 1 0.09% 0 0.00% 0.00
8 Holiday Punch 2.00 1 0.09% 0 0.00% 0.00
9 Minigun (Natascha) 1.00 1 0.09% 0 0.00% 0.00
10 Sentry Gun (Level 2) 1.00 1 0.09% 0 0.00% 0.00
11 Scottish Resistance 1.25 1 0.09% 0 0.00% 0.00
12 Skewer 3.00 1 0.09% 0 0.00% 0.00
13 Huntsman 1.00 1 0.09% 0 0.00% 0.00
14 The Ullapool Caber BOOM 1.10 1 0.09% 0 0.00% 0.00
15 Ambassador 1.50 2 0.18% 0 0.00% 0.00
16 Knife 1.00 2 0.18% 0 0.00% 0.00
17 Liberty Launcher 1.00 2 0.18% 0 0.00% 0.00
18 Sentry Gun (Level 3) 1.00 2 0.18% 0 0.00% 0.00
19 Baby Face's Blaster 1.00 2 0.18% 0 0.00% 0.00
20 Gunslinger 2.00 2 0.18% 0 0.00% 0.00
21 Flaregun 1.00 3 0.27% 0 0.00% 0.00
22 Frying Pan 2.00 3 0.27% 0 0.00% 0.00
23 L'Etranger 1.00 3 0.27% 0 0.00% 0.00
24 Conscientious Objector 2.00 3 0.27% 0 0.00% 0.00
25 Scout Pistol 1.00 3 0.27% 0 0.00% 0.00
26 Spy-cicle 1.00 3 0.27% 0 0.00% 0.00
27 Backburner 1.00 4 0.36% 0 0.00% 0.00
28 Cow Mangler 5000 1.00 4 0.36% 0 0.00% 0.00
29 Family Business 1.00 4 0.36% 0 0.00% 0.00
30 The Cleaner's Carbine 1.00 4 0.36% 0 0.00% 0.00
31 Showdown 5.00 4 0.36% 0 0.00% 0.00
32 The Powerjack 2.00 5 0.45% 0 0.00% 0.00
33 Direct Hit 1.00 5 0.45% 0 0.00% 0.00
34 Submachine Gun 1.00 5 0.45% 0 0.00% 0.00
35 Eyelander 1.00 5 0.45% 0 0.00% 0.00
36 The Sydney Sleeper 1.00 5 0.45% 0 0.00% 0.00
37 Rocket Launcher 1.00 6 0.54% 0 0.00% 0.00
38 Ubersaw 2.00 6 0.54% 0 0.00% 0.00
39 The Escape Plan 1.00 6 0.54% 0 0.00% 0.00
40 Flamethrower 1.00 7 0.63% 0 0.00% 0.00
41 Lugermorph 1.00 7 0.63% 0 0.00% 0.00
42 Stickybomb Launcher 1.00 7 0.63% 0 0.00% 0.00
43 Minigun (Sasha) 1.00 8 0.72% 0 0.00% 0.00
44 The Bushwacka 2.00 9 0.81% 0 0.00% 0.00
45 Sharpened Volcano Fragment 2.00 9 0.81% 0 0.00% 0.00
46 Market Gardener 1.50 9 0.81% 0 0.00% 0.00
47 Pretty Boy's Pocket Pistol 1.00 9 0.81% 0 0.00% 0.00
48 Righteous Bison 2.00 9 0.81% 0 0.00% 0.00
49 Engy Shotgun 1.00 10 0.90% 0 0.00% 0.00
50 The Hitman's Heatmaker 1.00 11 0.99% 9 8.49% 0.82
51 Revolver 1.00 11 0.99% 0 0.00% 0.00
52 Soldier Shotgun 1.00 13 1.17% 0 0.00% 0.00
53 The Crusader's Crossbow 1.25 16 1.44% 0 0.00% 0.00
54 Fists 2.00 17 1.53% 0 0.00% 0.00
55 Grenade Launcher 1.00 17 1.53% 0 0.00% 0.00
56 Original 1.00 19 1.71% 0 0.00% 0.00
57 Sniper Rifle 1.00 20 1.80% 18 16.98% 0.90
58 World 1.00 35 3.14% 0 0.00% 0.00
59 Scatter Gun 1.00 40 3.59% 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 / 1114 * 100, 2) AS kpercent,
			ROUND(headshots / 106 * 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