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

Sections

Clan Information

Statistics Summary
Clan:	NL
Home Page:
Activity:		54.00%
Members:	4 active members (6 total)
Avg. Member Points:	1,453
Total Kills:	676
Total Deaths:	3
Avg. Kills:	169
Kills per Death:	225.33
Kills per Minute:	5.85
Total Connection Time:	0d 01:55:37h
Avg. Connection Time:	0d 00:28:54h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	l4d2_timemachine_02
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[NL] 4Bigguys	2,394		0d 01:20:02h	500		73.96%	3	166.67
2	[NL] wolvencrew	1,358		0d 00:27:27h	152		22.49%	0	152.00
3	[NL] Jaelo	1,060		0d 00:07:24h	24		3.55%	0	24.00
4	[NL] Mo Money	1,000		0d 00:00:44h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	106 times	318
2	Protected Teammate	18 times	54
3	Friendly Fire	17 times	-51
4	Killed a Jockey	13 times	39
5	Killed a Charger	9 times	27
6	Killed a Spitter	7 times	21
7	Killed a Smoker	7 times	14
8	Killed a Boomer	7 times	7
9	Killed a Hunter	5 times	10
10	Revived Teammate	3 times	9
11	Used Adrenaline	2 times	4
12	Killed a Tank	2 times	8

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	10 times		40.00%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	228		33.73%	38		35.85%	0.17
2		1.00	143		21.15%	18		16.98%	0.13
3		1.50	60		8.88%	5		4.72%	0.08
4		1.00	57		8.43%	9		8.49%	0.16
5		1.50	30		4.44%	4		3.77%	0.13
6		0.10	29		4.29%	0		0.00%	0.00
7		1.00	25		3.70%	9		8.49%	0.36
8		2.00	25		3.70%	7		6.60%	0.28
9		5.00	18		2.66%	0		0.00%	0.00
10		2.00	13		1.92%	6		5.66%	0.46
11		2.50	10		1.48%	4		3.77%	0.40
12		1.50	10		1.48%	0		0.00%	0.00
13		1.75	8		1.18%	4		3.77%	0.50
14		2.50	7		1.04%	0		0.00%	0.00
15		1.50	6		0.89%	0		0.00%	0.00
16		1.50	3		0.44%	1		0.94%	0.33
17		2.20	2		0.30%	1		0.94%	0.50
18		0.10	2		0.30%	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,133	185	11,238	7	11	11.0000	8.7%	60.7	193.9
2		881	47	3,775	4	11	11.0000	5.3%	80.3	80.1
3		708	81	2,274	1	7	7.0000	11.4%	28.1	101.1
4		685	166	5,239	0	6	6.0000	24.2%	31.6	114.2
5		226	51	1,381	1	2	2.0000	22.6%	27.1	113.0
6		11	16	454	0	2	2.0000	145.5%	28.4	5.5
7		23	2	525	1	1	1.0000	8.7%	262.5	23.0
8		107	7	796	0	1	1.0000	6.5%	113.7	107.0
9		95	25	700	0	0	0.0000	26.3%	28.0	0.0
10		35	30	393	0	0	0.0000	85.7%	13.1	0.0
11		5	1	1	0	0	0.0000	20.0%	1.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		175	14.3%	71.4%	14.3%
2		146	19.9%	61.6%	18.5%
3		62	12.9%	71.0%	16.1%
4		43	7.0%	81.4%	11.6%
5		36	5.6%	69.4%	25.0%
6		27	7.4%	77.8%	14.8%
7		16	6.3%	50.0%	43.8%
8		10	0.0%	100.0%	0.0%
9		7	57.1%	28.6%	14.3%
10		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 = 661
			GROUP BY
				map;