HLstatsX Community Edition
  • VALVE
  • AG
  • Contents
  • Search
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: BOSS
Home Page:
Activity: 100.00% 100.00%
Members: 1 active members (10 total)
Avg. Member Points: 5,652
Total Kills: 22,598
Total Deaths: 5,720
Avg. Kills: 22,598
Kills per Death: 3.95
Kills per Minute: 1.19
Total Connection Time: 13d 04:21:32h
Avg. Connection Time: 13d 04:21:32h
Favorite Server:* >> [SPb] 1 > Russian CROSSFIRE ctf
Favorite Map:* crossfire
Favorite Weapon:* Crossbow Zoomed
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Germany[BOSS] R@LL3 5,652 100% 13d 04:21:32h 22,598 100.00% 100.00% 5,720 3.95




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot Kill 90 times 90
2 Double Kill (2 kills) 29 times 29
3 Domination (4 kills) 16 times 48
4 Triple Kill (3 kills) 10 times 20
5 Rampage (5 kills) 10 times 40
6 Killing Spree (9 kills) 5 times 40
7 God Like (12+ kills) 5 times 55
8 Monster Kill (10 kills) 2 times 18
9 Ultra Kill (8 kills) 1 times 7
10 Ownage (7 kills) 1 times 6
11 Mega Kill (6 kills) 1 times 5




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 red 18 times 1.73% 1.73%
2 blue 14 times 1.34% 1.34%




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Crossbow Zoomed 1.40 128 0.57% 0.57% 16 0.47% 0.47% 0.13
2 Gauss 1.00 123 0.54% 0.54% 23 0.68% 0.68% 0.19
3 RPG 1.00 66 0.29% 0.29% 14 0.41% 0.41% 0.21
4 Shotgun 1.20 39 0.17% 0.17% 4 0.12% 0.12% 0.10
5 Trip Mine 1.60 37 0.16% 0.16% 4 0.12% 0.12% 0.11
6 Grenade 1.00 35 0.15% 0.15% 4 0.12% 0.12% 0.11
7 9mm Mp5 1.00 29 0.13% 0.13% 7 0.21% 0.21% 0.24
8 Egon 0.50 28 0.12% 0.12% 7 0.21% 0.21% 0.25
9 Satchel 1.50 24 0.11% 0.11% 2 0.06% 0.06% 0.08
10 9mm Handgun 1.50 10 0.04% 0.04% 5 0.15% 0.15% 0.50
11 Crowbar 1.90 5 0.02% 0.02% 2 0.06% 0.06% 0.40
12 357 Revolver 1.60 4 0.02% 0.02% 2 0.06% 0.06% 0.50
13 Snark 1.80 1 0.00% 0.00% 0 0.00% 0.00% 0.00
14 Crossbow Bolt 1.70 1 0.00% 0.00% 0 0.00% 0.00% 0.00




ERROR
Database Error

Server Address: localhost
Server Username: website

Error Diagnostic:
Bad query.

Server Error: (145) Table '.\hlstatsx\hlstats_events_statsme' is marked as crashed and should be repaired

Last SQL Query:
		SELECT
			hlstats_Events_Statsme.weapon AS smweapon,
			SUM(hlstats_Events_Statsme.kills) AS smkills,
			SUM(hlstats_Events_Statsme.hits) AS smhits,
			SUM(hlstats_Events_Statsme.shots) AS smshots,
			SUM(hlstats_Events_Statsme.headshots) AS smheadshots,
			SUM(hlstats_Events_Statsme.deaths) AS smdeaths,
			SUM(hlstats_Events_Statsme.damage) AS smdamage,
			ROUND((SUM(hlstats_Events_Statsme.damage) / (IF( SUM(hlstats_Events_Statsme.hits)=0, 1, SUM(hlstats_Events_Statsme.hits) ))), 1) as smdhr,
			SUM(hlstats_Events_Statsme.kills) / IF((SUM(hlstats_Events_Statsme.deaths)=0), 1, (SUM(hlstats_Events_Statsme.deaths))) as smkdr,
      ROUND((SUM(hlstats_Events_Statsme.hits) / SUM(hlstats_Events_Statsme.shots) * 100), 1) as smaccuracy,
			ROUND(( (IF(SUM(hlstats_Events_Statsme.kills)=0, 0, SUM(hlstats_Events_Statsme.shots))) / (IF( SUM(hlstats_Events_Statsme.kills)=0, 1, SUM(hlstats_Events_Statsme.kills) ))), 1) as smspk
		FROM
			hlstats_Events_Statsme
		LEFT JOIN hlstats_Players ON
			hlstats_Players.playerId=hlstats_Events_Statsme.playerId
		WHERE
			clan=45
		GROUP BY
			hlstats_Events_Statsme.weapon
    HAVING
      SUM(hlstats_Events_Statsme.shots)>0
		ORDER BY
			smkills desc,
			smweapon desc