HLstatsX Community Edition

  Разделы

  Clan Information

Statistics Summary
Clan: NE
Home Page:
Activity: 100.00% 100.00%
Members: 1 active members (1 total)
Avg. Member Points: 7,346
Total Kills: 9,377
Total Deaths: 10,414
Avg. Kills: 9,377
Kills per Death: 0.90
Kills per Minute: 0.47
Total Connection Time: 333 час. 14 мин.
Avg. Connection Time: 333 час. 14 мин.
Favorite Server:* ТF2Bonus.ru | -=8=- 2.F.O.R.T №1
Favorite Map:* ctf_2fort
Favorite Weapon:* Sniper Rifle
Player Locations

  Members

Место Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Russian federation{NE}for{MALL} 7 346 100% 333 час. 14 мин. 9 377 100.00% 100.00% 10 414 0.90




  Player Actions *

Место Action Achieved sort-descending.gif Points Bonus
1 Прыжок на ракетомете (Rocket Jump) 173 times 0
2 Помощь в убистве 79 times 158
3 Headshot Kill 70 times 140
4 Airshot Rocket 67 times 0
5 Airshot Rocket (Airborne) 31 times 0
6 Двойное убийство (Double Kill (2 kills) 29 times 29
7 Triple Kill (3 kills) 15 times 30
8 Убийств с критами 8 times 0
9 Rampage (5 kills) 8 times 32
10 Destroyed a sentry gun 8 times 32
11 Domination (4 kills) 7 times 21
12 Rocket Jump Kill 6 times 0
13 Defended the flag 6 times 6
14 Разрушение раздатчика (Destroyed a dispenser) 4 times 12
15 Sticky Jump 4 times 0
16 Force Suicide 4 times 0
17 Extinguished Teammate (Medic) 4 times 4
18 Kill Assist - Medic 3 times 9
19 Уберзаряд (Ubercharge) 2 times 2
20 Ultra Kill (8 kills) 2 times 14
21 Mega Kill (6 kills) 2 times 10
22 Extinguished Teammate (Sniper) 2 times 2
23 Destroyed a teleporter 2 times 4
24 Picked up the flag 1 times 2
25 Ownage (7 kills) 1 times 6
26 Monster Kill (10 kills) 1 times 9
27 Killing Spree (9 kills) 1 times 8
28 Killed charged medic 1 times 1
29 Dropped the flag (on death) 1 times 0




  Victims of Player-Player Actions *

Место Action Times Victimized sort-ascending.gif Points Bonus
1 Доминирование (Domination) 1 times -5




  Team Selection *

Место Team sort-descending.gif Joined Percentage of Times %
1 Итого за Синих 19 times 20.21% 20.21%
2 Итого за Красных 26 times 27.66% 27.66%
3 Итого в Наблюдателях 21 times 22.34% 22.34%




  Role Selection *

Место Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Снайпер Снайпер 68 times 20.67% 20.67% 112 129 0.87
2 Пулеметчик Пулеметчик 62 times 18.84% 18.84% 48 21 2.29
3 Подрывник Подрывник 52 times 15.81% 15.81% 74 61 1.21
4 Инженер Инженер 32 times 9.73% 9.73% 2 2 1.00
5 Поджигатель Поджигатель 26 times 7.90% 7.90% 20 20 1.00
6 Солдат Солдат 25 times 7.60% 7.60% 25 25 1.00
7 Разведчик Разведчик 23 times 6.99% 6.99% 11 16 0.69
8 Медик Медик 22 times 6.69% 6.69% 0 4 0.00
9 Шпион Шпион 19 times 5.78% 5.78% 10 16 0.63




  Weapon Usage *

Место Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Sniper Rifle 1.00 62 0.66% 0.66% 43 3.76% 3.76% 0.69
2 Grenade Launcher 1.00 27 0.29% 0.29% 0 0.00% 0.00% 0.00
3 Original 2.00 21 0.22% 0.22% 0 0.00% 0.00% 0.00
4 The Hitman's Heatmaker 1.00 19 0.20% 0.20% 18 1.57% 1.57% 0.95
5 The Iron Curtain 1.00 19 0.20% 0.20% 0 0.00% 0.00% 0.00
6 Half-Zatoichi 2.00 17 0.18% 0.18% 0 0.00% 0.00% 0.00
7 Tomislav 1.00 14 0.15% 0.15% 0 0.00% 0.00% 0.00
8 The Bushwacka 2.00 11 0.12% 0.12% 0 0.00% 0.00% 0.00
9 The Brass Beast 1.00 11 0.12% 0.12% 0 0.00% 0.00% 0.00
10 World 1.00 10 0.11% 0.11% 0 0.00% 0.00% 0.00
11 Frying Pan 2.00 10 0.11% 0.11% 0 0.00% 0.00% 0.00
12 Machina 2.00 9 0.10% 0.10% 6 0.52% 0.52% 0.67
13 The Loch-n-Load 1.00 9 0.10% 0.10% 0 0.00% 0.00% 0.00
14 The Black Box 1.00 9 0.10% 0.10% 0 0.00% 0.00% 0.00
15 Scatter Gun 1.25 6 0.06% 0.06% 0 0.00% 0.00% 0.00
16 Ambassador 1.00 6 0.06% 0.06% 2 0.17% 0.17% 0.33
17 Pyro Shotgun 1.00 5 0.05% 0.05% 0 0.00% 0.00% 0.00
18 Huntsman 1.00 3 0.03% 0.03% 1 0.09% 0.09% 0.33
19 Cow Mangler 5000 1.00 3 0.03% 0.03% 0 0.00% 0.00% 0.00
20 Spy-cicle 2.00 2 0.02% 0.02% 0 0.00% 0.00% 0.00
21 Soda Popper 1.25 2 0.02% 0.02% 0 0.00% 0.00% 0.00
22 Your Eternal Reward 2.00 2 0.02% 0.02% 0 0.00% 0.00% 0.00
23 Wrench 2.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
24 Submachine Gun 1.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
25 Soldier Shotgun 1.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
26 The Cleaner's Carbine 1.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
27 Phlogistinator 2.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
28 Sentry Gun (Level 3) 1.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
29 Nessie's Nine Iron 2.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
30 Minigun (Natascha) 1.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
31 Minigun (Sasha) 1.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
32 Lugermorph 1.50 1 0.01% 0.01% 0 0.00% 0.00% 0.00
33 Force-A-Nature 1.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
34 Baseball 2.50 1 0.01% 0.01% 0 0.00% 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 / 9377 * 100, 2) AS kpercent,
			ROUND(headshots / 1145 * 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