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

Clan Information

Statistics Summary
Clan:	Real
Home Page:
Activity:		67.12%
Members:	8 active members (114 total)
Avg. Member Points:	1,402
Total Kills:	102
Total Deaths:	354
Avg. Kills:	13
Kills per Death:	0.29
Kills per Minute:	0.03
Total Connection Time:	2d 01:50:22h
Avg. Connection Time:	0d 06:13:47h
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	pyro gaming 4k ultra hd (real)		3,615		1d 15:11:53h	92		90.20%	298	0.31
2	Soldier (real)		1,415		0d 06:58:50h	10		9.80%	43	0.23
3	Darth Vader (real)		1,150		0d 02:04:35h	0		0.00%	6	0.00
4	spy tf2 (real)		1,032		0d 01:12:09h	0		0.00%	4	0.00
5	Madcap (real)		1,004		0d 00:16:53h	0		0.00%	3	0.00
6	birb42o (Real)		1,000		0d 00:04:39h	0		0.00%	0	0.00
7	I don't appreciate you (real)		1,000		0d 00:00:32h	0		0.00%	0	0.00
8	Engineer gaming (real)		1,000		0d 00:00:51h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Force Suicide	104 times	0
2	Critical Kill	47 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	Kill Assist	10 times	20
8	MVP #1	8 times	40
9	Drowned	5 times	0
10	Stun	2 times	0
11	Destroyed a teleporter	2 times	0
12	Backstab Kill	2 times	4
13	Ubercharge	1 times	1
14	Triple Kill (3 kills)	1 times	2
15	Revenge	1 times	3
16	Killed charged medic	1 times	1
17	God Like (12+ kills)	1 times	11
18	Double Kill (2 kills)	1 times	1
19	Destroyed a dispenser	1 times	0
20	Deployed Buff Flag	1 times	1
21	Defended a Medic	1 times	1
22	Attached a Sapper	1 times	2
23	Airshot Rocket (Airborne)	1 times	0
24	Airshot Pipebomb	1 times	0

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Airblast Player	95 times	0
2	Stun	16 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	140 times		39.66%
2	The BLU	66 times		18.70%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Demo Man	59 times	35.12%		14	66	0.21
2	Heavy	28 times	16.67%		15	22	0.68
3	Soldier	22 times	13.10%		5	15	0.33
4	Pyro	16 times	9.52%		2	7	0.29
5	Scout	13 times	7.74%		0	7	0.00
6	Engineer	11 times	6.55%		1	6	0.17
7	Spy	10 times	5.95%		2	10	0.20
8	Sniper	7 times	4.17%		0	3	0.00
9	Medic	2 times	1.19%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.80	1		0.98%	0		0.00%	0.00
2		2.00	1		0.98%	0		0.00%	0.00
3		2.00	1		0.98%	0		0.00%	0.00
4		1.00	1		0.98%	0		0.00%	0.00
5		1.00	1		0.98%	0		0.00%	0.00
6		2.00	1		0.98%	0		0.00%	0.00
7		2.00	2		1.96%	0		0.00%	0.00
8		1.00	2		1.96%	0		0.00%	0.00
9		2.00	2		1.96%	0		0.00%	0.00
10		2.00	2		1.96%	0		0.00%	0.00
11		1.00	5		4.90%	0		0.00%	0.00
12		5.00	6		5.88%	0		0.00%	0.00
13		1.00	12		11.76%	0		0.00%	0.00
14		2.00	39		38.24%	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

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 / 102 * 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