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 (118 total)
Avg. Member Points:	1,158
Total Kills:	26
Total Deaths:	83
Avg. Kills:	3
Kills per Death:	0.31
Kills per Minute:	0.02
Total Connection Time:	0d 20:21:30h
Avg. Connection Time:	0d 02:32:41h
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	Carne (Real)		1,024		0d 00:48:10h	1		3.85%	0	1.00
2	Big Box(Real)		1,894		0d 11:52:44h	25		96.15%	51	0.49
3	Demoknight (real)		1,156		0d 04:35:14h	0		0.00%	17	0.00
4	The Piss man (REAL)		1,132		0d 01:21:15h	0		0.00%	10	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	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	100 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	7 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	Mad Milking a player	1 times	0
2	Domination	5 times	-25
3	Stun	19 times	0
4	Airblast Player	100 times	0

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	The RED	166 times		40.69%
2	The BLU	77 times		18.87%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Demo Man	62 times	34.07%		14	72	0.19
2	Heavy	35 times	19.23%		16	24	0.67
3	Soldier	22 times	12.09%		5	15	0.33
4	Pyro	17 times	9.34%		2	8	0.25
5	Spy	16 times	8.79%		2	13	0.15
6	Scout	11 times	6.04%		0	7	0.00
7	Sniper	8 times	4.40%		0	3	0.00
8	Engineer	8 times	4.40%		1	3	0.33
9	Medic	3 times	1.65%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		2.00	39		150.00%	0		0.00%	0.00
2		1.00	12		46.15%	0		0.00%	0.00
3		5.00	6		23.08%	0		0.00%	0.00
4		1.00	5		19.23%	0		0.00%	0.00
5		2.00	2		7.69%	0		0.00%	0.00
6		2.00	2		7.69%	0		0.00%	0.00
7		1.00	2		7.69%	0		0.00%	0.00
8		2.00	2		7.69%	0		0.00%	0.00
9		2.00	1		3.85%	0		0.00%	0.00
10		1.00	1		3.85%	0		0.00%	0.00
11		1.00	1		3.85%	0		0.00%	0.00
12		2.00	1		3.85%	0		0.00%	0.00
13		2.00	1		3.85%	0		0.00%	0.00
14		2.00	1		3.85%	0		0.00%	0.00
15		1.80	1		3.85%	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

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