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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		64.00%
Members:	24 active members (296 total)
Avg. Member Points:	10,309
Total Kills:	102,183
Total Deaths:	102,449
Avg. Kills:	4,258
Kills per Death:	1.00
Kills per Minute:	0.52
Total Connection Time:	137d 13:55:35h
Avg. Connection Time:	5d 17:34:48h
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	40,958		47d 15:25:36h	39,406		38.56%	34,744	1.13
2	(2)NONAME	2,925		0d 07:35:07h	117		0.11%	106	1.10
3	(2)NONAME	17,741		1d 19:37:29h	1,123		1.10%	1,085	1.04
4	(2)NONAME	18,300		3d 04:56:21h	2,294		2.24%	2,382	0.96
5	(2)NONAME	6,237		0d 22:24:43h	299		0.29%	314	0.95
6	(2)NONAME	17,762		2d 16:05:39h	1,822		1.78%	2,263	0.81
7	(2)NONAME	5,948		0d 14:45:08h	299		0.29%	372	0.80
8	(2)NONAME	16,436		6d 13:14:02h	4,560		4.46%	7,055	0.65
9	(2)NONAME	1,024		0d 01:55:49h	18		0.02%	31	0.58
10	(2)NONAME	1,700		0d 05:17:05h	74		0.07%	144	0.51
11	(2)NONAME	1,002		0d 00:21:17h	1		0.00%	2	0.50
12	(2)NONAME	1,061		0d 02:19:08h	32		0.03%	70	0.46
13	(2)NONAME	14,184		3d 05:50:12h	1,161		1.14%	2,620	0.44
14	(2)NONAME	1,001		0d 00:04:43h	0		0.00%	2	0.00
15	(2)NONAME	1,000		0d 00:07:02h	0		0.00%	0	0.00
16	(2)NONAME	1,000		0d 00:05:58h	0		0.00%	0	0.00
17	(2)NONAME	1,000		0d 00:17:47h	0		0.00%	0	0.00
18	(2)NONAME	1,000		0d 00:00:28h	0		0.00%	0	0.00
19	(2)NONAME	1,000		0d 00:14:46h	0		0.00%	0	0.00
20	(2)NONAME	992		0d 00:26:36h	0		0.00%	6	0.00

Page: 1 2

Player Actions *

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

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	100 times		23.58%
2	Counter-Terrorist	94 times		22.17%

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	198		0.19%	30		0.08%	0.15
6		1.00	4		0.00%	1		0.00%	0.25
7		1.00	128		0.13%	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 / 102183 * 100, 2) AS kpercent,
			ROUND(headshots / 38183 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map asc,
			kills asc