Gunnys Krazy Kat HLStatsX Hooch - Left 4 Dead 2 - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	KING
Home Page:
Activity:		61.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,717
Total Kills:	268
Total Deaths:	21
Avg. Kills:	268
Kills per Death:	12.76
Kills per Minute:	5.00
Total Connection Time:	0d 00:53:35h
Avg. Connection Time:	0d 00:53:35h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	c5m3_cemetery
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[KING]a20202302	1,717		0d 00:53:35h	268		100.00%	21	12.76

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Protected Teammate	30 times	90
2	Headshot Kill	24 times	72
3	Friendly Fire	24 times	-72
4	Killed a Boomer	9 times	9
5	Killed a Charger	5 times	15
6	Hunter Punter (Melee a Hunter Mid-jump)	5 times	25
7	Killed a Spitter	4 times	12
8	Killed a Smoker	3 times	6
9	Killed a Hunter	3 times	6
10	Used Adrenaline	2 times	4
11	Killed a Witch	2 times	10
12	Killed a Jockey	2 times	6
13	Startled the Witch	1 times	-5
14	Revived Teammate	1 times	3

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	9 times		40.91%
2	Infected	4 times		18.18%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Producer	4 times	18.18%		261	6	43.50
2	SPITTER	3 times	13.64%		0	3	0.00
3	JOCKEY	3 times	13.64%		1	2	0.50
4	HUNTER	3 times	13.64%		0	3	0.00
5	CHARGER	3 times	13.64%		1	2	0.50
6	BOOMER	3 times	13.64%		0	3	0.00
7	SMOKER	2 times	9.09%		2	2	1.00
8	TANK	1 times	4.55%		3	0	3.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	99		36.94%	7		29.17%	0.07
2		1.50	38		14.18%	3		12.50%	0.08
3		2.20	30		11.19%	4		16.67%	0.13
4		2.50	30		11.19%	0		0.00%	0.00
5		2.50	16		5.97%	3		12.50%	0.19
6		1.50	16		5.97%	3		12.50%	0.19
7		1.00	10		3.73%	3		12.50%	0.30
8		0.10	8		2.99%	0		0.00%	0.00
9		1.00	5		1.87%	0		0.00%	0.00
10		1.50	4		1.49%	1		4.17%	0.25
11		-25.00	3		1.12%	0		0.00%	0.00
12		1.00	2		0.75%	0		0.00%	0.00
13		10.00	2		0.75%	0		0.00%	0.00
14		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		166	74	1,148	0	6	6.0000	44.6%	15.5	27.7
2		487	130	2,321	0	4	4.0000	26.7%	17.9	121.8
3		15	35	960	0	2	2.0000	233.3%	27.4	7.5
4		19	6	111	0	1	1.0000	31.6%	18.5	19.0
5		108	25	922	0	1	1.0000	23.1%	36.9	108.0
6		1	0	0	0	0	0.0000	0.0%	0.0	0.0
7	Smoker Claw	2,696	15	108	0	0	0.0000	0.6%	7.2	0.0
8		315	12	338	0	0	0.0000	3.8%	28.2	0.0
9		4	0	0	0	0	0.0000	0.0%	0.0	0.0
10	Jockey Claw	1,567	14	56	0	0	0.0000	0.9%	4.0	0.0
11	Hunter Claw	281	3	22	0	0	0.0000	1.1%	7.3	0.0
12	Charger Claw	1,334	10	140	0	0	0.0000	0.7%	14.0	0.0
13	Boomer Claw	532	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		100	22.0%	53.0%	25.0%
2		57	22.8%	50.9%	26.3%
3		26	7.7%	61.5%	30.8%
4		25	12.0%	64.0%	24.0%
5	Jockey Claw	14	0.0%	100.0%	0.0%
6	Smoker Claw	7	14.3%	14.3%	71.4%
7		6	0.0%	83.3%	16.7%
8		6	0.0%	83.3%	16.7%

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