Gunny's HLStatsX Hooch - Left 4 Dead 2 - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	SV
Home Page:
Activity:		66.14%
Members:	7 active members (31 total)
Avg. Member Points:	1,048
Total Kills:	135
Total Deaths:	2
Avg. Kills:	19
Kills per Death:	67.50
Kills per Minute:	3.82
Total Connection Time:	0d 00:35:21h
Avg. Connection Time:	0d 00:05:03h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	c5m1_waterfront
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Miwelasoxd [SV]	1,282		0d 00:21:56h	125		92.59%	1	125.00
2	Elmid [SV]	1,046		0d 00:05:55h	7		5.19%	1	7.00
3	VACE [SV]	1,006		0d 00:03:29h	3		2.22%	0	3.00
4	Horchatita [SV]	1,000		0d 00:00:33h	0		0.00%	0	0.00
5	gamelexGT22 [SV]	1,000		0d 00:01:16h	0		0.00%	0	0.00
6	Monster520 [SV]	1,000		0d 00:01:05h	0		0.00%	0	0.00
7	NARYA [SV]	1,000		0d 00:01:07h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Friendly Fire	20 times	-60
2	Headshot Kill	18 times	54
3	Killed a Tank	9 times	36
4	Revived Teammate	4 times	12
5	Protected Teammate	3 times	9
6	Used Adrenaline	2 times	4
7	Startled the Witch	1 times	-5
8	Killed a Witch	1 times	5
9	Killed a Jockey	1 times	3
10	Killed a Boomer	1 times	1
11	Healed Teammate	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	9 times		37.50%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Gambler	1 times	25.00%
2	Mechanic	1 times	25.00%
3	Coach	1 times	25.00%		125	1	125.00
4	NamVet	1 times	25.00%		7	1	7.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	42		31.11%	3		16.67%	0.07
2		2.00	27		20.00%	8		44.44%	0.30
3		1.00	19		14.07%	3		16.67%	0.16
4		1.50	14		10.37%	0		0.00%	0.00
5		3.00	8		5.93%	3		16.67%	0.38
6		5.00	5		3.70%	0		0.00%	0.00
7		0.10	4		2.96%	0		0.00%	0.00
8		1.00	3		2.22%	0		0.00%	0.00
9		2.00	3		2.22%	1		5.56%	0.33
10		0.10	3		2.22%	0		0.00%	0.00
11		5.00	3		2.22%	0		0.00%	0.00
12		2.00	1		0.74%	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		282	201	18,196	0	3	3.0000	71.3%	90.5	94.0
2		100	106	1,834	0	1	1.0000	106.0%	17.3	100.0
3		425	130	8,667	0	1	1.0000	30.6%	66.7	425.0
4		356	316	21,830	0	1	1.0000	88.8%	69.1	356.0
5		5	0	0	0	0	0.0000	0.0%	0.0	0.0
6		6	0	0	0	0	0.0000	0.0%	0.0	0.0
7		25	0	0	0	0	0.0000	0.0%	0.0	0.0
8		6	0	0	0	0	0.0000	0.0%	0.0	0.0
9		1	1	1	0	0	0.0000	100.0%	1.0	0.0
10		81	181	2,895	0	0	0.0000	223.5%	16.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		292	12.3%	70.9%	16.8%
2		201	9.0%	78.6%	12.4%
3		181	11.6%	66.3%	22.1%
4		130	21.5%	63.8%	14.6%
5		106	13.2%	69.8%	17.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 = 649
			GROUP BY
				map;