HLstatsX Community Edition - [BlER]Wiese >>> Italy [ONLY] <<< - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	Mu$ho
Home Page:
Activity:		45.00%
Members:	1 active members (1 total)
Avg. Member Points:	4,059
Total Kills:	848
Total Deaths:	866
Avg. Kills:	848
Kills per Death:	0.98
Kills per Minute:	0.45
Total Connection Time:	1d 07:12:30h
Avg. Connection Time:	1d 07:12:30h
Favorite Server:*	[BlER]Wiese >>> Italy [ONLY] <<<
Favorite Map:*	cs_italy
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Oligodentrocyt[Mu$ho]	4,059		1d 07:12:30h	848		100.00%	866	0.98

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Triple Kill (3 kills)	1 times	2
2	Headshot	1 times	1
3	Double Kill (2 kills)	1 times	1

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	1 times		50.00%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	3		0.35%	1		0.23%	0.33
2		1.20	1		0.12%	0		0.00%	0.00
3		1.20	1		0.12%	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		58	10	356	1	3	1.5000	17.2%	35.6	19.3
2		78	11	247	0	1	1.0000	14.1%	22.5	78.0
3		15	2	77	0	1	1.0000	13.3%	38.5	15.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		11	18.2%	63.6%	18.2%
2		10	40.0%	60.0%	0.0%
3		2	0.0%	100.0%	0.0%

Targets

Show total target statistics

ERROR

Database Error

Server Address: localhost
Server Username: hlstats

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