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

  Sections

  Clan Information

Statistics Summary
Clan: 415reg
Home Page:
Activity: 75.00% 75.00%
Members: 1 active members (4 total)
Avg. Member Points: 522
Total Kills: 1,324
Total Deaths: 1,375
Avg. Kills: 1,324
Kills per Death: 0.96
Kills per Minute: 2.76
Total Connection Time: 0d 07:58:57h
Avg. Connection Time: 0d 07:58:57h
Favorite Server:* Adult Gamers Community - DOD:S Gungame
Favorite Map:* cdc_mario_air_[rm]_[ob1]
Favorite Weapon:* Pistol c96
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United statesSplenda[415reg] 522 75% 0d 07:58:57h 1,324 100.00% 100.00% 1,375 0.96




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Double Kill (2 kills) 36 times 36
2 Triple Kill (3 kills) 26 times 52
3 Domination (4 kills) 8 times 24
4 Ownage (7 kills) 4 times 24
5 Rampage (5 kills) 3 times 12
6 Ultra Kill (8 kills) 1 times 7
7 Mega Kill (6 kills) 1 times 5




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Allies 19 times 28.79% 28.79%
2 Axis 10 times 15.15% 15.15%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Random 29 times 90.63% 90.63% 292 298 0.98
2 Axis Grenadier Axis Grenadier 2 times 6.25% 6.25% 19 31 0.61
3 American Master Sergeant American Master Sergeant 1 times 3.13% 3.13% 26 32 0.81




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Pistol c96 1.50 31 2.34% 2.34% 0 0.00% 0.00% 0.00
2 Thompson Submachine Gun 1.25 28 2.11% 2.11% 0 0.00% 0.00% 0.00
3 M1 Carbine 1.20 26 1.96% 1.96% 0 0.00% 0.00% 0.00
4 Mauser Kar 98k 1.30 26 1.96% 1.96% 0 0.00% 0.00% 0.00
5 MP40 Machine Pistol 1.25 25 1.89% 1.89% 0 0.00% 0.00% 0.00
6 M1 Garand Rifle 1.30 25 1.89% 1.89% 0 0.00% 0.00% 0.00
7 Spade Entrenchment Tool 3.00 23 1.74% 1.74% 0 0.00% 0.00% 0.00
8 MP44 Assault Rifle 1.35 22 1.66% 1.66% 0 0.00% 0.00% 0.00
9 BAR Browning Automatic Rifle 1.20 20 1.51% 1.51% 0 0.00% 0.00% 0.00
10 Mauser Karbiner k98 Sniper Rifle 1.50 19 1.44% 1.44% 0 0.00% 0.00% 0.00
11 MG42 Machine Gun 1.20 18 1.36% 1.36% 0 0.00% 0.00% 0.00
12 Springfield Rifle with Scope 1.50 16 1.21% 1.21% 0 0.00% 0.00% 0.00
13 .30 Caliber Machine Gun 1.25 13 0.98% 0.98% 0 0.00% 0.00% 0.00
14 Bazooka 2.25 12 0.91% 0.91% 0 0.00% 0.00% 0.00
15 U.S. Grenade 1.00 9 0.68% 0.68% 0 0.00% 0.00% 0.00
16 Panzerschreck 2.25 8 0.60% 0.60% 0 0.00% 0.00% 0.00
17 Colt .45 model 1911 1.60 7 0.53% 0.53% 0 0.00% 0.00% 0.00
18 German Grenade 1.00 5 0.38% 0.38% 0 0.00% 0.00% 0.00
19 Pistol 38 1.50 4 0.30% 0.30% 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 / 1324 * 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