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

Sections

Clan Information

Statistics Summary
Clan:	SAC
Home Page:
Activity:		57.30%
Members:	13 active members (53 total)
Avg. Member Points:	694
Total Kills:	7,730
Total Deaths:	8,961
Avg. Kills:	595
Kills per Death:	0.86
Kills per Minute:	2.01
Total Connection Time:	2d 16:11:54h
Avg. Connection Time:	0d 04:56:18h
Favorite Server:*	Adult Gamers Community - DOD:S Gungame
Favorite Map:*	dod_island_of_sodor_b1
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.19%	4	3.75
2	Bucket [SAC]	1,005		0d 00:15:32h	36		0.47%	37	0.97
3	GordieGetsBusy [SAC]	808		0d 02:07:43h	248		3.21%	233	1.06
4	Dark Simon DK [SAC]	785		0d 02:01:19h	334		4.32%	241	1.39
5	FiveseveN [SAC]	730		0d 00:58:15h	134		1.73%	110	1.22
6	MickeyPro [SAC]	673		0d 01:32:05h	232		3.00%	291	0.80
7	Lithium [SAC]	651		0d 03:44:47h	409		5.29%	344	1.19
8	Captavenger [SAC]	640		0d 10:20:11h	2,104		27.22%	1,655	1.27
9	Grateful transporter [SAC]	609		0d 01:06:34h	120		1.55%	175	0.69
10	Maj. DonnieBaker [SAC]	577		0d 06:15:14h	786		10.17%	995	0.79
11	Copperfield [SAC]	576		0d 03:32:09h	374		4.84%	441	0.85
12	Dark Cavalier [SAC]	571		0d 07:24:38h	760		9.83%	852	0.89
13	BoB FroM AcccountinG [SAC]	373		1d 00:42:49h	2,178		28.18%	3,583	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Ownage (7 kills)	1 times	6
2	Mega Kill (6 kills)	2 times	10
3	Ultra Kill (8 kills)	2 times	14
4	Rampage (5 kills)	3 times	12
5	Domination (4 kills)	19 times	57
6	Triple Kill (3 kills)	29 times	58
7	Double Kill (2 kills)	66 times	66

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	33 times		24.44%
2	Allies	32 times		23.70%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	65 times	100.00%		474	476	1.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	54		0.70%	0		0.00%	0.00
2		1.50	23		0.30%	0		0.00%	0.00
3		3.00	37		0.48%	0		0.00%	0.00
4		2.25	14		0.18%	0		0.00%	0.00
5		1.50	7		0.09%	0		0.00%	0.00
6		1.35	27		0.35%	0		0.00%	0.00
7		1.25	48		0.62%	0		0.00%	0.00
8		1.20	21		0.27%	0		0.00%	0.00
9		1.20	38		0.49%	0		0.00%	0.00
10		1.50	20		0.26%	0		0.00%	0.00
11		1.30	30		0.39%	0		0.00%	0.00
12		1.30	34		0.44%	0		0.00%	0.00
13		1.00	4		0.05%	0		0.00%	0.00
14		1.00	4		0.05%	0		0.00%	0.00
15		1.60	10		0.13%	0		0.00%	0.00
16		1.50	41		0.53%	0		0.00%	0.00
17		2.25	11		0.14%	0		0.00%	0.00
18		1.20	29		0.38%	0		0.00%	0.00
19		3.00	1		0.01%	0		0.00%	0.00
20		1.25	21		0.27%	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 / 7730 * 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 asc,
			kills asc