Gunnys Krazy Kat HLStatsX Hooch - Left 4 Dead 2 - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	GF
Home Page:
Activity:		76.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,128
Total Kills:	50
Total Deaths:	2
Avg. Kills:	50
Kills per Death:	25.00
Kills per Minute:	5.02
Total Connection Time:	0d 00:09:58h
Avg. Connection Time:	0d 00:09:58h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	c11m1_greenhouse
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[GF] D.O.S	1,128		0d 00:09:58h	50		100.00%	2	25.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	8 times	24
2	Friendly Fire	7 times	-21
3	Protected Teammate	6 times	18
4	Revived Teammate	1 times	3
5	Killed a Spitter	1 times	3
6	Killed a Boomer	1 times	1

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	1 times		25.00%
2	Infected	1 times		25.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	SMOKER	1 times	33.33%		0	1	0.00
2	Manager	1 times	33.33%		50	0	50.00
3	HUNTER	1 times	33.33%		0	1	0.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.20	50		100.00%	8		100.00%	0.16

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		712	165	2,971	0	2	2.0000	23.2%	18.0	356.0
2	Smoker Claw	9	0	0	0	0	0.0000	0.0%	0.0	0.0
3	Hunter Claw	238	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		161	18.6%	53.4%	28.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 = 673
			GROUP BY
				map;