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

Sections

Clan Information

Statistics Summary
Clan:	CR
Home Page:
Activity:		57.20%
Members:	10 active members (10 total)
Avg. Member Points:	1,164
Total Kills:	701
Total Deaths:	6
Avg. Kills:	70
Kills per Death:	116.83
Kills per Minute:	5.93
Total Connection Time:	0d 01:58:12h
Avg. Connection Time:	0d 00:11:49h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	l4d2_tank_challenge
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[CR] ItIsJoidOk	2,226		0d 01:00:01h	528		75.32%	0	528.00
2	[CR] S1NT4XYzzz	1,222		0d 00:21:16h	101		14.41%	5	20.20
3	[CR] Col8	1,052		0d 00:07:52h	19		2.71%	0	19.00
4	[CR] Raul_KraBv	1,050		0d 00:06:14h	19		2.71%	0	19.00
5	[CR] necro fantasma	1,049		0d 00:04:16h	14		2.00%	1	14.00
6	[CR] Blactrix19	1,041		0d 00:06:11h	20		2.85%	0	20.00
7	[CR] ChenWONDERLANDS	1,000		0d 00:03:01h	0		0.00%	0	0.00
8	[CR] Lordbluxor	1,000		0d 00:06:26h	0		0.00%	0	0.00
9	[CR] cripertonimo2008	1,000		0d 00:01:43h	0		0.00%	0	0.00
10	[CR] bull	1,000		0d 00:01:12h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Friendly Fire	19 times	-57
2	Headshot Kill	16 times	48
3	Revived Teammate	6 times	18
4	Protected Teammate	5 times	15
5	Killed a Spitter	3 times	9
6	Killed a Hunter	3 times	6
7	Healed Teammate	3 times	15
8	Used Adrenaline	2 times	4
9	Killed a Smoker	2 times	4
10	Startled the Witch	1 times	-5
11	Killed a Witch	1 times	5
12	Killed a Jockey	1 times	3
13	Killed a Charger	1 times	3

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	15 times		37.50%
2	Infected	1 times		2.50%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Gambler	3 times	50.00%		118	3	39.33
2	Producer	1 times	16.67%		20	0	20.00
3	Mechanic	1 times	16.67%		14	1	14.00
4	Coach	1 times	16.67%		21	2	10.50

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	38		5.42%	3		5.77%	0.08
2		5.00	25		3.57%	0		0.00%	0.00
3		1.75	20		2.85%	2		3.85%	0.10
4		2.00	19		2.71%	4		7.69%	0.21
5		0.10	16		2.28%	0		0.00%	0.00
6		0.10	14		2.00%	0		0.00%	0.00
7		1.50	12		1.71%	2		3.85%	0.17
8		1.50	10		1.43%	3		5.77%	0.30
9		1.50	8		1.14%	1		1.92%	0.13
10		2.20	6		0.86%	1		1.92%	0.17
11		2.00	2		0.29%	0		0.00%	0.00
12		1.00	2		0.29%	0		0.00%	0.00
13		0.10	1		0.14%	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		28	82	1,432	0	2	2.0000	292.9%	17.5	14.0
2		230	76	1,185	0	1	1.0000	33.0%	15.6	230.0
3		36	6	194	0	1	1.0000	16.7%	32.3	36.0
4		91	7	636	0	0	0.0000	7.7%	90.9	0.0
5		105	6	6	0	0	0.0000	5.7%	1.0	0.0
6		296	117	3,512	0	0	0.0000	39.5%	30.0	0.0
7		3	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		108	23.1%	58.3%	18.5%
2		78	12.8%	73.1%	14.1%
3		68	19.1%	73.5%	7.4%
4		4	0.0%	100.0%	0.0%
5		4	0.0%	100.0%	0.0%
6		3	0.0%	66.7%	33.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 = 641
			GROUP BY
				map;