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

Sections

Clan Information

Statistics Summary
Clan:	SAC
Home Page:
Activity:		70.46%
Members:	15 active members (51 total)
Avg. Member Points:	693
Total Kills:	20,604
Total Deaths:	18,808
Avg. Kills:	1,374
Kills per Death:	1.10
Kills per Minute:	2.76
Total Connection Time:	5d 04:25:43h
Avg. Connection Time:	0d 08:17:42h
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	NOVOCAINE [SAC]	1,027		0d 00:12:26h	32		0.16%	23	1.39
2	BearableToe [SAC]	1,002		0d 00:00:59h	1		0.00%	0	1.00
3	GordieGetsBusy [SAC]	808		0d 02:07:43h	248		1.20%	233	1.06
4	Dark Simon DK [SAC]	780		0d 02:00:05h	328		1.59%	237	1.38
5	MF PLATYPUS [SAC]	770		2d 10:22:42h	12,737		61.82%	9,418	1.35
6	MickeyPro [SAC]	717		0d 01:21:29h	210		1.02%	272	0.77
7	Captavenger [SAC]	652		0d 09:43:20h	1,972		9.57%	1,548	1.27
8	Dark Cavalier [SAC]	646		0d 07:10:11h	737		3.58%	825	0.89
9	GOMER==>> [SAC]	636		0d 02:42:52h	298		1.45%	432	0.69
10	yodasarmpit [SAC]	626		0d 01:10:15h	148		0.72%	183	0.81
11	Lithium [SAC]	614		0d 03:28:28h	386		1.87%	324	1.19
12	GET THE SHAFT [SAC]	604		0d 02:36:14h	324		1.57%	476	0.68
13	Maj. DonnieBaker [SAC]	572		0d 05:31:37h	672		3.26%	855	0.79
14	Copperfield [SAC]	567		0d 03:15:11h	335		1.63%	400	0.84
15	BoB FroM AcccountinG [SAC]	374		1d 00:42:11h	2,176		10.56%	3,582	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	109 times	109
2	Triple Kill (3 kills)	50 times	100
3	Domination (4 kills)	19 times	57
4	Rampage (5 kills)	7 times	28
5	Mega Kill (6 kills)	3 times	15

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Allies	57 times		23.85%
2	Axis	56 times		23.43%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	112 times	99.12%		714	836	0.85
2	American Rifleman	1 times	0.88%		0	4	0.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	90		0.44%	0		0.00%	0.00
2		1.25	82		0.40%	0		0.00%	0.00
3		1.50	76		0.37%	0		0.00%	0.00
4		1.20	61		0.30%	0		0.00%	0.00
5		3.00	59		0.29%	0		0.00%	0.00
6		1.30	53		0.26%	0		0.00%	0.00
7		1.30	46		0.22%	0		0.00%	0.00
8		1.35	44		0.21%	0		0.00%	0.00
9		1.20	44		0.21%	0		0.00%	0.00
10		1.50	43		0.21%	0		0.00%	0.00
11		1.50	37		0.18%	0		0.00%	0.00
12		1.25	30		0.15%	0		0.00%	0.00
13		1.20	17		0.08%	0		0.00%	0.00
14		2.25	12		0.06%	0		0.00%	0.00
15		2.25	8		0.04%	0		0.00%	0.00
16		3.00	5		0.02%	0		0.00%	0.00
17		1.60	5		0.02%	0		0.00%	0.00
18		1.50	2		0.01%	0		0.00%	0.00
19		1.00	1		0.00%	0		0.00%	0.00
20		1.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 / 20604 * 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