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

  Clan Information

Statistics Summary
Clan: *
Home Page:
Activity: 100.00%
Members: 1 active members (87 total)
Avg. Member Points: 1,138
Total Kills: 86
Total Deaths: 89
Avg. Kills: 86
Kills per Death: 0.97
Kills per Minute: 0.44
Total Connection Time: 0d 03:16:26h
Avg. Connection Time: 0d 03:16:26h
Favorite Server:* Panda-Community.com #16 | 2Fort
Favorite Map:* ctf_2fort
Favorite Weapon:* Pyro Shotgun
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  GermanyIdk how to call this ******* elorank 1,138 0d 03:16:26h 86 100.00% 89 0.97




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Airshot Rocket 1 times 0
2 Airshot Stun 1 times 0
3 Destroyed a dispenser 1 times 0
4 Destroyed a teleporter 1 times 0
5 Extinguished Teammate (Pyro) 1 times 1
6 Mega Kill (6 kills) 1 times 5
7 Ownage (7 kills) 1 times 6
8 Captured the flag 2 times 10
9 Domination (4 kills) 2 times 6
10 Defended the flag 3 times 3
11 Deflected Arrow 3 times 0
12 Deflected Flare 3 times 0
13 Revenge 3 times 9
14 Destroyed a sentry gun 4 times 0
15 Rocket Jump 4 times 0
16 Airshot Flare 6 times 0
17 Force Suicide 7 times 0
18 Stun 7 times 0
19 Deflected Rocket 8 times 0
20 Double Kill (2 kills) 8 times 8
21 Triple Kill (3 kills) 8 times 16
22 Domination 9 times 45
23 Critical Kill 13 times 0
24 Dropped the flag (while alive) 15 times -30
25 Picked up the flag 17 times 34
26 Kill Assist 19 times 38
27 Airblast Player 45 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Airblast Player 34 times 0
2 Stun 20 times 0
3 Domination 6 times -30
4 Revenge 5 times -15
5 Mad Milking a player 2 times 0
6 Jarated player 1 times -1
7 Deflected Flare 1 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 15 times 41.67%
2 The BLU 6 times 16.67%




  Role Selection *

Rank Role Joined % Ratio Kills Deaths K:D sort-descending.gif
1 Pyro Pyro 16 times 69.57% 82 73 1.12
2 Heavy Heavy 2 times 8.70% 4 13 0.31
3 Soldier Soldier 4 times 17.39% 0 3 0.00
4 Demo Man Demo Man 1 times 4.35%




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Pyro Shotgun 1.00 10 11.63% 0 0.00% 0.00
2 The Degreaser 1.00 9 10.47% 0 0.00% 0.00
3 Flamethrower 1.00 8 9.30% 0 0.00% 0.00
4 Axtinguisher 2.00 8 9.30% 0 0.00% 0.00
5 Phlogistinator 2.00 7 8.14% 0 0.00% 0.00
6 Detonator 2.00 4 4.65% 0 0.00% 0.00
7 Backburner 1.00 3 3.49% 0 0.00% 0.00
8 The Powerjack 2.00 2 2.33% 0 0.00% 0.00
9 Family Business 1.00 2 2.33% 0 0.00% 0.00
10 The Brass Beast 1.00 2 2.33% 0 0.00% 0.00
11 The Back Scratcher 2.00 2 2.33% 0 0.00% 0.00
12 Hadouken 5.00 1 1.16% 0 0.00% 0.00
13 Flaregun 2.00 1 1.16% 0 0.00% 0.00




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 / 86 * 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 desc,
			kills desc