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

  Sections

  Clan Information

Statistics Summary
Clan: 3
Home Page:
Activity: 63.40% 63.40%
Members: 10 active members (75 total)
Avg. Member Points: 8,305
Total Kills: 18,340
Total Deaths: 20,196
Avg. Kills: 1,834
Kills per Death: 0.91
Kills per Minute: 0.48
Total Connection Time: 26d 08:40:12h
Avg. Connection Time: 2d 15:16:01h
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 sort-descending.gif Kpd
1  Kyrgyzstan(3)-7 20,855 95% 18d 09:58:33h 13,088 71.36% 71.36% 15,322 0.85
2  No Country(3)COC 26,342 85% 3d 12:26:33h 2,368 12.91% 12.91% 1,891 1.25
3  No Country(3)* mansbro * 12,199 38% 1d 20:12:28h 1,095 5.97% 5.97% 1,681 0.65
4  No Country(3)NONAME 14,618 52% 1d 09:28:11h 1,529 8.34% 8.34% 966 1.58
5  No Country(3)NONAME 3,479 13% 0d 17:10:48h 166 0.91% 0.91% 215 0.77
6  No Country(3)NONAME 1,480 53% 0d 08:08:27h 64 0.35% 0.35% 82 0.78
7  No Country(3)NONAME 1,055 100% 0d 01:43:11h 25 0.14% 0.14% 23 1.09
8  No Country(3)NONAME 1,020 27% 0d 00:58:37h 5 0.03% 0.03% 11 0.45
9  No Country(3)NONAME 998 100% 0d 00:17:03h 0 0.00% 0.00% 5 0.00
10  No Country(3)NONAME 1,000 71% 0d 00:16:21h 0 0.00% 0.00% 0 0.00




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 53 times 53
2 Double Kill (2 kills) 13 times 13
3 Drop the Bomb 9 times -18
4 Pick up the Bomb 7 times 14
5 Triple Kill (3 kills) 4 times 8
6 Start Defusing the Bomb With a Defuse Kit 1 times 0
7 Domination (4 kills) 1 times 3




  Team Selection *

Rank Team sort-descending.gif Joined Percentage of Times %
1 Terrorist 42 times 22.58% 22.58%
2 Counter-Terrorist 46 times 24.73% 24.73%




  Weapon Usage *

Rank Weapon sort-ascending.gif Points Modifier Kills Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Kalashnikov AK-47 1.00 4 0.02% 0.02% 4 0.04% 0.04% 1.00
2 Arctic Warfare Magnum (Police) 1.00 23 0.13% 0.13% 3 0.03% 0.03% 0.13
3 Desert Eagle .50AE 1.20 6 0.03% 0.03% 3 0.03% 0.03% 0.50
4 H&K G3/SG1 Sniper Rifle 0.80 1 0.01% 0.01% 0 0.00% 0.00% 0.00
5 Glock 18 Select Fire 1.40 1 0.01% 0.01% 0 0.00% 0.00% 0.00
6 Bundeswehr Advanced Combat Knife 2.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
7 Colt M4A1 Carbine 1.00 9 0.05% 0.05% 4 0.04% 0.04% 0.44
8 FN P90 1.20 2 0.01% 0.01% 1 0.01% 0.01% 0.50




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