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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		63.77%
Members:	27 active members (295 total)
Avg. Member Points:	11,007
Total Kills:	245,838
Total Deaths:	195,491
Avg. Kills:	9,105
Kills per Death:	1.26
Kills per Minute:	0.66
Total Connection Time:	258d 09:38:37h
Avg. Connection Time:	9d 13:41:25h
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,000		0d 00:03:41h	0		0.00%	0	0.00
2	(2)NONAME	1,003		0d 00:39:53h	4		0.00%	9	0.44
3	(2)NONAME	1,024		0d 00:58:49h	9		0.00%	4	2.25
4	(2)NONAME	1,032		0d 01:53:38h	11		0.00%	43	0.26
5	(2)NONAME	1,032		0d 02:16:48h	18		0.01%	54	0.33
6	(2)NONAME	1,071		0d 06:19:05h	26		0.01%	48	0.54
7	(2)NONAME	1,091		0d 03:35:03h	38		0.02%	38	1.00
8	(2)NONAME	1,400		0d 05:14:24h	57		0.02%	72	0.79
9	(2)NONAME	3,286		0d 10:12:05h	138		0.06%	128	1.08
10	(2)COC	4,517		0d 05:47:41h	179		0.07%	113	1.58
11	(2)NONAME	4,963		0d 15:55:06h	204		0.08%	359	0.57
12	(2)NONAME	4,977		0d 15:34:06h	281		0.11%	577	0.49
13	(2)COC	12,547		0d 21:08:41h	583		0.24%	542	1.08
14	(2)NONAME	10,511		0d 15:29:25h	652		0.27%	452	1.44
15	(2)NONAME	11,835		1d 04:08:25h	755		0.31%	820	0.92
16	(2)NONAME	13,807		1d 09:36:41h	1,016		0.41%	778	1.31
17	(2)NONAME	14,530		1d 10:00:01h	1,064		0.43%	1,012	1.05
18	(2)* mansbro *	13,773		3d 21:23:55h	1,246		0.51%	1,492	0.84
19	(2)NONAME	15,303		1d 15:06:30h	1,247		0.51%	981	1.27
20	(2)NONAME	17,472		1d 23:11:55h	1,270		0.52%	1,167	1.09

Page: 1 2

Player Actions *

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

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	234 times		8.51%
2	Counter-Terrorist	234 times		8.51%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.40	25		0.01%	16		0.01%	0.64
2		1.00	4		0.00%	3		0.00%	0.75
3		0.80	8		0.00%	2		0.00%	0.25
4		1.10	2		0.00%	0		0.00%	0.00
5		1.20	290		0.12%	149		0.10%	0.51
6		1.20	1		0.00%	0		0.00%	0.00
7		1.00	49		0.02%	23		0.01%	0.47
8		1.20	2		0.00%	1		0.00%	0.50
9		2.00	4		0.00%	0		0.00%	0.00
10		1.80	8		0.00%	0		0.00%	0.00
11		1.40	10		0.00%	4		0.00%	0.40
12		1.10	1		0.00%	0		0.00%	0.00
13		0.80	1		0.00%	0		0.00%	0.00
14		1.50	3		0.00%	2		0.00%	0.67
15		1.00	4		0.00%	1		0.00%	0.25
16		1.20	92		0.04%	61		0.04%	0.66
17		1.00	284		0.12%	34		0.02%	0.12
18		1.00	1		0.00%	1		0.00%	1.00
19		1.00	36		0.01%	11		0.01%	0.31

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