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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		66.64%
Members:	28 active members (295 total)
Avg. Member Points:	11,134
Total Kills:	247,139
Total Deaths:	197,154
Avg. Kills:	8,826
Kills per Death:	1.25
Kills per Minute:	0.66
Total Connection Time:	260d 13:17:42h
Avg. Connection Time:	9d 07:19:55h
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)R	21,342		4d 10:38:08h	2,363		0.96%	3,158	0.75
2	(2)NONAME	1,024		0d 00:58:49h	9		0.00%	4	2.25
3	(2)NONAME	10,511		0d 15:29:25h	652		0.26%	452	1.44
4	(2)NONAME	13,807		1d 09:36:41h	1,016		0.41%	778	1.31
5	(2)NONAME	15,303		1d 15:06:30h	1,247		0.50%	981	1.27
6	(2)NONAME	17,756		2d 02:44:14h	1,811		0.73%	1,567	1.16
7	(2)NONAME	17,472		1d 23:11:55h	1,270		0.51%	1,167	1.09
8	(2)NONAME	3,286		0d 10:12:05h	138		0.06%	128	1.08
9	(2)NONAME	15,544		2d 00:06:01h	1,635		0.66%	1,563	1.05
10	(2)NONAME	14,530		1d 10:00:01h	1,064		0.43%	1,012	1.05
11	(2)NONAME	1,091		0d 03:35:03h	38		0.02%	38	1.00
12	(2)NONAME	11,835		1d 04:08:25h	755		0.31%	820	0.92
13	(2)NONAME	1,400		0d 05:14:24h	57		0.02%	72	0.79
14	(2)NONAME	14,478		2d 03:13:14h	1,294		0.52%	1,656	0.78
15	(2)NONAME	14,565		2d 23:40:25h	2,278		0.92%	2,965	0.77
16	(2)NONAME	4,963		0d 15:55:06h	204		0.08%	359	0.57
17	(2)NONAME	1,071		0d 06:19:05h	26		0.01%	48	0.54
18	(2)NONAME	4,977		0d 15:34:06h	281		0.11%	577	0.49
19	(2)NONAME	1,003		0d 00:39:53h	4		0.00%	9	0.44
20	(2)NONAME	1,032		0d 02:16:48h	18		0.01%	54	0.33

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Mega Kill (6 kills)	1 times	5
2	Rampage (5 kills)	7 times	28
3	Start Defusing the Bomb Without a Defuse Kit	9 times	0
4	Defuse the Bomb	11 times	110
5	Start Defusing the Bomb With a Defuse Kit	15 times	0
6	Domination (4 kills)	28 times	84
7	Plant the Bomb	52 times	520
8	Triple Kill (3 kills)	74 times	148
9	Drop the Bomb	125 times	-250
10	Pick up the Bomb	195 times	390
11	Double Kill (2 kills)	246 times	246
12	Headshot	623 times	623

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	235 times		8.52%
2	Terrorist	236 times		8.56%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.20	295		0.12%	153		0.10%	0.52
2		1.00	284		0.11%	34		0.02%	0.12
3		1.20	92		0.04%	61		0.04%	0.66
4		1.00	49		0.02%	23		0.01%	0.47
5		1.00	36		0.01%	11		0.01%	0.31
6		1.40	25		0.01%	16		0.01%	0.64
7		1.40	10		0.00%	4		0.00%	0.40
8		0.80	8		0.00%	2		0.00%	0.25
9		1.80	8		0.00%	0		0.00%	0.00
10		1.00	4		0.00%	3		0.00%	0.75
11		1.20	4		0.00%	2		0.00%	0.50
12		2.00	4		0.00%	0		0.00%	0.00
13		1.00	4		0.00%	1		0.00%	0.25
14		1.50	3		0.00%	2		0.00%	0.67
15		1.10	2		0.00%	0		0.00%	0.00
16		1.20	1		0.00%	0		0.00%	0.00
17		1.10	1		0.00%	0		0.00%	0.00
18		0.80	1		0.00%	0		0.00%	0.00
19		1.00	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 / 247139 * 100, 2) AS kpercent,
			ROUND(headshots / 156672 * 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