HLstatsX Community Edition
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: 4
Home Page:
Activity: 70.50% 70.50%
Members: 2 active members (15 total)
Avg. Member Points: 1,504
Total Kills: 102
Total Deaths: 111
Avg. Kills: 51
Kills per Death: 0.92
Kills per Minute: 0.23
Total Connection Time: 0d 07:29:04h
Avg. Connection Time: 0d 03:44:32h
Favorite Server:* GAMER.KG | CS:S Public Classic
Favorite Map:* de_tessa
Favorite Weapon:* M249 PARA Light Machine Gun
Player Locations

  Members

Rank Name Points Activity Time sort-descending.gif Kills Clan Kills % Deaths Kpd
1  No Country(4)NONAME 1,074 41% 0d 03:55:29h 20 19.61% 19.61% 31 0.65
2  No Country(4)NONAME 1,934 100% 0d 03:33:35h 82 80.39% 80.39% 80 1.03




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 5 times 5
2 Double Kill (2 kills) 1 times 1




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 5 times 35.71% 35.71%
2 Terrorist 1 times 7.14% 7.14%




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 M249 PARA Light Machine Gun 1.20 8 7.84% 7.84% 4 12.12% 12.12% 0.50
2 H&K UMP45 1.20 2 1.96% 1.96% 0 0.00% 0.00% 0.00
3 Arctic Warfare Magnum (Police) 1.00 2 1.96% 1.96% 0 0.00% 0.00% 0.00
4 Fusil Automatique 1.00 1 0.98% 0.98% 0 0.00% 0.00% 0.00
5 Desert Eagle .50AE 1.20 1 0.98% 0.98% 1 3.03% 3.03% 1.00




ERROR
Database Error

Server Address: 176.126.167.7
Server Username: mwa

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