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

  Sections

  Clan Information

Statistics Summary
Clan: 8th ID
Home Page:
Activity: 78.71% 78.71%
Members: 7 active members (25 total)
Avg. Member Points: 838
Total Kills: 14,330
Total Deaths: 13,638
Avg. Kills: 2,047
Kills per Death: 1.05
Kills per Minute: 2.64
Total Connection Time: 3d 18:36:47h
Avg. Connection Time: 0d 12:56:41h
Favorite Server:* Adult Gamers Community - DOD:S Gungame
Favorite Map:* dod_pacman_b2
Favorite Weapon:* Thompson Submachine Gun
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United statesT/5 A. Sheffer |8th ID| 994 70% 0d 00:09:43h 21 0.15% 0.15% 14 1.50
2  United statesS/Sgt. S. French |8th ID| 977 100% 0d 00:05:55h 5 0.03% 0.03% 5 1.00
3  United statesKim Kardashian |8th ID| 953 56% 0d 00:07:22h 22 0.15% 0.15% 24 0.92
4  United statesM/Sgt. M. McDowell |8th ID| 892 73% 0d 01:32:53h 230 1.61% 1.61% 186 1.24
5  United statesCWO D. Joaquin |8th ID| 780 95% 0d 01:57:00h 381 2.66% 2.66% 314 1.21
6  United statesS/Sgt. J. Sky |8th ID| 679 58% 0d 01:56:01h 477 3.33% 3.33% 401 1.19
7  CanadaCpl. T. Tritium |8th ID| 591 99% 3d 12:47:53h 13,194 92.07% 92.07% 12,694 1.04




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Double Kill (2 kills) 46 times 46
2 Triple Kill (3 kills) 20 times 40
3 Rampage (5 kills) 6 times 24
4 Domination (4 kills) 5 times 15
5 Ownage (7 kills) 3 times 18




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Allies 17 times 22.97% 22.97%
2 Axis 14 times 18.92% 18.92%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Random 31 times 96.88% 96.88% 292 291 1.00
2 American Rifleman American Rifleman 1 times 3.13% 3.13% 20 23 0.87




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Thompson Submachine Gun 1.25 28 0.20% 0.20% 0 0.00% 0.00% 0.00
2 M1 Carbine 1.20 27 0.19% 0.19% 0 0.00% 0.00% 0.00
3 Pistol c96 1.50 26 0.18% 0.18% 0 0.00% 0.00% 0.00
4 MP40 Machine Pistol 1.25 25 0.17% 0.17% 0 0.00% 0.00% 0.00
5 M1 Garand Rifle 1.30 24 0.17% 0.17% 0 0.00% 0.00% 0.00
6 Spade Entrenchment Tool 3.00 23 0.16% 0.16% 0 0.00% 0.00% 0.00
7 BAR Browning Automatic Rifle 1.20 23 0.16% 0.16% 0 0.00% 0.00% 0.00
8 Mauser Kar 98k 2.00 22 0.15% 0.15% 0 0.00% 0.00% 0.00
9 MP44 Assault Rifle 1.35 21 0.15% 0.15% 0 0.00% 0.00% 0.00
10 .30 Caliber Machine Gun 1.25 17 0.12% 0.12% 0 0.00% 0.00% 0.00
11 Springfield Rifle with Scope 1.50 16 0.11% 0.11% 0 0.00% 0.00% 0.00
12 Mauser Karbiner k98 Sniper Rifle 1.50 16 0.11% 0.11% 0 0.00% 0.00% 0.00
13 MG42 Machine Gun 1.20 14 0.10% 0.10% 0 0.00% 0.00% 0.00
14 Bazooka 2.25 13 0.09% 0.09% 0 0.00% 0.00% 0.00
15 Pistol 38 1.50 10 0.07% 0.07% 0 0.00% 0.00% 0.00
16 Panzerschreck 2.25 9 0.06% 0.06% 0 0.00% 0.00% 0.00
17 Colt .45 model 1911 1.60 7 0.05% 0.05% 0 0.00% 0.00% 0.00
18 U.S. Grenade 1.00 2 0.01% 0.01% 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 / 14330 * 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 asc,
			kills asc