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

  Sections

  Clan Information

Statistics Summary
Clan: 2
Home Page:
Activity: 61.76% 61.76%
Members: 25 active members (287 total)
Avg. Member Points: 9,538
Total Kills: 36,259
Total Deaths: 35,960
Avg. Kills: 1,450
Kills per Death: 1.01
Kills per Minute: 0.47
Total Connection Time: 53d 06:47:49h
Avg. Connection Time: 2d 03:09:06h
Favorite Server:* GAMER.KG | CS:S Public Classic
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=17
						AND
						    hlstats_Weapons.game='css'
						GROUP BY
							hlstats_Events_Frags.weapon
						ORDER BY
							kills desc, headshots desc
						LIMIT 1