HLstatsX Community Edition - Day of Defeat: Source - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	SAC
Home Page:
Activity:		64.00%
Members:	14 active members (51 total)
Avg. Member Points:	665
Total Kills:	20,629
Total Deaths:	18,834
Avg. Kills:	1,474
Kills per Death:	1.10
Kills per Minute:	2.76
Total Connection Time:	5d 04:39:36h
Avg. Connection Time:	0d 08:54:15h
Favorite Server:*	Adult Gamers Community - DOD:S Gungame
Favorite Map:*	cdc_mario_air_[rm]_[ob1]
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	NOVOCAINE [SAC]	1,027		0d 00:12:26h	32		0.16%	23	1.39
2	GordieGetsBusy [SAC]	808		0d 02:07:43h	248		1.20%	233	1.06
3	Dark Simon DK [SAC]	780		0d 02:00:05h	328		1.59%	237	1.38
4	MF PLATYPUS [SAC]	770		2d 10:22:42h	12,737		61.74%	9,418	1.35
5	MickeyPro [SAC]	675		0d 01:31:04h	231		1.12%	290	0.80
6	Captavenger [SAC]	652		0d 09:43:20h	1,972		9.56%	1,548	1.27
7	GOMER==>> [SAC]	636		0d 02:42:52h	298		1.44%	432	0.69
8	yodasarmpit [SAC]	626		0d 01:10:15h	148		0.72%	183	0.81
9	Lithium [SAC]	614		0d 03:28:28h	386		1.87%	324	1.19
10	GET THE SHAFT [SAC]	604		0d 02:36:14h	324		1.57%	476	0.68
11	Dark Cavalier [SAC]	602		0d 07:14:50h	740		3.59%	832	0.89
12	Maj. DonnieBaker [SAC]	572		0d 05:31:37h	672		3.26%	855	0.79
13	Copperfield [SAC]	567		0d 03:15:11h	335		1.62%	400	0.84
14	BoB FroM AcccountinG [SAC]	373		1d 00:42:49h	2,178		10.56%	3,583	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	83 times	83
2	Triple Kill (3 kills)	43 times	86
3	Domination (4 kills)	18 times	54
4	Rampage (5 kills)	7 times	28
5	Mega Kill (6 kills)	3 times	15

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	55 times		26.96%
2	Allies	42 times		20.59%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	96 times	98.97%		592	669	0.88
2	American Rifleman	1 times	1.03%		0	4	0.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	76		0.37%	0		0.00%	0.00
2		1.25	68		0.33%	0		0.00%	0.00
3		1.50	61		0.30%	0		0.00%	0.00
4		3.00	51		0.25%	0		0.00%	0.00
5		1.20	49		0.24%	0		0.00%	0.00
6		1.30	43		0.21%	0		0.00%	0.00
7		1.30	36		0.17%	0		0.00%	0.00
8		1.35	35		0.17%	0		0.00%	0.00
9		1.20	34		0.16%	0		0.00%	0.00
10		1.50	33		0.16%	0		0.00%	0.00
11		1.50	32		0.16%	0		0.00%	0.00
12		1.25	27		0.13%	0		0.00%	0.00
13		1.20	17		0.08%	0		0.00%	0.00
14		2.25	10		0.05%	0		0.00%	0.00
15		2.25	7		0.03%	0		0.00%	0.00
16		1.60	6		0.03%	0		0.00%	0.00
17		3.00	4		0.02%	0		0.00%	0.00
18		1.50	3		0.01%	0		0.00%	0.00
19		1.00	1		0.00%	0		0.00%	0.00
20		1.00	1		0.00%	0		0.00%	0.00

ERROR

Database Error

Server Address: localhost
Server Username: agc

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 / 20629 * 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