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

Sections

Clan Information

Statistics Summary
Clan:	VE
Home Page:
Activity:		42.69%
Members:	13 active members (140 total)
Avg. Member Points:	1,182
Total Kills:	930
Total Deaths:	67
Avg. Kills:	72
Kills per Death:	13.88
Kills per Minute:	5.24
Total Connection Time:	0d 02:57:34h
Avg. Connection Time:	0d 00:13:39h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	c1m1_hotel
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	BioEmptY [VE]	1,665		0d 00:22:56h	243		26.13%	1	243.00
2	ANSUMI1234 [VE]	1,579		0d 00:57:26h	242		26.02%	49	4.94
3	Mercury [VE]	1,328		0d 00:18:13h	119		12.80%	1	119.00
4	Rage_Soldier [VE]	1,279		0d 00:17:01h	96		10.32%	5	19.20
5	Stoylag [VE]	1,247		0d 00:09:01h	88		9.46%	1	88.00
6	Lincyjujux [VE]	1,204		0d 00:30:53h	111		11.94%	10	11.10
7	brahinert6 [VE]	1,049		0d 00:07:48h	24		2.58%	0	24.00
8	Yohander2007 [VE]	1,016		0d 00:03:00h	5		0.54%	0	5.00
9	Giorno418 [VE]	1,004		0d 00:00:20h	2		0.22%	0	2.00
10	ElRusso [VE]	1,000		0d 00:08:05h	0		0.00%	0	0.00
11	Bread-Cat•⩊• [VE]	1,000		0d 00:01:03h	0		0.00%	0	0.00
12	Larry K. [VE]	1,000		0d 00:00:57h	0		0.00%	0	0.00
13	kazuuas [VE]	994		0d 00:00:51h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	34 times	102
2	Friendly Fire	27 times	-81
3	Protected Teammate	17 times	51
4	Killed a Jockey	8 times	24
5	Killed a Charger	8 times	24
6	Revived Teammate	6 times	18
7	Killed a Spitter	6 times	18
8	Killed a Boomer	6 times	6
9	Killed a Smoker	5 times	10
10	Killed a Hunter	5 times	10
11	Used Adrenaline	4 times	8
12	Hunter Punter (Melee a Hunter Mid-jump)	2 times	10
13	Startled the Witch	1 times	-5
14	Rescued Teammate	1 times	3
15	No Survivors Died/Incapped by Tank	1 times	1
16	Killed a Tank	1 times	4

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	12 times		30.00%
2	Infected	4 times		10.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Producer	3 times	42.86%		120	7	17.14
2	Coach	2 times	28.57%		164	9	18.22
3	Biker	1 times	14.29%		5	0	5.00
4	Mechanic	1 times	14.29%		67	0	67.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	65		6.99%	7		6.54%	0.11
2		3.00	65		6.99%	3		2.80%	0.05
3		3.00	44		4.73%	4		3.74%	0.09
4		5.00	39		4.19%	7		6.54%	0.18
5		3.00	34		3.66%	2		1.87%	0.06
6		1.00	23		2.47%	3		2.80%	0.13
7		1.50	19		2.04%	2		1.87%	0.11
8		0.10	19		2.04%	0		0.00%	0.00
9		5.00	16		1.72%	0		0.00%	0.00
10		0.10	12		1.29%	0		0.00%	0.00
11		3.00	12		1.29%	0		0.00%	0.00
12		2.00	10		1.08%	2		1.87%	0.20
13		0.50	9		0.97%	0		0.00%	0.00
14		1.00	5		0.54%	2		1.87%	0.40
15		5.00	5		0.54%	1		0.93%	0.20
16		5.00	5		0.54%	0		0.00%	0.00
17		2.00	1		0.11%	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		494	734	18,695	0	18	18.0000	148.6%	25.5	27.4
2		120	183	3,926	0	5	5.0000	152.5%	21.5	24.0
3		282	54	4,748	0	2	2.0000	19.1%	87.9	141.0
4		89	12	215	0	2	2.0000	13.5%	17.9	44.5
5		299	39	1,763	0	0	0.0000	13.0%	45.2	0.0
6		78	7	9	0	0	0.0000	9.0%	1.3	0.0
7		1	0	0	0	0	0.0000	0.0%	0.0	0.0
8		340	126	3,988	0	0	0.0000	37.1%	31.7	0.0
9		4	3	15	0	0	0.0000	75.0%	5.0	0.0
10	Charger Claw	23	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		703	17.5%	62.7%	19.8%
2		178	2.2%	80.3%	17.4%
3		112	13.4%	72.3%	14.3%
4		53	17.0%	58.5%	24.5%
5		33	33.3%	48.5%	18.2%
6		12	33.3%	58.3%	8.3%
7		4	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 = 616
			GROUP BY
				map;