Live Stats

From TCAdmin 2.0 Documentation

Every time the game monitors queries a service the stats are saved to the table named tc_game_service_live_stats. You can use this table to create a list of services on your website with their current status.

Information currently available in the table:

  • Service Id
  • Online (1/0)
  • Process ID
  • Bandwidth (bytes)
  • CPU (%)
  • Memory (bytes)
  • Memory Limit (bytes) *Memory assigned to Minecraft and Craftbukkit services.
  • Game
  • Game type
  • Map
  • Name
  • Html name
  • Max players
  • Number of current players
  • Number of current spectators
  • Player details in XML format
  • Rules in XML format
  • Query time (UTC/GMT)

Examples

Get a list of services that are currently running:

SELECT a.ip_address, a.game_port, b.*
FROM tc_game_services a, tc_game_service_live_stats b
WHERE online = 1 AND a.service_id = b.service_id;

Get the total number of players connected on each server:

SELECT a.display_name, SUM(b.players) AS players
FROM tc_servers a, tc_game_service_live_stats b, tc_services c
WHERE c.server_id=a.server_id AND b.service_id=c.service_id AND b.online=1 
GROUP BY a.server_id;

Get the total RAM assigned to Minecraft/Craftbukkit services per server. The results are ordered from lowest to highest.

SELECT a.server_id ,a.display_name, ROUND(SUM(b.memory_limit)/1024/1024, 0) AS memory_limit_mb
FROM tc_servers a, tc_game_service_live_stats b, tc_services c
WHERE c.server_id=a.server_id AND b.service_id=c.service_id
GROUP BY a.server_id
ORDER BY SUM(b.memory_limit) ASC