<?php global $zdbh; /* * Calculate the home directory size for each 'active' user account on the server. */ $userssql = $zdbh->query("SELECT ac_id_pk, ac_user_vc FROM x_accounts WHERE ac_deleted_ts IS NULL"); echo fs_filehandler::NewLine() . "START Calculating disk Usage for all client accounts.." . fs_filehandler::NewLine(); while ($userdir = $userssql->fetch()) { $homedirectory = ctrl_options::GetSystemOption('hosted_dir') . $userdir['ac_user_vc']; if (fs_director::CheckFolderExists($homedirectory)) { $size = fs_director::GetDirectorySize($homedirectory); } else { $size = 0; } $currentuser = ctrl_users::GetUserDetail($userdir['ac_id_pk']); //$checksql = $zdbh->query("SELECT COUNT(*) AS total FROM x_bandwidth WHERE bd_month_in = " . date("Ym") . " AND bd_acc_fk = " . $userdir['ac_id_pk'] . "")->fetch(); $numrows = $zdbh->prepare("SELECT COUNT(*) AS total FROM x_bandwidth WHERE bd_month_in = :date AND bd_acc_fk = :ac_id_pk"); $date = date("Ym"); $numrows->bindParam(':date', $date); $numrows->bindParam(':ac_id_pk', $userdir['ac_id_pk']); $numrows->execute(); $checksql = $numrows->fetch(); if ($checksql['total'] == 0) { // $zdbh->query("INSERT INTO x_bandwidth (bd_acc_fk, bd_month_in, bd_transamount_bi, bd_diskamount_bi, bd_diskover_in, bd_diskcheck_in, bd_transover_in, bd_transcheck_in ) VALUES (" . $userdir['ac_id_pk'] . "," . date("Ym") . ",0,0,0,0,0,0);"); $numrows3 = $zdbh->prepare("INSERT INTO x_bandwidth (bd_acc_fk, bd_month_in, bd_transamount_bi, bd_diskamount_bi, bd_diskover_in, bd_diskcheck_in, bd_transover_in, bd_transcheck_in ) VALUES (:ac_id_pk,:date,0,0,0,0,0,0);"); //removed ;from end of statments $date = date("Ym"); $numrows3->bindParam(':date', $date); $numrows3->bindParam(':ac_id_pk', $userdir['ac_id_pk']); $numrows3->execute();