TF2Bonus-Stats - Team Fortress 2 - Clan Details

Разделы

Clan Information

Statistics Summary
Clan:	RU
Home Page:
Activity:		62.00%
Members:	3 active members (42 total)
Avg. Member Points:	1,660
Total Kills:	217
Total Deaths:	337
Avg. Kills:	72
Kills per Death:	0.64
Kills per Minute:	0.27
Total Connection Time:	13 час. 37 мин.
Avg. Connection Time:	4 час. 32 мин.
Favorite Server:*	ТF2Bonus.ru \| -=8=- 2.F.O.R.T №1
Favorite Map:*	ctf_2fort
Favorite Weapon:*

Player Locations

Members

Место	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	nOfrienD[Ru]	3 020		10 час. 16 мин.	189		87.10%	239	0.79
2	xerieci[RU]	1 013		2 час. 38 мин.	21		9.68%	68	0.31
3	[RU]Barbus	947		0 час. 42 мин.	7		3.23%	30	0.23

Player Actions *

Место	Action	Achieved	Points Bonus
1	Помощь в убистве	101 times	202
2	Двойное убийство (Double Kill (2 kills)	36 times	36
3	Доминирование (Domination)	23 times	115
4	Headshot Kill	23 times	46
5	Destroyed a sentry gun	21 times	84
6	Revenge	18 times	54
7	Triple Kill (3 kills)	11 times	22
8	Rampage (5 kills)	10 times	40
9	Extinguished Teammate (Pyro)	7 times	7
10	Picked up the flag	6 times	12
11	Kill Assist - Medic	5 times	15
12	Domination (4 kills)	5 times	15
13	Mega Kill (6 kills)	4 times	20
14	Killed charged medic	4 times	4
15	Destroyed a teleporter	4 times	8
16	Captured the flag	4 times	20
17	Уберзаряд (Ubercharge)	3 times	3
18	Defended the flag	3 times	3
19	Разрушение раздатчика (Destroyed a dispenser)	2 times	6
20	Ultra Kill (8 kills)	2 times	14
21	Ownage (7 kills)	2 times	12
22	Killing Spree (9 kills)	2 times	16
23	Dropped the flag (on death)	2 times	0
24	Unstoppable (11 kills)	1 times	10
25	Removed a Sapper	1 times	1
26	Monster Kill (10 kills)	1 times	9

Victims of Player-Player Actions *

Место	Action	Times Victimized	Points Bonus
1	Revenge	15 times	-45
2	Доминирование (Domination)	25 times	-125

Team Selection *

Место	Team	Joined	Percentage of Times	%
1	Итого за Красных	11 times		26.83%
2	Итого за Синих	9 times		21.95%
3	Итого в Наблюдателях	3 times		7.32%

Role Selection *

Место	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Медик	3 times	2.19%		0	3	0.00
2	Пулеметчик	7 times	5.11%		8	10	0.80
3	Поджигатель	10 times	7.30%		49	31	1.58
4	Инженер	13 times	9.49%		12	12	1.00
5	Разведчик	15 times	10.95%		47	27	1.74
6	Шпион	16 times	11.68%		12	20	0.60
7	Солдат	20 times	14.60%		134	103	1.30
8	Подрывник	26 times	18.98%		39	55	0.71
9	Снайпер	27 times	19.71%		37	54	0.69

Weapon Usage *

Место	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	29		13.36%	21		91.30%	0.72
2		1.00	4		1.84%	2		8.70%	0.50
3		2.00	1		0.46%	0		0.00%	0.00
4		1.00	12		5.53%	0		0.00%	0.00
5	The Escape Plan	1.00	1		0.46%	0		0.00%	0.00
6		1.00	7		3.23%	0		0.00%	0.00
7		1.00	7		3.23%	0		0.00%	0.00
8		2.00	20		9.22%	0		0.00%	0.00
9		2.00	2		0.92%	0		0.00%	0.00
10		1.00	1		0.46%	0		0.00%	0.00
11		1.00	26		11.98%	0		0.00%	0.00
12		1.00	3		1.38%	0		0.00%	0.00
13		1.00	6		2.76%	0		0.00%	0.00
14		1.25	1		0.46%	0		0.00%	0.00
15		1.00	49		22.58%	0		0.00%	0.00
16		1.00	3		1.38%	0		0.00%	0.00
17		2.00	13		5.99%	0		0.00%	0.00
18		1.00	1		0.46%	0		0.00%	0.00
19		2.00	3		1.38%	0		0.00%	0.00
20		1.00	3		1.38%	0		0.00%	0.00
21		1.00	1		0.46%	0		0.00%	0.00
22		1.00	4		1.84%	0		0.00%	0.00
23		1.00	33		15.21%	0		0.00%	0.00
24		1.00	6		2.76%	0		0.00%	0.00
25	Beggar's Bazooka	1.00	24		11.06%	0		0.00%	0.00
26		2.00	1		0.46%	0		0.00%	0.00
27		1.00	9		4.15%	0		0.00%	0.00
28		2.00	2		0.92%	0		0.00%	0.00
29		1.80	4		1.84%	0		0.00%	0.00
30		1.00	10		4.61%	0		0.00%	0.00
31		2.50	7		3.23%	0		0.00%	0.00
32		2.00	9		4.15%	0		0.00%	0.00

ERROR

Database Error

Server Address: localhost
Server Username: statsuser

Error Diagnostic:
Bad query.

Server Error: (1052) Column 'map' in order clause is ambiguous

Last SQL Query:

		SELECT *, 
			IFNULL(kills/deaths, '-') AS kpd,
			IFNULL(headshots / kills, '-') AS hpk,
			ROUND(kills / 217 * 100, 2) AS kpercent,
			ROUND(headshots / 23 * 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