[APG] Stats - Team Fortress Classic - Clan Details

Clan Information

Statistics Summary
Clan:	LWL
Home Page:
Activity:		90.00%
Members:	1 active members (4 total)
Avg. Member Points:	4,607
Total Kills:	2,877
Total Deaths:	3,038
Avg. Kills:	2,877
Kills per Death:	0.95
Kills per Minute:	0.88
Total Connection Time:	2d 06:25:05h
Avg. Connection Time:	2d 06:25:05h
Favorite Server:*	Royston Vasey
Favorite Map:*	vehi2000_c
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[LWL]Wiseguy		4,607		2d 06:25:05h	2,877		100.00%	3,038	0.95

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Upgraded Sentry to Lvl 2	9 times	9
2	Built Sentry	9 times	18
3	Double Kill (2 kills)	7 times	7
4	Upgraded Sentry to Lvl 3	6 times	6
5	Triple Kill (3 kills)	3 times	6
6	Built Dispenser	3 times	6
7	Concussion	2 times	2
8	Ultra Kill (8 kills)	1 times	7
9	Teleporter Exit Build	1 times	2
10	Teleporter Entrance Build	1 times	2
11	Discovered a Spy	1 times	2

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Destroyed Sentry Gun	8 times	-24
2	Teleporter Entrance Destroyed	2 times	-2
3	Hallucination	2 times	-2
4	Teleporter Exit Destroyed	1 times	-1
5	Infected Enemy	1 times	-2
6	Concussion	1 times	-1

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Red	4 times		30.77%
2	Defenders	2 times		15.38%
3	Attackers	1 times		7.69%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Scout	3 times	37.50%		2	15	0.13
2	HWGuy	2 times	25.00%		17	15	1.13
3	Engineer	2 times	25.00%		8	11	0.73

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.15	1		0.03%	0		0.00%	0.00
2		1.00	24		0.83%	0		0.00%	0.00
3		1.70	2		0.07%	0		0.00%	0.00
4		1.00	20		0.70%	0		0.00%	0.00

ERROR

Database Error

Server Address: 127.0.0.1
Server Username: apgclanstats

Error Diagnostic:
Bad query.

Server Error: ()

Last SQL Query:

		SELECT *, 
			IFNULL(kills/deaths, '-') AS kpd,
			IFNULL(headshots / kills, '-') AS hpk,
			ROUND(kills / 2877 * 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