Gunnys Krazy Kat HLStatsX Hooch - Left 4 Dead 2 - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	GY
Home Page:
Activity:		93.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,476
Total Kills:	180
Total Deaths:	2
Avg. Kills:	180
Kills per Death:	90.00
Kills per Minute:	9.95
Total Connection Time:	0d 00:18:05h
Avg. Connection Time:	0d 00:18:05h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	c11m4_terminal
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[GY] Chino	1,476		0d 00:18:05h	180		100.00%	2	90.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	28 times	84
2	Friendly Fire	9 times	-27
3	Revived Teammate	5 times	15
4	Protected Teammate	3 times	9
5	Used Adrenaline	2 times	4
6	Killed a Charger	2 times	6
7	Killed a Tank	1 times	4
8	Killed a Jockey	1 times	3
9	Killed a Hunter	1 times	2
10	Killed a Boomer	1 times	1
11	Healed Teammate	1 times	5
12	Defibrillated Teammate	1 times	10

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	2 times		40.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Biker	1 times	100.00%		180	2	90.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	55		30.56%	8		28.57%	0.15
2		1.00	40		22.22%	9		32.14%	0.23
3		1.00	40		22.22%	7		25.00%	0.18
4		1.50	8		4.44%	3		10.71%	0.38
5		1.50	8		4.44%	0		0.00%	0.00
6		1.00	7		3.89%	0		0.00%	0.00
7		1.20	6		3.33%	0		0.00%	0.00
8		2.00	6		3.33%	0		0.00%	0.00
9		1.00	3		1.67%	0		0.00%	0.00
10		0.10	3		1.67%	0		0.00%	0.00
11		5.00	2		1.11%	0		0.00%	0.00
12		0.10	1		0.56%	0		0.00%	0.00
13		1.50	1		0.56%	1		3.57%	1.00

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		445	48	2,133	0	3	3.0000	10.8%	44.4	148.3
2		45	5	59	0	1	1.0000	11.1%	11.8	45.0
3		177	284	8,389	0	1	1.0000	160.5%	29.5	177.0
4		20	0	0	0	0	0.0000	0.0%	0.0	0.0
5		2	0	0	0	0	0.0000	0.0%	0.0	0.0
6		119	52	1,548	0	0	0.0000	43.7%	29.8	0.0
7		21	3	196	0	0	0.0000	14.3%	65.3	0.0
8		1	1	20	0	0	0.0000	100.0%	20.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		278	17.3%	53.2%	29.5%
2		50	10.0%	80.0%	10.0%
3		30	0.0%	83.3%	16.7%
4		5	0.0%	100.0%	0.0%
5		3	0.0%	100.0%	0.0%

Targets

Show total target statistics

ERROR

Database Error

Server Address: localhost
Server Username: gunnys2

Error Diagnostic:
Bad query.

Server Error: (1050) Table 'tmp_clan_kills' already exists

Last SQL Query:

		CREATE TEMPORARY TABLE tmp_clan_kills
			SELECT
				IF(map='', '(Unaccounted)', map) AS map,
				COUNT(*) AS kills,
				SUM(headshot=1) AS headshots
			FROM
				hlstats_Events_Frags, hlstats_Players
			WHERE
				hlstats_Players.playerId = hlstats_Events_Frags.killerId
				AND hlstats_Players.clan = 696
			GROUP BY
				map;