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

Sections

Clan Information

Statistics Summary
Clan:	GP
Home Page:
Activity:		60.50%
Members:	2 active members (2 total)
Avg. Member Points:	1,015
Total Kills:	21
Total Deaths:	0
Avg. Kills:	11
Kills per Death:	-
Kills per Minute:	3.04
Total Connection Time:	0d 00:06:54h
Avg. Connection Time:	0d 00:03:27h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	c1m2_streets
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[GP] Shmy ♡	1,030		0d 00:06:39h	21		100.00%	0	21.00
2	[GP] Pobedna Pasma	1,000		0d 00:00:15h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Friendly Fire	14 times	-42
2	Headshot Kill	5 times	15
3	Killed a Jockey	2 times	6
4	Killed a Hunter	2 times	4
5	Killed a Boomer	2 times	2
6	Killed a Spitter	1 times	3

Team Selection *

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

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Gambler	1 times	50.00%		6	0	6.00
2	Mechanic	1 times	50.00%		15	0	15.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.50	12		57.14%	3		60.00%	0.25
2		2.20	9		42.86%	2		40.00%	0.22

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		113	40	716	1	3	3.0000	35.4%	17.9	37.7
2		5	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		40	45.0%	30.0%	25.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 = 637
			GROUP BY
				map;