HLstatsX - Day of Defeat - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	{IP}
Home Page:
Activity:		100.00%
Members:	2 active members (2 total)
Avg. Member Points:	1,003
Total Kills:	44
Total Deaths:	17
Avg. Kills:	22
Kills per Death:	2.59
Kills per Minute:	1.34
Total Connection Time:	0d 00:32:48h
Avg. Connection Time:	0d 00:16:24h
Favorite Server:*	PIF-PAF DOD:S Public
Favorite Map:*	dod_avalanche
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	-={IP}=-\| ★Sp@rKy★	1,007		0d 00:16:32h	18		40.91%	7	2.57
2	-={IP}=-\| DJ ReD-BuLL@VoDkA	999		0d 00:16:16h	26		59.09%	10	2.60

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Rampage (5 kills)	3 times	12
2	Double Kill (2 kills)	2 times	2
3	Domination (4 kills)	2 times	6
4	Triple Kill (3 kills)	1 times	2
5	Mega Kill (6 kills)	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	2 times		33.33%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Axis Sturmtruppe	1 times	50.00%		26	10	2.60
2	Axis Scharfschütze	1 times	50.00%		18	7	2.57

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.35	25		56.82%	0		0.00%	0.00
2		1.50	5		11.36%	0		0.00%	0.00
3		3.00	2		4.55%	0		0.00%	0.00

ERROR

Database Error

Server Address: localhost
Server Username: cs

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 / 44 * 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