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

Banner
  Clan Information

Statistics Summary
Clan: ♀
Home Page:
Activity: 97.00%
Members: 1 active members (1 total)
Avg. Member Points: 1,058
Total Kills: 2
Total Deaths: 1
Avg. Kills: 2
Kills per Death: 2.00
Kills per Minute: 0.31
Total Connection Time: 0d 00:06:28h
Avg. Connection Time: 0d 00:06:28h
Favorite Server:*
Favorite Map:*
Favorite Weapon:* Steyr Tactical Machine Pistol
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United statesJessie!!! [♀] elorank 1,058 0d 00:06:28h 2 100.00% 1 2.00




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 1 times 10




  Team Selection *

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




  Weapon Usage *

Rank Weapon Points Modifier Kills sort-descending.gif Percentage of Kills % Headshots Percentage of Headshots % Hpk
1 Steyr Tactical Machine Pistol 1.50 1 50.00% 1 100.00% 1.00
2 FN Five-Seven 1.50 1 50.00% 0 0.00% 0.00




  Weapon Stats *

Rank Weapon Shots Hits Damage Headshots Kills sort-descending.gif Kills per Death Accuracy Damage per Hit Shots per Kill
1 Benelli/H&K M4 Super 90 XM1014 4 2 20 0 1 1.0000 50.0% 10.0 4.0
2 Steyr Tactical Machine Pistol 9 0 0 0 0 0.0000 0.0% 0.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=61
		GROUP BY
			hlstats_Events_Statsme2.weapon
		HAVING
			smhits > 0				
		ORDER BY
			smhits desc,
			smweapon desc