pquery($sql_del, array('ftp_backup')); } $smarty = new vtigerCRM_Smarty; if($_REQUEST['error'] != '') { $smarty->assign("ERROR_MSG",''.vtlib_purify($_REQUEST["error"]).''); } if($_REQUEST['error1'] != '') { $smarty->assign("ERROR_STR",''.vtlib_purify($_REQUEST["error1"]).''); } $sql="select * from vtiger_systems where server_type = ?"; $result = $adb->pquery($sql, array('ftp_backup')); $server = $adb->query_result($result,0,'server'); $server_username = $adb->query_result($result,0,'server_username'); $server_password = $adb->query_result($result,0,'server_password'); $result = $adb->pquery($sql, array('local_backup')); $local_server = $adb->query_result($result,0,'server'); $server_path = $adb->query_result($result,0,'server_path'); if(isset($_REQUEST['bkp_server_mode']) && $_REQUEST['bkp_server_mode'] != '') $smarty->assign("BKP_SERVER_MODE",vtlib_purify($_REQUEST['bkp_server_mode'])); else $smarty->assign("BKP_SERVER_MODE",'view'); if(isset($_REQUEST['local_server_mode']) && $_REQUEST['local_server_mode'] != '') $smarty->assign("LOCAL_SERVER_MODE",vtlib_purify($_REQUEST['local_server_mode'])); else $smarty->assign("LOCAL_SERVER_MODE",'view'); if(isset($_REQUEST['server'])) $smarty->assign("FTPSERVER",vtlib_purify($_REQUEST['server'])); else if (isset($server)) $smarty->assign("FTPSERVER",$server); if (isset($_REQUEST['server_user'])) $smarty->assign("FTPUSER",vtlib_purify($_REQUEST['server_user'])); else if (isset($server_username)) $smarty->assign("FTPUSER",$server_username); if (isset($_REQUEST['password'])) $smarty->assign("FTPPASSWORD",vtlib_purify($_REQUEST['password'])); else if (isset($server_password)) $smarty->assign("FTPPASSWORD",$server_password); if (isset($_REQUEST['path'])) $smarty->assign("SERVER_BACKUP_PATH",vtlib_purify($_REQUEST['server_path'])); else if (isset($server_path)) $smarty->assign("SERVER_BACKUP_PATH",$server_path); $smarty->assign("MOD", return_module_language($current_language,'Settings')); $smarty->assign("IMAGE_PATH",$image_path); $smarty->assign("APP", $app_strings); $smarty->assign("THEME", $theme); $smarty->assign("CMOD", $mod_strings); require_once('user_privileges/enable_backup.php'); if($enable_local_backup == 'true') $local_backup_status = 'enabled'; else $local_backup_status = 'disabled'; if($enable_ftp_backup == 'true') $ftp_backup_status = 'enabled'; else $ftp_backup_status = 'disabled'; $smarty->assign("FTP_BACKUP_STATUS", $ftp_backup_status); $smarty->assign("LOCAL_BACKUP_STATUS", $local_backup_status); require_once('include/logging.php'); require_once('database/DatabaseConnection.php'); require_once('modules/Users/LoginHistory.php'); require_once('modules/Users/Users.php'); require_once('config.php'); require_once('include/db_backup/backup.php'); require_once('include/db_backup/ftp.php'); require_once('include/database/PearDatabase.php'); require_once('user_privileges/enable_backup.php'); global $adb, $enable_backup; if((isset($_REQUEST['backupnow']))) { define("dbserver", $dbconfig['db_hostname']); define("dbuser", $dbconfig['db_username']); define("dbpass", $dbconfig['db_password']); define("dbname", $dbconfig['db_name']); $path_query = $adb->pquery("SELECT * FROM vtiger_systems WHERE server_type = ?",array('local_backup')); $path = $adb->query_result($path_query,0,'server_path'); $currenttime=date("Ymd_His"); if(is_dir($path) && is_writable($path)) { require_once 'modules/VtigerBackup/VtigerBackup.php'; require_once 'include/db_backup/DatabaseBackup.php'; $backup = new VtigerBackup(); $backup->backup(); $fileName = $backup->getBackupFileName(); $smarty->assign("BACKUP_RESULT", ''. $fileName.''); } else $smarty->assign("BACKUP_RESULT", 'Failed to backup'); } if($_REQUEST['ajax'] == 'true' && $_REQUEST['server_type'] == 'ftp_backup') $smarty->display("Settings/BackupServerContents.tpl"); else $smarty->display("Settings/BackupServer.tpl"); ?>