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

Sections

Clan Information

Statistics Summary
Clan:	SAC
Home Page:
Activity:		63.07%
Members:	14 active members (53 total)
Avg. Member Points:	700
Total Kills:	20,467
Total Deaths:	18,379
Avg. Kills:	1,462
Kills per Death:	1.11
Kills per Minute:	2.78
Total Connection Time:	5d 02:34:36h
Avg. Connection Time:	0d 08:45:19h
Favorite Server:*	Adult Gamers Community - DOD:S Gungame
Favorite Map:*	dod_concrete_scoutz
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	DStriker [SAC]	1,028		0d 00:10:38h	15		0.07%	4	3.75
2	Bucket [SAC]	1,005		0d 00:15:32h	36		0.18%	37	0.97
3	GordieGetsBusy [SAC]	808		0d 02:07:43h	248		1.21%	233	1.06
4	Dark Simon DK [SAC]	785		0d 02:01:19h	334		1.63%	241	1.39
5	MF PLATYPUS [SAC]	770		2d 10:22:42h	12,737		62.23%	9,418	1.35
6	FiveseveN [SAC]	730		0d 00:58:15h	134		0.65%	110	1.22
7	MickeyPro [SAC]	673		0d 01:32:05h	232		1.13%	291	0.80
8	Lithium [SAC]	651		0d 03:44:47h	409		2.00%	344	1.19
9	Captavenger [SAC]	640		0d 10:20:11h	2,104		10.28%	1,655	1.27
10	Grateful transporter [SAC]	609		0d 01:06:34h	120		0.59%	175	0.69
11	Maj. DonnieBaker [SAC]	577		0d 06:15:14h	786		3.84%	995	0.79
12	Copperfield [SAC]	576		0d 03:32:09h	374		1.83%	441	0.85
13	Dark Cavalier [SAC]	571		0d 07:24:38h	760		3.71%	852	0.89
14	BoB FroM AcccountinG [SAC]	373		1d 00:42:49h	2,178		10.64%	3,583	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	82 times	82
2	Triple Kill (3 kills)	34 times	68
3	Domination (4 kills)	21 times	63
4	Rampage (5 kills)	4 times	16
5	Ultra Kill (8 kills)	2 times	14
6	Mega Kill (6 kills)	2 times	10
7	Ownage (7 kills)	1 times	6

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	43 times		27.39%
2	Allies	33 times		21.02%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	76 times	100.00%		552	571	0.97

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	63		0.31%	0		0.00%	0.00
2		1.25	57		0.28%	0		0.00%	0.00
3		1.50	48		0.23%	0		0.00%	0.00
4		3.00	45		0.22%	0		0.00%	0.00
5		1.20	44		0.21%	0		0.00%	0.00
6		1.30	40		0.20%	0		0.00%	0.00
7		1.30	36		0.18%	0		0.00%	0.00
8		1.20	36		0.18%	0		0.00%	0.00
9		1.35	33		0.16%	0		0.00%	0.00
10		1.50	28		0.14%	0		0.00%	0.00
11		1.50	25		0.12%	0		0.00%	0.00
12		1.25	25		0.12%	0		0.00%	0.00
13		1.20	21		0.10%	0		0.00%	0.00
14		2.25	14		0.07%	0		0.00%	0.00
15		2.25	11		0.05%	0		0.00%	0.00
16		1.60	10		0.05%	0		0.00%	0.00
17		1.50	7		0.03%	0		0.00%	0.00
18		1.00	4		0.02%	0		0.00%	0.00
19		1.00	4		0.02%	0		0.00%	0.00
20		3.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 / 20467 * 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