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

Sections

Clan Information

Statistics Summary
Clan:	PE
Home Page:
Activity:		48.77%
Members:	678 active members (1616 total)
Avg. Member Points:	1,449
Total Kills:	126,118
Total Deaths:	2,935
Avg. Kills:	186
Kills per Death:	42.97
Kills per Minute:	7.32
Total Connection Time:	11d 23:00:41h
Avg. Connection Time:	0d 00:25:23h
Favorite Server:*	Gunnys Hooch
Favorite Map:*	l4d2_lotrm1_moria
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
481	[PE] arturosa	1,010		0d 00:18:08h	9		0.01%	0	9.00
482	[PE] templiaftom1987	1,009		0d 00:06:56h	3		0.00%	4	0.75
483	[PE] qlionel8	1,008		0d 00:06:26h	4		0.00%	0	4.00
484	[PE] Cubo-Atomico	1,008		0d 00:01:25h	4		0.00%	0	4.00
485	[PE] R2	1,008		0d 00:01:33h	1		0.00%	0	1.00
486	[PE] steven_203	1,007		0d 00:01:28h	2		0.00%	0	2.00
487	[PE] ???	1,007		0d 00:34:19h	5		0.00%	11	0.45
488	[PE] Sopa Seca con Carapulcra	1,006		0d 00:01:55h	3		0.00%	0	3.00
489	[PE] señorgüait	1,006		0d 00:06:27h	3		0.00%	0	3.00
490	[PE] nunoadriangonzales	1,006		0d 00:04:50h	2		0.00%	1	2.00
491	[PE] William15xd	1,006		0d 00:04:50h	3		0.00%	3	1.00
492	[PE] walter.tocrapauccar	1,005		0d 00:11:58h	1		0.00%	0	1.00
493	[PE] El Brayan	1,005		0d 00:11:11h	0		0.00%	1	0.00
494	[PE] corralesluiggy1	1,004		0d 00:02:33h	2		0.00%	0	2.00
495	[PE] // ♥ Huǒ Lóng	1,004		0d 00:06:02h	2		0.00%	2	1.00
496	[PE] SoyShimmi	1,004		0d 00:05:52h	2		0.00%	4	0.50
497	[PE] NAHHH MANO	1,004		0d 00:05:51h	2		0.00%	7	0.29
498	[PE] oh no hermano	1,004		0d 00:05:47h	2		0.00%	7	0.29
499	[PE] The Ghost	1,004		0d 00:09:05h	2		0.00%	9	0.22
500	[PE] Tasha de los Backyardigans	1,004		0d 00:15:02h	2		0.00%	14	0.14

Page: First page ... 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	10,498 times	31,494
2	Friendly Fire	5,615 times	-16845
3	Protected Teammate	3,218 times	9,654
4	Killed a Boomer	1,287 times	1,287
5	Revived Teammate	1,136 times	3,408
6	Killed a Spitter	1,031 times	3,093
7	Killed a Charger	989 times	2,967
8	Killed a Hunter	944 times	1,888
9	Killed a Smoker	914 times	1,828
10	Killed a Jockey	891 times	2,673
11	Used Adrenaline	690 times	1,380
12	Killed a Tank	513 times	2,052
13	Startled the Witch	237 times	-1185
14	Healed Teammate	215 times	1,075
15	Killed a Witch	190 times	950
16	Hunter Punter (Melee a Hunter Mid-jump)	177 times	885
17	Tank Bilebombed	136 times	680
18	Rescued Teammate	45 times	135
19	No Survivors Died/Incapped by Tank	45 times	45
20	Defibrillated Teammate	33 times	330

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	1,837 times		39.69%
2	Infected	282 times		6.09%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	BOOMER	122 times	6.59%		3	117	0.03
2	Mechanic	120 times	6.49%		11,444	186	61.53
3	HUNTER	114 times	6.16%		31	101	0.31
4	CHARGER	113 times	6.11%		41	93	0.44
5	SPITTER	111 times	6.00%		5	107	0.05
6	Gambler	111 times	6.00%		12,455	188	66.25
7	Producer	107 times	5.78%		13,065	170	76.85
8	Coach	98 times	5.30%		10,425	156	66.83
9	JOCKEY	93 times	5.03%		14	80	0.18
10	SMOKER	89 times	4.81%		13	76	0.17
11	Manager	48 times	2.59%		4,839	108	44.81
12	NamVet	48 times	2.59%		3,247	92	35.29
13	TeenGirl	47 times	2.54%		4,966	77	64.49
14	Biker	46 times	2.49%		6,388	101	63.25
15	TANK	9 times	0.49%		19	5	3.80

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	6,287		4.99%	531		4.42%	0.08
2		5.00	6,136		4.87%	9		0.07%	0.00
3		1.00	6,039		4.79%	624		5.20%	0.10
4		1.00	5,975		4.74%	636		5.30%	0.11
5		2.00	5,868		4.65%	1,199		9.99%	0.20
6		1.50	5,415		4.29%	541		4.51%	0.10
7		0.10	5,380		4.27%	0		0.00%	0.00
8		2.20	5,248		4.16%	1,141		9.50%	0.22
9		1.00	5,158		4.09%	741		6.17%	0.14
10		1.00	4,748		3.76%	552		4.60%	0.12
11		2.50	4,243		3.36%	400		3.33%	0.09
12		1.50	4,233		3.36%	479		3.99%	0.11
13		0.10	4,064		3.22%	207		1.72%	0.05
14		2.50	3,609		2.86%	462		3.85%	0.13
15		1.50	3,253		2.58%	318		2.65%	0.10
16		1.00	2,736		2.17%	365		3.04%	0.13
17		0.10	2,442		1.94%	0		0.00%	0.00
18		0.50	1,732		1.37%	67		0.56%	0.04
19		1.20	1,694		1.34%	0		0.00%	0.00
20		2.00	1,568		1.24%	131		1.09%	0.08
21		1.50	1,500		1.19%	171		1.42%	0.11
22		1.50	1,467		1.16%	194		1.62%	0.13
23		1.50	1,451		1.15%	178		1.48%	0.12
24		4.00	1,339		1.06%	269		2.24%	0.20
25		2.00	1,155		0.92%	252		2.10%	0.22
26		2.00	1,082		0.86%	180		1.50%	0.17
27		1.20	993		0.79%	0		0.00%	0.00
28		1.50	895		0.71%	138		1.15%	0.15
29		2.00	851		0.67%	57		0.47%	0.07
30		1.50	669		0.53%	71		0.59%	0.11
31		1.50	666		0.53%	0		0.00%	0.00
32		1.50	639		0.51%	73		0.61%	0.11
33		1.50	508		0.40%	53		0.44%	0.10
34		1.75	481		0.38%	18		0.15%	0.04
35		2.50	410		0.33%	46		0.38%	0.11
36		1.50	329		0.26%	60		0.50%	0.18
37		2.50	285		0.23%	28		0.23%	0.10
38		1.75	271		0.21%	13		0.11%	0.05
39		0.10	263		0.21%	0		0.00%	0.00
40		2.50	110		0.09%	5		0.04%	0.05
41		-25.00	97		0.08%	0		0.00%	0.00
42		1.00	67		0.05%	0		0.00%	0.00
43		1.00	55		0.04%	1		0.01%	0.02
44		10.00	34		0.03%	0		0.00%	0.00
45		10.00	15		0.01%	0		0.00%	0.00
46		10.00	14		0.01%	0		0.00%	0.00
47		10.00	12		0.01%	0		0.00%	0.00
48		10.00	11		0.01%	0		0.00%	0.00
49		10.00	9		0.01%	0		0.00%	0.00
50		1.50	9		0.01%	0		0.00%	0.00
51		1.50	8		0.01%	0		0.00%	0.00
52		1.50	6		0.00%	0		0.00%	0.00
53		1.00	5		0.00%	1		0.01%	0.20
54		10.00	5		0.00%	0		0.00%	0.00
55		10.00	3		0.00%	0		0.00%	0.00
56		10.00	2		0.00%	0		0.00%	0.00
57		10.00	2		0.00%	0		0.00%	0.00
58		10.00	2		0.00%	0		0.00%	0.00
59		10.00	1		0.00%	0		0.00%	0.00
60		10.00	1		0.00%	0		0.00%	0.00
61		10.00	1		0.00%	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		27,704	7,870	834,316	94	583	583.0000	28.4%	106.0	47.5
2		100,217	14,367	358,408	97	493	493.0000	14.3%	24.9	203.3
3		54,252	10,481	738,611	90	451	451.0000	19.3%	70.5	120.3
4		88,854	27,527	530,334	115	386	386.0000	31.0%	19.3	230.2
5		15,581	11,848	371,991	0	374	374.0000	76.0%	31.4	41.7
6		8,205	9,699	295,160	0	365	365.0000	118.2%	30.4	22.5
7		64,811	23,317	795,656	77	365	365.0000	36.0%	34.1	177.6
8		11,636	12,937	315,552	0	326	326.0000	111.2%	24.4	35.7
9		6,926	7,701	200,520	0	215	215.0000	111.2%	26.0	32.2
10		27,276	4,067	188,585	38	211	211.0000	14.9%	46.4	129.3
11		5,508	750	72,470	39	148	148.0000	13.6%	96.6	37.2
12		581	570	58,339	0	117	117.0000	98.1%	102.3	5.0
13		19,427	6,709	217,435	34	84	84.0000	34.5%	32.4	231.3
14		18,060	6,916	127,334	13	54	54.0000	38.3%	18.4	334.4
15		12,364	1,773	50,145	13	53	53.0000	14.3%	28.3	233.3
16		11,243	2,243	105,819	0	52	52.0000	20.0%	47.2	216.2
17		2,838	383	27,446	11	46	46.0000	13.5%	71.7	61.7
18		669	556	57,339	2	18	18.0000	83.1%	103.1	37.2
19	Tank Claw	300	25	3,764	0	10	10.0000	8.3%	150.6	30.0
20	Jockey Claw	12,204	635	1,474	0	3	3.0000	5.2%	2.3	4,068
21	Hunter Claw	26,128	661	4,853	0	3	3.0000	2.5%	7.3	8,709
22	Smoker Claw	9,077	493	2,010	0	1	1.0000	5.4%	4.1	9,077
23		715	374	11,562	0	1	1.0000	52.3%	30.9	715.0
24	Charger Claw	5,754	362	3,795	0	0	0.0000	6.3%	10.5	0.0
25	Boomer Claw	10,777	108	432	0	0	0.0000	1.0%	4.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		22,188	21.1%	58.6%	20.3%
2		19,245	21.3%	57.4%	21.2%
3		11,715	12.5%	73.2%	14.3%
4		11,163	15.6%	68.6%	15.8%
5		9,869	14.0%	69.1%	16.9%
6		8,910	16.6%	65.2%	18.2%
7		8,890	12.2%	72.1%	15.7%
8		7,149	13.3%	70.6%	16.1%
9		6,503	13.8%	71.2%	15.0%
10		6,258	16.5%	66.4%	17.1%
11		6,169	21.1%	57.5%	21.4%
12		3,218	12.5%	72.1%	15.4%
13		923	20.9%	62.1%	17.0%
14		659	10.6%	73.6%	15.8%
15	Hunter Claw	397	12.3%	63.5%	24.2%
16	Jockey Claw	365	6.8%	77.0%	16.2%
17		338	19.5%	72.5%	8.0%
18		314	12.1%	75.2%	12.7%
19	Smoker Claw	273	11.7%	57.1%	31.1%
20	Charger Claw	183	12.6%	68.9%	18.6%
21		130	10.0%	81.5%	8.5%
22		47	10.6%	89.4%	0.0%
23		29	0.0%	89.7%	10.3%
24	Boomer Claw	1	100.0%	0.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 = 554
			GROUP BY
				map;