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

Sections

Clan Information

Statistics Summary
Clan:	DE
Home Page:
Activity:		21.00%
Members:	3 active members (25 total)
Avg. Member Points:	4,763
Total Kills:	4,725
Total Deaths:	17
Avg. Kills:	1,575
Kills per Death:	277.94
Kills per Minute:	8.12
Total Connection Time:	0d 09:42:04h
Avg. Connection Time:	0d 03:14:01h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	c1918_red_square_c4
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Rambo62 [DE]	10,512		0d 08:53:28h	4,008		84.83%	14	286.29
2	Boo [DE]	2,755		0d 00:47:15h	708		14.98%	3	236.00
3	Legion [DE]	1,021		0d 00:01:21h	9		0.19%	0	9.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	77 times	231
2	Protected Teammate	28 times	84
3	Friendly Fire	23 times	-69
4	Killed a Hunter	15 times	30
5	Killed a Boomer	13 times	13
6	Killed a Spitter	12 times	36
7	Killed a Jockey	9 times	27
8	Killed a Charger	7 times	21
9	Killed a Smoker	6 times	12
10	Revived Teammate	5 times	15
11	Used Adrenaline	4 times	8
12	Healed Teammate	4 times	20
13	Tank Bilebombed	2 times	10
14	Killed a Tank	2 times	8
15	Hunter Punter (Melee a Hunter Mid-jump)	2 times	10
16	Startled the Witch	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	TeenGirl	1 times	20.00%		190	0	190.00
2	Producer	1 times	20.00%		203	1	203.00
3	Gambler	1 times	20.00%		93	0	93.00
4	Mechanic	1 times	20.00%		505	2	252.50
5	Coach	1 times	20.00%		9	0	9.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	309		6.54%	34		11.04%	0.11
2		3.00	168		3.56%	8		2.60%	0.05
3		1.50	121		2.56%	11		3.57%	0.09
4		5.00	89		1.88%	0		0.00%	0.00
5		1.00	62		1.31%	4		1.30%	0.06
6		3.00	53		1.12%	3		0.97%	0.06
7		1.20	52		1.10%	0		0.00%	0.00
8		0.10	35		0.74%	0		0.00%	0.00
9		1.00	29		0.61%	4		1.30%	0.14
10		0.10	17		0.36%	1		0.32%	0.06
11		3.00	15		0.32%	3		0.97%	0.20
12		1.50	11		0.23%	4		1.30%	0.36
13		2.00	10		0.21%	3		0.97%	0.30
14		3.00	8		0.17%	1		0.32%	0.13
15		3.00	7		0.15%	1		0.32%	0.14
16		3.00	7		0.15%	0		0.00%	0.00
17		3.00	3		0.06%	0		0.00%	0.00
18		3.00	2		0.04%	0		0.00%	0.00
19		0.10	2		0.04%	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		637	76	7,429	2	23	23.0000	11.9%	97.8	27.7
2		1,812	98	10,352	5	19	19.0000	5.4%	105.6	95.4
3		555	132	1,425	0	4	4.0000	23.8%	10.8	138.8
4		191	80	2,694	1	4	4.0000	41.9%	33.7	47.8
5		369	57	5,019	1	3	3.0000	15.4%	88.1	123.0
6		72	50	845	0	3	3.0000	69.4%	16.9	24.0
7		138	0	0	0	0	0.0000	0.0%	0.0	0.0
8		44	7	86	0	0	0.0000	15.9%	12.3	0.0
9		7	0	0	0	0	0.0000	0.0%	0.0	0.0
10		7	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		131	28.2%	58.0%	13.7%
2		94	21.3%	63.8%	14.9%
3		65	12.3%	78.5%	9.2%
4		55	9.1%	69.1%	21.8%
5		45	13.3%	68.9%	17.8%
6		42	4.8%	88.1%	7.1%
7		7	42.9%	57.1%	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 = 647
			GROUP BY
				map;