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

  Sections

  Clan Information

Statistics Summary
Clan: Fredrik_
Home Page:
Activity: 100.00% 100.00%
Members: 2 active members (2 total)
Avg. Member Points: 1,011
Total Kills: 27
Total Deaths: 32
Avg. Kills: 14
Kills per Death: 0.84
Kills per Minute: 0.11
Total Connection Time: 0d 03:56:07h
Avg. Connection Time: 0d 01:58:03h
Favorite Server:* TF2 *FRIENDS* 2FORT [FAST:RESP]
Favorite Map:* ctf_2fort
Favorite Weapon:* Spy-cicle
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  No Country_Fredrik_123 1,024 100% 0d 01:49:10h 0 0.00% 0.00% 0 0.00
2  Russian federation_Fredrik_123 998 100% 0d 02:06:57h 27 100.00% 100.00% 32 0.84




  Player Actions *

Rank Action sort-descending.gif Achieved Points Bonus
1 Ubercharge 2 times 2
2 Rocket Jump Kill 1 times 0
3 Rocket Jump 9 times 0
4 Rampage (5 kills) 1 times 4
5 Picked up the flag 1 times 2
6 Kill Assist 12 times 24
7 Headshot Kill 2 times 4
8 Force Suicide 13 times 0
9 Dropped the flag (on death) 1 times 0
10 Double Kill (2 kills) 8 times 8
11 Domination 1 times 5
12 Destroyed a teleporter 1 times 2
13 Destroyed a sentry gun 2 times 8
14 Destroyed a dispenser 4 times 12
15 Critical Kill 13 times 0
16 Backstab Kill 11 times 22
17 Airshot Rocket 3 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Stun 7 times 0
2 Blocked with Shield 1 times 0




  Team Selection *

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




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Spy Spy 2 times 18.18% 18.18%
2 Soldier Soldier 2 times 18.18% 18.18%
3 Sniper Sniper 2 times 18.18% 18.18%
4 Medic Medic 2 times 18.18% 18.18%
5 Demo Man Demo Man 2 times 18.18% 18.18%
6 Engineer Engineer 1 times 9.09% 9.09%




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-ascending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Your Eternal Reward 2.00 1 3.70% 3.70% 0 0.00% 0.00% 0.00
2 L'Etranger 1.00 1 3.70% 3.70% 0 0.00% 0.00% 0.00
3 Submachine Gun 1.00 1 3.70% 3.70% 0 0.00% 0.00% 0.00
4 Frying Pan 2.00 3 11.11% 11.11% 0 0.00% 0.00% 0.00
5 Sniper Rifle 1.00 5 18.52% 18.52% 2 100.00% 100.00% 0.40
6 Rocket Launcher 1.00 5 18.52% 18.52% 0 0.00% 0.00% 0.00
7 Spy-cicle 2.00 11 40.74% 40.74% 0 0.00% 0.00% 0.00




ERROR
Database Error

Server Address: localhost
Server Username: hlstats

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 / 27 * 100, 2) AS kpercent,
			ROUND(headshots / 2 * 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