GAMER.KG | HLstatsX - Counter-Strike: Source - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		65.40%
Members:	27 active members (294 total)
Avg. Member Points:	11,010
Total Kills:	245,845
Total Deaths:	195,498
Avg. Kills:	9,105
Kills per Death:	1.26
Kills per Minute:	0.66
Total Connection Time:	258d 10:04:28h
Avg. Connection Time:	9d 13:42:23h
Favorite Server:*	GAMER.KG \| CS:S Public Classic
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	(2)NONAME	1,024		0d 00:58:49h	9		0.00%	4	2.25
2	(2)COC	4,517		0d 05:47:41h	179		0.07%	113	1.58
3	(2)NONAME	10,511		0d 15:29:25h	652		0.27%	452	1.44
4	(2)COC	31,480		168d 05:14:17h	185,748		75.55%	133,360	1.39
5	(2)NONAME	13,807		1d 09:36:41h	1,016		0.41%	778	1.31
6	(2)NONAME	15,303		1d 15:06:30h	1,247		0.51%	981	1.27
7	(2)NONAME	17,756		2d 02:44:14h	1,811		0.74%	1,567	1.16
8	(2)COC	25,096		38d 12:07:55h	27,409		11.15%	24,407	1.12
9	(2)NONAME	17,472		1d 23:11:55h	1,270		0.52%	1,167	1.09
10	(2)COC	12,547		0d 21:08:41h	583		0.24%	542	1.08
11	(2)NONAME	3,286		0d 10:12:05h	138		0.06%	128	1.08
12	(2)NONAME	15,544		2d 00:06:01h	1,635		0.67%	1,563	1.05
13	(2)NONAME	14,530		1d 10:00:01h	1,064		0.43%	1,012	1.05
14	(2)NONAME	1,091		0d 03:35:03h	38		0.02%	38	1.00
15	(2)NONAME	11,835		1d 04:08:25h	755		0.31%	820	0.92
16	(2)* mansbro *	13,773		3d 21:23:55h	1,246		0.51%	1,492	0.84
17	(2)awp!	35,313		24d 06:57:36h	15,803		6.43%	19,789	0.80
18	(2)NONAME	1,400		0d 05:14:24h	57		0.02%	72	0.79
19	(2)NONAME	14,565		2d 23:40:25h	2,278		0.93%	2,965	0.77
20	(2)R	21,342		4d 10:38:08h	2,363		0.96%	3,158	0.75

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Triple Kill (3 kills)	74 times	148
2	Start Defusing the Bomb Without a Defuse Kit	9 times	0
3	Start Defusing the Bomb With a Defuse Kit	15 times	0
4	Rampage (5 kills)	7 times	28
5	Plant the Bomb	52 times	520
6	Pick up the Bomb	195 times	390
7	Mega Kill (6 kills)	1 times	5
8	Headshot	623 times	623
9	Drop the Bomb	125 times	-250
10	Double Kill (2 kills)	246 times	246
11	Domination (4 kills)	28 times	84
12	Defuse the Bomb	11 times	110

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	235 times		8.53%
2	Counter-Terrorist	235 times		8.53%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	4		0.00%	0		0.00%	0.00
2		1.80	8		0.00%	0		0.00%	0.00
3		1.50	3		0.00%	2		0.00%	0.67
4		1.40	25		0.01%	16		0.01%	0.64
5		1.40	10		0.00%	4		0.00%	0.40
6		1.20	295		0.12%	153		0.10%	0.52
7		1.20	1		0.00%	0		0.00%	0.00
8		1.20	4		0.00%	2		0.00%	0.50
9		1.20	92		0.04%	61		0.04%	0.66
10		1.10	2		0.00%	0		0.00%	0.00
11		1.10	1		0.00%	0		0.00%	0.00
12		1.00	4		0.00%	3		0.00%	0.75
13		1.00	49		0.02%	23		0.01%	0.47
14		1.00	4		0.00%	1		0.00%	0.25
15		1.00	284		0.12%	34		0.02%	0.12
16		1.00	1		0.00%	1		0.00%	1.00
17		1.00	36		0.01%	11		0.01%	0.31
18		0.80	8		0.00%	2		0.00%	0.25
19		0.80	1		0.00%	0		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 / 245845 * 100, 2) AS kpercent,
			ROUND(headshots / 156183 * 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