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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		62.43%
Members:	23 active members (294 total)
Avg. Member Points:	10,486
Total Kills:	101,884
Total Deaths:	102,135
Avg. Kills:	4,430
Kills per Death:	1.00
Kills per Minute:	0.52
Total Connection Time:	136d 15:30:52h
Avg. Connection Time:	5d 22:35:15h
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:14:46h	0		0.00%	0	0.00
3	(2)NONAME	1,000		0d 00:07:02h	0		0.00%	0	0.00
4	(2)NONAME	1,000		0d 00:05:58h	0		0.00%	0	0.00
5	(2)NONAME	1,000		0d 00:17:47h	0		0.00%	0	0.00
6	(2)NONAME	1,000		0d 00:00:28h	0		0.00%	0	0.00
7	(2)NONAME	1,001		0d 00:04:43h	0		0.00%	2	0.00
8	(2)NONAME	14,184		3d 05:50:12h	1,161		1.14%	2,620	0.44
9	(2)NONAME	1,061		0d 02:19:08h	32		0.03%	70	0.46
10	(2)NONAME	1,002		0d 00:21:17h	1		0.00%	2	0.50
11	(2)NONAME	1,700		0d 05:17:05h	74		0.07%	144	0.51
12	(2)NONAME	1,024		0d 01:55:49h	18		0.02%	31	0.58
13	(2)NONAME	16,436		6d 13:14:02h	4,560		4.48%	7,055	0.65
14	(2)NONAME	5,948		0d 14:45:08h	299		0.29%	372	0.80
15	(2)NONAME	17,762		2d 16:05:39h	1,822		1.79%	2,263	0.81
16	(2)COC	22,864		3d 22:04:36h	2,110		2.07%	2,388	0.88
17	(2)NONAME	18,300		3d 04:56:21h	2,294		2.25%	2,382	0.96
18	(2)COC	33,677		58d 10:18:55h	42,335		41.55%	43,863	0.97
19	(2)NONAME	17,741		1d 19:37:29h	1,123		1.10%	1,085	1.04
20	(2)NONAME	2,925		0d 07:35:07h	117		0.11%	106	1.10

Page: 1 2

Player Actions *

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

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	93 times		22.09%
2	Terrorist	99 times		23.52%

Weapon Usage *

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