if (!defined('AJAXINCLUDED')) {
die('Do not access directly!');
}
include EASYWIDIR . '/stuff/methods/functions_ssh_exec.php';
include EASYWIDIR . '/stuff/methods/class_masterserver.php';
include EASYWIDIR . '/stuff/keyphrasefile.php';
$gamelist = array();
$sprache = getlanguagefile('roots', $user_language, $resellerLockupID);
$rootServer = new masterServer($ui->id('serverID', 10, 'get'), $aeskey);
$query = $sql->prepare("SELECT `shorten` FROM `servertypes` WHERE `id`=? AND `resellerid`=? LIMIT 1");
foreach ($ui->id('masterIDs', 10, 'get') as $masterID) {
$query->execute(array($masterID, $resellerLockupID));
$gameShorten = $query->fetchColumn();
if (strlen($gameShorten) > 0) {
$gamelist[] = $gameShorten;
$rootServer->collectData($masterID, true);
}
}
$return = $rootServer->sshConnectAndExecute();
if (count($gamelist) == 0) {
echo 'Nothing to update/sync!';
} else {
if ($return === false) {
echo $sprache->error_root_updatemaster . ' ( ' . implode(', ', $gamelist) . ' )';
} else {
echo $sprache->root_updatemaster . ' ( ' . implode(', ', $gamelist) . ' )';
}
if (isset($dbConnect['debug']) and $dbConnect['debug'] == 1) {
echo '<br>' . nl2br($rootServer->getCommands());
}
}
$query->execute(array($currentMinute));
echo "Checking for servers to be updated and or synced at hour {$currentHour} and between minutes {$lastUpdateRun} and {$currentMinute}\r\n";
// avoid less/more OR equal in SQL. We want only less/more to eliminate the OR comparison
$currentMinute++;
$lastUpdateRun--;
echo "Altered minutes for running a more efficient query will be updateMinute > {$lastUpdateRun} AND updateMinute < {$currentMinute}\r\n";
$query = $sql->prepare("SELECT `id`,`updates` FROM `rserverdata` WHERE (`alreadyStartedAt` IS NULL OR `alreadyStartedAt`!=?) AND `updateMinute`>? AND `updateMinute`<?");
$query2 = $sql->prepare("UPDATE `rserverdata` SET `alreadyStartedAt`=? WHERE `id`=? LIMIT 1");
$query->execute(array($currentHour, $lastUpdateRun, $currentMinute));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$rootServer = new masterServer($row['id'], $aeskey);
if ($row['updates'] == 3) {
echo "Updates deactivated for: " . $rootServer->sship . "\r\n";
} else {
if (4 == $currentHour) {
$rootServer->collectData(true, true, false);
} else {
$rootServer->collectData();
}
$sshReturn = $rootServer->sshConnectAndExecute();
if ($sshReturn === false and $rootServer->updateAmount > 0) {
echo "Updating failed for: " . $rootServer->sship . "\r\n";
} else {
if ($rootServer->updateAmount > 0) {
echo "Updater started for " . $rootServer->sship . "\r\n";
if (isset($dbConnect['debug']) and $dbConnect['debug'] == 1) {
print_r($rootServer->getCommands());
}
} else {
echo "No updates to be executed for " . $rootServer->sship . "\r\n";
}
