[APG] Stats - Team Fortress Classic - Clan Details

Clan Information

Statistics Summary
Clan:	LWL
Home Page:
Activity:		70.00%
Members:	1 active members (4 total)
Avg. Member Points:	3,818
Total Kills:	6,432
Total Deaths:	8,438
Avg. Kills:	6,432
Kills per Death:	0.76
Kills per Minute:	0.83
Total Connection Time:	5d 09:42:33h
Avg. Connection Time:	5d 09:42:33h
Favorite Server:*	Royston Vasey
Favorite Map:*	killbox
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[LWL]Finny		3,818		5d 09:42:33h	6,432		100.00%	8,438	0.76

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	20 times	20
2	Triple Kill (3 kills)	8 times	16
3	Headshot Kill	8 times	8
4	Destroyed Sentry Gun	7 times	21
5	Domination (4 kills)	6 times	18
6	Dispenser Destroyed	3 times	15
7	Teleporter Exit Destroyed	2 times	2
8	Ownage (7 kills)	1 times	6

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Concussion	14 times	-14
2	Hallucination	7 times	-7

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Red	7 times		26.92%
2	Blue	2 times		7.69%
3	Attackers	1 times		3.85%
4	(Hunted) Bodyguards	1 times		3.85%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Soldier	11 times	73.33%		106	138	0.77
2	Sniper	4 times	26.67%		38	68	0.56

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	42		0.65%	8		6.78%	0.19
2		1.00	60		0.93%	0		0.00%	0.00
3		1.10	64		1.00%	0		0.00%	0.00
4		1.80	1		0.02%	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 / 6432 * 100, 2) AS kpercent,
			ROUND(headshots / 118 * 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