HLstatsX Community Edition

  Разделы

  Clan Information

Statistics Summary
Clan: RU
Home Page:
Activity: 25.50% 25.50%
Members: 2 active members (42 total)
Avg. Member Points: 1,984
Total Kills: 196
Total Deaths: 269
Avg. Kills: 98
Kills per Death: 0.73
Kills per Minute: 0.30
Total Connection Time: 10 час. 58 мин.
Avg. Connection Time: 5 час. 29 мин.
Favorite Server:* ТF2Bonus.ru | -=8=- 2.F.O.R.T №1
Favorite Map:* ctf_2fort
Favorite Weapon:* Flamethrower
Player Locations

  Members

Место Name Points Activity Time Kills Clan Kills % Deaths Kpd sort-descending.gif
1  Russian federationnOfrienD[Ru] 3 020 42% 10 час. 16 мин. 189 96.43% 96.43% 239 0.79
2  Russian federation[RU]Barbus 947 9% 0 час. 42 мин. 7 3.57% 3.57% 30 0.23




  Player Actions *





  Team Selection *

Место Team Joined sort-descending.gif Percentage of Times %
1 Итого за Красных 4 times 28.57% 28.57%
2 Итого за Синих 3 times 21.43% 21.43%




  Role Selection *

Место Role Joined % Ratio Kills Deaths K:D sort-ascending.gif
1 Медик Медик 1 times 2.86% 2.86%
2 Снайпер Снайпер 8 times 22.86% 22.86%
3 Шпион Шпион 4 times 11.43% 11.43%
4 Инженер Инженер 5 times 14.29% 14.29% 0 1 0.00
5 Подрывник Подрывник 4 times 11.43% 11.43% 0 4 0.00
6 Солдат Солдат 2 times 5.71% 5.71% 0 1 0.00
7 Поджигатель Поджигатель 4 times 11.43% 11.43% 3 12 0.25
8 Разведчик Разведчик 7 times 20.00% 20.00% 2 8 0.25




  Weapon Usage *

Место Weapon Points Modifier Kills Percentage of Kills % Headshots Percentage of Headshots % Hpk sort-descending.gif
1 Force-A-Nature 1.00 2 1.02% 1.02% 0 0.00% 0.00% 0.00
2 Flamethrower 1.00 3 1.53% 1.53% 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 / 196 * 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