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

Sections

Clan Information

Statistics Summary
Clan:	HN
Home Page:
Activity:		68.00%
Members:	6 active members (20 total)
Avg. Member Points:	1,152
Total Kills:	359
Total Deaths:	13
Avg. Kills:	60
Kills per Death:	27.62
Kills per Minute:	5.43
Total Connection Time:	0d 01:06:06h
Avg. Connection Time:	0d 00:11:01h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	Dead_Series1
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Dullahanxz7_ [HN]	1,608		0d 00:25:50h	216		60.17%	6	36.00
2	darkcrow [HN]	1,197		0d 00:21:03h	96		26.74%	0	96.00
3	[HN] Pepe Silvia	1,091		0d 00:03:52h	36		10.03%	3	12.00
4	ikxpixel [HN]	1,016		0d 00:05:57h	11		3.06%	0	11.00
5	[HN] GotT80BVM	1,000		0d 00:00:36h	0		0.00%	0	0.00
6	[HN] Volcaveon	1,000		0d 00:08:48h	0		0.00%	4	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	33 times	99
2	Friendly Fire	31 times	-93
3	Protected Teammate	20 times	60
4	Killed a Hunter	8 times	16
5	Killed a Charger	8 times	24
6	Killed a Boomer	8 times	8
7	Killed a Smoker	7 times	14
8	Revived Teammate	6 times	18
9	Killed a Spitter	6 times	18
10	Killed a Jockey	6 times	18
11	Hunter Punter (Melee a Hunter Mid-jump)	2 times	10
12	Used Adrenaline	1 times	2

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	8 times		32.00%
2	Infected	3 times		12.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Mechanic	4 times	25.00%		243	5	48.60
2	SMOKER	3 times	18.75%		0	3	0.00
3	Coach	3 times	18.75%		102	1	102.00
4	SPITTER	1 times	6.25%		0	1	0.00
5	Gambler	1 times	6.25%		14	0	14.00
6	JOCKEY	1 times	6.25%		0	1	0.00
7	HUNTER	1 times	6.25%		0	1	0.00
8	CHARGER	1 times	6.25%
9	BOOMER	1 times	6.25%		0	1	0.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	93		25.91%	12		36.36%	0.13
2		1.50	57		15.88%	6		18.18%	0.11
3		5.00	56		15.60%	0		0.00%	0.00
4		1.75	29		8.08%	1		3.03%	0.03
5		2.50	29		8.08%	1		3.03%	0.03
6		1.50	28		7.80%	2		6.06%	0.07
7		2.00	17		4.74%	2		6.06%	0.12
8		2.50	16		4.46%	3		9.09%	0.19
9		1.50	13		3.62%	2		6.06%	0.15
10		4.00	11		3.06%	3		9.09%	0.27
11		2.50	8		2.23%	1		3.03%	0.13
12		2.00	1		0.28%	0		0.00%	0.00
13		2.00	1		0.28%	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		910	255	14,275	2	14	14.0000	28.0%	56.0	65.0
2		34	99	1,704	0	5	5.0000	291.2%	17.2	6.8
3		64	89	2,070	0	4	4.0000	139.1%	23.3	16.0
4		201	19	373	0	2	2.0000	9.5%	19.6	100.5
5		417	126	3,527	0	2	2.0000	30.2%	28.0	208.5
6		27	1	105	0	1	1.0000	3.7%	105.0	27.0
7		209	64	1,438	1	1	1.0000	30.6%	22.5	209.0
8	Smoker Claw	82	3	9	0	0	0.0000	3.7%	3.0	0.0
9		15	0	0	0	0	0.0000	0.0%	0.0	0.0
10		5	0	0	0	0	0.0000	0.0%	0.0	0.0
11		5	1	4	0	0	0.0000	20.0%	4.0	0.0
12	Jockey Claw	75	4	8	0	0	0.0000	5.3%	2.0	0.0
13	Hunter Claw	50	0	0	0	0	0.0000	0.0%	0.0	0.0
14	Boomer Claw	93	1	4	0	0	0.0000	1.1%	4.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		233	12.4%	76.8%	10.7%
2		125	9.6%	76.0%	14.4%
3		93	17.2%	54.8%	28.0%
4		80	10.0%	77.5%	12.5%
5		56	17.9%	53.6%	28.6%
6		17	11.8%	70.6%	17.6%
7	Jockey Claw	4	0.0%	100.0%	0.0%
8	Smoker Claw	1	0.0%	0.0%	100.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 = 607
			GROUP BY
				map;