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

  Sections

  Clan Information

Statistics Summary
Clan: MOE
Home Page:
Activity: 100.00% 100.00%
Members: 3 active members (3 total)
Avg. Member Points: 1,092
Total Kills: 69
Total Deaths: 68
Avg. Kills: 23
Kills per Death: 1.01
Kills per Minute: 0.63
Total Connection Time: 0d 01:49:00h
Avg. Connection Time: 0d 00:36:20h
Favorite Server:* - XGN | TF2 #01 [TEST] | www.XGN.in.th -
Favorite Map:* cp_egypt_final
Favorite Weapon:* Spy-cicle
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  No Country[MOE]DeKuRaNighT [TH] 1,164 100% 0d 00:57:07h 36 52.17% 52.17% 32 1.13
2  Thailand[MOE] HaLAkU 1,070 100% 0d 00:32:05h 27 39.13% 39.13% 26 1.04
3  Thailand[Moe]ValkielY 1,042 100% 0d 00:19:48h 6 8.70% 8.70% 10 0.60




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Kill Assist 14 times 28
2 Built a sentry gun 13 times 39
3 Double Kill (2 kills) 7 times 7
4 Destroyed a sentry gun 6 times 24
5 Built a dispenser 6 times 18
6 Triple Kill (3 kills) 4 times 8
7 Attached a Sapper 3 times 6
8 Destroyed a dispenser 2 times 6
9 Rampage (5 kills) 1 times 4
10 Point Captured 1 times 5
11 Ownage (7 kills) 1 times 6
12 Killed charged medic 1 times 1
13 Kill Assist - Medic 1 times 3
14 Extinguished Teammate (Engineer) 1 times 1
15 Domination (4 kills) 1 times 3
16 Domination 1 times 5




  Victims of Player-Player Actions *





  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 9 times 33.33% 33.33%
2 The BLU 7 times 25.93% 25.93%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Spy Spy 12 times 40.00% 40.00% 34 32 1.06
2 Scout Scout 6 times 20.00% 20.00% 5 12 0.42
3 Sniper Sniper 3 times 10.00% 10.00% 0 2 0.00
4 Soldier Soldier 2 times 6.67% 6.67% 4 4 1.00
5 Pyro Pyro 2 times 6.67% 6.67% 3 2 1.50
6 Engineer Engineer 2 times 6.67% 6.67% 15 6 2.50
7 Demo Man Demo Man 2 times 6.67% 6.67% 7 8 0.88
8 Medic Medic 1 times 3.33% 3.33% 1 2 0.50




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Spy-cicle 2.00 26 37.68% 37.68% 0 0.00% 0.00% 0.00
2 Sentry Gun (Level 3) 1.00 7 10.14% 10.14% 0 0.00% 0.00% 0.00
3 Knife 2.00 6 8.70% 8.70% 0 0.00% 0.00% 0.00
4 Soda Popper 1.25 5 7.25% 7.25% 0 0.00% 0.00% 0.00
5 Liberty Launcher 1.00 4 5.80% 5.80% 0 0.00% 0.00% 0.00
6 The Claidheamohmor 2.00 4 5.80% 5.80% 0 0.00% 0.00% 0.00
7 Grenade Launcher 1.00 3 4.35% 4.35% 0 0.00% 0.00% 0.00
8 Backburner 1.00 3 4.35% 4.35% 0 0.00% 0.00% 0.00
9 Wrangler 1.00 2 2.90% 2.90% 0 0.00% 0.00% 0.00
10 Frontier Justice 1.00 2 2.90% 2.90% 0 0.00% 0.00% 0.00
11 Ambassador 1.00 2 2.90% 2.90% 0 0.00% 0.00% 0.00
12 Gunslinger 2.00 1 1.45% 1.45% 0 0.00% 0.00% 0.00
13 Sentry Gun (Level 2) 1.00 1 1.45% 1.45% 0 0.00% 0.00% 0.00
14 The Amputator 1.00 1 1.45% 1.45% 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 / 69 * 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