Deutsches Vaterland HLstatsXce - Deutsches.Vaterland.OldSchool - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	FRA
Home Page:
Activity:		52.00%
Members:	1 active members (1 total)
Avg. Member Points:	3,316
Total Kills:	186
Total Deaths:	291
Avg. Kills:	186
Kills per Death:	0.64
Kills per Minute:	0.38
Total Connection Time:	0d 08:03:49h
Avg. Connection Time:	0d 08:03:49h
Favorite Server:*	Deutsches.Vaterland.OldSchool
Favorite Map:*	dod_snow_bridge_beta8_v4
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	L' Ostéo Pâpate (FRA)	3,316		0d 08:03:49h	186		100.00%	291	0.64

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Area Captured	2 times	40

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1 times		25.00%
2	Allies	1 times		25.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Axis Sturmtruppe	1 times	33.33%		1	1	1.00
2	Axis Scharfschütze	1 times	33.33%
3	American Sniper	1 times	33.33%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.35	1		0.54%	0		0.00%	0.00

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		5	2	100	0	1	1.0000	40.0%	50.0	5.0
2		3	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		2	0.0%	100.0%	0.0%

Targets

Show total target statistics

ERROR

Database Error

Server Address: localhost
Server Username: hl1137

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 / 186 * 100, 2) AS kpercent,
			ROUND(headshots / 27 * 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