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

Clan Information

Statistics Summary
Clan:	Real
Home Page:
Activity:		51.75%
Members:	8 active members (119 total)
Avg. Member Points:	1,172
Total Kills:	27
Total Deaths:	86
Avg. Kills:	3
Kills per Death:	0.31
Kills per Minute:	0.02
Total Connection Time:	0d 21:41:39h
Avg. Connection Time:	0d 02:42:42h
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	Big Box(Real)		1,894		0d 11:52:44h	25		92.59%	51	0.49
2	Demoknight (real)		1,156		0d 04:35:14h	0		0.00%	17	0.00
3	Dr.Eggman(Real)		1,138		0d 02:32:18h	1		3.70%	7	0.14
4	The Piss man (REAL)		1,132		0d 01:21:15h	0		0.00%	10	0.00
5	Holy Diver (real)		1,028		0d 00:30:50h	0		0.00%	1	0.00
6	Carne (Real)		1,024		0d 00:48:10h	1		3.70%	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	101 times	0
2	Critical Kill	50 times	0
3	Rocket Jump	20 times	0
4	MVP #3	17 times	34
5	MVP #2	15 times	45
6	Airshot Rocket	12 times	0
7	MVP #1	11 times	55
8	Kill Assist	11 times	22
9	Drowned	9 times	0
10	Sticky Jump	5 times	0
11	Stun	2 times	0
12	Destroyed a teleporter	2 times	0
13	Backstab Kill	2 times	4
14	Ubercharge	1 times	1
15	Triple Kill (3 kills)	1 times	2
16	Revenge	1 times	3
17	Killed charged medic	1 times	1
18	God Like (12+ kills)	1 times	11
19	Double Kill (2 kills)	1 times	1
20	Deployed Buff Flag	1 times	1
21	Defended a Medic	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	100 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	171 times		40.81%
2	The BLU	78 times		18.62%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Demo Man	65 times	32.99%		14	74	0.19
2	Heavy	37 times	18.78%		16	25	0.64
3	Soldier	24 times	12.18%		5	16	0.31
4	Spy	17 times	8.63%		2	13	0.15
5	Pyro	20 times	10.15%		2	9	0.22
6	Scout	12 times	6.09%		0	7	0.00
7	Sniper	10 times	5.08%		0	3	0.00
8	Engineer	8 times	4.06%		1	3	0.33
9	Medic	4 times	2.03%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	39		144.44%	0		0.00%	0.00
2		2.00	2		7.41%	0		0.00%	0.00
3		1.00	5		18.52%	0		0.00%	0.00
4		1.80	1		3.70%	0		0.00%	0.00
5		1.00	2		7.41%	0		0.00%	0.00
6		2.00	1		3.70%	0		0.00%	0.00
7		2.00	2		7.41%	0		0.00%	0.00
8		2.00	1		3.70%	0		0.00%	0.00
9		2.00	2		7.41%	0		0.00%	0.00
10		2.00	1		3.70%	0		0.00%	0.00
11		2.00	1		3.70%	0		0.00%	0.00
12		5.00	6		22.22%	0		0.00%	0.00
13		1.00	1		3.70%	0		0.00%	0.00
14		1.00	12		44.44%	0		0.00%	0.00
15		1.00	1		3.70%	0		0.00%	0.00
16		2.00	1		3.70%	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 / 27 * 100, 2) AS kpercent,
			ROUND(headshots / 1 * 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