HLstatsX ~TAMBOV-WOLF~ - - Clan Details

Clan Information

Statistics Summary
Clan:
Home Page:
Activity:		66.50%
Members:	2 active members (2 total)
Avg. Member Points:	1,730
Total Kills:	172
Total Deaths:	124
Avg. Kills:	86
Kills per Death:	1.39
Kills per Minute:	0.67
Total Connection Time:	0d 04:16:57h
Avg. Connection Time:	0d 02:08:28h
Favorite Server:*	~TAMBOFF-WOLF [NIGHT VIP] PUBLIC NOSTEAM~
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Pinokio		2,164		0d 02:21:43h	111		64.53%	77	1.44
2	Tourdana		1,295		0d 01:55:14h	61		35.47%	47	1.30

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Pick up the Bomb	5 times	10
2	Headshot	5 times	5
3	Drop the Bomb	4 times	-8
4	Round MVP	3 times	0
5	Revenge	1 times	3
6	Plant the Bomb	1 times	10

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Domination	1 times	-5

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1	P228	13	0	0	0	0	0.0000	0.0%	0.0	0.0
2	Sg552	23	4	154	1	1	1.0000	17.4%	38.5	23.0
3	Ak47	106	17	775	4	5	5.0000	16.0%	45.6	21.2

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1	Sg552	4	0.0%	100.0%	0.0%
2	Ak47	17	11.8%	70.6%	17.6%

Targets

Show total target statistics

ERROR

Database Error

Server Address: localhost
Server Username: hlstatsxce

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