Gunny's HLStatsX Hooch - Left 4 Dead 2 - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	*
Home Page:
Activity:		77.00%
Members:	1 active members (5 total)
Avg. Member Points:	19,326
Total Kills:	7,747
Total Deaths:	29
Avg. Kills:	7,747
Kills per Death:	267.14
Kills per Minute:	7.62
Total Connection Time:	0d 16:56:33h
Avg. Connection Time:	0d 16:56:33h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	dworld09_tuto2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[US] ****	19,326		0d 16:56:33h	7,747		100.00%	29	267.14

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	21 times	63
2	Killed a Tank	8 times	32
3	Friendly Fire	8 times	-24
4	Protected Teammate	7 times	21
5	Revived Teammate	5 times	15
6	Killed a Spitter	5 times	15
7	Killed a Boomer	4 times	4
8	Killed a Smoker	3 times	6
9	Killed a Charger	3 times	9
10	Killed a Jockey	2 times	6
11	Killed a Hunter	2 times	4
12	Healed Teammate	2 times	10
13	Startled the Witch	1 times	-5
14	Killed a Witch	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	10 times		43.48%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Manager	1 times	25.00%		152	0	152.00
2	Biker	1 times	25.00%		51	0	51.00
3	Mechanic	1 times	25.00%		100	3	33.33
4	NamVet	1 times	25.00%		3	0	3.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		0.10	139		1.79%	12		2.60%	0.09
2		1.00	62		0.80%	9		1.95%	0.15
3		0.10	49		0.63%	0		0.00%	0.00
4		1.00	37		0.48%	0		0.00%	0.00
5		1.50	11		0.14%	0		0.00%	0.00
6		-25.00	3		0.04%	0		0.00%	0.00
7		0.50	2		0.03%	0		0.00%	0.00
8		5.00	1		0.01%	0		0.00%	0.00
9		10.00	1		0.01%	0		0.00%	0.00
10		1.50	1		0.01%	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		118	73	1,343	0	6	6.0000	61.9%	18.4	19.7
2		140	238	28,844	0	2	2.0000	170.0%	121.2	70.0
3		1	0	0	0	0	0.0000	0.0%	0.0	0.0
4		1	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		193	4.7%	75.6%	19.7%
2		44	9.1%	81.8%	9.1%

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 = 562
			GROUP BY
				map;