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

Sections

Clan Information

Statistics Summary
Clan:	CR
Home Page:
Activity:		37.00%
Members:	4 active members (20 total)
Avg. Member Points:	1,435
Total Kills:	793
Total Deaths:	9
Avg. Kills:	198
Kills per Death:	88.11
Kills per Minute:	6.76
Total Connection Time:	0d 01:57:17h
Avg. Connection Time:	0d 00:29:19h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	l4d2_lotrm3_helms_deep_redux
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[CR] Hero	2,739		0d 01:48:41h	792		99.87%	8	99.00
2	[CR] Tortilla	1,000		0d 00:01:33h	0		0.00%	1	0.00
3	[CR] kendall110k	1,000		0d 00:00:37h	0		0.00%	0	0.00
4	[CR] Gimena	999		0d 00:06:26h	1		0.13%	0	1.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Friendly Fire	23 times	-69
2	Headshot Kill	15 times	45
3	Used Adrenaline	8 times	16
4	Revived Teammate	7 times	21
5	Protected Teammate	7 times	21
6	Killed a Tank	4 times	16
7	Killed a Jockey	4 times	12
8	Killed a Charger	4 times	12
9	Killed a Spitter	2 times	6
10	Killed a Hunter	2 times	4
11	Killed a Boomer	2 times	2
12	Tank Bilebombed	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	14 times		41.18%
2	Infected	1 times		2.94%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	SPITTER	1 times	16.67%
2	Manager	1 times	16.67%		1	0	1.00
3	JOCKEY	1 times	16.67%
4	Mechanic	1 times	16.67%		505	2	252.50
5	Coach	1 times	16.67%		52	2	26.00
6	BOOMER	1 times	16.67%		0	1	0.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	238		30.01%	5		16.13%	0.02
2		0.10	206		25.98%	9		29.03%	0.04
3		0.10	61		7.69%	0		0.00%	0.00
4		5.00	6		0.76%	0		0.00%	0.00
5		1.00	5		0.63%	0		0.00%	0.00
6		1.50	5		0.63%	0		0.00%	0.00
7		1.20	3		0.38%	0		0.00%	0.00
8		0.50	3		0.38%	0		0.00%	0.00
9		0.10	3		0.38%	0		0.00%	0.00
10		2.50	1		0.13%	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		1,029	279	25,323	0	10	10.0000	27.1%	90.8	102.9
2		141	63	1,949	0	1	1.0000	44.7%	30.9	141.0
3		3	0	0	0	0	0.0000	0.0%	0.0	0.0
4		2	6	6	0	0	0.0000	300.0%	1.0	0.0
5		23	0	0	0	0	0.0000	0.0%	0.0	0.0
6		1	0	0	0	0	0.0000	0.0%	0.0	0.0
7		1	0	0	0	0	0.0000	0.0%	0.0	0.0
8	Boomer Claw	84	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		81	16.0%	67.9%	16.0%
2		3	0.0%	66.7%	33.3%

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 = 641
			GROUP BY
				map;