#!/usr/bin/php -q
<?php
require_once "/usr/share/alternc/panel/class/config_nochk.php";
global $db;
echo "\n---------------------------\n Generating size-cache for web accounts\n\n";
exec("/usr/lib/alternc/quota_get_all", $list_quota_tmp);
$list_quota = array();
foreach ($list_quota_tmp as $qt) {
$qt = explode(" ", $qt);
$list_quota[$qt[0]] = array('used' => $qt[1], 'quota' => $qt[2]);
}
if ($db->query("SELECT uid,login FROM membres;")) {
$db2 = new DB_system();
while ($db->next_record()) {
if (isset($list_quota[$db->f('uid')])) {
$qu = $list_quota[$db->f('uid')];
$db2->query("INSERT OR REPLACE INTO size_web SET uid='" . intval($db->f('uid')) . "',size='" . intval($qu['used']) . "';");
echo $db->f('login') . " (" . $qu['used'] . " B)\n";
}
}
}
echo "\n---------------------------\n Generating size-cache for MySQL databases\n\n";
// We get all hosts on which sql users' DB are
$r = mysql_query("select * from db_servers;");
$tab = array();
while ($c = mysql_fetch_array($r)) {
$tab = $mysql->get_dbus_size($c["name"], $c["host"], $c["login"], $c["password"], $c["client"]);
echo "++ Processing " . $c["name"] . " ++\n";
foreach ($tab as $dbname => $size) {
$db->query("REPLACE INTO size_db SET db='" . $dbname . "',size='{$size}';");
echo " {$dbname} done ({$size} B) \n";
$queryList = array("mysql -u {$user} --password='******' -e 'DROP DATABASE IF EXISTS {$database} '", "mysql -u {$user} --password='******' -e 'CREATE DATABASE {$database}'", "mysql -u {$user} --password='******' {$database} < " . __DIR__ . "/../install/mysql.sql");
foreach ($queryList as $exec_command) {
exec($exec_command, $output, $return_var);
if ($return_var) {
throw new \Exception("[!] Mysql exec error : {$exec_command} \n Error : \n " . print_r($output, true));
}
}
echo "*** In progress: mysql.sql imported\n";
global $db;
global $cuid;
global $variables;
global $err;
global $mem;
global $admin;
global $mysql;
global $ftp;
global $quota;
global $db;
$db = new \DB_system($user, $database, $password);
$db->connect();
$cuid = 0;
$variables = new \m_variables();
$mem = new \m_mem();
$err = new \m_err();
$authip = new \m_authip();
$hooks = new \m_hooks();
$bro = new \m_bro();
$admin = new \m_admin();
$mysql = new \m_mysql();
$ftp = new \m_ftp();
$quota = new \m_quota();