[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,838
Total Kills:	6,300
Total Deaths:	8,232
Avg. Kills:	6,300
Kills per Death:	0.77
Kills per Minute:	0.82
Total Connection Time:	5d 07:56:53h
Avg. Connection Time:	5d 07:56:53h
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]Finny		3,838		5d 07:56:53h	6,300		100.00%	8,232	0.77

Player Actions *

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

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Hallucination	3 times	-3
2	Infected Enemy	10 times	-20
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	Soldier	19 times	57.58%		141	170	0.83
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.00	113		1.79%	0		0.00%	0.00
2		1.00	5		0.08%	0		0.00%	0.00
3		1.10	60		0.95%	0		0.00%	0.00
4		1.15	1		0.02%	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.70	1		0.02%	0		0.00%	0.00
9		1.70	1		0.02%	0		0.00%	0.00
10		1.80	3		0.05%	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 / 6300 * 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