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

Sections

Clan Information

Statistics Summary
Clan:	DO
Home Page:
Activity:		36.42%
Members:	7 active members (27 total)
Avg. Member Points:	1,316
Total Kills:	875
Total Deaths:	31
Avg. Kills:	125
Kills per Death:	28.23
Kills per Minute:	3.69
Total Connection Time:	0d 03:57:06h
Avg. Connection Time:	0d 00:33:52h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	l4d2_daybreak04_cruise
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Tejada021 [DO]	2,856		0d 03:22:03h	739		84.46%	31	23.84
2	DLowuis [DO]	1,396		0d 00:22:41h	136		15.54%	0	136.00
3	R4Ni3L [DO]	1,000		0d 00:03:31h	0		0.00%	0	0.00
4	ChocoDaddy02 [DO]	1,000		0d 00:01:53h	0		0.00%	0	0.00
5	Cristhopher_35 [DO]	1,000		0d 00:01:48h	0		0.00%	0	0.00
6	LeonelJC [DO]	982		0d 00:02:33h	0		0.00%	0	0.00
7	KinoS27 [DO]	979		0d 00:02:37h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	34 times	102
2	Friendly Fire	20 times	-60
3	Protected Teammate	5 times	15
4	Used Adrenaline	3 times	6
5	Killed a Tank	3 times	12
6	Killed a Hunter	2 times	4
7	Startled the Witch	1 times	-5
8	Killed a Witch	1 times	5
9	Killed a Spitter	1 times	3
10	Killed a Jockey	1 times	3
11	Killed a Charger	1 times	3
12	Killed a Boomer	1 times	1
13	Healed Teammate	1 times	5

Team Selection *

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

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	NamVet	3 times	50.00%		28	2	14.00
2	Manager	1 times	16.67%
3	Biker	1 times	16.67%
4	Mechanic	1 times	16.67%		133	0	133.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	91		10.40%	21		20.79%	0.23
2		3.00	33		3.77%	9		8.91%	0.27
3		2.00	10		1.14%	2		1.98%	0.20
4		5.00	9		1.03%	1		0.99%	0.11
5		0.10	8		0.91%	0		0.00%	0.00
6		3.00	5		0.57%	1		0.99%	0.20
7		2.00	4		0.46%	0		0.00%	0.00
8		0.10	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		1,224	305	20,143	2	4	4.0000	24.9%	66.0	306.0
2		665	29	551	1	2	2.0000	4.4%	19.0	332.5
3		123	35	925	0	2	2.0000	28.5%	26.4	61.5
4		19	10	900	0	0	0.0000	52.6%	90.0	0.0
5		66	29	30	0	0	0.0000	43.9%	1.0	0.0
6		12	25	41	0	0	0.0000	208.3%	1.6	0.0
7		97	32	93	0	0	0.0000	33.0%	2.9	0.0
8		181	40	930	0	0	0.0000	22.1%	23.3	0.0
9		35	7	73	0	0	0.0000	20.0%	10.4	0.0
10		1	0	0	0	0	0.0000	0.0%	0.0	0.0
11		11	10	50	0	0	0.0000	90.9%	5.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		303	14.2%	75.6%	10.2%
2		40	20.0%	57.5%	22.5%
3		34	23.5%	50.0%	26.5%
4		32	3.1%	84.4%	12.5%
5		29	6.9%	65.5%	27.6%
6		28	10.7%	75.0%	14.3%
7		25	0.0%	64.0%	36.0%
8		10	0.0%	70.0%	30.0%
9		10	0.0%	100.0%	0.0%
10		4	0.0%	75.0%	25.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 = 614
			GROUP BY
				map;