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

  Sections

  Clan Information

Statistics Summary
Clan: 3
Home Page:
Activity: 79.57% 79.57%
Members: 7 active members (73 total)
Avg. Member Points: 10,668
Total Kills: 23,978
Total Deaths: 25,504
Avg. Kills: 3,425
Kills per Death: 0.94
Kills per Minute: 0.47
Total Connection Time: 35d 04:30:30h
Avg. Connection Time: 5d 00:38:38h
Favorite Server:* GAMER.KG | CS:S CW/MIX 1 [В ожидании: 10]
Favorite Map:* de_dust2
Favorite Weapon:*
ERROR
Database Error

Server Address: 176.126.167.7
Server Username: mwa

Error Diagnostic:
Bad query.

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

Last SQL Query:
						SELECT
							hlstats_Events_Frags.weapon,
							hlstats_Weapons.name,
							COUNT(hlstats_Events_Frags.weapon) AS kills,
							SUM(hlstats_Events_Frags.headshot=1) as headshots
						FROM
							hlstats_Events_Frags
						INNER JOIN
							hlstats_Weapons
						ON
							hlstats_Weapons.code = hlstats_Events_Frags.weapon
						INNER JOIN 
                            hlstats_Players
						ON
							hlstats_Events_Frags.killerId=hlstats_Players.playerId
						WHERE
							clan=37
						AND
						    hlstats_Weapons.game='css'
						GROUP BY
							hlstats_Events_Frags.weapon
						ORDER BY
							kills desc, headshots desc
						LIMIT 1