HLstatsX Community Edition
  • Contents
  • Search
  • Forum
  • Help
Style:

Banner
  Sections

  Clan Information

Statistics Summary
Clan: D.T.B
Home Page:
Activity: 41.00% 41.00%
Members: 7 active members (7 total)
Avg. Member Points: 1,276
Total Kills: 242
Total Deaths: 162
Avg. Kills: 35
Kills per Death: 1.49
Kills per Minute: 1.76
Total Connection Time: 0d 02:17:31h
Avg. Connection Time: 0d 00:19:38h
Favorite Server:*
Favorite Map:*
Favorite Weapon:*
Player Locations

  Members

Rank Name Points Activity Time sort-descending.gif Kills Clan Kills % Deaths Kpd
1  No Country[D.T.B] Teofilo 1,688 47% 0d 00:45:15h 62 25.62% 25.62% 41 1.51
2  No Country[D.T.B] Morgadinho 1,458 47% 0d 00:42:12h 49 20.25% 20.25% 46 1.07
3  No Country[D.T.B] ρєℓℓ''s2 1,644 43% 0d 00:40:02h 131 54.13% 54.13% 69 1.90
4  No Country[D.T.B] Galo Cinza Misterioso 1,155 39% 0d 00:07:36h 0 0.00% 0.00% 0 0.00
5  No Country[D.T.B] Capitão Esdras 985 43% 0d 00:02:12h 0 0.00% 0.00% 6 0.00
6  No Country[D.T.B]DSHOCK™ 1,000 39% 0d 00:00:13h 0 0.00% 0.00% 0 0.00
7  No Country[D.T.B] Hel 1,000 29% 0d 00:00:01h 0 0.00% 0.00% 0 0.00




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk




ERROR
Database Error

Server Address: localhost
Server Username: root

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