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

  Sections

  Clan Information

Statistics Summary
Clan: 3
Home Page:
Activity: 49.15% 49.15%
Members: 13 active members (74 total)
Avg. Member Points: 10,143
Total Kills: 26,607
Total Deaths: 19,292
Avg. Kills: 2,047
Kills per Death: 1.38
Kills per Minute: 0.69
Total Connection Time: 26d 18:35:55h
Avg. Connection Time: 2d 01:25:50h
Favorite Server:* GAMER.KG | CS:S Public Classic
Favorite Map:* de_dust2
Favorite Weapon:* Arctic Warfare Magnum (Police)
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  No Country(3)COC 49,812 100% 17d 07:51:53h 18,242 68.56% 68.56% 11,754 1.55
2  No Country(3)NONAME 19,144 77% 2d 18:25:02h 2,699 10.14% 10.14% 2,064 1.31
3  No Country(3)NONAME 16,987 84% 2d 04:36:27h 2,266 8.52% 8.52% 1,916 1.18
4  No Country(3)NONAME 14,504 32% 1d 13:29:17h 1,289 4.84% 4.84% 1,113 1.16
5  No Country(3)NONAME 12,745 35% 0d 23:33:31h 962 3.62% 3.62% 719 1.34
6  Kyrgyzstan(3)NONAME 11,533 95% 1d 19:27:12h 1,126 4.23% 4.23% 1,684 0.67
7  No Country(3)NONAME 1,105 52% 0d 02:05:32h 23 0.09% 0.09% 25 0.92
8  No Country(3)NONAME 1,017 95% 0d 00:23:50h 0 0.00% 0.00% 9 0.00
9  No Country(3)NONAME 1,006 7% 0d 00:18:55h 0 0.00% 0.00% 6 0.00
10  No Country(3)NONAME 1,004 17% 0d 00:06:46h 0 0.00% 0.00% 0 0.00
11  No Country(3)NONAME 1,000 21% 0d 00:02:40h 0 0.00% 0.00% 0 0.00
12  No Country(3)NONAME 1,000 7% 0d 00:00:37h 0 0.00% 0.00% 0 0.00
13  No Country(3)NONAME 996 17% 0d 00:14:13h 0 0.00% 0.00% 2 0.00




  Player Actions *





  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 18 times 24.00% 24.00%
2 Terrorist 16 times 21.33% 21.33%




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-ascending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Fusil Automatique 1.00 1 0.00% 0.00% 0 0.00% 0.00% 0.00
2 High Explosive Grenade 1.80 1 0.00% 0.00% 0 0.00% 0.00% 0.00
3 Bundeswehr Advanced Combat Knife 2.00 1 0.00% 0.00% 0 0.00% 0.00% 0.00
4 H&K MP5-Navy 1.20 1 0.00% 0.00% 0 0.00% 0.00% 0.00
5 Kalashnikov AK-47 1.00 5 0.02% 0.02% 2 0.02% 0.02% 0.40
6 FN P90 1.20 7 0.03% 0.03% 1 0.01% 0.01% 0.14
7 Colt M4A1 Carbine 1.00 16 0.06% 0.06% 9 0.10% 0.10% 0.56
8 Desert Eagle .50AE 1.20 34 0.13% 0.13% 20 0.23% 0.23% 0.59
9 Arctic Warfare Magnum (Police) 1.00 90 0.34% 0.34% 7 0.08% 0.08% 0.08




ERROR
Database Error

Server Address: 176.126.167.7
Server Username: mwa

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