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

  Sections

  Clan Information

Statistics Summary
Clan: 2
Home Page:
Activity: 58.76% 58.76%
Members: 25 active members (296 total)
Avg. Member Points: 7,054
Total Kills: 20,540
Total Deaths: 23,968
Avg. Kills: 822
Kills per Death: 0.86
Kills per Minute: 0.45
Total Connection Time: 31d 18:39:04h
Avg. Connection Time: 1d 06:30:21h
Favorite Server:* GAMER.KG | CS:S Public Classic
Favorite Map:* awpcup_map2_v2
Favorite Weapon:* Arctic Warfare Magnum (Police)
Player Locations

  Members

Rank Name Points Activity Time Kills Clan Kills % Deaths sort-ascending.gif Kpd
1  No Country(2)NONAME 1,000 96% 0d 00:00:37h 0 0.00% 0.00% 0 0.00
2  No Country(2)NONAME 1,000 68% 0d 00:17:47h 0 0.00% 0.00% 0 0.00
3  No Country(2)NONAME 1,000 10% 0d 00:00:28h 0 0.00% 0.00% 0 0.00
4  No Country(2)NONAME 1,000 21% 0d 00:05:58h 0 0.00% 0.00% 0 0.00
5  No Country(2)NONAME 1,000 53% 0d 00:07:02h 0 0.00% 0.00% 0 0.00
6  No Country(2)NONAME 1,001 70% 0d 00:04:43h 0 0.00% 0.00% 2 0.00
7  No Country(2)NONAME 996 96% 0d 00:11:45h 0 0.00% 0.00% 2 0.00
8  No Country(2)NONAME 1,002 52% 0d 00:21:17h 1 0.00% 0.00% 2 0.50
9  No Country(2)-7 1,018 20% 0d 00:29:38h 4 0.02% 0.02% 2 2.00
10  No Country(2)NONAME 992 54% 0d 00:26:36h 0 0.00% 0.00% 6 0.00
11  No Country(2)NONAME 1,024 26% 0d 01:55:49h 18 0.09% 0.09% 31 0.58
12  No Country(2)NONAME 1,059 96% 0d 02:24:22h 25 0.12% 0.12% 42 0.60
13  No Country(2)NONAME 1,061 75% 0d 02:19:08h 32 0.16% 0.16% 70 0.46
14  No Country(2)NONAME 1,509 100% 0d 03:45:11h 71 0.35% 0.35% 71 1.00
15  No Country(2)NONAME 2,925 74% 0d 07:35:07h 117 0.57% 0.57% 106 1.10
16  No Country(2)NONAME 1,700 54% 0d 05:17:05h 74 0.36% 0.36% 144 0.51
17  No Country(2)NONAME 6,237 88% 0d 22:24:43h 299 1.46% 1.46% 314 0.95
18  No Country(2)NONAME 5,948 11% 0d 14:45:08h 299 1.46% 1.46% 372 0.80
19  No Country(2)NONAME 17,741 64% 1d 19:37:29h 1,123 5.47% 5.47% 1,085 1.04
20  Kyrgyzstan(2)NONAME 17,762 67% 2d 16:05:39h 1,822 8.87% 8.87% 2,263 0.81


Page: 1 2




  Player Actions *





  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 49 times 22.17% 22.17%
2 Counter-Terrorist 49 times 22.17% 22.17%




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Arctic Warfare Magnum (Police) 1.00 63 0.31% 0.31% 9 0.10% 0.10% 0.14
2 Colt M4A1 Carbine 1.00 41 0.20% 0.20% 25 0.27% 0.27% 0.61
3 Kalashnikov AK-47 1.00 33 0.16% 0.16% 15 0.16% 0.16% 0.45
4 Desert Eagle .50AE 1.20 29 0.14% 0.14% 18 0.19% 0.19% 0.62
5 Steyr Scout 1.10 11 0.05% 0.05% 11 0.12% 0.12% 1.00
6 FN P90 1.20 8 0.04% 0.04% 5 0.05% 0.05% 0.63
7 Bundeswehr Advanced Combat Knife 2.00 8 0.04% 0.04% 0 0.00% 0.00% 0.00
8 High Explosive Grenade 1.80 4 0.02% 0.02% 0 0.00% 0.00% 0.00
9 Fusil Automatique 1.00 3 0.01% 0.01% 1 0.01% 0.01% 0.33
10 H&K UMP45 1.20 1 0.00% 0.00% 1 0.01% 0.01% 1.00
11 Sig Sauer SG-552 Commando 1.00 1 0.00% 0.00% 0 0.00% 0.00% 0.00




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 / 20540 * 100, 2) AS kpercent,
			ROUND(headshots / 9325 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map asc,
			kills asc