4 require_once(
"/usr/share/alternc/panel/class/config_nochk.php");
8 echo
"\n---------------------------\n Generating size-cache for web accounts\n\n";
9 exec(
"/usr/lib/alternc/quota_get_all", $list_quota_tmp);
11 foreach ($list_quota_tmp as $qt) {
12 $qt = explode(
" ", $qt);
13 $list_quota[$qt[0]] = array(
'used'=>$qt[1],
'quota'=>$qt[2]);
16 if (
$db->query(
"SELECT uid,login FROM membres;")) {
18 while (
$db->next_record()) {
25 $size=exec(
"/usr/bin/du -s /var/www/alternc/".substr(
$login,0,1).
"/".
$login);
27 $db2->query(
"REPLACE INTO size_web SET uid=?, size=?;",array(intval(
$db->f(
'uid')),intval($size)));
28 echo
$db->f(
'login').
" (".(round($size/1024, 1)).
" MB)\n";
32 echo
"\n---------------------------\n Generating size-cache for MySQL databases\n\n";
34 $r=
$db->query(
"select * from db_servers;");
36 while (
$db->next_record()) {
39 $db->query(
"DELETE FROM size_db;");
42 $tab=$mysql->get_dbus_size(
$c[
"name"],
$c[
"host"],
$c[
"login"],
$c[
"password"],
$c[
"client"]);
43 echo
"++ Processing ".$c[
"name"].
" ++\n";
44 foreach (
$tab as $dbname=>$size) {
45 $db->query(
"REPLACE INTO size_db SET db=?,size=?;",array($dbname,$size));
46 echo
" $dbname done (".(round(($size/1024)/1024,1)).
" MB) \n"; flush();
51 echo
"---------------------------\n Generating size-cache for mailman\n\n";
52 if (
$db->query(
"SELECT uid, name FROM mailman;")) {
56 while (
$db->next_record()) {
57 $cc[]=array(
"uid" =>
$db->f(
"uid"),
"name" =>
$db->f(
"name"));
60 echo
$c[
"uid"].
"/".
$c[
"name"]; flush();
61 $size1=exec(
"sudo /usr/bin/du -s ".escapeshellarg(
"/var/lib/mailman/lists/".
$c[
"name"]));
62 $size2=exec(
"sudo /usr/bin/du -s ".escapeshellarg(
"/var/lib/mailman/archives/private/".
$c[
"name"]));
63 $size3=exec(
"sudo /usr/bin/du -s ".escapeshellarg(
"/var/lib/mailman/archives/private/".
$c[
"name"].
".mbox"));
64 $size=(intval($size1)+intval($size2)+intval($size3));
65 $db->query(
"REPLACE INTO size_mailman SET uid=?,list=?,size=?;",array(
$c[
"uid"],
$c[
"name"],$size));
66 echo
" done (".(round($size/1024, 1)).
" MB) \n"; flush();
Class for MySQL management in the panel.