[APG] Stats - Team Fortress Classic - Clan Details

Clan Information

Statistics Summary
Clan:	APG
Home Page:
Activity:		90.00%
Members:	1 active members (3 total)
Avg. Member Points:	6,275
Total Kills:	14,856
Total Deaths:	11,106
Avg. Kills:	14,856
Kills per Death:	1.34
Kills per Minute:	2.46
Total Connection Time:	4d 04:51:07h
Avg. Connection Time:	4d 04:51:07h
Favorite Server:*	[APG] - TFC Rat Rampage [Stats\|Hook]
Favorite Map:*	rats
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[APG]RoboCop[CL]		6,275		4d 04:51:07h	14,856		100.00%	11,106	1.34

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	6 times	6
2	Concussion	5 times	5
3	Triple Kill (3 kills)	3 times	6
4	Infected Enemy	2 times	4
5	Upgraded Sentry to Lvl 3	1 times	1
6	Upgraded Sentry to Lvl 2	1 times	1
7	Teleporter Exit Destroyed	1 times	1
8	Teleporter Exit Build	1 times	2
9	Teleporter Entrance Build	1 times	2
10	Rampage (5 kills)	1 times	4
11	Cured Infection	1 times	2
12	Built Sentry	1 times	2

Victims of Player-Player Actions *

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

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Red	2 times		7.14%
2	Green	2 times		7.14%
3	Blue	2 times		7.14%
4	Yellow	1 times		3.57%
5	Defenders	1 times		3.57%
6	Attackers	1 times		3.57%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Soldier	2 times	22.22%		12	8	1.50
2	Sniper	2 times	22.22%
3	Medic	2 times	22.22%		7	8	0.88
4	Spy	1 times	11.11%
5	Engineer	1 times	11.11%
6	Demoman	1 times	11.11%		11	14	0.79

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.35	10		0.07%	0		0.00%	0.00
2		1.10	7		0.05%	0		0.00%	0.00
3		1.15	5		0.03%	0		0.00%	0.00
4		1.00	5		0.03%	0		0.00%	0.00
5		0.00	2		0.01%	0		0.00%	0.00
6		1.50	2		0.01%	0		0.00%	0.00
7		1.70	1		0.01%	0		0.00%	0.00
8		1.35	1		0.01%	0		0.00%	0.00

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		2	27	105	0	0	0.0000	1,350%	3.9	0.0
2		3	0	0	0	0	0.0000	0.0%	0.0	0.0
3		21	0	0	0	0	0.0000	0.0%	0.0	0.0

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 / 14856 * 100, 2) AS kpercent,
			ROUND(headshots / 234 * 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