[APG] Stats - Team Fortress Classic - Clan Details

Clan Information

Statistics Summary
Clan:	LWL
Home Page:
Activity:		100.00%
Members:	1 active members (4 total)
Avg. Member Points:	3,847
Total Kills:	6,307
Total Deaths:	8,243
Avg. Kills:	6,307
Kills per Death:	0.77
Kills per Minute:	0.82
Total Connection Time:	5d 08:02:34h
Avg. Connection Time:	5d 08:02:34h
Favorite Server:*	Royston Vasey
Favorite Map:*	ukfootie
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[LWL]Finny		3,847		5d 08:02:34h	6,307		100.00%	8,243	0.77

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	37 times	37
2	Destroyed Sentry Gun	8 times	24
3	Triple Kill (3 kills)	7 times	14
4	Infected Enemy	5 times	10
5	Domination (4 kills)	4 times	12
6	Dispenser Destroyed	3 times	15
7	Captured Blue Flag	2 times	14
8	Teleporter Exit Destroyed	1 times	1
9	Rampage (5 kills)	1 times	4
10	Mega Kill (6 kills)	1 times	5
11	Captured Point 1	1 times	2

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Hallucination	8 times	-8
2	Infected Enemy	10 times	-20
3	Concussion	45 times	-45

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Blue	1 times		1.89%
2	Defenders	4 times		7.55%
3	Red	16 times		30.19%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Soldier	19 times	57.58%		148	180	0.82
2	Civilian	4 times	12.12%		2	1	2.00
3	Sniper	4 times	12.12%		5	8	0.63
4	Scout	2 times	6.06%		1	4	0.25
5	Demoman	2 times	6.06%		4	5	0.80
6	Pyro	1 times	3.03%		11	26	0.42
7	Medic	1 times	3.03%		1	12	0.08

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.70	1		0.02%	0		0.00%	0.00
2		1.70	1		0.02%	0		0.00%	0.00
3		1.15	1		0.02%	0		0.00%	0.00
4		1.60	2		0.03%	0		0.00%	0.00
5		1.35	2		0.03%	0		0.00%	0.00
6		1.35	2		0.03%	0		0.00%	0.00
7		1.80	3		0.05%	0		0.00%	0.00
8		1.00	5		0.08%	0		0.00%	0.00
9		1.10	64		1.01%	0		0.00%	0.00
10		1.00	116		1.84%	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 / 6307 * 100, 2) AS kpercent,
			ROUND(headshots / 110 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map asc,
			kills asc