HLstatsX Community Edition
  • Contents
  • Search
  • Help
Style:

  Clan Information

Statistics Summary
Clan: they)
Home Page:
Activity: 100.00%
Members: 2 active members (2 total)
Avg. Member Points: 1,543
Total Kills: 195
Total Deaths: 344
Avg. Kills: 98
Kills per Death: 0.57
Kills per Minute: 0.58
Total Connection Time: 0d 05:37:51h
Avg. Connection Time: 0d 02:48:56h
Favorite Server:* MicSnobs TF2 24/7 NoCrit Doublecross or Vote!
Favorite Map:* ctf_doublecross
Favorite Weapon:* Flamethrower
Player Locations

  Members

Rank Name Rank sort-descending.gif Points Activity Time Kills Clan Kills % Deaths Kpd
1  .gifCorginnit (she/they) elorank 2,085 0d 05:36:29h 195 100.00% 344 0.57
2  .gifThe Daily Coomer (she/they) elorank 1,000 0d 00:01:22h 0 0.00% 0 0.00




  Player Actions *

Rank Action Achieved Points Bonus sort-ascending.gif
1 Dropped the flag (while alive) 3 times -3
2 Dropped the flag (on death) 14 times 0
3 Extinguished Teammate (Pyro) 1 times 1
4 Domination (4 kills) 2 times 6
5 Extinguished Teammate (Medic) 4 times 8
6 Rampage (5 kills) 2 times 8
7 Ubercharge 3 times 9
8 Captured the flag 13 times 13
9 Triple Kill (3 kills) 7 times 14
10 Kill Assist - Medic 12 times 24
11 Domination 6 times 30
12 Picked up the flag 31 times 31
13 Double Kill (2 kills) 38 times 38
14 Kill Assist 47 times 47
15 Revenge 23 times 69




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-ascending.gif Points Bonus
1 Revenge 3 times -9
2 Domination 36 times -180




  Team Selection *

Rank Team sort-descending.gif Joined Percentage of Times %
1 The RED 10 times 27.78%
2 The BLU 9 times 25.00%




  Role Selection *

Rank Role Joined % Ratio Kills Deaths K:D sort-descending.gif
1 Pyro Pyro 11 times 16.18% 100 118 0.85
2 Sniper Sniper 8 times 11.76% 6 8 0.75
3 Spy Spy 2 times 2.94% 12 18 0.67
4 Engineer Engineer 12 times 17.65% 46 88 0.52
5 Soldier Soldier 5 times 7.35% 5 13 0.38
6 Scout Scout 18 times 26.47% 19 52 0.37
7 Demo Man Demo Man 4 times 5.88% 4 12 0.33
8 Medic Medic 5 times 7.35% 1 29 0.03
9 Heavy Heavy 3 times 4.41% 0 5 0.00




  Weapon Usage *

Rank Weapon Points Modifier Kills Percentage of Kills % Headshots Percentage of Headshots % Hpk sort-ascending.gif
1 Atomizer 2.00 1 0.51% 0 0.00% 0.00
2 Blutsauger 1.50 1 0.51% 0 0.00% 0.00
3 Cow Mangler 5000 1.00 1 0.51% 0 0.00% 0.00
4 Deflected Rocket 2.00 2 1.03% 0 0.00% 0.00
5 Half-Zatoichi 1.00 4 2.05% 0 0.00% 0.00
6 Flamethrower 1.00 79 40.51% 0 0.00% 0.00
7 Force-A-Nature 1.00 7 3.59% 0 0.00% 0.00
8 Frontier Justice 1.00 2 1.03% 0 0.00% 0.00
9 Knife 1.00 12 6.15% 0 0.00% 0.00
10 Lugermorph 1.00 10 5.13% 0 0.00% 0.00
11 Sentry Gun (Mini) 1.00 3 1.54% 0 0.00% 0.00
12 Sentry Gun (Level 1) 1.00 3 1.54% 0 0.00% 0.00
13 Sentry Gun (Level 2) 1.00 1 0.51% 0 0.00% 0.00
14 Sentry Gun (Level 3) 1.00 6 3.08% 0 0.00% 0.00
15 Gunslinger 2.00 3 1.54% 0 0.00% 0.00
16 Scatter Gun 1.00 1 0.51% 0 0.00% 0.00
17 Engy Shotgun 1.00 2 1.03% 0 0.00% 0.00
18 Pyro Shotgun 1.00 7 3.59% 0 0.00% 0.00
19 Rocket Launcher 1.00 4 2.05% 0 0.00% 0.00
20 The Widowmaker 1.00 20 10.26% 0 0.00% 0.00
21 World 1.00 18 9.23% 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 / 195 * 100, 2) AS kpercent,
			ROUND(headshots / 1 * 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