auth->check_module_permissions('sites'); $app->load('listform_actions','functions'); class list_action extends listform_actions { public function prepareDataRow($rec) { global $app; $app->uses('functions'); $rec = parent::prepareDataRow($rec); $rec['active'] = "
Yes
"; if ($rec['backup_interval'] === 'none') { $rec['active'] = "
No
"; $rec['backup_copies'] = 0; } $recBackup = $app->db->queryOneRecord('SELECT COUNT(backup_id) AS backup_count FROM mail_backup WHERE mailuser_id = ?', $rec['mailuser_id']); $rec['backup_copies_exists'] = $recBackup['backup_count']; unset($recBackup); $recBackup = $app->db->queryOneRecord('SELECT SUM(filesize) AS backup_size FROM mail_backup WHERE mailuser_id = ?', $rec['mailuser_id']); $rec['backup_size'] = $app->functions->formatBytes($recBackup['backup_size']); return $rec; } } $list = new list_action; $list->SQLExtWhere = ""; $list->onLoad();