[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,299
Total Deaths:	8,229
Avg. Kills:	6,299
Kills per Death:	0.77
Kills per Minute:	0.82
Total Connection Time:	5d 07:54:58h
Avg. Connection Time:	5d 07:54:58h
Favorite Server:*	Royston Vasey
Favorite Map:*	dustbowl
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[LWL]Finny		3,847		5d 07:54:58h	6,299		100.00%	8,229	0.77

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	35 times	35
2	Triple Kill (3 kills)	7 times	14
3	Destroyed Sentry Gun	7 times	21
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	Infected Enemy	10 times	-20
2	Hallucination	3 times	-3
3	Concussion	45 times	-45

Team Selection *

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

Role Selection *

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

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	113		1.79%	0		0.00%	0.00
2		1.10	59		0.94%	0		0.00%	0.00
3		1.00	5		0.08%	0		0.00%	0.00
4		1.80	3		0.05%	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.60	2		0.03%	0		0.00%	0.00
8		1.15	1		0.02%	0		0.00%	0.00
9		1.70	1		0.02%	0		0.00%	0.00
10		1.70	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 / 6299 * 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 desc,
			kills desc