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

Sections

Clan Information

Statistics Summary
Clan:	IE
Home Page:
Activity:		61.00%
Members:	1 active members (10 total)
Avg. Member Points:	2,666
Total Kills:	752
Total Deaths:	8
Avg. Kills:	752
Kills per Death:	94.00
Kills per Minute:	5.78
Total Connection Time:	0d 02:10:04h
Avg. Connection Time:	0d 02:10:04h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	bt1
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	beepboopbep [IE]	2,666		0d 02:10:04h	752		100.00%	8	94.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Friendly Fire	80 times	-240
2	Headshot Kill	56 times	168
3	Protected Teammate	48 times	144
4	Killed a Hunter	9 times	18
5	Killed a Boomer	9 times	9
6	Killed a Spitter	7 times	21
7	Killed a Charger	7 times	21
8	Killed a Smoker	6 times	12
9	Killed a Jockey	5 times	15
10	Startled the Witch	2 times	-10
11	Hunter Punter (Melee a Hunter Mid-jump)	2 times	10
12	Used Adrenaline	1 times	2
13	Revived Teammate	1 times	3
14	Killed a Tank	1 times	4
15	Defibrillated Teammate	1 times	10

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	11 times		45.83%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Mechanic	2 times	50.00%		407	1	407.00
2	Producer	1 times	25.00%		7	0	7.00
3	Gambler	1 times	25.00%		338	7	48.29

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	241		32.05%	12		21.43%	0.05
2		3.00	177		23.54%	24		42.86%	0.14
3		0.10	101		13.43%	0		0.00%	0.00
4		3.00	99		13.16%	18		32.14%	0.18
5		5.00	37		4.92%	0		0.00%	0.00
6		0.10	27		3.59%	0		0.00%	0.00
7		1.20	18		2.39%	0		0.00%	0.00
8		3.00	16		2.13%	0		0.00%	0.00
9		0.10	11		1.46%	1		1.79%	0.09
10		3.00	7		0.93%	0		0.00%	0.00
11		1.00	6		0.80%	0		0.00%	0.00
12		1.50	6		0.80%	0		0.00%	0.00
13		2.00	4		0.53%	1		1.79%	0.25
14		3.00	2		0.27%	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		1,715	202	14,109	1	20	20.0000	11.8%	69.8	85.8
2		3,537	922	14,755	2	11	11.0000	26.1%	16.0	321.5
3		1,514	90	2,748	5	10	10.0000	5.9%	30.5	151.4
4		50	18	423	0	1	1.0000	36.0%	23.5	50.0
5		38	3	54	0	0	0.0000	7.9%	18.0	0.0
6		10	0	0	0	0	0.0000	0.0%	0.0	0.0
7		75	0	0	0	0	0.0000	0.0%	0.0	0.0
8		1	0	0	0	0	0.0000	0.0%	0.0	0.0
9		5	4	39	0	0	0.0000	80.0%	9.8	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		837	26.3%	51.6%	22.1%
2		180	13.9%	60.6%	25.6%
3		82	18.3%	72.0%	9.8%
4		15	13.3%	73.3%	13.3%
5		3	66.7%	0.0%	33.3%

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