Live Stats MySQL Query

[ringo]

Nice! Looks Good.

[Jaggl]

thx :=)

[nmo0ory]

i want theis !

[Raizio]

i want theis !

 

Ringo's post has all that you need, mate. Ringo, thanks for this beautiful piece of code.

[votick]

Anyone got a script for showing stats for servers owned by a certian user id.

 

E.g. I want to show the status and player count on a website for demo servers owned by the admin account.

 

I seem to get multiple results for the same server (some wrong).

 

GMod Server (0/0)

GMod Server (0/0)

GMod Server (0/)

GMod Server (0/)

GMod Server (2/6)

GMod Server (2/6)

GMod Server (0/8)

GMod Server (0/8)

GMod Server (0/0)

GMod Server (0/0)

 

And I can't seem to grab the ip or port from the mysql table.

 

I'll give it another shot tomorrow.

[ringo]

It should probably be possible. I'll have to play around with it and see if I can't work something up.

[votick]

That would be a great help.

Don't quite fully get all this table calling and stuff xD

[votick]

Here's what I have t the moment:

 

<?php
mysql_connect("ADDRESS", "USER", "PASSWORD") or die(mysql_error());
mysql_select_db("DATABASE") or die(mysql_error());
$result = mysql_query("SELECT s.ip_address,s.game_port,g.display_name,g.query_protocol,g.game_id,ls.online,ls.map,ls.name,ls.max_players,ls.players,ls.service_id
FROM tc_game_services s
INNER JOIN tc_games g ON s.game_id = g.game_id
INNER JOIN tc_game_service_live_stats ls ON s.service_id = ls.service_id
WHERE online = 1
ORDER BY g.display_name ASC, ls.name ASC") or die(mysql_error());
while($row = mysql_fetch_array($result)){
   echo "<li><img src='images/gameimages/mini/16/" . $row['game_id'] . ".png' border='0' width='16px' height='16px' /> <a href='http://www.gametracker.com/server_info/" . $row['ip_address'] . ":" . $row['game_port'] . "' target='_blank'>" . $row['ip_address'] . ":" . $row['game_port'] . "</a> (" . $row['players'] . "/" . $row['max_players'] . ")</li>";
} 
?>

 

So I have the address and online/max slots. Only thing I'm having trouble with is showing only the results by userid 15.

 

Anyone shed any light?

[nmo0ory]

how to add it to whmcs ?

tpl file ?

[Jaggl]

see this page: http://clientforums.tcadmin.com/showthread.php?t=9692&page=3