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

  Sections

  Clan Information

Statistics Summary
Clan: TH
Home Page:
Activity: 100.00% 100.00%
Members: 58 active members (58 total)
Avg. Member Points: 1,155
Total Kills: 2,372
Total Deaths: 2,295
Avg. Kills: 41
Kills per Death: 1.03
Kills per Minute: 0.64
Total Connection Time: 2d 13:46:26h
Avg. Connection Time: 0d 01:03:54h
Favorite Server:* - XGN | TF2 #01 [TEST] | www.XGN.in.th -
Favorite Map:* ctf_2fort
Favorite Weapon:* Flamethower
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
41  Thailand[TH]megusta/#$12!+ 1,012 100% 0d 00:13:54h 3 0.13% 0.13% 6 0.50
42  No CountryMC-BANK [TH] 1,009 100% 0d 00:11:02h 4 0.17% 0.17% 8 0.50
43  No CountryHorizon[TH] 1,005 100% 0d 00:22:31h 2 0.08% 0.08% 4 0.50
44  ThailandJeAoF[TH] 1,002 100% 0d 00:05:24h 2 0.08% 0.08% 1 2.00
45  ThailandBooMzKaK[TH] 1,002 100% 0d 00:03:15h 1 0.04% 0.04% 0 1.00
46  Asia/pacific regionVertice[T141][TH] 1,002 100% 0d 00:06:15h 1 0.04% 0.04% 6 0.17
47  ThailandNoNamEKuB[TH] 1,000 100% 0d 00:09:29h 0 0.00% 0.00% 0 0.00
48  No CountryQ_NooB[TH] 1,000 100% 0d 00:02:07h 0 0.00% 0.00% 0 0.00
49  Thailandpeedza007 [TH] 1,000 100% 0d 00:08:54h 0 0.00% 0.00% 0 0.00
50  No CountryJamez[th] 1,000 100% 0d 00:01:38h 0 0.00% 0.00% 0 0.00
51  No Country-=C-x-i-z-C-i-x=-[TH] 1,000 100% 0d 00:02:39h 0 0.00% 0.00% 0 0.00
52  No CountryTheSmootss[TH] 1,000 100% 0d 00:05:46h 0 0.00% 0.00% 0 0.00
53  No Country[TH] TUMza 1,000 100% 0d 00:07:12h 0 0.00% 0.00% 0 0.00
54  No Country7PCrop [TH] 1,000 100% 0d 00:22:47h 0 0.00% 0.00% 0 0.00
55  Thailanddanny[TH] 1,000 100% 0d 00:01:21h 0 0.00% 0.00% 0 0.00
56  Asia/pacific regionFUS RO DAH [TH] 999 100% 0d 00:09:33h 0 0.00% 0.00% 2 0.00
57  Thailand[TH]Gu_Rock!!!!!!!!! 975 100% 0d 00:08:59h 1 0.04% 0.04% 7 0.14
58  ThailandRackle[TH] 968 100% 0d 00:28:36h 9 0.38% 0.38% 26 0.35


Page: 1 2 3




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Kill Assist 399 times 798
2 Double Kill (2 kills) 148 times 148
3 Domination 133 times 665
4 Built a sentry gun 122 times 366
5 Destroyed a sentry gun 92 times 368
6 Kill Assist - Medic 85 times 255
7 Revenge 79 times 237
8 Triple Kill (3 kills) 76 times 152
9 Headshot Kill 68 times 136
10 Attached a Sapper 68 times 136
11 Point Captured 59 times 295
12 Extinguished Teammate (Medic) 58 times 58
13 Capture Blocked 56 times 56
14 Built a dispenser 50 times 150
15 Built a teleporter 41 times 82
16 Destroyed a dispenser 34 times 102
17 Picked up the flag 32 times 64
18 Domination (4 kills) 30 times 90
19 Destroyed a teleporter 29 times 58
20 Removed a Sapper 26 times 26
21 Rampage (5 kills) 17 times 68
22 Dropped the flag (on death) 15 times 0
23 Ubercharge 14 times 14
24 Mega Kill (6 kills) 11 times 55
25 Ownage (7 kills) 10 times 60
26 Extinguished Teammate (Engineer) 10 times 10
27 Captured the flag 10 times 50
28 Defended the flag 8 times 8
29 Killed charged medic 7 times 7
30 Dropped the flag (while alive) 6 times -12
31 Ultra Kill (8 kills) 3 times 21
32 Killing Spree (9 kills) 3 times 24
33 Extinguished Teammate (Scout) 3 times 3
34 Disassembled a sentry gun 3 times -9
35 Disassembled a teleporter 2 times -4
36 Monster Kill (10 kills) 1 times 9
37 Extinguished Teammate (Sniper) 1 times 1




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Domination 148 times -740
2 Revenge 79 times -237




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The BLU 172 times 29.91% 29.91%
2 The RED 165 times 28.70% 28.70%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Scout Scout 204 times 20.63% 20.63% 193 280 0.69
2 Spy Spy 157 times 15.87% 15.87% 236 329 0.72
3 Sniper Sniper 123 times 12.44% 12.44% 179 217 0.82
4 Pyro Pyro 108 times 10.92% 10.92% 489 390 1.25
5 Soldier Soldier 105 times 10.62% 10.62% 144 97 1.48
6 Demo Man Demo Man 101 times 10.21% 10.21% 66 62 1.06
7 Heavy Heavy 78 times 7.89% 7.89% 87 38 2.29
8 Engineer Engineer 78 times 7.89% 7.89% 114 56 2.04
9 Medic Medic 35 times 3.54% 3.54% 2 49 0.04




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Flamethower 1.00 230 9.70% 9.70% 0 0.00% 0.00% 0.00
2 Phlogistinator 2.00 180 7.59% 7.59% 0 0.00% 0.00% 0.00
3 Scatter Gun 1.25 115 4.85% 4.85% 0 0.00% 0.00% 0.00
4 Knife 2.00 85 3.58% 3.58% 0 0.00% 0.00% 0.00
5 The Black Box 1.00 83 3.50% 3.50% 0 0.00% 0.00% 0.00
6 Spy-cicle 2.00 75 3.16% 3.16% 0 0.00% 0.00% 0.00
7 Huntsman 1.00 64 2.70% 2.70% 22 19.47% 19.47% 0.34
8 Sniper Rifle 1.00 61 2.57% 2.57% 37 32.74% 32.74% 0.61
9 Sentry Gun (Level 3) 1.00 55 2.32% 2.32% 0 0.00% 0.00% 0.00
10 Minigun (Sasha) 1.00 34 1.43% 1.43% 0 0.00% 0.00% 0.00
11 Tomislav 1.00 29 1.22% 1.22% 0 0.00% 0.00% 0.00
12 Grenade Launcher 1.00 29 1.22% 1.22% 0 0.00% 0.00% 0.00
13 World 1.00 28 1.18% 1.18% 0 0.00% 0.00% 0.00
14 Stickybomb Launcher 1.00 28 1.18% 1.18% 0 0.00% 0.00% 0.00
15 Your Eternal Reward 2.00 26 1.10% 1.10% 0 0.00% 0.00% 0.00
16 The Degreaser 1.00 25 1.05% 1.05% 0 0.00% 0.00% 0.00
17 Force-A-Nature 1.00 22 0.93% 0.93% 0 0.00% 0.00% 0.00
18 Rocket Launcher 1.00 21 0.89% 0.89% 0 0.00% 0.00% 0.00
19 Liberty Launcher 1.00 19 0.80% 0.80% 0 0.00% 0.00% 0.00
20 Big Earner 2.00 19 0.80% 0.80% 0 0.00% 0.00% 0.00
21 Sentry Gun (Level 2) 1.00 18 0.76% 0.76% 0 0.00% 0.00% 0.00
22 The Shortstop 1.00 16 0.67% 0.67% 0 0.00% 0.00% 0.00
23 Conniver's Kunai 2.00 15 0.63% 0.63% 0 0.00% 0.00% 0.00
24 Backburner 1.00 15 0.63% 0.63% 0 0.00% 0.00% 0.00
25 Machina 2.00 12 0.51% 0.51% 8 7.08% 7.08% 0.67
26 Ambassador 1.00 12 0.51% 0.51% 1 0.88% 0.88% 0.08
27 Scout Pistol 1.50 11 0.46% 0.46% 0 0.00% 0.00% 0.00
28 The Sandman 1.75 10 0.42% 0.42% 0 0.00% 0.00% 0.00
29 Sentry Gun (Level 1) 1.00 10 0.42% 0.42% 0 0.00% 0.00% 0.00
30 The Bushwacka 2.00 10 0.42% 0.42% 0 0.00% 0.00% 0.00
31 Bat 2.00 9 0.38% 0.38% 0 0.00% 0.00% 0.00
32 Engy Shotgun 1.00 8 0.34% 0.34% 0 0.00% 0.00% 0.00
33 Frontier Justice 1.00 8 0.34% 0.34% 0 0.00% 0.00% 0.00
34 Axtinguisher 2.00 8 0.34% 0.34% 0 0.00% 0.00% 0.00
35 Reserve Shooter 2.00 7 0.30% 0.30% 0 0.00% 0.00% 0.00
36 Submachine Gun 1.00 6 0.25% 0.25% 0 0.00% 0.00% 0.00
37 Kukri 2.00 6 0.25% 0.25% 0 0.00% 0.00% 0.00
38 Southern Hospitality 2.00 5 0.21% 0.21% 0 0.00% 0.00% 0.00
39 Soldier Shotgun 1.00 5 0.21% 0.21% 0 0.00% 0.00% 0.00
40 Cow Mangler 5000 1.00 5 0.21% 0.21% 0 0.00% 0.00% 0.00
41 Pyro Shotgun 1.00 4 0.17% 0.17% 0 0.00% 0.00% 0.00
42 Direct Hit 1.00 4 0.17% 0.17% 0 0.00% 0.00% 0.00
43 Conscientious Objector 2.00 4 0.17% 0.17% 0 0.00% 0.00% 0.00
44 Sharpened Volcano Fragment 2.00 4 0.17% 0.17% 0 0.00% 0.00% 0.00
45 Flaregun 2.00 4 0.17% 0.17% 0 0.00% 0.00% 0.00
46 Syringe Gun 1.00 3 0.13% 0.13% 0 0.00% 0.00% 0.00
47 Detonator 2.00 3 0.13% 0.13% 0 0.00% 0.00% 0.00
48 Wrench 2.00 2 0.08% 0.08% 0 0.00% 0.00% 0.00
49 Winger 1.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
50 Eyelander 2.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
51 Splendid Screen 2.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
52 Shahanshah 2.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
53 Righteous Bison 2.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
54 Revolver 1.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
55 Original 2.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
56 Engy Pistol 1.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
57 Persian Persuader 2.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
58 The Claidheamohmor 2.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
59 The Candy Cane 2.00 1 0.04% 0.04% 0 0.00% 0.00% 0.00
60 Bleed Kill 1.80 1 0.04% 0.04% 0 0.00% 0.00% 0.00
61 Atomizer 2.00 1 0.04% 0.04% 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 / 2372 * 100, 2) AS kpercent,
			ROUND(headshots / 113 * 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