HLstatsX Community Edition
  • TF
  • TF_IDLESERVERS
  • TF_ZOMBIE
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: _SC_
Home Page:
Activity: 75.75% 75.75%
Members: 4 active members (4 total)
Avg. Member Points: 1,038
Total Kills: 301
Total Deaths: 190
Avg. Kills: 75
Kills per Death: 1.58
Kills per Minute: 0.28
Total Connection Time: 0d 17:52:44h
Avg. Connection Time: 0d 04:28:11h
Favorite Server:* ★ WonderLand FL | Orange x3 | x1000 - FREE ITEMS!
Favorite Map:* cp_orange_x3
Favorite Weapon:*
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  No Country*_SC_* Kool Kat 1,193 62% 0d 10:55:44h 276 91.69% 91.69% 154 1.79
2  No Country*_SC_* hoooodiini 996 70% 0d 00:30:29h 2 0.66% 0.66% 4 0.50
3  No Country*_SC_*Gameperson 982 81% 0d 02:03:29h 14 4.65% 4.65% 18 0.78
4  United states*_SC_* KillerPuncake 980 90% 0d 04:23:02h 9 2.99% 2.99% 14 0.64




ERROR
Database Error

Server Address: 213.239.196.115
Server Username: xyz

Error Diagnostic:
Bad query.

Server Error: ()

Last SQL Query:
		(SELECT
			code,
			hlstats_Actions.description,
			COUNT(hlstats_Events_PlayerActions.id) AS obj_count,
			SUM(hlstats_Events_PlayerActions.bonus) AS obj_bonus
		FROM
			hlstats_Actions
		LEFT JOIN
			hlstats_Events_PlayerActions
		ON
			hlstats_Events_PlayerActions.actionId = hlstats_Actions.id
		LEFT JOIN
			hlstats_Players
		ON
			hlstats_Players.playerId=hlstats_Events_PlayerActions.playerId
		WHERE
			clan=8206
		GROUP BY
			hlstats_Actions.id)
		UNION ALL
		(SELECT
			code,
			hlstats_Actions.description,
			COUNT(hlstats_Events_PlayerPlayerActions.id) AS obj_count,
			SUM(hlstats_Events_PlayerPlayerActions.bonus) AS obj_bonus
		FROM
			hlstats_Actions
		LEFT JOIN
			hlstats_Events_PlayerPlayerActions
		ON
			hlstats_Events_PlayerPlayerActions.actionId = hlstats_Actions.id
		LEFT JOIN
			hlstats_Players
		ON
			hlstats_Players.playerId=hlstats_Events_PlayerPlayerActions.playerId
		WHERE
			clan=8206
		GROUP BY
			hlstats_Actions.id)
		ORDER BY
			obj_count desc,
			description desc