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

Sections

Clan Information

Statistics Summary
Clan:	SV
Home Page:
Activity:		68.83%
Members:	6 active members (8 total)
Avg. Member Points:	1,077
Total Kills:	186
Total Deaths:	12
Avg. Kills:	31
Kills per Death:	15.50
Kills per Minute:	4.45
Total Connection Time:	0d 00:41:46h
Avg. Connection Time:	0d 00:06:57h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	c1m1_hotel
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[SV] ŞΔŁVΔĐØŘ™	1,429		0d 00:25:05h	166		89.25%	12	13.83
2	[SV] jasoonalexander2	1,040		0d 00:03:45h	20		10.75%	0	20.00
3	[SV] Raccoon	1,000		0d 00:05:07h	0		0.00%	0	0.00
4	[SV] lindohitstop	1,000		0d 00:00:21h	0		0.00%	0	0.00
5	[SV] Dearvale	1,000		0d 00:04:41h	0		0.00%	0	0.00
6	[SV] ✩ 『¡StuartLight!』 ✩	991		0d 00:02:47h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	24 times	72
2	Friendly Fire	18 times	-54
3	Protected Teammate	8 times	24
4	Killed a Spitter	6 times	18
5	Killed a Charger	5 times	15
6	Killed a Smoker	4 times	8
7	Killed a Boomer	4 times	4
8	Killed a Jockey	3 times	9
9	Revived Teammate	2 times	6
10	Killed a Hunter	2 times	4
11	Used Adrenaline	1 times	2
12	Healed Teammate	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	6 times		26.09%
2	Infected	5 times		21.74%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Manager	1 times	6.25%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	47		25.27%	5		20.83%	0.11
2		1.50	36		19.35%	2		8.33%	0.06
3		2.00	28		15.05%	9		37.50%	0.32
4		5.00	24		12.90%	0		0.00%	0.00
5		1.00	20		10.75%	4		16.67%	0.20
6		0.10	15		8.06%	0		0.00%	0.00
7		2.20	13		6.99%	4		16.67%	0.31
8		1.50	2		1.08%	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		435	65	1,732	2	8	8.0000	14.9%	26.6	54.4
2		294	43	2,771	2	6	6.0000	14.6%	64.4	49.0
3		296	77	1,154	0	1	1.0000	26.0%	15.0	296.0
4		77	9	136	0	0	0.0000	11.7%	15.1	0.0
5	Smoker Claw	20	2	6	0	0	0.0000	10.0%	3.0	0.0
6		4	28	28	0	0	0.0000	700.0%	1.0	0.0
7		3	0	0	0	0	0.0000	0.0%	0.0	0.0
8	Jockey Claw	117	33	72	0	0	0.0000	28.2%	2.2	0.0
9	Hunter Claw	256	4	16	0	0	0.0000	1.6%	4.0	0.0
10	Charger Claw	8	6	80	0	0	0.0000	75.0%	13.3	0.0
11	Boomer Claw	313	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		68	25.0%	63.2%	11.8%
2		57	10.5%	73.7%	15.8%
3		34	20.6%	76.5%	2.9%
4		28	17.9%	75.0%	7.1%
5		9	0.0%	100.0%	0.0%
6	Charger Claw	6	0.0%	100.0%	0.0%
7	Jockey Claw	4	75.0%	25.0%	0.0%
8	Hunter Claw	4	0.0%	100.0%	0.0%
9	Smoker Claw	2	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 = 649
			GROUP BY
				map;