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

Sections

Clan Information

Statistics Summary
Clan:	PR
Home Page:
Activity:		42.50%
Members:	4 active members (5 total)
Avg. Member Points:	1,183
Total Kills:	276
Total Deaths:	59
Avg. Kills:	69
Kills per Death:	4.68
Kills per Minute:	2.47
Total Connection Time:	0d 01:51:52h
Avg. Connection Time:	0d 00:27:58h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	l4d2_tanksplayground
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[PR] xavierromanofficial	1,673		0d 01:19:25h	276		100.00%	58	4.76
2	[PR] Cargo	1,059		0d 00:30:40h	0		0.00%	1	0.00
3	[PR] UnknownLonewolf	1,000		0d 00:00:25h	0		0.00%	0	0.00
4	[PR] rangenki	1,000		0d 00:01:22h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Revived Teammate	8 times	24
2	Used Adrenaline	7 times	14
3	Healed Teammate	1 times	5

Team Selection *

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

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Manager	2 times	66.67%		0	1	0.00
2	CHARGER	1 times	33.33%		1	1	1.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1	Charger Claw	2	0	0	0	0	0.0000	0.0%	0.0	0.0

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