public function getBackupList($offset = null, $limit = null) { $db = PearDatabase::getInstance(); $query = 'SELECT * FROM vtiger_backup ORDER BY endtime DESC'; if ($offset !== null) { $query .= " LIMIT {$offset}, {$limit}"; } $result = $db->query($query); $return = []; $moduleName = 'Settings::BackUp'; for ($i = 0; $i < $db->num_rows($result); $i++) { $return[] = ['id' => $db->query_result_raw($result, $i, 'id'), 'starttime' => $db->query_result_raw($result, $i, 'starttime'), 'endtime' => $db->query_result_raw($result, $i, 'endtime') != null ? $db->query_result_raw($result, $i, 'endtime') : '', 'filename' => $db->query_result_raw($result, $i, 'filename') . '.zip', 'status' => vtranslate(self::getStatusName($db->query_result_raw($result, $i, 'status')), $moduleName), 'backuptime' => Settings_BackUp_Module_Model::formatBackupTime($db->query_result_raw($result, $i, 'backuptime'))]; } return $return; }