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

Sections

Clan Information

Statistics Summary
Clan:	NI
Home Page:
Activity:		75.40%
Members:	5 active members (5 total)
Avg. Member Points:	1,163
Total Kills:	309
Total Deaths:	4
Avg. Kills:	62
Kills per Death:	77.25
Kills per Minute:	5.29
Total Connection Time:	0d 00:58:28h
Avg. Connection Time:	0d 00:11:41h
Favorite Server:*	Gunnys Krazy Kat Hooch
Favorite Map:*	Glubtastic3_2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[NI] Iwatani_Naofumi	1,638		0d 00:34:39h	219		70.87%	3	73.00
2	[NI] zambranadanild	1,137		0d 00:13:56h	68		22.01%	0	68.00
3	[NI] M1Y4M0T0	1,039		0d 00:07:27h	22		7.12%	1	22.00
4	[NI] dragoninfernal181	1,000		0d 00:00:33h	0		0.00%	0	0.00
5	[NI] eljonr12	1,000		0d 00:01:53h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	42 times	126
2	Killed a Boomer	26 times	26
3	Friendly Fire	20 times	-60
4	Killed a Spitter	17 times	51
5	Killed a Smoker	10 times	20
6	Killed a Jockey	9 times	27
7	Killed a Charger	9 times	27
8	Revived Teammate	7 times	21
9	Used Adrenaline	3 times	6
10	Protected Teammate	3 times	9
11	Killed a Hunter	2 times	4
12	Hunter Punter (Melee a Hunter Mid-jump)	2 times	10
13	Startled the Witch	1 times	-5
14	Killed a Tank	1 times	4
15	Healed Teammate	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	7 times		33.33%
2	Infected	2 times		9.52%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	NamVet	2 times	66.67%		90	1	90.00
2	Gambler	1 times	33.33%		219	3	73.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	153		49.51%	4		9.52%	0.03
2		2.00	44		14.24%	14		33.33%	0.32
3		2.20	44		14.24%	18		42.86%	0.41
4		1.00	17		5.50%	3		7.14%	0.18
5		1.50	14		4.53%	1		2.38%	0.07
6		1.00	11		3.56%	1		2.38%	0.09
7		1.50	9		2.91%	0		0.00%	0.00
8		5.00	7		2.27%	0		0.00%	0.00
9		1.50	4		1.29%	1		2.38%	0.25
10		0.10	3		0.97%	0		0.00%	0.00
11		0.10	3		0.97%	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		1,678	317	5,349	3	22	22.0000	18.9%	16.9	76.3
2		501	178	10,288	0	22	22.0000	35.5%	57.8	22.8
3		958	264	5,900	4	11	11.0000	27.6%	22.3	87.1
4		21	7	13	0	0	0.0000	33.3%	1.9	0.0
5		4	0	0	0	0	0.0000	0.0%	0.0	0.0
6		3	4	23	0	0	0.0000	133.3%	5.8	0.0
7	Hunter Claw	14	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		301	25.6%	57.8%	16.6%
2		243	21.4%	63.4%	15.2%
3		76	28.9%	56.6%	14.5%
4		4	0.0%	75.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 = 694
			GROUP BY
				map;