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

Sections

Clan Information

Statistics Summary
Clan:	SAC
Home Page:
Activity:		61.33%
Members:	15 active members (53 total)
Avg. Member Points:	721
Total Kills:	20,492
Total Deaths:	18,398
Avg. Kills:	1,366
Kills per Death:	1.11
Kills per Minute:	2.78
Total Connection Time:	5d 02:43:07h
Avg. Connection Time:	0d 08:10:52h
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	NOVOCAINE [SAC]	1,027		0d 00:12:26h	32		0.16%	23	1.39
3	Bucket [SAC]	1,005		0d 00:15:32h	36		0.18%	37	0.97
4	GordieGetsBusy [SAC]	808		0d 02:07:43h	248		1.21%	233	1.06
5	Dark Simon DK [SAC]	785		0d 02:01:19h	334		1.63%	241	1.39
6	MF PLATYPUS [SAC]	770		2d 10:22:42h	12,737		62.16%	9,418	1.35
7	FiveseveN [SAC]	730		0d 00:58:15h	134		0.65%	110	1.22
8	MickeyPro [SAC]	673		0d 01:32:05h	232		1.13%	291	0.80
9	Lithium [SAC]	651		0d 03:44:47h	409		2.00%	344	1.19
10	Captavenger [SAC]	640		0d 10:20:11h	2,104		10.27%	1,655	1.27
11	Grateful transporter [SAC]	599		0d 01:02:39h	113		0.55%	171	0.66
12	Maj. DonnieBaker [SAC]	577		0d 06:15:14h	786		3.84%	995	0.79
13	Copperfield [SAC]	576		0d 03:32:09h	374		1.83%	441	0.85
14	Dark Cavalier [SAC]	571		0d 07:24:38h	760		3.71%	852	0.89
15	BoB FroM AcccountinG [SAC]	373		1d 00:42:49h	2,178		10.63%	3,583	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	79 times	79
2	Triple Kill (3 kills)	36 times	72
3	Domination (4 kills)	22 times	66
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	44 times		27.67%
2	Allies	33 times		20.75%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	77 times	100.00%		557	574	0.97

Weapon Usage *

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