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

Sections

Clan Information

Statistics Summary
Clan:	KG
Home Page:
Activity:		94.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,086
Total Kills:	30
Total Deaths:	0
Avg. Kills:	30
Kills per Death:	-
Kills per Minute:	5.10
Total Connection Time:	0d 00:05:53h
Avg. Connection Time:	0d 00:05:53h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	C1_mario1_1
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	suplexx [KG]	1,086		0d 00:05:53h	30		100.00%	0	30.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	5 times	15
2	Protected Teammate	1 times	3
3	Killed a Smoker	1 times	2
4	Killed a Boomer	1 times	1
5	Hunter Punter (Melee a Hunter Mid-jump)	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	1 times		33.33%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Coach	1 times	100.00%		30	0	30.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	15		50.00%	3		60.00%	0.20
2		3.00	9		30.00%	1		20.00%	0.11
3		5.00	6		20.00%	1		20.00%	0.17

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		33	13	267	0	1	1.0000	39.4%	20.5	33.0
2		72	11	350	0	0	0.0000	15.3%	31.8	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		13	0.0%	69.2%	30.8%
2		11	36.4%	45.5%	18.2%

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