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

Sections

Clan Information

Statistics Summary
Clan:	SV
Home Page:
Activity:		37.87%
Members:	8 active members (11 total)
Avg. Member Points:	1,069
Total Kills:	223
Total Deaths:	18
Avg. Kills:	28
Kills per Death:	12.39
Kills per Minute:	3.93
Total Connection Time:	0d 00:56:43h
Avg. Connection Time:	0d 00:07:05h
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		74.44%	12	13.83
2	[SV] TheCoverfine	1,090		0d 00:17:04h	37		16.59%	5	7.40
3	[SV] jasoonalexander2	1,040		0d 00:03:45h	20		8.97%	0	20.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] El de los tamales y F1	1,000		0d 00:01:23h	0		0.00%	1	0.00
7	[SV] Natch ◕︎‿︎◕	1,000		0d 00:01:37h	0		0.00%	0	0.00
8	[SV] ✩ 『¡StuartLight!』 ✩	991		0d 00:02:47h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	28 times	84
2	Friendly Fire	25 times	-75
3	Protected Teammate	11 times	33
4	Killed a Spitter	7 times	21
5	Killed a Smoker	6 times	12
6	Killed a Charger	6 times	18
7	Killed a Boomer	5 times	5
8	Killed a Jockey	4 times	12
9	Killed a Hunter	3 times	6
10	Revived Teammate	2 times	6
11	Used Adrenaline	1 times	2
12	Healed Teammate	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Infected	9 times		25.00%
2	Survivors	8 times		22.22%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	SPITTER	2 times	7.69%		2	1	2.00
2	HUNTER	2 times	7.69%		0	2	0.00
3	SMOKER	1 times	3.85%		0	1	0.00
4	Gambler	1 times	3.85%		17	1	17.00
5	Manager	1 times	3.85%
6	JOCKEY	1 times	3.85%		1	1	1.00
7	Coach	1 times	3.85%		17	0	17.00
8	CHARGER	1 times	3.85%
9	BOOMER	1 times	3.85%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	47		21.08%	5		17.86%	0.11
2		1.50	36		16.14%	2		7.14%	0.06
3		2.00	28		12.56%	9		32.14%	0.32
4		5.00	24		10.76%	0		0.00%	0.00
5		1.00	20		8.97%	4		14.29%	0.20
6		4.00	17		7.62%	0		0.00%	0.00
7		2.00	17		7.62%	4		14.29%	0.24
8		0.10	15		6.73%	0		0.00%	0.00
9		2.20	13		5.83%	4		14.29%	0.31
10		1.50	2		0.90%	0		0.00%	0.00
11		1.50	2		0.90%	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		243	85	2,678	0	4	4.0000	35.0%	31.5	60.8
4		296	77	1,154	0	1	1.0000	26.0%	15.0	296.0
5		77	9	136	0	0	0.0000	11.7%	15.1	0.0
6	Smoker Claw	20	2	6	0	0	0.0000	10.0%	3.0	0.0
7		4	28	28	0	0	0.0000	700.0%	1.0	0.0
8		3	0	0	0	0	0.0000	0.0%	0.0	0.0
9	Jockey Claw	878	59	126	0	0	0.0000	6.7%	2.1	0.0
10	Hunter Claw	272	9	54	0	0	0.0000	3.3%	6.0	0.0
11	Charger Claw	9	7	90	0	0	0.0000	77.8%	12.9	0.0
12	Boomer Claw	313	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		79	11.4%	74.7%	13.9%
2		68	25.0%	63.2%	11.8%
3		57	10.5%	73.7%	15.8%
4		34	20.6%	76.5%	2.9%
5	Jockey Claw	29	10.3%	89.7%	0.0%
6		28	17.9%	75.0%	7.1%
7		9	0.0%	100.0%	0.0%
8	Charger Claw	7	0.0%	100.0%	0.0%
9	Hunter Claw	4	0.0%	100.0%	0.0%
10	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;