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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		63.00%
Members:	26 active members (296 total)
Avg. Member Points:	10,868
Total Kills:	188,685
Total Deaths:	189,726
Avg. Kills:	7,257
Kills per Death:	0.99
Kills per Minute:	0.63
Total Connection Time:	207d 17:04:29h
Avg. Connection Time:	7d 23:44:01h
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,002		0d 00:21:17h	1		0.00%	2	0.50
9	(2)NONAME	1,003		0d 00:39:53h	4		0.00%	9	0.44
10	(2)-7	1,018		0d 00:29:38h	4		0.00%	2	2.00
11	(2)NONAME	1,024		0d 01:55:49h	18		0.01%	31	0.58
12	(2)NONAME	1,061		0d 02:19:08h	32		0.02%	70	0.46
13	(2)NONAME	1,700		0d 05:17:05h	74		0.04%	144	0.51
14	(2)NONAME	2,925		0d 07:35:07h	117		0.06%	106	1.10
15	(2)NONAME	5,948		0d 14:45:08h	299		0.16%	372	0.80
16	(2)NONAME	14,184		3d 05:50:12h	1,161		0.62%	2,620	0.44
17	(2)NONAME	14,517		2d 03:25:50h	1,295		0.69%	1,659	0.78
18	(2)NONAME	16,436		6d 13:14:02h	4,560		2.42%	7,055	0.65
19	(2)NONAME	17,741		1d 19:37:29h	1,123		0.60%	1,085	1.04
20	(2)NONAME	17,762		2d 16:05:39h	1,822		0.97%	2,263	0.81

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Triple Kill (3 kills)	54 times	108
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	Rampage (5 kills)	1 times	4
5	Plant the Bomb	48 times	480
6	Pick up the Bomb	144 times	288
7	Mega Kill (6 kills)	1 times	5
8	Headshot	395 times	395
9	Drop the Bomb	88 times	-176
10	Double Kill (2 kills)	163 times	163
11	Domination (4 kills)	20 times	60
12	Defuse the Bomb	2 times	20

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	155 times		24.26%
2	Counter-Terrorist	135 times		21.13%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.40	4		0.00%	4		0.01%	1.00
2		1.50	1		0.00%	1		0.00%	1.00
3		1.40	3		0.00%	3		0.00%	1.00
4		1.20	11		0.01%	8		0.01%	0.73
5		1.00	11		0.01%	6		0.01%	0.55
6		1.00	150		0.08%	77		0.13%	0.51
7		1.20	206		0.11%	106		0.18%	0.51
8		1.20	10		0.01%	5		0.01%	0.50
9		1.10	2		0.00%	1		0.00%	0.50
10		1.20	146		0.08%	68		0.11%	0.47
11		1.40	17		0.01%	8		0.01%	0.47
12		1.00	104		0.06%	49		0.08%	0.47
13		1.20	9		0.00%	4		0.01%	0.44
14		1.50	7		0.00%	3		0.00%	0.43
15		1.00	4		0.00%	1		0.00%	0.25
16		0.80	5		0.00%	1		0.00%	0.20
17		1.00	302		0.16%	49		0.08%	0.16
18		0.80	9		0.00%	1		0.00%	0.11
19		1.20	1		0.00%	0		0.00%	0.00
20		2.00	12		0.01%	0		0.00%	0.00
21		1.80	17		0.01%	0		0.00%	0.00
22		1.00	3		0.00%	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 / 188685 * 100, 2) AS kpercent,
			ROUND(headshots / 60198 * 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