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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		61.56%
Members:	25 active members (295 total)
Avg. Member Points:	10,268
Total Kills:	103,183
Total Deaths:	103,803
Avg. Kills:	4,127
Kills per Death:	0.99
Kills per Minute:	0.52
Total Connection Time:	138d 19:36:35h
Avg. Connection Time:	5d 13:15:51h
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	992		0d 00:26:36h	0		0.00%	6	0.00
2	(2)NONAME	1,000		0d 00:07:02h	0		0.00%	0	0.00
3	(2)NONAME	1,000		0d 00:05:58h	0		0.00%	0	0.00
4	(2)NONAME	1,000		0d 00:14:46h	0		0.00%	0	0.00
5	(2)NONAME	1,000		0d 00:00:28h	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,001		0d 00:04:43h	0		0.00%	2	0.00
8	(2)NONAME	1,003		0d 00:39:53h	4		0.00%	9	0.44
9	(2)NONAME	14,184		3d 05:50:12h	1,161		1.13%	2,620	0.44
10	(2)NONAME	1,061		0d 02:19:08h	32		0.03%	70	0.46
11	(2)NONAME	1,002		0d 00:21:17h	1		0.00%	2	0.50
12	(2)NONAME	1,700		0d 05:17:05h	74		0.07%	144	0.51
13	(2)NONAME	1,024		0d 01:55:49h	18		0.02%	31	0.58
14	(2)NONAME	16,436		6d 13:14:02h	4,560		4.42%	7,055	0.65
15	(2)NONAME	14,517		2d 03:25:50h	1,295		1.26%	1,659	0.78
16	(2)NONAME	5,948		0d 14:45:08h	299		0.29%	372	0.80
17	(2)NONAME	17,762		2d 16:05:39h	1,822		1.77%	2,263	0.81
18	(2)COC	22,864		3d 22:04:36h	2,110		2.04%	2,388	0.88
19	(2)NONAME	18,300		3d 04:56:21h	2,294		2.22%	2,382	0.96
20	(2)COC	33,677		58d 10:18:55h	42,335		41.03%	43,863	0.97

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	Counter-Terrorist	94 times		21.96%
2	Terrorist	101 times		23.60%

Weapon Usage *

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