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

  Sections

  Clan Information

Statistics Summary
Clan: 415
Home Page:
Activity: 76.00% 76.00%
Members: 4 active members (14 total)
Avg. Member Points: 637
Total Kills: 8,072
Total Deaths: 10,254
Avg. Kills: 2,018
Kills per Death: 0.79
Kills per Minute: 1.95
Total Connection Time: 2d 21:09:14h
Avg. Connection Time: 0d 17:17:18h
Favorite Server:* Adult Gamers Community - DOD:S Gungame
Favorite Map:* cdc_mario_air_[rm]_[ob1]
Favorite Weapon:* MP40 Machine Pistol
Player Locations

  Members

Rank Name Points sort-ascending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United states[415]Nurse 411 99% 1d 23:53:03h 4,697 58.19% 58.19% 6,470 0.73
2  United states[415]ChiefBreakingWind 592 25% 0d 08:45:52h 1,302 16.13% 16.13% 1,726 0.75
3  United states[415]SoreDayofDaFeet 598 88% 0d 12:03:35h 2,001 24.79% 24.79% 2,004 1.00
4  United states[415]sYmYn 948 92% 0d 00:26:44h 72 0.89% 0.89% 54 1.33




  Player Actions *

Rank Action sort-descending.gif Achieved Points Bonus
1 Triple Kill (3 kills) 58 times 116
2 Rampage (5 kills) 14 times 56
3 Ownage (7 kills) 4 times 24
4 Mega Kill (6 kills) 5 times 25
5 Double Kill (2 kills) 159 times 159
6 Domination (4 kills) 23 times 69




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Allies 105 times 35.84% 35.84%
2 Axis 40 times 13.65% 13.65%




  Role Selection *

Rank Role Joined sort-descending.gif % Ratio Kills Deaths K:D
1 Random 145 times 100.00% 100.00% 1,125 1,468 0.77




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 MP40 Machine Pistol 1.25 131 1.62% 1.62% 0 0.00% 0.00% 0.00
2 Thompson Submachine Gun 1.25 126 1.56% 1.56% 0 0.00% 0.00% 0.00
3 Pistol c96 1.50 125 1.55% 1.55% 0 0.00% 0.00% 0.00
4 Spade Entrenchment Tool 3.00 123 1.52% 1.52% 0 0.00% 0.00% 0.00
5 M1 Carbine 1.20 110 1.36% 1.36% 0 0.00% 0.00% 0.00
6 M1 Garand Rifle 1.30 93 1.15% 1.15% 0 0.00% 0.00% 0.00
7 MP44 Assault Rifle 1.35 88 1.09% 1.09% 0 0.00% 0.00% 0.00
8 Mauser Kar 98k 1.30 75 0.93% 0.93% 0 0.00% 0.00% 0.00
9 BAR Browning Automatic Rifle 1.20 67 0.83% 0.83% 0 0.00% 0.00% 0.00
10 Springfield Rifle with Scope 1.50 40 0.50% 0.50% 0 0.00% 0.00% 0.00
11 Mauser Karbiner k98 Sniper Rifle 1.50 39 0.48% 0.48% 0 0.00% 0.00% 0.00
12 .30 Caliber Machine Gun 1.25 34 0.42% 0.42% 0 0.00% 0.00% 0.00
13 MG42 Machine Gun 1.20 27 0.33% 0.33% 0 0.00% 0.00% 0.00
14 Bazooka 2.25 24 0.30% 0.30% 0 0.00% 0.00% 0.00
15 Panzerschreck 2.25 11 0.14% 0.14% 0 0.00% 0.00% 0.00
16 Colt .45 model 1911 1.60 6 0.07% 0.07% 0 0.00% 0.00% 0.00
17 Pistol 38 1.50 5 0.06% 0.06% 0 0.00% 0.00% 0.00
18 U.S. Grenade 1.00 3 0.04% 0.04% 0 0.00% 0.00% 0.00
19 German Grenade 1.00 3 0.04% 0.04% 0 0.00% 0.00% 0.00
20 Butt Stock Hit 3.00 1 0.01% 0.01% 0 0.00% 0.00% 0.00
21 U.S. Issue Knife 3.00 1 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 / 8072 * 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