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

Clan Information

Statistics Summary
Clan:	Real
Home Page:
Activity:		48.00%
Members:	11 active members (115 total)
Avg. Member Points:	1,377
Total Kills:	128
Total Deaths:	403
Avg. Kills:	12
Kills per Death:	0.32
Kills per Minute:	0.03
Total Connection Time:	2d 14:38:54h
Avg. Connection Time:	0d 05:41:43h
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		71.88%	298	0.31
2	Big Box(Real)		1,880		0d 11:28:57h	25		19.53%	48	0.52
3	Soldier (real)		1,415		0d 06:58:50h	10		7.81%	43	0.23
4	Darth Vader (real)		1,150		0d 02:04:35h	0		0.00%	6	0.00
5	spy tf2 (real)		1,032		0d 01:12:09h	0		0.00%	4	0.00
6	Holy Diver (real)		1,028		0d 00:30:50h	0		0.00%	1	0.00
7	Carne (Real)		1,024		0d 00:48:10h	1		0.78%	0	1.00
8	Madcap (real)		1,004		0d 00:16:53h	0		0.00%	3	0.00
9	Engineer gaming (real)		1,000		0d 00:00:51h	0		0.00%	0	0.00
10	birb42o (Real)		1,000		0d 00:04:39h	0		0.00%	0	0.00
11	Karl Franz Gaming (Real)		1,000		0d 00:01:07h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Force Suicide	89 times	0
2	Critical Kill	50 times	0
3	Rocket Jump	20 times	0
4	MVP #3	16 times	32
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	6 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	Deployed Buff Flag	1 times	1
20	Defended a Medic	1 times	1
21	Airshot Rocket (Airborne)	1 times	0
22	Airshot Pipebomb	1 times	0

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Airblast Player	94 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	141 times		39.94%
2	The BLU	66 times		18.70%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Demo Man	57 times	34.76%		14	65	0.22
2	Heavy	33 times	20.12%		16	23	0.70
3	Soldier	20 times	12.20%		5	13	0.38
4	Pyro	17 times	10.37%		2	8	0.25
5	Scout	11 times	6.71%		0	7	0.00
6	Spy	9 times	5.49%		2	6	0.33
7	Sniper	7 times	4.27%		0	3	0.00
8	Engineer	7 times	4.27%		1	3	0.33
9	Medic	3 times	1.83%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.80	1		0.78%	0		0.00%	0.00
2		2.00	1		0.78%	0		0.00%	0.00
3		2.00	1		0.78%	0		0.00%	0.00
4		2.00	1		0.78%	0		0.00%	0.00
5		1.00	1		0.78%	0		0.00%	0.00
6		1.00	1		0.78%	0		0.00%	0.00
7		2.00	1		0.78%	0		0.00%	0.00
8		2.00	2		1.56%	0		0.00%	0.00
9		1.00	2		1.56%	0		0.00%	0.00
10		2.00	2		1.56%	0		0.00%	0.00
11		2.00	2		1.56%	0		0.00%	0.00
12		1.00	5		3.91%	0		0.00%	0.00
13		5.00	6		4.69%	0		0.00%	0.00
14		1.00	12		9.38%	0		0.00%	0.00
15		2.00	39		30.47%	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 / 128 * 100, 2) AS kpercent,
			ROUND(headshots / 2 * 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