Server status

[Meister]

Do I need to add privileges on mysql so that the ports will be open from my website ? I can't let my status go online. Yes there are threads about it but I can't seem to follow it.

Any guides or tutorial from youtube so that it'll be easy? Thanks!

[Dythe]

SQL has nothing to do with that

SQL =/= ports

Edited September 13, 2012 by Dythe

[Meister]

SQL has nothing to do with that

SQL =/= ports

Then what should I do to make it work?

[clydelion]

Make sure that your web host allows you to access other ports other than 80..

[Jasc]

if you use SQL on phpmyadmin, set a user with the correct host and priviledges so you don't get any mysql errors

[Chok Designer]

im little confusing with this..

my server is online but server status in offline in my fluxcp...

plz help me......tnx....

all applications is working my server status is the only error...

here's my screenshots..

[Sryx]

im little confusing with this..

my server is online but server status in offline in my fluxcp...

plz help me......tnx....

all applications is working my server status is the only error...

here's my screenshots..

Post your status.php here.

[Chok Designer]

<?php
if (!defined('FLUX_ROOT')) exit;

$title = Flux::message('ServerStatusTitle');
$cache = FLUX_DATA_DIR.'/tmp/ServerStatus.cache';

if (file_exists($cache) && (time() - filemtime($cache)) < (Flux::config('ServerStatusCache') * 60)) {
$serverStatus = unserialize(file_get_contents($cache));
}
else {
$serverStatus = array();
foreach (Flux::$loginAthenaGroupRegistry as $groupName => $loginAthenaGroup) {
if (!array_key_exists($groupName, $serverStatus)) {
$serverStatus[$groupName] = array();
}

$loginServerUp = $loginAthenaGroup->loginServer->isUp();

foreach ($loginAthenaGroup->athenaServers as $athenaServer) {
$serverName = $athenaServer->serverName;

$sql = "SELECT COUNT(char_id) AS players_online FROM {$athenaServer->charMapDatabase}.char WHERE online > 0";
$sth = $loginAthenaGroup->connection->getStatement($sql);
$sth->execute();
$res = $sth->fetch();

$serverStatus[$groupName][$serverName] = array(
'loginServerUp' => $loginServerUp,
'charServerUp' => $athenaServer->charServer->isUp(),
'mapServerUp' => $athenaServer->mapServer->isUp(),
'playersOnline' => intval($res ? $res->players_online : 0)
);
}
}

$fp = fopen($cache, 'w');
if (is_resource($fp)) {
fwrite($fp, serialize($serverStatus));
fclose($fp);
}
}
?>

Here!...

SOLVED!

Edited January 1, 2013 by gniryudan
Please use [CODEBOX] or Attachments for long contents.