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

Banner
  Clan Information

Statistics Summary
Clan: gamer
Home Page:
Activity: 74.00%
Members: 1 active members (1 total)
Avg. Member Points: 1,137
Total Kills: 4
Total Deaths: 4
Avg. Kills: 4
Kills per Death: 1.00
Kills per Minute: 0.87
Total Connection Time: 0d 00:04:36h
Avg. Connection Time: 0d 00:04:36h
Favorite Server:* 【NoMad Fury】|GUNGAME|nomad-fury.com
Favorite Map:* gg_simpsons_office
Favorite Weapon:* Steyr Scout
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United statesavocado (gamer) elorank 1,137 0d 00:04:36h 4 100.00% 4 1.00




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 4 times 40
2 Double Kill (2 kills) 1 times 5




  Team Selection *

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




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Steyr Scout 1.10 2 50.00% 2 50.00% 1.00
2 H&K UMP45 1.20 1 25.00% 1 25.00% 1.00
3 FN P90 1.20 1 25.00% 1 25.00% 1.00




  Weapon Stats *

Rank Weapon Shots Hits Damage Headshots Kills sort-descending.gif Kills per Death Accuracy Damage per Hit Shots per Kill
1 H&K UMP45 41 10 284 2 2 2.0000 24.4% 28.4 20.5
2 FN P90 10 4 304 2 2 2.0000 40.0% 76.0 5.0
3 Galil 11 2 184 0 0 0.0000 18.2% 92.0 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=52
		GROUP BY
			hlstats_Events_Statsme2.weapon
		HAVING
			smhits > 0				
		ORDER BY
			smhits desc,
			smweapon desc