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

Clan Information

Statistics Summary
Clan:	ɪllegʌL [Sʌ]
Home Page:
Activity:		70.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,550
Total Kills:	16
Total Deaths:	1
Avg. Kills:	16
Kills per Death:	16.00
Kills per Minute:	1.29
Total Connection Time:	0d 00:12:23h
Avg. Connection Time:	0d 00:12:23h
Favorite Server:*	【NoMad Fury】\|Zombies Reloaded\|nomad-fury.com
Favorite Map:*	zm_ancientb3
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Solid Snake		1,550		0d 00:12:23h	16		100.00%	1	16.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	6 times	60
2	God Like (12+ kills)	1 times	75
3	Domination (4 kills)	1 times	15

Team Selection *

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

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.20	12		75.00%	6		100.00%	0.50

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		2,300	972	41,650	12	24	24.0000	42.3%	42.8	95.8
2		9	10	464	0	0	0.0000	111.1%	46.4	0.0
3		3	2	22	0	0	0.0000	66.7%	11.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=55
		GROUP BY
			hlstats_Events_Statsme2.weapon
		HAVING
			smhits > 0				
		ORDER BY
			smhits desc,
			smweapon desc