Main Header
HLstatsX Community Edition
  • CSGO
  • CSS
  • CSTRIKE
  • HL2MP
  • L4D2
  • TF
  • VALVE
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: E
Home Page:
Activity: 100.00% 100.00%
Members: 3 active members (3 total)
Avg. Member Points: 1,254
Total Kills: 120
Total Deaths: 71
Avg. Kills: 40
Kills per Death: 1.69
Kills per Minute: 0.70
Total Connection Time: 0d 02:51:20h
Avg. Connection Time: 0d 00:57:06h
Favorite Server:* - XGN | TF2 #01 [TEST] | www.XGN.in.th -
Favorite Map:* ctf_turbine
Favorite Weapon:* The Black Box
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Thailand[E] Misaka Misaka 1,640 100% 0d 02:25:43h 111 92.50% 92.50% 67 1.66
2  Thailand[E]xit.Non<Onion Club 1,114 100% 0d 00:23:32h 9 7.50% 7.50% 3 3.00
3  Asia/pacific region[E]xit.AOF<Onion Club 1,009 100% 0d 00:02:05h 0 0.00% 0.00% 1 0.00




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Kill Assist - Medic 9 times 27
2 Kill Assist 9 times 18
3 Point Captured 8 times 40
4 Domination 7 times 35
5 Triple Kill (3 kills) 5 times 10
6 Ubercharge 4 times 4
7 Headshot Kill 4 times 8
8 Built a teleporter 4 times 8
9 Built a sentry gun 3 times 9
10 Removed a Sapper 2 times 2
11 Rampage (5 kills) 2 times 8
12 Double Kill (2 kills) 2 times 2
13 Domination (4 kills) 2 times 6
14 Capture Blocked 2 times 2
15 Built a dispenser 2 times 6
16 Ultra Kill (8 kills) 1 times 7
17 Revenge 1 times 3
18 Killing Spree (9 kills) 1 times 8




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 2 times -6
2 Domination 2 times -10




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 11 times 34.38% 34.38%
2 The BLU 6 times 18.75% 18.75%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Spy Spy 8 times 17.78% 17.78% 17 5 3.40
2 Engineer Engineer 8 times 17.78% 17.78% 4 1 4.00
3 Soldier Soldier 7 times 15.56% 15.56% 26 6 4.33
4 Medic Medic 6 times 13.33% 13.33% 3 5 0.60
5 Sniper Sniper 5 times 11.11% 11.11% 13 12 1.08
6 Scout Scout 4 times 8.89% 8.89% 6 2 3.00
7 Pyro Pyro 4 times 8.89% 8.89% 0 1 0.00
8 Demo Man Demo Man 2 times 4.44% 4.44%
9 Heavy Heavy 1 times 2.22% 2.22%




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 The Black Box 1.00 25 20.83% 20.83% 0 0.00% 0.00% 0.00
2 Huntsman 1.00 10 8.33% 8.33% 4 100.00% 100.00% 0.40
3 Scatter Gun 1.25 5 4.17% 4.17% 0 0.00% 0.00% 0.00
4 Sentry Gun (Level 3) 1.00 3 2.50% 2.50% 0 0.00% 0.00% 0.00
5 Knife 2.00 3 2.50% 2.50% 0 0.00% 0.00% 0.00
6 The Amputator 1.00 3 2.50% 2.50% 0 0.00% 0.00% 0.00
7 Engy Shotgun 1.00 1 0.83% 0.83% 0 0.00% 0.00% 0.00
8 Lugermorph 1.50 1 0.83% 0.83% 0 0.00% 0.00% 0.00
9 Frying Pan 2.00 1 0.83% 0.83% 0 0.00% 0.00% 0.00
10 Enforcer 2.00 1 0.83% 0.83% 0 0.00% 0.00% 0.00




ERROR
Database Error

Server Address: localhost:3334
Server Username: xgn_hlx_main

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