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

  Sections

  Clan Information

Statistics Summary
Clan: 247
Home Page:
Activity: 59.25% 59.25%
Members: 4 active members (15 total)
Avg. Member Points: 685
Total Kills: 187,973
Total Deaths: 170,610
Avg. Kills: 46,993
Kills per Death: 1.10
Kills per Minute: 3.09
Total Connection Time: 42d 04:41:26h
Avg. Connection Time: 10d 13:10:21h
Favorite Server:* Adult Gamers Community - DOD:S Gungame
Favorite Map:* cdc_mario_air_[rm]_[ob1]
Favorite Weapon:* Spade Entrenchment Tool
Player Locations

  Members

Rank Name Points Activity Time Kills sort-descending.gif Clan Kills % Deaths Kpd
1  United states[247] COL Night Raider 675 99% 29d 04:33:03h 140,047 74.50% 74.50% 121,713 1.15
2  Canada[247] Maj Gen. TriggerFinger 574 88% 12d 21:31:42h 47,672 25.36% 25.36% 48,541 0.98
3  United states[247] LTC. Barf 657 41% 0d 01:33:39h 131 0.07% 0.07% 214 0.61
4  United kingdom[247] tony.sands 833 9% 0d 01:03:02h 123 0.07% 0.07% 142 0.87




  Player Actions *

Rank Action sort-descending.gif Achieved Points Bonus
1 Unstoppable (11 kills) 5 times 50
2 Ultra Kill (8 kills) 32 times 224
3 Triple Kill (3 kills) 727 times 1,454
4 Rampage (5 kills) 177 times 708
5 Ownage (7 kills) 75 times 450
6 Monster Kill (10 kills) 5 times 45
7 Mega Kill (6 kills) 108 times 540
8 Killing Spree (9 kills) 17 times 136
9 God Like (12+ kills) 12 times 132
10 Double Kill (2 kills) 1,470 times 1,470
11 Domination (4 kills) 365 times 1,095
12 Bomb Planter Killed 13 times 26
13 Bomb Planted 22 times 44




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Axis 577 times 39.04% 39.04%
2 Allies 168 times 11.37% 11.37%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Random 745 times 87.24% 87.24% 10,448 9,079 1.15
2 Axis Unteroffizier Axis Unteroffizier 108 times 12.65% 12.65% 1,942 1,519 1.28
3 American Rifleman American Rifleman 1 times 0.12% 0.12%




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-ascending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Butt Stock Hit 3.00 9 0.00% 0.00% 0 0.00% 0.00% 0.00
2 TNT Bomb 1.00 35 0.02% 0.02% 0 0.00% 0.00% 0.00
3 U.S. Issue Knife 3.00 79 0.04% 0.04% 0 0.00% 0.00% 0.00
4 German Grenade 1.00 162 0.09% 0.09% 0 0.00% 0.00% 0.00
5 U.S. Grenade 1.00 292 0.16% 0.16% 0 0.00% 0.00% 0.00
6 Colt .45 model 1911 1.60 370 0.20% 0.20% 0 0.00% 0.00% 0.00
7 Pistol 38 1.50 385 0.20% 0.20% 0 0.00% 0.00% 0.00
8 Panzerschreck 2.25 445 0.24% 0.24% 0 0.00% 0.00% 0.00
9 Bazooka 2.25 572 0.30% 0.30% 0 0.00% 0.00% 0.00
10 .30 Caliber Machine Gun 1.25 620 0.33% 0.33% 0 0.00% 0.00% 0.00
11 Mauser Karbiner k98 Sniper Rifle 1.50 638 0.34% 0.34% 0 0.00% 0.00% 0.00
12 MG42 Machine Gun 1.20 657 0.35% 0.35% 0 0.00% 0.00% 0.00
13 Springfield Rifle with Scope 1.50 672 0.36% 0.36% 0 0.00% 0.00% 0.00
14 BAR Browning Automatic Rifle 1.20 695 0.37% 0.37% 0 0.00% 0.00% 0.00
15 Mauser Kar 98k 1.30 698 0.37% 0.37% 0 0.00% 0.00% 0.00
16 MP44 Assault Rifle 1.35 701 0.37% 0.37% 0 0.00% 0.00% 0.00
17 M1 Garand Rifle 1.30 706 0.38% 0.38% 0 0.00% 0.00% 0.00
18 M1 Carbine 1.20 722 0.38% 0.38% 0 0.00% 0.00% 0.00
19 Pistol c96 1.50 726 0.39% 0.39% 0 0.00% 0.00% 0.00
20 MP40 Machine Pistol 1.25 734 0.39% 0.39% 0 0.00% 0.00% 0.00
21 Thompson Submachine Gun 1.25 741 0.39% 0.39% 0 0.00% 0.00% 0.00
22 Spade Entrenchment Tool 3.00 1,851 0.98% 0.98% 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 / 187973 * 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