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

  Sections

  Clan Information

Statistics Summary
Clan: 3
Home Page:
Activity: 52.70% 52.70%
Members: 10 active members (76 total)
Avg. Member Points: 8,315
Total Kills: 18,369
Total Deaths: 20,274
Avg. Kills: 1,837
Kills per Death: 0.91
Kills per Minute: 0.48
Total Connection Time: 26d 10:38:51h
Avg. Connection Time: 2d 15:27:53h
Favorite Server:* GAMER.KG | CS:S Public Classic
Favorite Map:* de_dust2
Favorite Weapon:* Arctic Warfare Magnum (Police)
Player Locations

  Members

Rank Name Points Activity Time Kills Clan Kills % Deaths Kpd sort-descending.gif
1  No Country(3)NONAME 14,618 41% 1d 09:28:11h 1,529 8.32% 8.32% 966 1.58
2  No Country(3)COC 26,342 74% 3d 12:26:33h 2,368 12.89% 12.89% 1,891 1.25
3  Kyrgyzstan(3)-7 20,855 84% 18d 09:58:33h 13,088 71.25% 71.25% 15,322 0.85
4  No Country(3)NONAME 1,480 42% 0d 08:08:27h 64 0.35% 0.35% 82 0.78
5  No Country(3)NONAME 3,479 2% 0d 17:10:48h 166 0.90% 0.90% 215 0.77
6  No Country(3)* mansbro * 12,199 27% 1d 20:12:28h 1,095 5.96% 5.96% 1,681 0.65
7  No Country(3)NONAME 1,161 92% 0d 03:41:50h 54 0.29% 0.29% 101 0.53
8  No Country(3)NONAME 1,020 16% 0d 00:58:37h 5 0.03% 0.03% 11 0.45
9  No Country(3)NONAME 1,000 60% 0d 00:16:21h 0 0.00% 0.00% 0 0.00
10  No Country(3)NONAME 998 89% 0d 00:17:03h 0 0.00% 0.00% 5 0.00




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 50 times 50
2 Pick up the Bomb 11 times 22
3 Drop the Bomb 11 times -22
4 Double Kill (2 kills) 9 times 9
5 Triple Kill (3 kills) 3 times 6
6 Domination (4 kills) 1 times 3




  Team Selection *

Rank Team sort-ascending.gif Joined Percentage of Times %
1 Counter-Terrorist 35 times 21.21% 21.21%
2 Terrorist 39 times 23.64% 23.64%




  Weapon Usage *

Rank Weapon Points Modifier Kills Percentage of Kills % Headshots Percentage of Headshots % Hpk sort-ascending.gif
1 Bundeswehr Advanced Combat Knife 2.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
2 M249 PARA Light Machine Gun 1.20 1 0.01% 0.01% 0 0.00% 0.00% 0.00
3 Benelli M3 Super 90 Combat 1.20 1 0.01% 0.01% 0 0.00% 0.00% 0.00
4 Steyr Scout 1.10 1 0.01% 0.01% 0 0.00% 0.00% 0.00
5 H&K UMP45 1.20 1 0.01% 0.01% 0 0.00% 0.00% 0.00
6 Benelli/H&K M4 Super 90 XM1014 1.10 1 0.01% 0.01% 0 0.00% 0.00% 0.00
7 Arctic Warfare Magnum (Police) 1.00 15 0.08% 0.08% 3 0.03% 0.03% 0.20
8 Kalashnikov AK-47 1.00 3 0.02% 0.02% 2 0.02% 0.02% 0.67
9 Colt M4A1 Carbine 1.00 5 0.03% 0.03% 4 0.04% 0.04% 0.80
10 Steyr Aug 1.00 1 0.01% 0.01% 1 0.01% 0.01% 1.00
11 Glock 18 Select Fire 1.40 1 0.01% 0.01% 1 0.01% 0.01% 1.00
12 FN P90 1.20 1 0.01% 0.01% 1 0.01% 0.01% 1.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 / 18369 * 100, 2) AS kpercent,
			ROUND(headshots / 10010 * 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