FENIX-HOME-PAGE - 6 - DeathMatch FUN ! mDk||cs.FeNix.lt - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	__
Home Page:
Activity:		87.00%
Members:	2 active members (2 total)
Avg. Member Points:	949
Total Kills:	70
Total Deaths:	133
Avg. Kills:	35
Kills per Death:	0.53
Kills per Minute:	0.93
Total Connection Time:	0d 01:15:23h
Avg. Connection Time:	0d 00:37:41h
Favorite Server:*	#DeathMatch FUN ! mDk\|\|cs.FeNix.lt
Favorite Map:*	de_dust2_3x3
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Psiho____________	1,004		0d 00:08:27h	8		11.43%	9	0.89
2	orthodox GREEK fighter___	893		0d 01:06:56h	62		88.57%	124	0.50

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Triple Kill (3 kills)	4 times	8
2	Rampage (5 kills)	1 times	4
3	Headshot	19 times	19
4	Double Kill (2 kills)	11 times	11

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		88	16	660	2	5	1.2500	18.2%	41.3	17.6
2		4,045	305	7,431	17	61	0.5755	7.5%	24.4	66.3
3		30	5	100	0	0	0.0000	16.7%	20.0	0.0
4		25	4	76	0	1	1.0000	16.0%	19.0	25.0
5		42	0	0	0	0	0.0000	0.0%	0.0	0.0
6		5	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		305	41.6%	32.5%	25.9%
2		16	43.8%	31.3%	25.0%
3		5	80.0%	0.0%	20.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 / 70 * 100, 2) AS kpercent,
			ROUND(headshots / 19 * 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