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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		60.37%
Members:	40 active members (298 total)
Avg. Member Points:	6,123
Total Kills:	205,263
Total Deaths:	155,524
Avg. Kills:	5,132
Kills per Death:	1.32
Kills per Minute:	0.72
Total Connection Time:	198d 07:32:39h
Avg. Connection Time:	4d 22:59:18h
Favorite Server:*	GAMER.KG \| CS:S Public Classic
Favorite Map:*	de_tessa
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	(2)asd	976		0d 01:28:29h	0		0.00%	16	0.00
2	(2)NONAME	977		0d 02:30:29h	1		0.00%	13	0.08
3	(2)NONAME	986		0d 01:14:34h	0		0.00%	7	0.00
4	(2)NONAME	990		0d 01:30:45h	0		0.00%	10	0.00
5	(2)тимачо	992		0d 00:40:53h	0		0.00%	6	0.00
6	(2)NONAME	994		0d 00:09:11h	1		0.00%	4	0.25
7	(2)NONAME	998		0d 00:32:53h	0		0.00%	1	0.00
8	(2)NONAME	1,000		0d 00:02:52h	0		0.00%	0	0.00
9	(2)NONAME	1,000		0d 00:10:48h	0		0.00%	0	0.00
10	(2)NONAME	1,000		0d 00:00:00h	0		0.00%	0	0.00
11	(2)NONAME	1,000		0d 00:02:26h	0		0.00%	0	0.00
12	(2)-7	1,000		0d 00:02:31h	0		0.00%	0	0.00
13	(2)NONAME	1,001		0d 03:20:40h	10		0.00%	29	0.34
14	(2)NONAME	1,002		0d 00:14:57h	0		0.00%	2	0.00
15	(2)NONAME	1,033		0d 03:24:28h	4		0.00%	10	0.40
16	(2)qwerty	1,036		0d 04:09:23h	35		0.02%	44	0.80
17	(2)NONAME	1,047		0d 01:05:00h	17		0.01%	8	2.13
18	(2)NONAME	1,061		0d 00:51:12h	22		0.01%	17	1.29
19	(2)NONAME	1,079		0d 06:26:23h	34		0.02%	111	0.31
20	(2)NONAME	1,128		0d 05:22:23h	39		0.02%	87	0.45

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	258 times	258
2	Double Kill (2 kills)	88 times	88
3	Pick up the Bomb	71 times	142
4	Drop the Bomb	49 times	-98
5	Triple Kill (3 kills)	34 times	68
6	Plant the Bomb	13 times	130
7	Domination (4 kills)	8 times	24
8	Start Defusing the Bomb With a Defuse Kit	5 times	0
9	Touch a Hostage	4 times	0
10	Rampage (5 kills)	4 times	16
11	Start Defusing the Bomb Without a Defuse Kit	3 times	0
12	Defuse the Bomb	3 times	30
13	Ownage (7 kills)	1 times	6
14	Kill a Hostage	1 times	-15

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	109 times		22.76%
2	Terrorist	91 times		19.00%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.20	281		0.14%	146		0.10%	0.52
2		1.00	123		0.06%	18		0.01%	0.15
3		1.20	69		0.03%	40		0.03%	0.58
4		1.00	32		0.02%	16		0.01%	0.50
5		1.00	24		0.01%	10		0.01%	0.42
6		0.80	11		0.01%	4		0.00%	0.36
7		1.40	9		0.00%	5		0.00%	0.56
8		1.40	9		0.00%	4		0.00%	0.44
9		1.80	5		0.00%	0		0.00%	0.00
10		1.00	4		0.00%	2		0.00%	0.50
11		1.20	4		0.00%	1		0.00%	0.25
12		1.20	4		0.00%	2		0.00%	0.50
13		2.00	4		0.00%	0		0.00%	0.00
14		1.00	4		0.00%	3		0.00%	0.75
15		1.10	3		0.00%	3		0.00%	1.00
16		0.80	3		0.00%	1		0.00%	0.33
17		1.00	3		0.00%	2		0.00%	0.67
18		1.10	2		0.00%	0		0.00%	0.00
19		1.20	2		0.00%	0		0.00%	0.00
20		1.50	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 / 205263 * 100, 2) AS kpercent,
			ROUND(headshots / 139662 * 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