Gamester Counter Strike Portal - Counter-Strike - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	**Jonny
Home Page:
Activity:		100.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,785
Total Kills:	136
Total Deaths:	93
Avg. Kills:	136
Kills per Death:	1.46
Kills per Minute:	0.68
Total Connection Time:	0d 03:19:09h
Avg. Connection Time:	0d 03:19:09h
Favorite Server:*	Gamester.AVONET.cz \| PUBLIC
Favorite Map:*	de_nuke
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	*Jonny*	1,785		0d 03:19:09h	136		100.00%	93	1.46

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	23 times	23
2	Spawn with the Bomb	13 times	26
3	Drop the Bomb	10 times	-20
4	Pick up the Bomb	7 times	14
5	Plant the Bomb	6 times	90
6	Start Defusing the Bomb With a Defuse Kit	5 times	0
7	Domination (4 kills)	5 times	15
8	Triple Kill (3 kills)	3 times	6
9	Defuse the Bomb	2 times	30
10	Start Defusing the Bomb Without a Defuse Kit	1 times	0
11	Rampage (5 kills)	1 times	4

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	17 times		42.50%
2	Counter-Terrorist	14 times		35.00%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	53		38.97%	0		0.00%	0.00
2		1.00	43		31.62%	0		0.00%	0.00
3		1.50	15		11.03%	0		0.00%	0.00
4		1.50	9		6.62%	0		0.00%	0.00
5		1.40	9		6.62%	0		0.00%	0.00
6		1.00	4		2.94%	0		0.00%	0.00
7		1.80	3		2.21%	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		39	26	719	0	3	3.0000	66.7%	27.7	13.0
2		60	12	587	3	4	2.0000	20.0%	48.9	15.0
3		34	11	1,162	0	9	1.8000	32.4%	105.6	3.8
4		974	132	4,772	24	43	1.6538	13.6%	36.2	22.7
5		817	169	7,023	25	53	1.4722	20.7%	41.6	15.4
6		164	51	2,423	6	15	1.2500	31.1%	47.5	10.9
7		168	60	1,011	1	9	1.1250	35.7%	16.9	18.7
8		21	2	8	0	0	0.0000	9.5%	4.0	0.0
9		8	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		169	42.0%	41.4%	16.6%
2		132	43.2%	40.2%	16.7%
3		60	50.0%	41.7%	8.3%
4		51	45.1%	43.1%	11.8%
5		12	16.7%	75.0%	8.3%
6		11	27.3%	45.5%	27.3%
7		2	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 / 136 * 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