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"; } }
* @copyright 2014-2015 Sentora Project (http://www.sentora.org/) * Sentora is a GPL fork of the ZPanel Project whose original header follows: * * Initiates the database driver object and debug object and registers the $zdhb and $zlo globals for the framework. * @package zpanelx * @subpackage core * @author Bobby Allen (ballen@bobbyallen.me) * @copyright ZPanel Project (http://www.zpanelcp.com/) * @link http://www.zpanelcp.com/ * @license GPL (http://www.gnu.org/licenses/gpl.html) */ /** * @global debug_logger $zlo */ global $zlo; /** * @global db_driver $zdbh */ global $zdbh; $zlo = new debug_logger(); try { $zdbh = new db_driver("mysql:host={$host};dbname={$dbname}", $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'")); $zdbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { $zlo->method = "text"; $zlo->logcode = "0100"; $zlo->detail = "Unable to connect or authenticate against the database supplied!"; $zlo->mextra = $e; $error_html = "<style type=\"text/css\"><!--\n .dbwarning {\n font-family: Verdana, Geneva, sans-serif;\n font-size: 14px;\n color: #C00;\n background-color: #FCC;\n padding: 30px;\n border: 1px solid #C00;\n }\n p {\n font-size: 12px;\n color: #666;\n }\n </style>\n <div class=\"dbwarning\"><strong>Critical Error:</strong> [0100] - Unable to connect or authenticate to the Sentora database (<em>{$dbname}</em>).<p>We advice that you contact the server administrator to ensure that the database server is online and that the correct connection parameters are being used.</p></div>"; die($error_html); }