pquery($query, array('ftp_backup')); $rowCount = $db->num_rows($result); if($rowCount > 0) { $details['server'] = $db->query_result($result,0,'server'); $details['username'] = $db->query_result($result,0,'server_username'); $details['password'] = $db->query_result($result,0,'server_password'); return $details; } return null; } public static function doFTPBackup($source,$details) { //TODO wirte a cleaner ftp handle ftpBackupFile($source, $details['server'], $details['username'], $details['password']); if(file_exists($source)){ unlink($source); } } public static function getLocalBackupPath() { $db = PearDatabase::getInstance(); $path_query = $db->pquery("SELECT * FROM vtiger_systems WHERE server_type = ?", array('local_backup')); $path = $db->query_result($path_query,0,'server_path'); return $path; } } ?>