Nomad-Fury HLstatsX - Counter-Strike: Source - Clan Details

Clan Information

Statistics Summary
Clan:	SAF
Home Page:
Activity:		97.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,185
Total Kills:	6
Total Deaths:	5
Avg. Kills:	6
Kills per Death:	1.20
Kills per Minute:	0.71
Total Connection Time:	0d 00:08:28h
Avg. Connection Time:	0d 00:08:28h
Favorite Server:*	【NoMad Fury】\|GUNGAME\|Funtimes/Iceworld\| nomad-fury.com
Favorite Map:*	gg_fy_funtimes
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	\|SAF\| Mr Scruff		1,185		0d 00:08:28h	6		100.00%	5	1.20

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	4 times	40
2	Double Kill (2 kills)	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	2 times		66.67%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.20	2		33.33%	1		25.00%	0.50
2		1.00	1		16.67%	0		0.00%	0.00
3		1.50	1		16.67%	1		25.00%	1.00
4		1.40	1		16.67%	1		25.00%	1.00
5		1.20	1		16.67%	1		25.00%	1.00

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		123	34	866	2	6	1.5000	27.6%	25.5	20.5
2		9	2	80	2	2	2.0000	22.2%	40.0	4.5
3		5	6	252	2	2	1.0000	120.0%	42.0	2.5
4		17	6	392	2	2	2.0000	35.3%	65.3	8.5
5		16	12	138	0	0	0.0000	75.0%	11.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=59
		GROUP BY
			hlstats_Events_Statsme2.weapon
		HAVING
			smhits > 0				
		ORDER BY
			smhits desc,
			smweapon desc