Panda Community HLstatsX - Panda-Community.com US | Jailbreak - Clan Details

Clan Information

Statistics Summary
Clan:	Real
Home Page:
Activity:		55.37%
Members:	8 active members (120 total)
Avg. Member Points:	1,800
Total Kills:	475
Total Deaths:	264
Avg. Kills:	59
Kills per Death:	1.80
Kills per Minute:	0.12
Total Connection Time:	2d 15:43:03h
Avg. Connection Time:	0d 07:57:52h
Favorite Server:*	Panda-Community.com US \| Jailbreak
Favorite Map:*	jb_hopjb_v12
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Scout (real)		5,758		1d 14:02:41h	444		93.47%	165	2.69
2	Big Box(Real)		1,894		0d 11:52:44h	25		5.26%	51	0.49
3	Dr.Eggman(Real)		1,438		0d 07:01:51h	5		1.05%	21	0.24
4	Demoknight (real)		1,156		0d 04:35:14h	0		0.00%	17	0.00
5	The Piss man (REAL)		1,132		0d 01:21:15h	0		0.00%	10	0.00
6	Carne (Real)		1,024		0d 00:48:10h	1		0.21%	0	1.00
7	Karl Franz Gaming (Real)		1,000		0d 00:01:07h	0		0.00%	0	0.00
8	moth :3 (real)		1,000		0d 00:00:01h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Force Suicide	105 times	0
2	Critical Kill	57 times	0
3	Rocket Jump	20 times	0
4	MVP #3	20 times	40
5	MVP #2	18 times	54
6	Kill Assist	13 times	26
7	Airshot Rocket	12 times	0
8	MVP #1	11 times	55
9	Drowned	11 times	0
10	Stun	6 times	0
11	Sticky Jump	5 times	0
12	Destroyed a teleporter	2 times	0
13	Defended a Medic	2 times	2
14	Backstab Kill	2 times	4
15	Ubercharge	1 times	1
16	Triple Kill (3 kills)	1 times	2
17	Revenge	1 times	3
18	Killed charged medic	1 times	1
19	God Like (12+ kills)	1 times	11
20	Double Kill (2 kills)	1 times	1
21	Deployed Buff Flag	1 times	1
22	Airshot Rocket (Airborne)	1 times	0
23	Airshot Pipebomb	1 times	0

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Airblast Player	101 times	0
2	Stun	19 times	0
3	Domination	5 times	-25
4	Mad Milking a player	2 times	0
5	Jarated player	2 times	-2

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	The RED	186 times		40.79%
2	The BLU	84 times		18.42%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Demo Man	68 times	31.63%		14	77	0.18
2	Heavy	38 times	17.67%		16	25	0.64
3	Soldier	27 times	12.56%		5	17	0.29
4	Pyro	23 times	10.70%		6	13	0.46
5	Scout	20 times	9.30%		1	14	0.07
6	Spy	17 times	7.91%		2	13	0.15
7	Sniper	10 times	4.65%		0	3	0.00
8	Engineer	8 times	3.72%		1	3	0.33
9	Medic	4 times	1.86%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	1		0.21%	0		0.00%	0.00
2		1.00	1		0.21%	0		0.00%	0.00
3		1.00	12		2.53%	0		0.00%	0.00
4		1.00	1		0.21%	0		0.00%	0.00
5		5.00	6		1.26%	0		0.00%	0.00
6		2.00	1		0.21%	0		0.00%	0.00
7		1.25	2		0.42%	0		0.00%	0.00
8		2.00	1		0.21%	0		0.00%	0.00
9		1.50	2		0.42%	0		0.00%	0.00
10		2.00	2		0.42%	0		0.00%	0.00
11		2.00	1		0.21%	0		0.00%	0.00
12		2.00	2		0.42%	0		0.00%	0.00
13		2.00	1		0.21%	0		0.00%	0.00
14		1.00	2		0.42%	0		0.00%	0.00
15		1.80	1		0.21%	0		0.00%	0.00
16		1.00	5		1.05%	0		0.00%	0.00
17		2.00	2		0.42%	0		0.00%	0.00
18		2.00	39		8.21%	0		0.00%	0.00
19		2.00	4		0.84%	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		34	13	912	0	0	0.0000	38.2%	70.2	0.0
2		3	1	100	0	0	0.0000	33.3%	100.0	0.0
3		27	0	0	0	0	0.0000	0.0%	0.0	0.0

ERROR

Database Error

Server Address: 172.16.217.100
Server Username: hlstats_user

Error Diagnostic:
Bad query.

Server Error: (1052) Column 'map' in order clause is ambiguous

Last SQL Query:

		SELECT *, 
			IFNULL(kills/deaths, '-') AS kpd,
			IFNULL(headshots / kills, '-') AS hpk,
			ROUND(kills / 475 * 100, 2) AS kpercent,
			ROUND(headshots / 3 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map desc,
			kills desc