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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		60.37%
Members:	24 active members (295 total)
Avg. Member Points:	10,654
Total Kills:	103,179
Total Deaths:	103,794
Avg. Kills:	4,299
Kills per Death:	0.99
Kills per Minute:	0.52
Total Connection Time:	138d 18:56:42h
Avg. Connection Time:	5d 18:47:21h
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:00:28h	0		0.00%	0	0.00
2	(2)NONAME	1,001		0d 00:04:43h	0		0.00%	2	0.00
3	(2)NONAME	1,000		0d 00:05:58h	0		0.00%	0	0.00
4	(2)NONAME	1,000		0d 00:07:02h	0		0.00%	0	0.00
5	(2)NONAME	1,000		0d 00:14:46h	0		0.00%	0	0.00
6	(2)NONAME	1,000		0d 00:17:47h	0		0.00%	0	0.00
7	(2)NONAME	1,002		0d 00:21:17h	1		0.00%	2	0.50
8	(2)NONAME	992		0d 00:26:36h	0		0.00%	6	0.00
9	(2)-7	1,018		0d 00:29:38h	4		0.00%	2	2.00
10	(2)NONAME	1,024		0d 01:55:49h	18		0.02%	31	0.58
11	(2)NONAME	1,061		0d 02:19:08h	32		0.03%	70	0.46
12	(2)NONAME	1,700		0d 05:17:05h	74		0.07%	144	0.51
13	(2)NONAME	2,925		0d 07:35:07h	117		0.11%	106	1.10
14	(2)NONAME	5,948		0d 14:45:08h	299		0.29%	372	0.80
15	(2)NONAME	17,741		1d 19:37:29h	1,123		1.09%	1,085	1.04
16	(2)NONAME	14,517		2d 03:25:50h	1,295		1.26%	1,659	0.78
17	(2)NONAME	17,762		2d 16:05:39h	1,822		1.77%	2,263	0.81
18	(2)NONAME	18,300		3d 04:56:21h	2,294		2.22%	2,382	0.96
19	(2)NONAME	14,184		3d 05:50:12h	1,161		1.13%	2,620	0.44
20	(2)COC	22,864		3d 22:04:36h	2,110		2.04%	2,388	0.88

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Defuse the Bomb	2 times	20
2	Domination (4 kills)	19 times	57
3	Double Kill (2 kills)	112 times	112
4	Drop the Bomb	50 times	-100
5	Headshot	285 times	285
6	Mega Kill (6 kills)	1 times	5
7	Pick up the Bomb	84 times	168
8	Plant the Bomb	32 times	320
9	Start Defusing the Bomb With a Defuse Kit	2 times	0
10	Start Defusing the Bomb Without a Defuse Kit	3 times	0
11	Triple Kill (3 kills)	43 times	86

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	100 times		23.58%
2	Counter-Terrorist	93 times		21.93%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	3		0.00%	0		0.00%	0.00
2		1.80	11		0.01%	0		0.00%	0.00
3		2.00	11		0.01%	0		0.00%	0.00
4		1.20	1		0.00%	0		0.00%	0.00
5		0.80	1		0.00%	0		0.00%	0.00
6		1.00	199		0.19%	30		0.08%	0.15
7		1.00	4		0.00%	1		0.00%	0.25
8		1.00	89		0.09%	38		0.10%	0.43
9		1.40	17		0.02%	8		0.02%	0.47
10		1.20	71		0.07%	34		0.09%	0.48
11		1.10	2		0.00%	1		0.00%	0.50
12		1.20	6		0.01%	3		0.01%	0.50
13		1.20	4		0.00%	2		0.01%	0.50
14		1.00	8		0.01%	4		0.01%	0.50
15		1.00	128		0.12%	65		0.17%	0.51
16		1.20	157		0.15%	93		0.24%	0.59
17		0.80	1		0.00%	1		0.00%	1.00
18		1.40	1		0.00%	1		0.00%	1.00
19		1.50	1		0.00%	1		0.00%	1.00
20		1.40	3		0.00%	3		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 / 103179 * 100, 2) AS kpercent,
			ROUND(headshots / 38533 * 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