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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		64.07%
Members:	26 active members (294 total)
Avg. Member Points:	10,873
Total Kills:	243,567
Total Deaths:	192,533
Avg. Kills:	9,368
Kills per Death:	1.27
Kills per Minute:	0.66
Total Connection Time:	255d 10:24:03h
Avg. Connection Time:	9d 19:47:04h
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)COC	31,480		168d 05:14:17h	185,748		76.26%	133,360	1.39
2	(2)COC	25,096		38d 12:07:55h	27,409		11.25%	24,407	1.12
3	(2)awp!	35,313		24d 06:57:36h	15,803		6.49%	19,789	0.80
4	(2)R	21,342		4d 10:38:08h	2,363		0.97%	3,158	0.75
5	(2)* mansbro *	13,773		3d 21:23:55h	1,246		0.51%	1,492	0.84
6	(2)NONAME	17,756		2d 02:44:14h	1,811		0.74%	1,567	1.16
7	(2)NONAME	15,544		2d 00:06:01h	1,635		0.67%	1,563	1.05
8	(2)NONAME	17,472		1d 23:11:55h	1,270		0.52%	1,167	1.09
9	(2)NONAME	15,303		1d 15:06:30h	1,247		0.51%	981	1.27
10	(2)NONAME	14,530		1d 10:00:01h	1,064		0.44%	1,012	1.05
11	(2)NONAME	13,807		1d 09:36:41h	1,016		0.42%	778	1.31
12	(2)NONAME	11,835		1d 04:08:25h	755		0.31%	820	0.92
13	(2)COC	12,547		0d 21:08:41h	583		0.24%	542	1.08
14	(2)NONAME	4,963		0d 15:55:06h	204		0.08%	359	0.57
15	(2)NONAME	4,977		0d 15:34:06h	281		0.12%	577	0.49
16	(2)NONAME	10,511		0d 15:29:25h	652		0.27%	452	1.44
17	(2)NONAME	3,286		0d 10:12:05h	138		0.06%	128	1.08
18	(2)NONAME	1,071		0d 06:19:05h	26		0.01%	48	0.54
19	(2)COC	4,517		0d 05:47:41h	179		0.07%	113	1.58
20	(2)NONAME	1,400		0d 05:14:24h	57		0.02%	72	0.79

Page: 1 2

Player Actions *

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

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	233 times		8.48%
2	Terrorist	233 times		8.48%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.20	290		0.12%	149		0.10%	0.51
2		1.00	284		0.12%	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		2.00	4		0.00%	0		0.00%	0.00
12		1.00	4		0.00%	1		0.00%	0.25
13		1.50	3		0.00%	2		0.00%	0.67
14		1.10	2		0.00%	0		0.00%	0.00
15		1.20	2		0.00%	1		0.00%	0.50
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 / 243567 * 100, 2) AS kpercent,
			ROUND(headshots / 155075 * 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