function CalculateAllDatabaseSize()
{
global $zdbh;
include 'cnf/db.php';
$z_db_user = $user;
$z_db_pass = $pass;
$mysqlsql = $zdbh->query("SELECT my_id_pk, my_name_vc FROM x_mysql_databases WHERE my_deleted_ts IS NULL");
while ($database = $mysqlsql->fetch()) {
$currentdb = new db_driver("mysql:host={$host};dbname=" . $database['my_name_vc'] . "", $z_db_user, $z_db_pass);
$currentdb->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbsize = $currentdb->query("SHOW TABLE STATUS");
$dbgetsize = 0;
while ($row = $dbsize->fetch()) {
$dbgetsize = $dbgetsize + ($row['Data_length'] + $row['Index_length']);
}
//$zdbh->query("UPDATE x_mysql_databases SET my_usedspace_bi = '" . $dbgetsize . "' WHERE my_id_pk =" . $database['my_id_pk'] . "");
$numrows = $zdbh->prepare("UPDATE x_mysql_databases SET my_usedspace_bi = :dbgetsize WHERE my_id_pk =:my_id_pk");
$numrows->bindParam(':dbgetsize', $dbgetsize);
$numrows->bindParam(':my_id_pk', $database['my_id_pk']);
$numrows->execute();
//echo "Database found: " . $database['my_name_vc'] . " - " . $dbgetsize . " \n";
}
}
$z_db_host = $host;
$z_db_name = $dbname;
try {
$zdbh = new db_driver("mysql:host=" . $z_db_host . ";dbname=" . $z_db_name . "", $z_db_user, $z_db_pass);
} catch (PDOException $e) {
}
echo fs_filehandler::NewLine() . "START Backup Config." . fs_filehandler::NewLine();
if (ui_module::CheckModuleEnabled('Backup Config')) {
echo "Backup Config module ENABLED..." . fs_filehandler::NewLine();
// Schedule daily backups are enabled...
if (strtolower(ctrl_options::GetSystemOption('schedule_bu')) == "true") {
runtime_hook::Execute('OnBeforeScheduleBackup');
echo "Backup Scheduling enabled - Backing up all enabled client files now..." . fs_filehandler::NewLine();
// Get all accounts
$bsql = "SELECT * FROM x_accounts WHERE ac_enabled_in=1 AND ac_deleted_ts IS NULL";
$numrows = $zdbh->query($bsql);
if ($numrows->fetchColumn() != 0) {
$bsql = $zdbh->prepare($bsql);
$bsql->execute();
while ($rowclients = $bsql->fetch()) {
echo "Backing up client folder: " . $rowclients['ac_user_vc'] . "/public_html..." . fs_filehandler::NewLine();
// User loop
$username = $rowclients['ac_user_vc'];
$userid = $rowclients['ac_id_pk'];
$homedir = ctrl_options::GetSystemOption('hosted_dir') . $username;
//$backupname = $username . "_" . date("M-d-Y_hms", time());
$backupname = $username . "_" . date("M-d-Y_His", time());
// fixes incorrect time stamp
$dbstamp = date("dmy_Gi", time());
// We now see what the OS is before we work out what compression command to use..
if (sys_versions::ShowOSPlatformVersion() == "Windows") {
