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

  Sections

  Clan Information

Statistics Summary
Clan: 4
Home Page:
Activity: 99.00% 99.00%
Members: 2 active members (16 total)
Avg. Member Points: 8,194
Total Kills: 1,248
Total Deaths: 977
Avg. Kills: 624
Kills per Death: 1.28
Kills per Minute: 0.53
Total Connection Time: 1d 15:10:00h
Avg. Connection Time: 0d 19:35:00h
Favorite Server:* GAMER.KG | CS:S CW/MIX 1 [В ожидании: 8]
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=3615
						AND
						    hlstats_Weapons.game='css'
						GROUP BY
							hlstats_Events_Frags.weapon
						ORDER BY
							kills desc, headshots desc
						LIMIT 1