Gamester Counter Strike Portal - Counter-Strike - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	B-Hop
Home Page:
Activity:		100.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,008
Total Kills:	4
Total Deaths:	3
Avg. Kills:	4
Kills per Death:	1.33
Kills per Minute:	0.83
Total Connection Time:	0d 00:04:50h
Avg. Connection Time:	0d 00:04:50h
Favorite Server:*	Gamester.AVONET.cz \| Paintball
Favorite Map:*	de_dust
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[B-Hop]ACD Dusan	1,008		0d 00:04:50h	4		100.00%	3	1.33

Player Actions *

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

Team Selection *

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

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	3		75.00%	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		67	4	400	4	4	2.0000	6.0%	100.0	16.8
2		2	0	0	0	0	0.0000	0.0%	0.0	0.0
3		1	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

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

Targets

Show total target statistics

ERROR

Database Error

Server Address: localhost
Server Username: root

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