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

Sections

Clan Information

Statistics Summary
Clan:	HR
Home Page:
Activity:		80.00%
Members:	1 active members (1 total)
Avg. Member Points:	2,552
Total Kills:	711
Total Deaths:	7
Avg. Kills:	711
Kills per Death:	101.57
Kills per Minute:	6.56
Total Connection Time:	0d 01:48:21h
Avg. Connection Time:	0d 01:48:21h
Favorite Server:*
Favorite Map:*	bdp_bunker01
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[HR] Giankz	2,552		0d 01:48:21h	711		100.00%	7	101.57

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Friendly Fire	63 times	-189
2	Headshot Kill	50 times	150
3	Protected Teammate	33 times	99
4	Killed a Spitter	8 times	24
5	Killed a Jockey	7 times	21
6	Killed a Charger	6 times	18
7	Revived Teammate	3 times	9
8	Killed a Smoker	3 times	6
9	Killed a Boomer	3 times	3
10	Killed a Tank	2 times	8
11	Killed a Hunter	2 times	4
12	Used Adrenaline	1 times	2

Team Selection *

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

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	136		19.13%	5		10.00%	0.04
2		1.00	83		11.67%	6		12.00%	0.07
3		0.10	83		11.67%	0		0.00%	0.00
4		2.00	73		10.27%	6		12.00%	0.08
5		1.00	68		9.56%	11		22.00%	0.16
6		2.00	53		7.45%	11		22.00%	0.21
7		1.50	47		6.61%	2		4.00%	0.04
8		2.00	35		4.92%	0		0.00%	0.00
9		5.00	34		4.78%	0		0.00%	0.00
10		2.20	33		4.64%	4		8.00%	0.12
11		1.00	20		2.81%	2		4.00%	0.10
12		1.00	16		2.25%	2		4.00%	0.13
13		2.50	10		1.41%	0		0.00%	0.00
14		2.00	9		1.27%	1		2.00%	0.11
15		1.00	3		0.42%	0		0.00%	0.00
16		0.10	3		0.42%	0		0.00%	0.00
17		2.50	2		0.28%	0		0.00%	0.00
18		1.20	1		0.14%	0		0.00%	0.00
19		1.00	1		0.14%	0		0.00%	0.00
20		0.10	1		0.14%	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		381	114	13,068	1	10	10.0000	29.9%	114.6	38.1
2		476	22	1,936	1	6	6.0000	4.6%	88.0	79.3
3		73	42	666	0	3	3.0000	57.5%	15.9	24.3
4		582	59	1,499	0	2	2.0000	10.1%	25.4	291.0
5		1,302	281	11,406	1	2	2.0000	21.6%	40.6	651.0
6		1,018	48	274	0	1	1.0000	4.7%	5.7	1,018
7		186	2	83	0	1	1.0000	1.1%	41.5	186.0
8		13	6	111	0	1	1.0000	46.2%	18.5	13.0
9		1	0	0	0	0	0.0000	0.0%	0.0	0.0
10		625	87	2,754	0	0	0.0000	13.9%	31.7	0.0
11		156	59	493	0	0	0.0000	37.8%	8.4	0.0
12		17	15	15	0	0	0.0000	88.2%	1.0	0.0
13		71	23	966	0	0	0.0000	32.4%	42.0	0.0
14		3	2	2	0	0	0.0000	66.7%	1.0	0.0
15		122	2	180	0	0	0.0000	1.6%	90.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		194	22.2%	55.2%	22.7%
2		95	10.5%	84.2%	5.3%
3		85	29.4%	43.5%	27.1%
4		54	13.0%	53.7%	33.3%
5		53	11.3%	75.5%	13.2%
6		47	8.5%	80.9%	10.6%
7		32	15.6%	50.0%	34.4%
8		22	31.8%	50.0%	18.2%
9		16	12.5%	75.0%	12.5%
10		15	0.0%	100.0%	0.0%
11		2	50.0%	50.0%	0.0%
12		1	100.0%	0.0%	0.0%
13		1	100.0%	0.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 = 774
			GROUP BY
				map;