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

Banner
  Clan Information

Statistics Summary
Clan: TheSharkLair
Home Page:
Activity: 99.00%
Members: 1 active members (1 total)
Avg. Member Points: 1,233
Total Kills: 5
Total Deaths: 1
Avg. Kills: 5
Kills per Death: 5.00
Kills per Minute: 0.72
Total Connection Time: 0d 00:06:56h
Avg. Connection Time: 0d 00:06:56h
Favorite Server:* 【NoMad Fury】|DUST2| Nomad-Fury.com
Favorite Map:* de_chateau
Favorite Weapon:* Glock 18 Select Fire
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United statesblurp :3 elorank 1,233 0d 00:06:56h 5 100.00% 1 5.00




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 3 times 30
2 Pick up the Bomb 2 times 4
3 Round MVP 1 times 50
4 Rampage (5 kills) 1 times 20
5 Drop the Bomb 1 times -2




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 1 times 50.00%




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Glock 18 Select Fire 1.40 3 60.00% 2 66.67% 0.67
2 Steyr Tactical Machine Pistol 1.50 2 40.00% 1 33.33% 0.50




  Weapon Stats *

Rank Weapon Shots Hits Damage Headshots Kills sort-descending.gif Kills per Death Accuracy Damage per Hit Shots per Kill
1 Glock 18 Select Fire 52 24 630 4 6 6.0000 46.2% 26.3 8.7
2 Steyr Tactical Machine Pistol 56 16 330 2 4 4.0000 28.6% 20.6 14.0
3 Kalashnikov AK-47 60 8 260 0 0 0.0000 13.3% 32.5 0.0




ERROR
Database Error

Server Address: 192.168.1.60
Server Username: kevin

Error Diagnostic:
Bad query.

Server Error: (144) Table './hlstatsx/hlstats_Events_Statsme2' is marked as crashed and last (automatic?) repair failed

Last SQL Query:
		SELECT
			hlstats_Events_Statsme2.weapon AS smweapon,
			SUM(hlstats_Events_Statsme2.head) AS smhead,
			SUM(hlstats_Events_Statsme2.chest) AS smchest,
			SUM(hlstats_Events_Statsme2.stomach) AS smstomach,
			SUM(hlstats_Events_Statsme2.leftarm) AS smleftarm,
			SUM(hlstats_Events_Statsme2.rightarm) AS smrightarm,
			SUM(hlstats_Events_Statsme2.leftleg) AS smleftleg,
			SUM(hlstats_Events_Statsme2.rightleg) AS smrightleg,
			SUM(hlstats_Events_Statsme2.head)+SUM(hlstats_Events_Statsme2.chest)+SUM(hlstats_Events_Statsme2.stomach)+
			SUM(hlstats_Events_Statsme2.leftarm)+SUM(hlstats_Events_Statsme2.rightarm)+SUM(hlstats_Events_Statsme2.leftleg)+
			SUM(hlstats_Events_Statsme2.rightleg) as smhits,							
			IFNULL(ROUND((SUM(hlstats_Events_Statsme2.leftarm) + SUM(hlstats_Events_Statsme2.leftleg)) / (SUM(hlstats_Events_Statsme2.head) + SUM(hlstats_Events_Statsme2.chest) + SUM(hlstats_Events_Statsme2.stomach) + SUM(hlstats_Events_Statsme2.leftarm ) + SUM(hlstats_Events_Statsme2.rightarm) + SUM(hlstats_Events_Statsme2.leftleg) + SUM(hlstats_Events_Statsme2.rightleg)) * 100, 1), 0.0) AS smleft,
			IFNULL(ROUND((SUM(hlstats_Events_Statsme2.rightarm) + SUM(hlstats_Events_Statsme2.rightleg)) / (SUM(hlstats_Events_Statsme2.head) + SUM(hlstats_Events_Statsme2.chest) + SUM(hlstats_Events_Statsme2.stomach) + SUM(hlstats_Events_Statsme2.leftarm ) + SUM(hlstats_Events_Statsme2.rightarm) + SUM(hlstats_Events_Statsme2.leftleg) + SUM(hlstats_Events_Statsme2.rightleg)) * 100, 1), 0.0) AS smright,
			IFNULL(ROUND((SUM(hlstats_Events_Statsme2.head) + SUM(hlstats_Events_Statsme2.chest) + SUM(hlstats_Events_Statsme2.stomach)) / (SUM(hlstats_Events_Statsme2.head) + SUM(hlstats_Events_Statsme2.chest) + SUM(hlstats_Events_Statsme2.stomach) + SUM(hlstats_Events_Statsme2.leftarm ) + SUM(hlstats_Events_Statsme2.rightarm) + SUM(hlstats_Events_Statsme2.leftleg) + SUM(hlstats_Events_Statsme2.rightleg)) * 100, 1), 0.0) AS smmiddle
		FROM
			hlstats_Events_Statsme2
		LEFT JOIN hlstats_Players ON
			hlstats_Players.playerId=hlstats_Events_Statsme2.playerId
		WHERE
			clan=64
		GROUP BY
			hlstats_Events_Statsme2.weapon
		HAVING
			smhits > 0				
		ORDER BY
			smhits desc,
			smweapon desc