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

Sections

Clan Information

Statistics Summary
Clan:	SAC
Home Page:
Activity:		73.04%
Members:	22 active members (58 total)
Avg. Member Points:	666
Total Kills:	28,947
Total Deaths:	27,185
Avg. Kills:	1,316
Kills per Death:	1.06
Kills per Minute:	2.63
Total Connection Time:	7d 15:40:36h
Avg. Connection Time:	0d 08:20:56h
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	MF PLATYPUS [SAC]	709		2d 16:21:35h	14,091		48.68%	10,454	1.35
2	BoB FroM AcccountinG [SAC]	399		1d 01:09:02h	2,212		7.64%	3,649	0.61
3	Angry Dirty Bastard [SAC]	550		1d 00:01:55h	2,995		10.35%	3,192	0.94
4	Captavenger [SAC]	658		0d 10:45:39h	2,186		7.55%	1,734	1.26
5	Maj. DonnieBaker [SAC]	530		0d 08:11:02h	1,002		3.46%	1,275	0.79
6	6thRb\| Mudpug [SAC]	366		0d 08:48:36h	880		3.04%	1,165	0.76
7	GET THE SHAFT [SAC]	699		0d 04:23:30h	644		2.22%	774	0.83
8	Lithium [SAC]	712		0d 07:23:38h	882		3.05%	734	1.20
9	Little Toe [SAC]	553		0d 05:24:19h	858		2.96%	732	1.17
10	MickeyPro [SAC]	489		0d 03:22:08h	483		1.67%	573	0.84
11	GOMER==>> [SAC]	545		0d 03:12:46h	364		1.26%	526	0.69
12	Copperfield [SAC]	549		0d 04:25:59h	435		1.50%	515	0.84
13	GordieGetsBusy [SAC]	546		0d 03:35:33h	509		1.76%	481	1.06
14	Dark Simon DK [SAC]	783		0d 03:55:14h	633		2.19%	427	1.48
15	yodasarmpit [SAC]	422		0d 02:13:54h	276		0.95%	368	0.75
16	Klaytos [SAC]	624		0d 02:02:10h	282		0.97%	319	0.88
17	FiveseveN [SAC]	692		0d 01:11:31h	181		0.63%	149	1.21
18	Death Knell [SAC]	840		0d 01:07:23h	34		0.12%	115	0.30
19	Casanova Funkenstein[SAC]	994		0d 00:04:03h	0		0.00%	3	0.00
20	Skirrner [SAC]	1,000		0d 00:00:06h	0		0.00%	0	0.00

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	245 times	245
2	Triple Kill (3 kills)	103 times	206
3	Domination (4 kills)	57 times	171
4	Rampage (5 kills)	27 times	108
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	Allies	135 times		23.94%
2	Axis	134 times		23.76%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	269 times	98.90%		1,912	1,920	1.00
2	American Sniper	2 times	0.74%		12	17	0.71
3	American Machine Gunner	1 times	0.37%		5	1	5.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	233		0.80%	0		0.00%	0.00
2		1.25	203		0.70%	0		0.00%	0.00
3		1.50	187		0.65%	0		0.00%	0.00
4		3.00	175		0.60%	0		0.00%	0.00
5		1.20	169		0.58%	0		0.00%	0.00
6		1.30	147		0.51%	0		0.00%	0.00
7		2.00	135		0.47%	0		0.00%	0.00
8		1.35	131		0.45%	0		0.00%	0.00
9		1.20	116		0.40%	0		0.00%	0.00
10		1.50	99		0.34%	0		0.00%	0.00
11		1.50	90		0.31%	0		0.00%	0.00
12		1.25	70		0.24%	0		0.00%	0.00
13		1.20	69		0.24%	0		0.00%	0.00
14		2.25	43		0.15%	0		0.00%	0.00
15		2.25	23		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		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 / 28947 * 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