FENIX-HOME-PAGE - 1 - Public mDk||cs.FeNix.lt - Clan Details - Zs

Sections

Clan Information

Statistics Summary
Clan:	Zs
Home Page:
Activity:		96.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,000
Total Kills:	7
Total Deaths:	10
Avg. Kills:	7
Kills per Death:	0.70
Kills per Minute:	0.85
Total Connection Time:	0d 00:08:14h
Avg. Connection Time:	0d 00:08:14h
Favorite Server:*	#Public mDk\|\|cs.FeNix.lt
Favorite Map:*	de_cpl_mill
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Zs \| MaKoO	1,000		0d 00:08:14h	7		100.00%	10	0.70

Player Actions *

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

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		203	28	805	3	6	1.5000	13.8%	28.8	33.8
2		28	8	161	0	1	1.0000	28.6%	20.1	28.0
3		1	0	0	0	0	0.0000	0.0%	0.0	0.0
4		32	2	57	0	0	0.0000	6.3%	28.5	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		28	25.0%	60.7%	14.3%
2		8	87.5%	0.0%	12.5%
3		2	0.0%	50.0%	50.0%

Targets

Show total target statistics

ERROR

Database Error

Server Address: 185.80.128.218
Server Username: statsx

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