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

Sections

Clan Information

Statistics Summary
Clan:	NI
Home Page:
Activity:		45.57%
Members:	7 active members (19 total)
Avg. Member Points:	1,215
Total Kills:	607
Total Deaths:	12
Avg. Kills:	87
Kills per Death:	50.58
Kills per Minute:	6.23
Total Connection Time:	0d 01:37:25h
Avg. Connection Time:	0d 00:13:55h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	l4d2_tank_challenge
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Peloncha [NI]	1,812		0d 00:33:15h	327		53.87%	2	163.50
2	Monik^w^ [NI]	1,413		0d 00:07:18h	152		25.04%	1	152.00
3	Leroy2002 [NI]	1,130		0d 00:33:11h	59		9.72%	3	19.67
4	JavDK22 [NI]	1,072		0d 00:04:23h	32		5.27%	3	10.67
5	Cale [NI]	1,048		0d 00:02:08h	23		3.79%	0	23.00
6	JARCDARK [NI]	1,029		0d 00:03:39h	14		2.31%	3	4.67
7	[NI] DeluxGamer	1,000		0d 00:13:31h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	76 times	228
2	Friendly Fire	23 times	-69
3	Protected Teammate	13 times	39
4	Killed a Hunter	9 times	18
5	Killed a Jockey	7 times	21
6	Killed a Boomer	6 times	6
7	Killed a Spitter	4 times	12
8	Killed a Smoker	4 times	8
9	Hunter Punter (Melee a Hunter Mid-jump)	4 times	20
10	Startled the Witch	2 times	-10
11	Killed a Charger	2 times	6
12	Revived Teammate	1 times	3
13	Killed a Witch	1 times	5
14	Killed a Tank	1 times	4

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	13 times		39.39%
2	Infected	1 times		3.03%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Mechanic	2 times	28.57%		350	2	175.00
2	NamVet	2 times	28.57%		73	3	24.33
3	SPITTER	1 times	14.29%		0	1	0.00
4	Producer	1 times	14.29%		32	2	16.00
5	Coach	1 times	14.29%		152	1	152.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	190		31.30%	27		35.53%	0.14
2		1.00	136		22.41%	13		17.11%	0.10
3		1.50	55		9.06%	18		23.68%	0.33
4		3.00	50		8.24%	3		3.95%	0.06
5		5.00	33		5.44%	8		10.53%	0.24
6		3.00	25		4.12%	0		0.00%	0.00
7		0.10	22		3.62%	0		0.00%	0.00
8		2.00	19		3.13%	5		6.58%	0.26
9		5.00	19		3.13%	0		0.00%	0.00
10		3.00	18		2.97%	1		1.32%	0.06
11		2.00	11		1.81%	0		0.00%	0.00
12		0.10	11		1.81%	0		0.00%	0.00
13		5.00	4		0.66%	0		0.00%	0.00
14		3.00	3		0.49%	0		0.00%	0.00
15		0.10	3		0.49%	0		0.00%	0.00
16		5.00	1		0.16%	0		0.00%	0.00
17		3.00	1		0.16%	0		0.00%	0.00
18		1.20	1		0.16%	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		348	347	10,593	0	9	9.0000	99.7%	30.5	38.7
2		903	115	6,546	2	5	5.0000	12.7%	56.9	180.6
3		62	23	679	0	4	4.0000	37.1%	29.5	15.5
4		184	61	1,497	1	1	1.0000	33.2%	24.5	184.0
5		193	52	836	0	0	0.0000	26.9%	16.1	0.0
6		1	0	0	0	0	0.0000	0.0%	0.0	0.0
7		50	1	1	0	0	0.0000	2.0%	1.0	0.0
8		176	28	831	0	0	0.0000	15.9%	29.7	0.0
9		5	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		337	9.8%	76.6%	13.6%
2		100	18.0%	58.0%	24.0%
3		59	13.6%	47.5%	39.0%
4		52	40.4%	50.0%	9.6%
5		27	11.1%	81.5%	7.4%
6		23	21.7%	78.3%	0.0%
7		1	0.0%	0.0%	100.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 = 694
			GROUP BY
				map;