Gamester Counter Strike Portal - Counter-Strike - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	*SLW*
Home Page:
Activity:		100.00%
Members:	2 active members (2 total)
Avg. Member Points:	1,062
Total Kills:	35
Total Deaths:	28
Avg. Kills:	18
Kills per Death:	1.25
Kills per Minute:	0.63
Total Connection Time:	0d 00:55:18h
Avg. Connection Time:	0d 00:27:39h
Favorite Server:*	Gamester.AVONET.cz \| PUBLIC
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	SLW Kelis	1,123		0d 00:51:14h	35		100.00%	28	1.25
2	SLWIRENKA	1,000		0d 00:04:04h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Triple Kill (3 kills)	2 times	4
2	Start Defusing the Bomb With a Defuse Kit	2 times	0
3	Double Kill (2 kills)	2 times	2
4	Defuse the Bomb	2 times	30
5	Spawn with the Bomb	1 times	2
6	Drop the Bomb	1 times	-2

Team Selection *

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

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	30		85.71%	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		1,206	39	3,900	6	39	1.3929	3.2%	100.0	30.9
2		88	0	0	0	0	0.0000	0.0%	0.0	0.0
3		4	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		39	33.3%	53.8%	12.8%

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 / 35 * 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