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

Sections

Clan Information

Statistics Summary
Clan:	CR
Home Page:
Activity:		75.40%
Members:	5 active members (5 total)
Avg. Member Points:	1,290
Total Kills:	629
Total Deaths:	5
Avg. Kills:	126
Kills per Death:	125.80
Kills per Minute:	6.80
Total Connection Time:	0d 01:32:27h
Avg. Connection Time:	0d 00:18:29h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	beldurra2_1
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		83.94%	0	528.00
2	[CR] S1NT4XYzzz	1,222		0d 00:21:16h	101		16.06%	5	20.20
3	[CR] ChenWONDERLANDS	1,000		0d 00:03:01h	0		0.00%	0	0.00
4	[CR] Lordbluxor	1,000		0d 00:06:26h	0		0.00%	0	0.00
5	[CR] cripertonimo2008	1,000		0d 00:01:43h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	42 times	126
2	Friendly Fire	36 times	-108
3	Protected Teammate	25 times	75
4	Killed a Hunter	7 times	14
5	Killed a Spitter	6 times	18
6	Killed a Boomer	5 times	5
7	Killed a Jockey	4 times	12
8	Killed a Charger	4 times	12
9	Revived Teammate	3 times	9
10	Healed Teammate	3 times	15
11	Used Adrenaline	2 times	4
12	Startled the Witch	2 times	-10
13	Killed a Witch	2 times	10
14	Killed a Smoker	2 times	4
15	Killed a Tank	1 times	4

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	16 times		43.24%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Mechanic	2 times	50.00%		528	0	528.00
2	Gambler	1 times	25.00%		80	3	26.67
3	Coach	1 times	25.00%		21	2	10.50

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	175		27.82%	22		52.38%	0.13
2		1.50	141		22.42%	3		7.14%	0.02
3		2.00	68		10.81%	7		16.67%	0.10
4		2.50	66		10.49%	4		9.52%	0.06
5		1.20	63		10.02%	0		0.00%	0.00
6		5.00	33		5.25%	0		0.00%	0.00
7		1.75	20		3.18%	2		4.76%	0.10
8		0.10	16		2.54%	0		0.00%	0.00
9		0.10	14		2.23%	0		0.00%	0.00
10		1.50	12		1.91%	2		4.76%	0.17
11		2.00	7		1.11%	1		2.38%	0.14
12		2.20	6		0.95%	1		2.38%	0.17
13		4.00	5		0.79%	0		0.00%	0.00
14		2.00	2		0.32%	0		0.00%	0.00
15		0.10	1		0.16%	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		265	197	3,190	0	10	10.0000	74.3%	16.2	26.5
2		71	106	7,231	0	7	7.0000	149.3%	68.2	10.1
3		122	6	854	1	3	3.0000	4.9%	142.3	40.7
4		230	76	1,185	0	1	1.0000	33.0%	15.6	230.0
5		36	6	194	0	1	1.0000	16.7%	32.3	36.0
6		91	7	636	0	0	0.0000	7.7%	90.9	0.0
7		130	0	0	0	0	0.0000	0.0%	0.0	0.0
8		97	42	1,245	0	0	0.0000	43.3%	29.6	0.0
9		5	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		158	15.8%	70.3%	13.9%
2		84	8.3%	76.2%	15.5%
3		68	19.1%	73.5%	7.4%
4		40	20.0%	70.0%	10.0%
5		5	0.0%	80.0%	20.0%
6		4	0.0%	100.0%	0.0%
7		4	0.0%	100.0%	0.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 = 641
			GROUP BY
				map;