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

Clan Information

Statistics Summary
Clan:	Real
Home Page:
Activity:		58.25%
Members:	8 active members (120 total)
Avg. Member Points:	1,768
Total Kills:	472
Total Deaths:	251
Avg. Kills:	59
Kills per Death:	1.88
Kills per Minute:	0.13
Total Connection Time:	2d 11:52:48h
Avg. Connection Time:	0d 07:29:06h
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,760		1d 13:54:26h	444		94.07%	164	2.71
2	Big Box(Real)		1,894		0d 11:52:44h	25		5.30%	51	0.49
3	Dr.Eggman(Real)		1,178		0d 03:19:51h	2		0.42%	9	0.22
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	54 times	0
3	Rocket Jump	20 times	0
4	MVP #3	20 times	40
5	MVP #2	17 times	51
6	Kill Assist	12 times	24
7	Airshot Rocket	12 times	0
8	MVP #1	11 times	55
9	Drowned	10 times	0
10	Sticky Jump	5 times	0
11	Stun	2 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	1 times	0

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	The RED	180 times		40.63%
2	The BLU	83 times		18.74%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Medic	4 times	1.94%
2	Engineer	8 times	3.88%		1	3	0.33
3	Sniper	10 times	4.85%		0	3	0.00
4	Scout	17 times	8.25%		1	9	0.11
5	Spy	17 times	8.25%		2	13	0.15
6	Pyro	21 times	10.19%		3	10	0.30
7	Soldier	25 times	12.14%		5	16	0.31
8	Heavy	38 times	18.45%		16	25	0.64
9	Demo Man	66 times	32.04%		14	75	0.19

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.80	1		0.21%	0		0.00%	0.00
3		2.00	1		0.21%	0		0.00%	0.00
4		2.00	1		0.21%	0		0.00%	0.00
5		2.00	1		0.21%	0		0.00%	0.00
6		2.00	1		0.21%	0		0.00%	0.00
7		1.00	1		0.21%	0		0.00%	0.00
8		1.00	1		0.21%	0		0.00%	0.00
9		2.00	1		0.21%	0		0.00%	0.00
10		2.00	2		0.42%	0		0.00%	0.00
11		1.00	2		0.42%	0		0.00%	0.00
12		2.00	2		0.42%	0		0.00%	0.00
13		2.00	2		0.42%	0		0.00%	0.00
14		1.50	2		0.42%	0		0.00%	0.00
15		1.25	2		0.42%	0		0.00%	0.00
16		1.00	5		1.06%	0		0.00%	0.00
17		5.00	6		1.27%	0		0.00%	0.00
18		1.00	12		2.54%	0		0.00%	0.00
19		2.00	39		8.26%	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		3	1	100	0	0	0.0000	33.3%	100.0	0.0
2		34	13	912	0	0	0.0000	38.2%	70.2	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 / 472 * 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