NeonHeights Servers - Team Fortress 2 - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	NHS
Home Page:
Activity:		89.00%
Members:	1 active members (3 total)
Avg. Member Points:	545,555
Total Kills:	176,407
Total Deaths:	51,881
Avg. Kills:	176,407
Kills per Death:	3.40
Kills per Minute:	0.68
Total Connection Time:	181d 08:43:06h
Avg. Connection Time:	181d 08:43:06h
Favorite Server:*	NeonHeights \| Main Hub
Favorite Map:*	trade_minecraft_neon_v197
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	-=NHS=- Kwas	545,555		181d 08:43:06h	176,407		100.00%	51,881	3.40

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Destroyed a dispenser	1 times	1
2	Kill Assist	1 times	2
3	Ultra Kill (8 kills)	1 times	7
4	Destroyed a sentry gun	2 times	4
5	Domination	2 times	10
6	Double Kill (2 kills)	2 times	2

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Revenge	1 times	-3

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	RED	2 times		66.67%
2	BLU	1 times		33.33%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Demo Man	3 times	12.50%		12	3	4.00
2	Scout	7 times	29.17%		3	0	3.00
3	Soldier	7 times	29.17%		1	2	0.50
4	Sniper	2 times	8.33%
5	Pyro	4 times	16.67%
6	Heavy	1 times	4.17%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.50	1		0.00%	0		0.00%	0.00
2		2.00	11		0.01%	0		0.00%	0.00
3		1.00	2		0.00%	0		0.00%	0.00

ERROR

Database Error

Server Address: localhost
Server Username: mainhub

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 / 176407 * 100, 2) AS kpercent,
			ROUND(headshots / 29685 * 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