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

Sections

Clan Information

Statistics Summary
Clan:	RS
Home Page:
Activity:		98.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,082
Total Kills:	39
Total Deaths:	1
Avg. Kills:	39
Kills per Death:	39.00
Kills per Minute:	5.82
Total Connection Time:	0d 00:06:42h
Avg. Connection Time:	0d 00:06:42h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	atc1m1_appartment
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[RS] SImke1	1,082		0d 00:06:42h	39		100.00%	1	39.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Startled the Witch	2 times	-10
2	Killed a Jockey	2 times	6
3	Killed a Witch	1 times	5
4	Headshot Kill	1 times	3

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	2 times		50.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Mechanic	1 times	100.00%		39	1	39.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	11		28.21%	1		100.00%	0.09
2		1.50	10		25.64%	0		0.00%	0.00
3		1.00	8		20.51%	0		0.00%	0.00
4		0.10	6		15.38%	0		0.00%	0.00
5		2.50	4		10.26%	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		16	14	333	0	1	1.0000	87.5%	23.8	16.0
2		129	0	0	0	0	0.0000	0.0%	0.0	0.0
3		6	0	0	0	0	0.0000	0.0%	0.0	0.0
4		4	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		11	0.0%	54.5%	45.5%

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