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

Sections

Clan Information

Statistics Summary
Clan:	CZ
Home Page:
Activity:		57.00%
Members:	1 active members (4 total)
Avg. Member Points:	2,336
Total Kills:	534
Total Deaths:	7
Avg. Kills:	534
Kills per Death:	76.29
Kills per Minute:	10.67
Total Connection Time:	0d 00:50:03h
Avg. Connection Time:	0d 00:50:03h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	l4d_noe2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[CZ] Frantis	2,336		0d 00:50:03h	534		100.00%	7	76.29

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	66 times	198
2	Protected Teammate	9 times	27
3	Killed a Jockey	6 times	18
4	Friendly Fire	6 times	-18
5	Killed a Spitter	5 times	15
6	Killed a Smoker	3 times	6
7	Startled the Witch	2 times	-10
8	Revived Teammate	2 times	6
9	Killed a Hunter	2 times	4
10	Killed a Boomer	2 times	2
11	Healed Teammate	2 times	10
12	Killed a Witch	1 times	5
13	Hunter Punter (Melee a Hunter Mid-jump)	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	3 times		50.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Producer	1 times	50.00%		473	5	94.60
2	Gambler	1 times	50.00%		61	2	30.50

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	189		35.39%	21		31.82%	0.11
2		2.00	67		12.55%	4		6.06%	0.06
3		1.50	61		11.42%	8		12.12%	0.13
4		1.00	38		7.12%	12		18.18%	0.32
5		1.00	35		6.55%	1		1.52%	0.03
6		2.00	34		6.37%	8		12.12%	0.24
7		0.10	30		5.62%	0		0.00%	0.00
8		1.50	27		5.06%	9		13.64%	0.33
9		1.00	16		3.00%	2		3.03%	0.13
10		0.10	12		2.25%	0		0.00%	0.00
11		4.00	10		1.87%	0		0.00%	0.00
12		2.00	6		1.12%	1		1.52%	0.17
13		2.20	4		0.75%	0		0.00%	0.00
14		5.00	4		0.75%	0		0.00%	0.00
15		1.75	1		0.19%	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		326	186	4,092	0	7	7.0000	57.1%	22.0	46.6
2		561	150	3,057	1	3	3.0000	26.7%	20.4	187.0
3		450	198	6,255	2	3	3.0000	44.0%	31.6	150.0
4		450	4	227	0	1	1.0000	0.9%	56.8	450.0
5		124	3	367	1	1	1.0000	2.4%	122.3	124.0
6		3	0	0	0	0	0.0000	0.0%	0.0	0.0
7		125	1	1	0	0	0.0000	0.8%	1.0	0.0
8		34	16	224	0	0	0.0000	47.1%	14.0	0.0
9		171	52	1,641	0	0	0.0000	30.4%	31.6	0.0
10		1	0	0	0	0	0.0000	0.0%	0.0	0.0
11		180	1	1	0	0	0.0000	0.6%	1.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		197	10.2%	75.6%	14.2%
2		159	10.7%	50.3%	39.0%
3		136	18.4%	67.6%	14.0%
4		50	14.0%	66.0%	20.0%
5		16	12.5%	75.0%	12.5%
6		3	0.0%	100.0%	0.0%
7		3	0.0%	100.0%	0.0%
8		1	0.0%	100.0%	0.0%
9		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 = 724
			GROUP BY
				map;