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

Sections

Clan Information

Statistics Summary
Clan:	2
Home Page:
Activity:		56.33%
Members:	39 active members (298 total)
Avg. Member Points:	7,204
Total Kills:	45,632
Total Deaths:	43,397
Avg. Kills:	1,170
Kills per Death:	1.05
Kills per Minute:	0.52
Total Connection Time:	61d 08:41:42h
Avg. Connection Time:	1d 13:45:41h
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)-7	1,000		0d 00:02:31h	0		0.00%	0	0.00
2	(2)NONAME	1,000		0d 00:02:26h	0		0.00%	0	0.00
3	(2)NONAME	1,000		0d 00:00:00h	0		0.00%	0	0.00
4	(2)NONAME	1,000		0d 00:10:48h	0		0.00%	0	0.00
5	(2)NONAME	1,000		0d 00:02:52h	0		0.00%	0	0.00
6	(2)NONAME	998		0d 00:32:53h	0		0.00%	1	0.00
7	(2)NONAME	990		0d 01:30:45h	0		0.00%	10	0.00
8	(2)NONAME	986		0d 01:14:34h	0		0.00%	7	0.00
9	(2)asd	976		0d 01:28:29h	0		0.00%	16	0.00
10	(2)NONAME	977		0d 02:30:29h	1		0.00%	13	0.08
11	(2)NONAME	994		0d 00:09:11h	1		0.00%	4	0.25
12	(2)NONAME	1,033		0d 03:24:28h	4		0.01%	10	0.40
13	(2)NONAME	1,024		0d 00:58:49h	9		0.02%	4	2.25
14	(2)NONAME	1,001		0d 03:20:40h	10		0.02%	29	0.34
15	(2)NONAME	1,032		0d 01:53:38h	11		0.02%	43	0.26
16	(2)NONAME	1,047		0d 01:05:00h	17		0.04%	8	2.13
17	(2)NONAME	1,061		0d 00:51:12h	22		0.05%	17	1.29
18	(2)qwerty	1,036		0d 04:09:23h	35		0.08%	44	0.80
19	(2)NONAME	1,128		0d 05:22:23h	39		0.09%	87	0.45
20	(2)NONAME	1,196		0d 02:49:10h	51		0.11%	75	0.68

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	73 times	73
2	Double Kill (2 kills)	30 times	30
3	Pick up the Bomb	29 times	58
4	Drop the Bomb	21 times	-42
5	Triple Kill (3 kills)	11 times	22
6	Plant the Bomb	5 times	50
7	Start Defusing the Bomb With a Defuse Kit	2 times	0
8	Rampage (5 kills)	2 times	8
9	Domination (4 kills)	2 times	6

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	74 times		22.91%
2	Terrorist	68 times		21.05%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	1		0.00%	0		0.00%	0.00
2		1.80	2		0.00%	0		0.00%	0.00
3		1.50	1		0.00%	1		0.00%	1.00
4		1.40	5		0.01%	2		0.01%	0.40
5		1.40	1		0.00%	0		0.00%	0.00
6		1.20	4		0.01%	0		0.00%	0.00
7		1.20	21		0.05%	11		0.05%	0.52
8		1.20	4		0.01%	1		0.00%	0.25
9		1.20	4		0.01%	2		0.01%	0.50
10		1.20	1		0.00%	0		0.00%	0.00
11		1.20	30		0.07%	16		0.08%	0.53
12		1.10	1		0.00%	0		0.00%	0.00
13		1.10	1		0.00%	1		0.00%	1.00
14		1.00	3		0.01%	1		0.00%	0.33
15		1.00	15		0.03%	9		0.04%	0.60
16		1.00	4		0.01%	3		0.01%	0.75
17		1.00	99		0.22%	10		0.05%	0.10
18		1.00	1		0.00%	1		0.00%	1.00
19		1.00	19		0.04%	10		0.05%	0.53
20		0.80	11		0.02%	4		0.02%	0.36
21		0.80	2		0.00%	1		0.00%	0.50

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 / 45632 * 100, 2) AS kpercent,
			ROUND(headshots / 20445 * 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