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

Sections

Clan Information

Statistics Summary
Clan:	IE
Home Page:
Activity:		42.75%
Members:	4 active members (9 total)
Avg. Member Points:	1,018
Total Kills:	26
Total Deaths:	9
Avg. Kills:	7
Kills per Death:	2.89
Kills per Minute:	1.42
Total Connection Time:	0d 00:18:20h
Avg. Connection Time:	0d 00:04:35h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	c8m1_apartment
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	ⱫØ₥฿łɆⱫⱫⱫ [IE]	1,070		0d 00:11:35h	26		100.00%	8	3.25
2	[IE] Marisa <3	1,000		0d 00:01:41h	0		0.00%	0	0.00
3	dr_thrax [IE]	1,000		0d 00:00:59h	0		0.00%	0	0.00
4	gaogaogao [IE]	1,000		0d 00:04:05h	0		0.00%	1	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	3 times	9
2	Killed a Hunter	2 times	4
3	Killed a Smoker	1 times	2
4	Killed a Charger	1 times	3

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Infected	5 times		31.25%
2	Survivors	4 times		25.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	HUNTER	3 times	25.00%		1	2	0.50
2	CHARGER	2 times	16.67%		0	2	0.00
3	BOOMER	2 times	16.67%		0	2	0.00
4	TeenGirl	1 times	8.33%
5	SPITTER	1 times	8.33%		0	1	0.00
6	SMOKER	1 times	8.33%		0	1	0.00
7	JOCKEY	1 times	8.33%		0	1	0.00
8	NamVet	1 times	8.33%		25	0	25.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	16		61.54%	1		33.33%	0.06
2		3.00	9		34.62%	2		66.67%	0.22

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		25	23	807	0	2	2.0000	92.0%	35.1	12.5
2	Smoker Claw	23	5	21	0	0	0.0000	21.7%	4.2	0.0
3	Hunter Claw	242	16	166	0	0	0.0000	6.6%	10.4	0.0
4	Charger Claw	25	5	52	0	0	0.0000	20.0%	10.4	0.0
5	Boomer Claw	160	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		16	6.3%	87.5%	6.3%
2	Smoker Claw	1	0.0%	100.0%	0.0%
3	Charger Claw	1	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 = 757
			GROUP BY
				map;