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

Sections

Clan Information

Statistics Summary
Clan:	SAC
Home Page:
Activity:		72.15%
Members:	13 active members (52 total)
Avg. Member Points:	695
Total Kills:	20,184
Total Deaths:	18,264
Avg. Kills:	1,553
Kills per Death:	1.11
Kills per Minute:	2.78
Total Connection Time:	5d 01:03:00h
Avg. Connection Time:	0d 09:18:41h
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	DStriker [SAC]	1,028		0d 00:10:34h	15		0.07%	4	3.75
2	NOVOCAINE [SAC]	1,027		0d 00:12:26h	32		0.16%	23	1.39
3	GordieGetsBusy [SAC]	808		0d 02:07:43h	248		1.23%	233	1.06
4	MF PLATYPUS [SAC]	770		2d 10:22:42h	12,737		63.10%	9,418	1.35
5	FiveseveN [SAC]	730		0d 00:58:15h	134		0.66%	110	1.22
6	MickeyPro [SAC]	673		0d 01:32:05h	232		1.15%	291	0.80
7	Lithium [SAC]	651		0d 03:44:47h	409		2.03%	344	1.19
8	Captavenger [SAC]	640		0d 10:01:47h	2,044		10.13%	1,601	1.28
9	GET THE SHAFT [SAC]	604		0d 02:36:14h	324		1.61%	476	0.68
10	Dark Cavalier [SAC]	603		0d 07:18:24h	746		3.70%	839	0.89
11	Copperfield [SAC]	600		0d 03:20:35h	348		1.72%	407	0.86
12	Maj. DonnieBaker [SAC]	533		0d 05:54:39h	737		3.65%	935	0.79
13	BoB FroM AcccountinG [SAC]	373		1d 00:42:49h	2,178		10.79%	3,583	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	71 times	71
2	Triple Kill (3 kills)	43 times	86
3	Domination (4 kills)	25 times	75
4	Rampage (5 kills)	7 times	28
5	Ultra Kill (8 kills)	2 times	14
6	Mega Kill (6 kills)	2 times	10

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	54 times		30.17%
2	Allies	31 times		17.32%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	84 times	100.00%		587	607	0.97

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	75		0.37%	0		0.00%	0.00
2		1.25	65		0.32%	0		0.00%	0.00
3		1.50	56		0.28%	0		0.00%	0.00
4		3.00	46		0.23%	0		0.00%	0.00
5		1.20	46		0.23%	0		0.00%	0.00
6		1.30	42		0.21%	0		0.00%	0.00
7		1.20	37		0.18%	0		0.00%	0.00
8		1.30	34		0.17%	0		0.00%	0.00
9		1.50	33		0.16%	0		0.00%	0.00
10		1.35	33		0.16%	0		0.00%	0.00
11		1.50	31		0.15%	0		0.00%	0.00
12		1.25	27		0.13%	0		0.00%	0.00
13		1.20	22		0.11%	0		0.00%	0.00
14		2.25	11		0.05%	0		0.00%	0.00
15		2.25	9		0.04%	0		0.00%	0.00
16		1.60	8		0.04%	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	3		0.01%	0		0.00%	0.00
20		1.00	2		0.01%	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 / 20184 * 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