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

Sections

Clan Information

Statistics Summary
Clan:	SAC
Home Page:
Activity:		78.17%
Members:	23 active members (59 total)
Avg. Member Points:	688
Total Kills:	29,049
Total Deaths:	27,265
Avg. Kills:	1,263
Kills per Death:	1.07
Kills per Minute:	2.62
Total Connection Time:	7d 16:27:03h
Avg. Connection Time:	0d 08:01:10h
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	Mudpug [SAC]	1,000		0d 00:00:00h	0		0.00%	0	0.00
2	Skirrner [SAC]	1,000		0d 00:00:06h	0		0.00%	0	0.00
3	Thrillhouse™ [SAC]	1,000		0d 00:00:12h	0		0.00%	0	0.00
4	Casanova Funkenstein[SAC]	994		0d 00:04:03h	0		0.00%	3	0.00
5	DStriker [SAC]	1,028		0d 00:10:46h	15		0.05%	4	3.75
6	Death Knell [SAC]	840		0d 01:07:23h	34		0.12%	115	0.30
7	FiveseveN [SAC]	692		0d 01:11:31h	181		0.62%	149	1.21
8	Klaytos [SAC]	624		0d 02:02:10h	282		0.97%	319	0.88
9	yodasarmpit [SAC]	435		0d 02:16:33h	278		0.96%	369	0.75
10	Dark Simon DK [SAC]	783		0d 03:55:14h	633		2.18%	427	1.48
11	GordieGetsBusy [SAC]	521		0d 03:40:19h	516		1.78%	491	1.05
12	Copperfield [SAC]	549		0d 04:25:59h	435		1.50%	515	0.84
13	GOMER==>> [SAC]	545		0d 03:12:46h	364		1.25%	526	0.69
14	MickeyPro [SAC]	489		0d 03:22:08h	483		1.66%	573	0.84
15	Lithium [SAC]	717		0d 07:23:54h	883		3.04%	734	1.20
16	Little Toe [SAC]	697		0d 05:34:26h	904		3.11%	760	1.19
17	GET THE SHAFT [SAC]	699		0d 04:23:30h	644		2.22%	774	0.83
18	6th\| [415] Mudpug [SAC]	371		0d 08:58:15h	890		3.06%	1,178	0.76
19	Maj. DonnieBaker [SAC]	530		0d 08:11:02h	1,002		3.45%	1,275	0.79
20	Captavenger [SAC]	658		0d 10:45:39h	2,186		7.53%	1,734	1.26

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	247 times	247
2	Triple Kill (3 kills)	105 times	210
3	Domination (4 kills)	61 times	183
4	Rampage (5 kills)	26 times	104
5	Mega Kill (6 kills)	16 times	80
6	Ownage (7 kills)	3 times	18
7	Killing Spree (9 kills)	3 times	24
8	Ultra Kill (8 kills)	2 times	14
9	God Like (12+ kills)	1 times	11
10	Bomb Planter Killed	1 times	2

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	139 times		24.39%
2	Allies	135 times		23.68%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	274 times	98.92%		1,946	1,945	1.00
2	American Sniper	2 times	0.72%		12	17	0.71
3	American Machine Gunner	1 times	0.36%		5	1	5.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	239		0.82%	0		0.00%	0.00
2		1.25	205		0.71%	0		0.00%	0.00
3		1.50	188		0.65%	0		0.00%	0.00
4		3.00	179		0.62%	0		0.00%	0.00
5		1.20	171		0.59%	0		0.00%	0.00
6		1.30	152		0.52%	0		0.00%	0.00
7		2.00	139		0.48%	0		0.00%	0.00
8		1.35	134		0.46%	0		0.00%	0.00
9		1.20	117		0.40%	0		0.00%	0.00
10		1.50	100		0.34%	0		0.00%	0.00
11		1.50	89		0.31%	0		0.00%	0.00
12		1.25	71		0.24%	0		0.00%	0.00
13		1.20	69		0.24%	0		0.00%	0.00
14		2.25	45		0.15%	0		0.00%	0.00
15		2.25	24		0.08%	0		0.00%	0.00
16		1.60	14		0.05%	0		0.00%	0.00
17		1.50	12		0.04%	0		0.00%	0.00
18		1.00	4		0.01%	0		0.00%	0.00
19		1.00	4		0.01%	0		0.00%	0.00
20		1.00	3		0.01%	0		0.00%	0.00
21		1.00	2		0.01%	0		0.00%	0.00
22		10.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 / 29049 * 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