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

  Sections

  Clan Information

Statistics Summary
Clan: ESP
Home Page:
Activity: 44.00% 44.00%
Members: 2 active members (4 total)
Avg. Member Points: 890
Total Kills: 5,129
Total Deaths: 3,898
Avg. Kills: 2,565
Kills per Death: 1.32
Kills per Minute: 2.98
Total Connection Time: 1d 04:43:50h
Avg. Connection Time: 0d 14:21:55h
Favorite Server:* Adult Gamers Community - DOD:S Gungame
Favorite Map:* dod_orange_cube_shiteur_v2
Favorite Weapon:* Spade Entrenchment Tool
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Spain[ESP] Majoney 1,000 5% 0d 00:00:35h 0 0.00% 0.00% 0 0.00
2  SpainRudolf Pedersen Hansen[ESP] 780 83% 1d 04:43:15h 5,129 100.00% 100.00% 3,898 1.32




  Player Actions *





  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Axis 11 times 30.56% 30.56%
2 Allies 7 times 19.44% 19.44%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Random 18 times 100.00% 100.00% 191 157 1.22




  Weapon Usage *

Rank Weapon Points Modifier sort-descending.gif Kills Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Spade Entrenchment Tool 3.00 38 0.74% 0.74% 0 0.00% 0.00% 0.00
2 Butt Stock Hit 3.00 7 0.14% 0.14% 0 0.00% 0.00% 0.00
3 U.S. Issue Knife 3.00 2 0.04% 0.04% 0 0.00% 0.00% 0.00
4 Panzerschreck 2.25 6 0.12% 0.12% 0 0.00% 0.00% 0.00
5 Bazooka 2.25 4 0.08% 0.08% 0 0.00% 0.00% 0.00
6 Colt .45 model 1911 1.60 4 0.08% 0.08% 0 0.00% 0.00% 0.00
7 Springfield Rifle with Scope 1.50 11 0.21% 0.21% 0 0.00% 0.00% 0.00
8 Pistol 38 1.50 4 0.08% 0.08% 0 0.00% 0.00% 0.00
9 Mauser Karbiner k98 Sniper Rifle 1.50 8 0.16% 0.16% 0 0.00% 0.00% 0.00
10 Pistol c96 1.50 10 0.19% 0.19% 0 0.00% 0.00% 0.00
11 MP44 Assault Rifle 1.35 9 0.18% 0.18% 0 0.00% 0.00% 0.00
12 Mauser Kar 98k 1.30 8 0.16% 0.16% 0 0.00% 0.00% 0.00
13 M1 Garand Rifle 1.30 9 0.18% 0.18% 0 0.00% 0.00% 0.00
14 Thompson Submachine Gun 1.25 14 0.27% 0.27% 0 0.00% 0.00% 0.00
15 MP40 Machine Pistol 1.25 10 0.19% 0.19% 0 0.00% 0.00% 0.00
16 .30 Caliber Machine Gun 1.25 8 0.16% 0.16% 0 0.00% 0.00% 0.00
17 MG42 Machine Gun 1.20 6 0.12% 0.12% 0 0.00% 0.00% 0.00
18 M1 Carbine 1.20 12 0.23% 0.23% 0 0.00% 0.00% 0.00
19 BAR Browning Automatic Rifle 1.20 12 0.23% 0.23% 0 0.00% 0.00% 0.00
20 U.S. Grenade 1.00 6 0.12% 0.12% 0 0.00% 0.00% 0.00
21 German Grenade 1.00 3 0.06% 0.06% 0 0.00% 0.00% 0.00




ERROR
Database Error

Server Address: localhost
Server Username: agc

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