Gamester Counter Strike Portal - Counter Strike Gungame - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	LOTF
Home Page:
Activity:		100.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,049
Total Kills:	156
Total Deaths:	230
Avg. Kills:	156
Kills per Death:	0.68
Kills per Minute:	2.24
Total Connection Time:	0d 01:09:40h
Avg. Connection Time:	0d 01:09:40h
Favorite Server:*	Gamester.AVONET.cz \| GunGame
Favorite Map:*	gg_anubis
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[LOTF]-::-AndroiD 2.3	1,049		0d 01:09:40h	156		100.00%	230	0.68

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	22 times	22
2	Triple Kill (3 kills)	7 times	14
3	Domination (4 kills)	3 times	9

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	8 times		72.73%
2	Terrorist	2 times		18.18%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.50	2		1.28%	0		0.00%	0.00
2		1.00	3		1.92%	0		0.00%	0.00
3		1.00	3		1.92%	0		0.00%	0.00
4		1.50	3		1.92%	0		0.00%	0.00
5		1.60	3		1.92%	0		0.00%	0.00
6		1.50	6		3.85%	0		0.00%	0.00
7		1.50	6		3.85%	0		0.00%	0.00
8		1.00	8		5.13%	0		0.00%	0.00
9		1.50	9		5.77%	0		0.00%	0.00
10		1.25	9		5.77%	0		0.00%	0.00
11		1.25	10		6.41%	0		0.00%	0.00
12		1.25	10		6.41%	0		0.00%	0.00
13		1.25	10		6.41%	0		0.00%	0.00
14		1.25	10		6.41%	0		0.00%	0.00
15		1.40	11		7.05%	0		0.00%	0.00
16		1.40	12		7.69%	0		0.00%	0.00
17		1.50	16		10.26%	0		0.00%	0.00
18		1.80	25		16.03%	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		4	1	60	0	1	1.0000	25.0%	60.0	4.0
2		7	4	368	1	3	1.5000	57.1%	92.0	2.3
3		28	6	245	1	3	1.5000	21.4%	40.8	9.3
4		61	10	193	0	2	0.6667	16.4%	19.3	30.5
5		38	13	421	1	3	0.7500	34.2%	32.4	12.7
6		74	14	369	1	3	0.7500	18.9%	26.4	24.7
7		75	17	348	0	5	1.2500	22.7%	20.5	15.0
8		113	19	364	1	4	0.4000	16.8%	19.2	28.3
9		171	22	424	1	3	0.4286	12.9%	19.3	57.0
10		94	26	657	0	4	0.4444	27.7%	25.3	23.5
11		60	27	1,937	2	14	0.4375	45.0%	71.7	4.3
12		32	29	1,136	2	9	0.6429	90.6%	39.2	3.6
13		152	40	658	2	7	1.4000	26.3%	16.5	21.7
14		115	49	1,668	2	11	0.5238	42.6%	34.0	10.5
15		173	53	944	3	7	0.5000	30.6%	17.8	24.7
16		227	54	892	4	9	0.7500	23.8%	16.5	25.2
17		262	63	966	4	7	1.0000	24.0%	15.3	37.4
18		369	66	1,117	2	9	0.4737	17.9%	16.9	41.0
19		303	87	1,582	5	15	0.7143	28.7%	18.2	20.2

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		1	0.0%	0.0%	100.0%
2		4	50.0%	50.0%	0.0%
3		6	33.3%	66.7%	0.0%
4		10	50.0%	20.0%	30.0%
5		13	61.5%	30.8%	7.7%
6		13	15.4%	53.8%	30.8%
7		14	57.1%	35.7%	7.1%
8		17	35.3%	41.2%	23.5%
9		19	57.9%	15.8%	26.3%
10		22	27.3%	54.5%	18.2%
11		26	46.2%	23.1%	30.8%
12		29	44.8%	31.0%	24.1%
13		40	47.5%	30.0%	22.5%
14		49	38.8%	26.5%	34.7%
15		53	37.7%	37.7%	24.5%
16		54	42.6%	37.0%	20.4%
17		63	41.3%	46.0%	12.7%
18		66	34.8%	47.0%	18.2%
19		87	46.0%	36.8%	17.2%

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