- XtremeGaminG Network - HLStatsX: CE - - Counter-Strike - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	f
Home Page:
Activity:		100.00%
Members:	9 active members (9 total)
Avg. Member Points:	1,861
Total Kills:	3,675
Total Deaths:	3,805
Avg. Kills:	408
Kills per Death:	0.97
Kills per Minute:	0.78
Total Connection Time:	3d 06:36:50h
Avg. Connection Time:	0d 08:44:05h
Favorite Server:*	- XGN \| CS1.6 #05 [Zombie Plague] \| www.XGN.in.th -
Favorite Map:*	cs_italy
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	f\|ea`	5,394		1d 16:41:10h	2,334		63.51%	2,428	0.96
2	f\|ea`	2,309		0d 04:17:05h	464		12.63%	484	0.96
3	f\|ea`	1,854		0d 02:05:26h	337		9.17%	370	0.91
4	F\|Okky ZUZA <3 ` !N Th4!\|aND	1,586		1d 02:40:04h	267		7.27%	239	1.12
5	f\|ea`	1,307		0d 01:13:29h	124		3.37%	116	1.07
6	f\|ea`	1,145		0d 00:56:04h	64		1.74%	69	0.93
7	F\|ea`	1,105		0d 01:55:59h	72		1.96%	73	0.99
8	F\|L@	1,030		0d 00:31:37h	7		0.19%	16	0.44
9	f\|ea`	1,018		0d 00:15:56h	6		0.16%	10	0.60

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	51 times	51
2	Double Kill (2 kills)	12 times	12
3	Triple Kill (3 kills)	8 times	16
4	Domination (4 kills)	5 times	15
5	Rampage (5 kills)	2 times	8
6	Mega Kill (6 kills)	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	272 times		51.61%
2	Terrorist	195 times		37.00%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	38		1.03%	17		1.18%	0.45
2		1.80	29		0.79%	4		0.28%	0.14
3		1.00	15		0.41%	8		0.56%	0.53
4		0.80	15		0.41%	10		0.70%	0.67
5		1.40	14		0.38%	9		0.63%	0.64
6		1.40	2		0.05%	0		0.00%	0.00
7		1.40	1		0.03%	0		0.00%	0.00
8		1.25	1		0.03%	1		0.07%	1.00
9		1.60	1		0.03%	0		0.00%	0.00
10		1.25	1		0.03%	0		0.00%	0.00
11		1.25	1		0.03%	1		0.07%	1.00
12		1.50	1		0.03%	1		0.07%	1.00

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		8,975	1,701	67,749	15	34	11.3333	19.0%	39.8	264.0
2		1,549	66	5,680	4	31	0.9394	4.3%	86.1	50.0
3		2,240	562	21,069	8	15	15.0000	25.1%	37.5	149.3
4		600	285	28,171	10	15	15.0000	47.5%	98.8	40.0
5		133	654	22,941	6	11	11.0000	491.7%	35.1	12.1
6		93	39	2,042	1	2	2.0000	41.9%	52.4	46.5
7		53	22	2,369	0	2	2.0000	41.5%	107.7	26.5
8		114	37	1,951	0	1	1.0000	32.5%	52.7	114.0
9		665	94	2,970	1	1	1.0000	14.1%	31.6	665.0
10		238	58	1,395	0	1	1.0000	24.4%	24.1	238.0
11		461	86	2,798	1	1	1.0000	18.7%	32.5	461.0
12		13	0	0	0	0	0.0000	0.0%	0.0	0.0
13		40	0	0	0	0	0.0000	0.0%	0.0	0.0
14		18	4	140	0	0	0.0000	22.2%	35.0	0.0
15		21	0	0	0	0	0.0000	0.0%	0.0	0.0
16		78	0	0	0	0	0.0000	0.0%	0.0	0.0
17		34	28	1,009	0	0	0.0000	82.4%	36.0	0.0
18		70	9	280	0	0	0.0000	12.9%	31.1	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		1,701	29.7%	45.7%	24.6%
2		654	39.8%	38.7%	21.6%
3		562	29.2%	47.7%	23.1%
4		285	29.1%	50.2%	20.7%
5		94	38.3%	41.5%	20.2%
6		86	33.7%	50.0%	16.3%
7		58	22.4%	58.6%	19.0%
8		39	25.6%	61.5%	12.8%
9		37	27.0%	40.5%	32.4%
10		32	28.1%	50.0%	21.9%
11		28	17.9%	53.6%	28.6%
12		22	18.2%	59.1%	22.7%
13		9	22.2%	44.4%	33.3%
14		4	25.0%	50.0%	25.0%

Targets

Show total target statistics

ERROR

Database Error

Server Address: localhost:3334
Server Username: xgn_hlx_main

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