<?php
$servername = "XXX.XXX.XXX.XXX";
$username = "root";
$password = "XXXXXXXX";
$conn = mysql_connect($servername, $username, $password);
// Check connection
if(! $conn ) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('gunbound');
$query = "SELECT SUM(`UserCount`) ol FROM (SELECT `UserCount` FROM `concurrentuser` WHERE `Time` = ( SELECT MAX(`Time`) FROM `concurrentuser` WHERE `ServerPort`='8360')) cnt GROUP BY `UserCount`;";
UNION
SELECT `UserCount` FROM `concurrentuser` WHERE `Time` = ( SELECT MAX(`Time`) FROM `concurrentuser` WHERE `ServerPort`='8361') cnt GROUP BY `UserCount`;
$result = mysql_query($query, $conn );
if (!$result) exit("The query did not succeded");
else {
while ($row = mysql_fetch_array($result)) {
echo "Online: ". $row['ol'];
}
}
?>