[APG] Stats - Team Fortress Classic - Clan Details

Clan Information

Statistics Summary
Clan:	LWL
Home Page:
Activity:		65.00%
Members:	2 active members (4 total)
Avg. Member Points:	4,144
Total Kills:	9,059
Total Deaths:	11,164
Avg. Kills:	4,530
Kills per Death:	0.81
Kills per Minute:	0.84
Total Connection Time:	7d 12:05:04h
Avg. Connection Time:	3d 18:02:32h
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		31.76%	3,038	0.95
2	[LWL]Finny		3,681		5d 05:39:59h	6,182		68.24%	8,126	0.76

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Built Dispenser	2 times	4
2	Built Sentry	8 times	16
3	Captured Blue Flag	2 times	14
4	Captured Point 1	1 times	2
5	Destroyed Sentry Gun	4 times	12
6	Dispenser Destroyed	2 times	10
7	Domination (4 kills)	1 times	3
8	Double Kill (2 kills)	13 times	13
9	Infected Enemy	5 times	10
10	Teleporter Entrance Build	1 times	2
11	Teleporter Exit Build	1 times	2
12	Triple Kill (3 kills)	4 times	8
13	Ultra Kill (8 kills)	1 times	7
14	Upgraded Sentry to Lvl 2	8 times	8
15	Upgraded Sentry to Lvl 3	5 times	5

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Concussion	10 times	-10
2	Destroyed Sentry Gun	7 times	-21
3	Infected Enemy	5 times	-10
4	Teleporter Entrance Destroyed	2 times	-2
5	Teleporter Exit Destroyed	1 times	-1

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Red	8 times		32.00%
2	Defenders	3 times		12.00%
3	Blue	1 times		4.00%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Soldier	7 times	50.00%		50	87	0.57
2	Scout	2 times	14.29%		0	4	0.00
3	Pyro	1 times	7.14%		11	26	0.42
4	Medic	1 times	7.14%		1	12	0.08
5	Engineer	1 times	7.14%		4	4	1.00
6	Demoman	2 times	14.29%		4	5	0.80

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	35		0.39%	0		0.00%	0.00
2		1.10	28		0.31%	0		0.00%	0.00
3		1.00	21		0.23%	0		0.00%	0.00
4		1.35	2		0.02%	0		0.00%	0.00
5		1.35	2		0.02%	0		0.00%	0.00
6		1.60	2		0.02%	0		0.00%	0.00
7		1.15	1		0.01%	0		0.00%	0.00
8		1.70	1		0.01%	0		0.00%	0.00
9		1.80	1		0.01%	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 / 9059 * 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