- XtremeGaminG Network - HLStatsX: CE - - Half-Life 1 Multiplayer - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	o
Home Page:
Activity:		100.00%
Members:	63 active members (63 total)
Avg. Member Points:	963
Total Kills:	374
Total Deaths:	1,150
Avg. Kills:	6
Kills per Death:	0.33
Kills per Minute:	0.27
Total Connection Time:	0d 22:44:00h
Avg. Connection Time:	0d 00:21:39h
Favorite Server:*	- XGN \| HL:DM Free For All \| www.XGN.in.th -
Favorite Map:*	crossfire
Favorite Weapon:*	Gluon / Gauss Gun

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[o] [PNP]Concealed_Crisis	1,012		0d 00:06:28h	13		3.48%	8	1.63
2	[o] AR4I	1,010		0d 00:04:26h	6		1.60%	2	3.00
3	[o] wicKed (REPUBLIC OF KOSOVO)	1,008		0d 00:06:44h	3		0.80%	0	3.00
4	[o] Vlad_3345	1,008		0d 00:13:40h	22		5.88%	19	1.16
5	[o] Player	1,000		0d 00:04:47h	0		0.00%	0	0.00
6	[o] [ujjl-squad] Grooz	1,000		0d 00:04:38h	0		0.00%	0	0.00
7	[o] [PNP]botman;	1,000		0d 00:05:04h	0		0.00%	0	0.00
8	[o] Player	1,000		0d 00:01:31h	0		0.00%	0	0.00
9	[o] $TereL()/(	1,000		0d 00:00:11h	0		0.00%	0	0.00
10	[o] lgan	1,000		0d 00:06:38h	0		0.00%	0	0.00
11	[o] aba	1,000		0d 00:08:33h	0		0.00%	0	0.00
12	[o] No Swear	1,000		0d 00:03:28h	0		0.00%	0	0.00
13	[o] St	1,000		0d 00:04:23h	0		0.00%	0	0.00
14	[o] tu ahyel?	1,000		0d 00:08:33h	0		0.00%	0	0.00
15	[o] vaka	1,000		0d 00:04:30h	0		0.00%	0	0.00
16	[o] Newbie N8076	1,000		0d 00:00:15h	0		0.00%	0	0.00
17	[o] Zaidejas	1,000		0d 00:00:52h	0		0.00%	0	0.00
18	[o] KILLER	1,000		0d 00:05:08h	0		0.00%	0	0.00
19	[o] Player	1,000		0d 00:04:15h	0		0.00%	0	0.00
20	[o] Mistrz(PL_POLAND)	1,000		0d 00:04:30h	0		0.00%	0	0.00

Page: 1 2 3 4

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	33 times	33
2	Triple Kill (3 kills)	15 times	30
3	Domination (4 kills)	5 times	15
4	Rampage (5 kills)	2 times	8

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.60	2		0.53%	0		0.00%	0.00
2		1.00	43		11.50%	0		0.00%	0.00
3		1.80	2		0.53%	0		0.00%	0.00
4		1.20	19		5.08%	0		0.00%	0.00
5		1.50	1		0.27%	0		0.00%	0.00
6		1.00	41		10.96%	0		0.00%	0.00
7		1.30	2		0.53%	0		0.00%	0.00
8		1.00	14		3.74%	0		0.00%	0.00
9	Gluon / Gauss Gun	1.00	48		12.83%	0		0.00%	0.00
10		1.90	15		4.01%	0		0.00%	0.00
11		1.40	16		4.28%	0		0.00%	0.00
12		1.70	2		0.53%	0		0.00%	0.00
13		1.50	20		5.35%	0		0.00%	0.00
14		1.00	29		7.75%	0		0.00%	0.00
15		1.60	9		2.41%	0		0.00%	0.00

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