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

  Sections

  Clan Information

Statistics Summary
Clan: /ps
Home Page:
Activity: 76.25% 76.25%
Members: 4 active members (5 total)
Avg. Member Points: 2,021
Total Kills: 2,554
Total Deaths: 1,123
Avg. Kills: 639
Kills per Death: 2.27
Kills per Minute: 0.28
Total Connection Time: 6d 08:37:34h
Avg. Connection Time: 1d 14:09:23h
Favorite Server:* ★ WonderLand FL | Trading! - FREE ITEMS!
Favorite Map:* trade_plaza_2
Favorite Weapon:* Sniper Rifle
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Costa rica/ps/Delirium 4,004 96% 3d 07:36:02h 1,805 70.67% 70.67% 649 2.78
2  Panama/ps/ Weegee 1,907 99% 2d 19:09:31h 675 26.43% 26.43% 407 1.66
3  United states/ps/Ice 1,167 100% 0d 05:38:21h 71 2.78% 2.78% 66 1.08
4  United kingdom/ps/ シ BlueBerry シ 1,004 10% 0d 00:13:40h 3 0.12% 0.12% 1 3.00




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=1716
		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=1716
		GROUP BY
			hlstats_Actions.id)
		ORDER BY
			obj_count desc,
			description desc