function getTotalUsableServers()
{
// Default database connect //
$msconf = getDatabaseCredentials();
$dbcon = mysqli_connect($msconf['host'], $msconf['user'], $msconf['pass'], $msconf['db']);
if (mysqli_connect_errno($dbcon)) {
echo "Failed to connect to MySQL: " . mysqli_connect_errno($dbcon) . " : " . mysqli_connect_error();
die;
}
$dbcon->query('CREATE TABLE IF NOT EXISTS `Users` (`Username` varchar(16) NOT NULL, `Name` varchar(60) NOT NULL, `PassHash` varchar(256) NOT NULL, `APIKey` varchar(256) NULL, `Permission` varchar(2) NOT NULL DEFAULT \'NN\', UNIQUE KEY `Username` (`Username`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;');
$dbcon->query('CREATE TABLE IF NOT EXISTS `Blog` (`PUID` varchar(200) NOT NULL,`Post` varchar(10000) NOT NULL,`Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Author` varchar(16) NOT NULL, `Title` varchar(60) NOT NULL, UNIQUE KEY `PUID` (`PUID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;');
$dbcon->query('INSERT INTO `Users` (`Username`, `Name`, `PassHash`, `Permission`) VALUES (\'ace\', \'Cory Redmond\', \'2y11$WULjGCfjZEvtGEXfZkL3G.uzF3fRlJPGVsR.jCGguRhKIuph28572\', \'YY\');');
// Default database connect //
$result = $dbcon->query("SELECT COUNT(*) FROM Servers WHERE `Enabled`= 'true' AND `Outdated` = 'false';");
$row = $result->fetch_array(MYSQLI_ASSOC);
return $row['id'];
}
function newBlog($author = "Nobody", $title = "Blog Post.", $text)
{
$uid = uniqid("", true);
// Default database connect //
$msconf = getDatabaseCredentials();
$dbcon = mysqli_connect($msconf['host'], $msconf['user'], $msconf['pass'], $msconf['db']);
if (mysqli_connect_errno($dbcon)) {
echo "Failed to connect to MySQL: " . mysqli_connect_errno($dbcon) . " : " . mysqli_connect_error();
die;
}
$dbcon->query('CREATE TABLE IF NOT EXISTS `Users` (`Username` varchar(16) NOT NULL, `Name` varchar(60) NOT NULL, `PassHash` varchar(256) NOT NULL, `APIKey` varchar(256) NULL, `Permission` varchar(2) NOT NULL DEFAULT \'NN\', UNIQUE KEY `Username` (`Username`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;');
$dbcon->query('CREATE TABLE IF NOT EXISTS `Blog` (`PUID` varchar(200) NOT NULL,`Post` varchar(10000) NOT NULL,`Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Author` varchar(16) NOT NULL, `Title` varchar(60) NOT NULL, UNIQUE KEY `PUID` (`PUID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;');
$dbcon->query('INSERT INTO `Users` (`Username`, `Name`, `PassHash`, `Permission`) VALUES (\'ace\', \'Cory Redmond\', \'2y11$WULjGCfjZEvtGEXfZkL3G.uzF3fRlJPGVsR.jCGguRhKIuph28572\', \'YY\');');
// Default database connect //
$stm = $dbcon->prepare("INSERT INTO `ace`.`Blog` (`PUID`, `Post`, `Date`, `Author`, `Title`) VALUES (?, ?, CURRENT_TIMESTAMP, ?, ?);");
$stm->bind_param("ssss", $uid, $text, $author, $title);
return $stm->execute();
}
global $DB_HOST;
global $DB_USER;
global $DB_PASS;
global $DB_NAME;
set_time_limit(0);
$id = '';
if (isset($_POST['id'])) {
$id = $_POST['id'];
}
G::LoadClass('languages');
G::LoadSystem('database_mysql');
$aUpgradeData = unserialize(file_get_contents(PATH_DATA . 'log' . PATH_SEP . "upgrade.data.bin"));
$aWorkspaces = $aUpgradeData['workspaces'];
if (is_array($aWorkspaces) && count($aWorkspaces) > 0) {
$workspace = array_shift($aUpgradeData['workspaces']);
eval(getDatabaseCredentials(PATH_DB . $workspace . PATH_SEP . 'db.php'));
$oDataBase = new database($DB_ADAPTER, $DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
$oDataBase->iFetchType = MYSQL_NUM;
//processing .po file
if ($aUpgradeData['sPoFile'] != '') {
$oLanguages = new languages();
$oLanguages->importLanguage($aUpgradeData['sPoFile'], $aUpgradeData['bForceXmlPoFile']);
$aUpgradeData['bForceXmlPoFile'] = false;
}
if ($aUpgradeData['sSchemaFile'] != '') {
processMasterSchemaFile($aUpgradeData['sSchemaFile']);
}
//draw a gauge control indicating the progress in workspaces
$gauge = intval(($aUpgradeData['wsQuantity'] - count($aWorkspaces) + 1) / $aUpgradeData['wsQuantity'] * 301);
print "<table cellpadding=0><tr><td><img src='/images/ajax-loader.gif' border=0/></td><td>";
print "<div style='border-style:solid;border-width:1px; border-color: #A1C868; width:300px; height:19px;' >";
