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

Sections

Clan Information

Statistics Summary
Clan:	DK
Home Page:
Activity:		94.00%
Members:	2 active members (5 total)
Avg. Member Points:	672
Total Kills:	16,512
Total Deaths:	15,589
Avg. Kills:	8,256
Kills per Death:	1.06
Kills per Minute:	2.01
Total Connection Time:	5d 16:50:21h
Avg. Connection Time:	2d 20:25:10h
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	Speedy [DK]	789		3d 23:16:01h	11,371		68.87%	9,199	1.24
2	Breum [DK]	555		1d 17:34:20h	5,141		31.13%	6,390	0.80

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	195 times	195
2	Triple Kill (3 kills)	88 times	176
3	Domination (4 kills)	41 times	123
4	Rampage (5 kills)	22 times	88
5	Mega Kill (6 kills)	13 times	65
6	Ownage (7 kills)	10 times	60
7	Ultra Kill (8 kills)	6 times	42
8	Killing Spree (9 kills)	4 times	32
9	Monster Kill (10 kills)	2 times	18
10	God Like (12+ kills)	2 times	22

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	134 times		31.98%
2	Allies	57 times		13.60%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	191 times	99.48%		1,651	1,561	1.06
2	Axis Unteroffizier	1 times	0.52%		6	5	1.20

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	164		0.99%	0		0.00%	0.00
2		1.50	104		0.63%	0		0.00%	0.00
3		3.00	57		0.35%	0		0.00%	0.00
4		2.25	32		0.19%	0		0.00%	0.00
5		1.50	14		0.08%	0		0.00%	0.00
6		1.35	120		0.73%	0		0.00%	0.00
7		1.25	165		1.00%	0		0.00%	0.00
8		1.20	68		0.41%	0		0.00%	0.00
9		1.20	146		0.88%	0		0.00%	0.00
10		1.50	94		0.57%	0		0.00%	0.00
11		1.30	128		0.78%	0		0.00%	0.00
12		1.30	141		0.85%	0		0.00%	0.00
13		1.00	9		0.05%	0		0.00%	0.00
14		1.00	7		0.04%	0		0.00%	0.00
15		1.60	21		0.13%	0		0.00%	0.00
16		1.50	160		0.97%	0		0.00%	0.00
17		2.25	51		0.31%	0		0.00%	0.00
18		1.20	114		0.69%	0		0.00%	0.00
19		3.00	1		0.01%	0		0.00%	0.00
20		1.25	74		0.45%	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 / 16512 * 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