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

Sections

Clan Information

Statistics Summary
Clan:	MA
Home Page:
Activity:		52.00%
Members:	1 active members (4 total)
Avg. Member Points:	1,939
Total Kills:	411
Total Deaths:	13
Avg. Kills:	411
Kills per Death:	31.62
Kills per Minute:	6.33
Total Connection Time:	0d 01:04:58h
Avg. Connection Time:	0d 01:04:58h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	bt1
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Random [MA]	1,939		0d 01:04:58h	411		100.00%	13	31.62

Player Actions *

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

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	8 times		33.33%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	TeenGirl	2 times	66.67%		122	12	10.17
2	Mechanic	1 times	33.33%		289	1	289.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	83		20.19%	5		20.00%	0.06
2		1.50	81		19.71%	2		8.00%	0.02
3		1.20	54		13.14%	0		0.00%	0.00
4		0.10	35		8.52%	0		0.00%	0.00
5		3.00	26		6.33%	0		0.00%	0.00
6		3.00	23		5.60%	2		8.00%	0.09
7		0.10	18		4.38%	2		8.00%	0.11
8		2.00	17		4.14%	7		28.00%	0.41
9		3.00	15		3.65%	2		8.00%	0.13
10		5.00	15		3.65%	0		0.00%	0.00
11		3.00	15		3.65%	0		0.00%	0.00
12		3.00	13		3.16%	3		12.00%	0.23
13		3.00	8		1.95%	2		8.00%	0.25
14		3.00	3		0.73%	0		0.00%	0.00
15		5.00	2		0.49%	0		0.00%	0.00
16		5.00	2		0.49%	0		0.00%	0.00
17		0.10	1		0.24%	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		181	20	1,902	2	6	6.0000	11.0%	95.1	30.2
2		387	156	4,247	1	2	2.0000	40.3%	27.2	193.5
3		46	16	333	0	1	1.0000	34.8%	20.8	46.0
4		447	47	468	0	0	0.0000	10.5%	10.0	0.0
5		4	0	0	0	0	0.0000	0.0%	0.0	0.0
6		25	9	142	0	0	0.0000	36.0%	15.8	0.0
7		4	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		130	16.9%	66.9%	16.2%
2		39	17.9%	64.1%	17.9%
3		16	12.5%	68.8%	18.8%
4		15	20.0%	80.0%	0.0%
5		9	0.0%	55.6%	44.4%

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