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

Sections

Clan Information

Statistics Summary
Clan:	DE
Home Page:
Activity:		1.00%
Members:	1 active members (12 total)
Avg. Member Points:	1,847
Total Kills:	271
Total Deaths:	14
Avg. Kills:	271
Kills per Death:	19.36
Kills per Minute:	3.60
Total Connection Time:	0d 01:15:11h
Avg. Connection Time:	0d 01:15:11h
Favorite Server:*
Favorite Map:*
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[DE] The	1,847		0d 01:15:11h	271		100.00%	14	19.36

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	36 times	108
2	Friendly Fire	35 times	-105
3	Killed a Spitter	23 times	69
4	Used Adrenaline	16 times	32
5	Protected Teammate	14 times	42
6	Killed a Jockey	11 times	33
7	Killed a Charger	11 times	33
8	Killed a Hunter	10 times	20
9	Killed a Smoker	9 times	18
10	Revived Teammate	8 times	24
11	Killed a Boomer	7 times	7
12	Hunter Punter (Melee a Hunter Mid-jump)	2 times	10
13	Healed Teammate	2 times	10
14	Killed a Tank	1 times	4

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	5 times		45.45%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Coach	1 times	100.00%		271	14	19.36

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.20	56		20.66%	20		55.56%	0.36
2		0.10	44		16.24%	0		0.00%	0.00
3		1.50	38		14.02%	8		22.22%	0.21
4		5.00	32		11.81%	0		0.00%	0.00
5		1.20	18		6.64%	0		0.00%	0.00
6		1.50	17		6.27%	1		2.78%	0.06
7		1.00	14		5.17%	0		0.00%	0.00
8		0.10	13		4.80%	0		0.00%	0.00
9		2.00	9		3.32%	2		5.56%	0.22
10		4.00	8		2.95%	3		8.33%	0.38
11		1.00	6		2.21%	1		2.78%	0.17
12		1.00	4		1.48%	0		0.00%	0.00
13		0.10	3		1.11%	0		0.00%	0.00
14		1.50	2		0.74%	0		0.00%	0.00
15		0.10	2		0.74%	0		0.00%	0.00
16		2.00	2		0.74%	1		2.78%	0.50
17		1.00	1		0.37%	0		0.00%	0.00
18		1.50	1		0.37%	0		0.00%	0.00
19		1.50	1		0.37%	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		761	146	5,040	2	17	17.0000	19.2%	34.5	44.8
2		2,039	558	14,348	5	15	15.0000	27.4%	25.7	135.9
3		79	22	1,979	0	2	2.0000	27.8%	90.0	39.5
4		26	49	916	0	2	2.0000	188.5%	18.7	13.0
5		48	5	628	1	2	2.0000	10.4%	125.6	24.0
6		90	25	799	0	1	1.0000	27.8%	32.0	90.0
7		10	0	0	0	0	0.0000	0.0%	0.0	0.0
8		5	0	0	0	0	0.0000	0.0%	0.0	0.0
9		1	2	4	0	0	0.0000	200.0%	2.0	0.0
10		13	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		369	19.8%	61.0%	19.2%
2		134	22.4%	47.8%	29.9%
3		43	9.3%	74.4%	16.3%
4		24	12.5%	66.7%	20.8%
5		4	0.0%	100.0%	0.0%
6		2	0.0%	50.0%	50.0%
7		1	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 = 647
			GROUP BY
				map;