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") {