Difference between revisions of "Live Stats"
| Line 1: | Line 1: | ||
| − | Every time the game monitors queries a service the stats are saved to the table named '''tc_game_service_live_stats'''. | + | 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 with their current status. |
| − | + | Information currently available in the table: | |
| + | * Service Id | ||
| + | * Online (1/0) | ||
| + | * 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) | ||
For example you can get a list of services that are currently running with this query: | For example you can get a list of services that are currently running with this query: | ||
<source lang="sql">SELECT * FROM tc_game_service_live_stats WHERE online = 1;</source> | <source lang="sql">SELECT * FROM tc_game_service_live_stats WHERE online = 1;</source> | ||
Revision as of 13:16, 15 July 2011
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 with their current status.
Information currently available in the table:
- Service Id
- Online (1/0)
- 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)
For example you can get a list of services that are currently running with this query:
SELECT * FROM tc_game_service_live_stats WHERE online = 1;