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

Sections

Clan Information

Statistics Summary
Clan:	PA
Home Page:
Activity:		50.42%
Members:	7 active members (26 total)
Avg. Member Points:	1,201
Total Kills:	562
Total Deaths:	7
Avg. Kills:	80
Kills per Death:	80.29
Kills per Minute:	4.78
Total Connection Time:	0d 01:57:39h
Avg. Connection Time:	0d 00:16:48h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	dw_woods
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	ZEKIII [PA]	1,804		0d 00:41:02h	307		54.63%	4	76.75
2	D3athGenes [PA]	1,211		0d 00:15:44h	77		13.70%	0	77.00
3	Ishi [PA]	1,149		0d 00:23:55h	64		11.39%	0	64.00
4	CX1.MP4 [PA]	1,139		0d 00:07:55h	63		11.21%	0	63.00
5	germayori_kiki [PA]	1,108		0d 00:23:56h	51		9.07%	0	51.00
6	HILDYWILDY [PA]	1,000		0d 00:00:57h	0		0.00%	0	0.00
7	GokiGT [PA]	997		0d 00:04:10h	0		0.00%	3	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	71 times	213
2	Friendly Fire	40 times	-120
3	Protected Teammate	20 times	60
4	Killed a Witch	6 times	30
5	Killed a Spitter	6 times	18
6	Killed a Hunter	6 times	12
7	Killed a Tank	4 times	16
8	Killed a Smoker	4 times	8
9	Killed a Charger	4 times	12
10	Startled the Witch	3 times	-15
11	Revived Teammate	3 times	9
12	Killed a Jockey	3 times	9
13	Killed a Boomer	3 times	3
14	Used Adrenaline	2 times	4
15	Tank Bilebombed	2 times	10
16	Rescued Teammate	2 times	6
17	No Survivors Died/Incapped by Tank	2 times	2
18	Hunter Punter (Melee a Hunter Mid-jump)	1 times	5
19	Healed Teammate	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	12 times		38.71%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Manager	2 times	40.00%		371	4	92.75
2	NamVet	2 times	40.00%		128	0	128.00
3	Gambler	1 times	20.00%		63	0	63.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.50	106		18.86%	11		15.49%	0.10
2		1.00	73		12.99%	12		16.90%	0.16
3		3.00	72		12.81%	18		25.35%	0.25
4		1.00	67		11.92%	7		9.86%	0.10
5		5.00	64		11.39%	1		1.41%	0.02
6		3.00	49		8.72%	6		8.45%	0.12
7		3.00	42		7.47%	7		9.86%	0.17
8		2.00	32		5.69%	2		2.82%	0.06
9		3.00	30		5.34%	2		2.82%	0.07
10		3.00	7		1.25%	3		4.23%	0.43
11		0.10	7		1.25%	0		0.00%	0.00
12		5.00	6		1.07%	1		1.41%	0.17
13		1.20	3		0.53%	0		0.00%	0.00
14		5.00	3		0.53%	1		1.41%	0.33
15		0.10	1		0.18%	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		209	574	19,494	0	9	9.0000	274.6%	34.0	23.2
2		201	411	12,497	0	8	8.0000	204.5%	30.4	25.1
3		183	13	623	0	2	2.0000	7.1%	47.9	91.5
4		494	21	844	1	2	2.0000	4.3%	40.2	247.0
5		77	27	289	0	1	1.0000	35.1%	10.7	77.0
6		123	22	1,276	0	1	1.0000	17.9%	58.0	123.0
7		23	0	0	0	0	0.0000	0.0%	0.0	0.0
8		3	0	0	0	0	0.0000	0.0%	0.0	0.0
9		21	9	352	0	0	0.0000	42.9%	39.1	0.0
10		8	7	6	0	0	0.0000	87.5%	0.9	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		540	20.6%	74.4%	5.0%
2		380	11.6%	75.0%	13.4%
3		27	44.4%	51.9%	3.7%
4		22	13.6%	77.3%	9.1%
5		18	11.1%	50.0%	38.9%
6		13	30.8%	69.2%	0.0%
7		9	0.0%	66.7%	33.3%

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