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"; }