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

Sections

Clan Information

Statistics Summary
Clan:	QA
Home Page:
Activity:		53.00%
Members:	1 active members (1 total)
Avg. Member Points:	6,956
Total Kills:	1,545
Total Deaths:	165
Avg. Kills:	1,545
Kills per Death:	9.36
Kills per Minute:	1.34
Total Connection Time:	0d 19:12:07h
Avg. Connection Time:	0d 19:12:07h
Favorite Server:*
Favorite Map:*	l4d2_tanksplayground
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[QA] jane 11	6,956		0d 19:12:07h	1,545		100.00%	165	9.36

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Killed a Tank	12 times	48
2	Used Adrenaline	9 times	18
3	Tank Bilebombed	3 times	15
4	Revived Teammate	3 times	9

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	3 times		42.86%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		0.10	7		0.45%	0		0.00%	0.00
2		-25.00	3		0.19%	0		0.00%	0.00
3		1.00	2		0.13%	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		340	551	77,093	0	2	2.0000	162.1%	139.9	170.0
2		2	5	74	0	0	0.0000	250.0%	14.8	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		454	11.2%	65.6%	23.1%

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 = 663
			GROUP BY
				map;