private function suspendUser($client)
{
// todo optimize suspension
// todo add change billing
if (!function_exists('serversuspendaccount')) {
require_once $this->root . 'includes/modulefunctions.php';
}
$result = serversuspendaccount($client['service_id']);
}
function hook_onappusers_AutoSuspend()
{
global $CONFIG;
if ($CONFIG['AutoSuspension'] != 'on') {
return;
}
$qry = 'SELECT
tblhosting.`id`
FROM
tblinvoices
LEFT JOIN tblinvoiceitems ON
tblinvoiceitems.`invoiceid` = tblinvoices.`id`
LEFT JOIN tblhosting ON
tblhosting.`id` = tblinvoiceitems.`relid`
WHERE
tblinvoices.`status` = "Unpaid"
AND tblinvoiceitems.`type` = "onappusers"
AND tblhosting.`domainstatus` = "Active"
AND NOW() > DATE_ADD( tblinvoices.`duedate`, INTERVAL :days DAY )
AND tblhosting.`overideautosuspend` != "on"
GROUP BY
tblhosting.`id`';
$qry = str_replace(':days', $CONFIG['AutoSuspensionDays'], $qry);
$result = full_query($qry);
$path = dirname(dirname(dirname(__DIR__))) . '/includes/';
if (!function_exists('serversuspendaccount')) {
require_once $path . 'modulefunctions.php';
}
while ($data = mysql_fetch_assoc($result)) {
serversuspendaccount($data['id']);
}
}
