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

Sections

Clan Information

Statistics Summary
Clan:	FR
Home Page:
Activity:		59.66%
Members:	6 active members (6 total)
Avg. Member Points:	1,047
Total Kills:	100
Total Deaths:	1
Avg. Kills:	17
Kills per Death:	100.00
Kills per Minute:	2.95
Total Connection Time:	0d 00:33:54h
Avg. Connection Time:	0d 00:05:39h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	l4d2_lotrm1_moria
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[FR] pfcopa	1,188		0d 00:13:52h	72		72.00%	1	72.00
2	[FR] mikility972	1,054		0d 00:03:45h	16		16.00%	0	16.00
3	[FR] ♥Francis♥戦車への攻撃	1,023		0d 00:09:11h	7		7.00%	0	7.00
4	[FR] ivashadvokatov	1,016		0d 00:04:33h	5		5.00%	0	5.00
5	[FR] Ptit_Jul	1,000		0d 00:02:06h	0		0.00%	0	0.00
6	[FR] Saiki	1,000		0d 00:00:27h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	14 times	42
2	Protected Teammate	10 times	30
3	Friendly Fire	2 times	-6
4	Startled the Witch	1 times	-5
5	Revived Teammate	1 times	3
6	Killed a Witch	1 times	5
7	Killed a Spitter	1 times	3
8	Killed a Smoker	1 times	2
9	Killed a Jockey	1 times	3
10	Killed a Charger	1 times	3
11	Killed a Boomer	1 times	1

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	10 times		35.71%
2	Infected	2 times		7.14%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Gambler	3 times	50.00%		79	1	79.00
2	Producer	1 times	16.67%		16	0	16.00
3	HUNTER	1 times	16.67%
4	Mechanic	1 times	16.67%		5	0	5.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.20	41		41.00%	6		42.86%	0.15
2		4.00	26		26.00%	7		50.00%	0.27
3		2.00	20		20.00%	1		7.14%	0.05
4		0.10	6		6.00%	0		0.00%	0.00
5		2.00	4		4.00%	0		0.00%	0.00
6		1.00	3		3.00%	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		233	92	2,926	3	3	3.0000	39.5%	31.8	77.7
2		704	148	2,667	0	1	1.0000	21.0%	18.0	704.0
3		398	0	0	0	0	0.0000	0.0%	0.0	0.0
4	Hunter Claw	4	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		139	31.7%	37.4%	30.9%
2		79	11.4%	68.4%	20.3%

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