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

Sections

Clan Information

Statistics Summary
Clan:	FR
Home Page:
Activity:		76.00%
Members:	3 active members (17 total)
Avg. Member Points:	2,170
Total Kills:	1,476
Total Deaths:	4
Avg. Kills:	492
Kills per Death:	369.00
Kills per Minute:	13.35
Total Connection Time:	0d 01:50:36h
Avg. Connection Time:	0d 00:36:52h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	l4d_noe2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Anneau-Magique64 [FR]	2,753		0d 00:46:09h	709		48.04%	1	709.00
2	Frankenstein29 [FR]	2,146		0d 00:36:40h	525		35.57%	3	175.00
3	Chompski [FR]	1,610		0d 00:27:47h	242		16.40%	0	242.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	108 times	324
2	Protected Teammate	44 times	132
3	Friendly Fire	35 times	-105
4	Killed a Smoker	18 times	36
5	Killed a Hunter	15 times	30
6	Killed a Boomer	14 times	14
7	Killed a Jockey	11 times	33
8	Killed a Spitter	9 times	27
9	Killed a Charger	8 times	24
10	Killed a Witch	6 times	30
11	Revived Teammate	5 times	15
12	Killed a Tank	3 times	12
13	Startled the Witch	2 times	-10
14	Healed Teammate	2 times	10
15	Tank Bilebombed	1 times	5
16	Hunter Punter (Melee a Hunter Mid-jump)	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	9 times		45.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Gambler	2 times	50.00%		928	3	309.33
2	Producer	1 times	25.00%		306	1	306.00
3	Biker	1 times	25.00%		242	0	242.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	327		22.15%	18		16.67%	0.06
2		2.00	269		18.22%	29		26.85%	0.11
3		0.10	204		13.82%	0		0.00%	0.00
4		1.50	175		11.86%	9		8.33%	0.05
5		1.00	71		4.81%	5		4.63%	0.07
6		1.00	70		4.74%	4		3.70%	0.06
7		0.50	69		4.67%	2		1.85%	0.03
8		5.00	68		4.61%	1		0.93%	0.01
9		1.00	62		4.20%	4		3.70%	0.06
10		3.00	55		3.73%	14		12.96%	0.25
11		3.00	33		2.24%	4		3.70%	0.12
12		3.00	24		1.63%	9		8.33%	0.38
13		1.50	16		1.08%	3		2.78%	0.19
14		0.10	15		1.02%	2		1.85%	0.13
15		5.00	7		0.47%	2		1.85%	0.29
16		3.00	4		0.27%	2		1.85%	0.50
17		3.00	4		0.27%	0		0.00%	0.00
18		0.10	3		0.20%	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		2,651	990	34,881	4	26	26.0000	37.3%	35.2	102.0
2		745	88	9,387	6	21	21.0000	11.8%	106.7	35.5
3		354	173	18,761	2	8	8.0000	48.9%	108.4	44.3
4		185	39	1,061	0	3	3.0000	21.1%	27.2	61.7
5		462	125	1,774	0	2	2.0000	27.1%	14.2	231.0
6		853	27	956	0	1	1.0000	3.2%	35.4	853.0
7		54	0	0	0	0	0.0000	0.0%	0.0	0.0
8		56	0	0	0	0	0.0000	0.0%	0.0	0.0
9		40	15	491	0	0	0.0000	37.5%	32.7	0.0
10		10	1	9	0	0	0.0000	10.0%	9.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		846	19.4%	64.3%	16.3%
2		168	6.0%	72.6%	21.4%
3		121	18.2%	68.6%	13.2%
4		71	21.1%	67.6%	11.3%
5		33	6.1%	75.8%	18.2%
6		21	19.0%	52.4%	28.6%
7		12	16.7%	66.7%	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 = 678
			GROUP BY
				map;