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

Sections

Clan Information

Statistics Summary
Clan:	Da07_
Home Page:
Activity:		5.00%
Members:	1 active members (1 total)
Avg. Member Points:	3,919
Total Kills:	1,165
Total Deaths:	10
Avg. Kills:	1,165
Kills per Death:	116.50
Kills per Minute:	7.43
Total Connection Time:	0d 02:36:43h
Avg. Connection Time:	0d 02:36:43h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	l4d_yama_2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[MX] __Da07_	3,919		0d 02:36:43h	1,165		100.00%	10	116.50

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	78 times	234
2	Friendly Fire	20 times	-60
3	Protected Teammate	17 times	51
4	Killed a Boomer	13 times	13
5	Killed a Spitter	10 times	30
6	Killed a Jockey	9 times	27
7	Revived Teammate	7 times	21
8	Killed a Hunter	7 times	14
9	Killed a Smoker	6 times	12
10	Killed a Charger	6 times	18
11	Hunter Punter (Melee a Hunter Mid-jump)	4 times	20
12	Startled the Witch	3 times	-15
13	Killed a Witch	3 times	15
14	Killed a Tank	2 times	8
15	Healed Teammate	2 times	10
16	Used Adrenaline	1 times	2
17	Tank Bilebombed	1 times	5

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	1 times	33.33%		508	4	127.00
2	Coach	1 times	33.33%		41	0	41.00
3	NamVet	1 times	33.33%		259	3	86.33

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	152		13.05%	25		25.00%	0.16
2		1.00	146		12.53%	8		8.00%	0.05
3		1.50	101		8.67%	10		10.00%	0.10
4		1.50	79		6.78%	7		7.00%	0.09
5		1.00	74		6.35%	5		5.00%	0.07
6		1.50	73		6.27%	5		5.00%	0.07
7		1.00	44		3.78%	2		2.00%	0.05
8		5.00	37		3.18%	1		1.00%	0.03
9		2.00	34		2.92%	12		12.00%	0.35
10		0.10	24		2.06%	0		0.00%	0.00
11		1.20	15		1.29%	0		0.00%	0.00
12		1.00	10		0.86%	1		1.00%	0.10
13		0.10	7		0.60%	0		0.00%	0.00
14		1.50	6		0.52%	0		0.00%	0.00
15		0.10	2		0.17%	0		0.00%	0.00
16		1.00	1		0.09%	0		0.00%	0.00
17		1.50	1		0.09%	1		1.00%	1.00

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		1,813	187	3,976	1	16	16.0000	10.3%	21.3	113.3
2		1,145	181	13,193	0	7	7.0000	15.8%	72.9	163.6
3		980	231	7,427	2	7	7.0000	23.6%	32.2	140.0
4		361	12	433	0	1	1.0000	3.3%	36.1	361.0
5		25	3	3	0	0	0.0000	12.0%	1.0	0.0
6		128	0	0	0	0	0.0000	0.0%	0.0	0.0
7		273	85	2,773	0	0	0.0000	31.1%	32.6	0.0
8		3	1	1	0	0	0.0000	33.3%	1.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		204	24.5%	54.4%	21.1%
2		150	14.0%	71.3%	14.7%
3		135	12.6%	65.2%	22.2%
4		83	27.7%	55.4%	16.9%
5		10	0.0%	80.0%	20.0%
6		3	0.0%	66.7%	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 = 781
			GROUP BY
				map;