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

Sections

Clan Information

Statistics Summary
Clan:	HR
Home Page:
Activity:		38.00%
Members:	3 active members (4 total)
Avg. Member Points:	1,543
Total Kills:	718
Total Deaths:	15
Avg. Kills:	239
Kills per Death:	47.87
Kills per Minute:	5.31
Total Connection Time:	0d 02:15:17h
Avg. Connection Time:	0d 00:45:05h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	l4d_draxmap0
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[HR] BlasPeanut	1,990		0d 01:04:07h	433		60.31%	5	86.60
2	[HR] Boruzgva	1,613		0d 01:04:52h	276		38.44%	8	34.50
3	[HR] Xolik	1,027		0d 00:06:18h	9		1.25%	2	4.50

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	74 times	222
2	Friendly Fire	46 times	-138
3	Protected Teammate	29 times	87
4	Revived Teammate	15 times	45
5	Killed a Boomer	12 times	12
6	Killed a Jockey	7 times	21
7	Killed a Charger	7 times	21
8	Killed a Smoker	6 times	12
9	Killed a Hunter	6 times	12
10	Killed a Spitter	5 times	15
11	Killed a Witch	3 times	15
12	Startled the Witch	2 times	-10
13	Used Adrenaline	1 times	2
14	Tank Bilebombed	1 times	5
15	Rescued Teammate	1 times	3
16	No Survivors Died/Incapped by Tank	1 times	1
17	Killed a Tank	1 times	4
18	Healed Teammate	1 times	5
19	Defibrillated Teammate	1 times	10

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	21 times		38.89%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	TeenGirl	5 times	45.45%		233	8	29.13
2	Biker	4 times	36.36%		432	5	86.40
3	NamVet	2 times	18.18%		53	2	26.50

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	133		18.52%	19		25.68%	0.14
2		0.10	127		17.69%	0		0.00%	0.00
3		2.50	120		16.71%	7		9.46%	0.06
4		1.00	88		12.26%	12		16.22%	0.14
5		1.00	57		7.94%	7		9.46%	0.12
6		2.20	49		6.82%	16		21.62%	0.33
7		0.10	27		3.76%	0		0.00%	0.00
8		1.50	23		3.20%	4		5.41%	0.17
9		1.00	22		3.06%	2		2.70%	0.09
10		2.00	21		2.92%	0		0.00%	0.00
11		5.00	21		2.92%	0		0.00%	0.00
12		1.50	7		0.97%	2		2.70%	0.29
13		1.50	7		0.97%	2		2.70%	0.29
14		4.00	6		0.84%	1		1.35%	0.17
15		2.00	5		0.70%	2		2.70%	0.40
16		10.00	2		0.28%	0		0.00%	0.00
17		10.00	1		0.14%	0		0.00%	0.00
18		10.00	1		0.14%	0		0.00%	0.00
19		0.10	1		0.14%	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		3,146	211	9,138	3	13	13.0000	6.7%	43.3	242.0
2		198	168	3,982	0	6	6.0000	84.8%	23.7	33.0
3		714	262	3,887	1	5	5.0000	36.7%	14.8	142.8
4		201	121	2,681	0	4	4.0000	60.2%	22.2	50.3
5		63	9	804	0	3	3.0000	14.3%	89.3	21.0
6		859	403	10,184	2	3	3.0000	46.9%	25.3	286.3
7		35	8	728	0	2	2.0000	22.9%	91.0	17.5
8		160	32	1,162	0	0	0.0000	20.0%	36.3	0.0
9		4	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		318	23.3%	55.0%	21.7%
2		232	24.1%	57.8%	18.1%
3		187	16.0%	66.3%	17.6%
4		145	9.7%	75.2%	15.2%
5		111	13.5%	55.9%	30.6%
6		31	35.5%	41.9%	22.6%
7		7	14.3%	71.4%	14.3%
8		7	28.6%	57.1%	14.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 = 774
			GROUP BY
				map;