/**
* save display layout property value in system
* @static
* @param $listingTypeID
* @param $layoutID
* @return array|bool|int
*/
public static function setDisplayLayout($listingTypeID, $layoutID)
{
$name = SJB_DisplayFormFieldsBuilder::getDisplayLayoutNamePart($listingTypeID);
return SJB_Settings::saveSetting($name, $layoutID);
}
public function execute()
{
ini_set('max_execution_time', 0);
$errors = array();
$tp = SJB_System::getTemplateProcessor();
$action = SJB_Request::getVar('action', false);
$dir_separator = DIRECTORY_SEPARATOR;
$script_path = explode(SJB_System::getSystemSettings('SYSTEM_URL_BASE'), __FILE__);
$script_path = array_shift($script_path);
$identifier = SJB_Request::getVar('identifier', time());
$filename = SJB_Request::getVar('filename', false);
$settings = array();
if ($filename) {
SJB_Backup::sendArchiveFile($filename, $script_path . 'backup' . $dir_separator . $filename);
}
if (SJB_Request::getVar('action') == "save") {
$expPeriod = SJB_Request::getVar('backup_expired_period');
if (!empty($expPeriod) && (!is_numeric($expPeriod) || $expPeriod < 0)) {
$errors[] = 'EXP_PERIOD_NOT_VALID';
}
$ftpValid = $this->isFTPDataValid();
if (SJB_Request::getVar('autobackup', false) && SJB_Request::getVar('ftp_backup', false) && !$ftpValid) {
$errors[] = 'FTP_DETAILS_NOT_VALID';
}
if (empty($errors)) {
$backupSettings = $_REQUEST;
foreach ($backupSettings as $setting => $value) {
if (!SJB_Settings::saveSetting($setting, $value)) {
$errors['SETTINGS_SAVED_WITH_PROBLEMS'] = "SETTINGS_SAVED_WITH_PROBLEMS";
}
}
if (empty($errors)) {
$tp->assign('successSaveMessage', true);
}
} else {
$settings = $_REQUEST;
}
}
switch ($action) {
case 'backup':
if (SJB_System::getSystemSettings('isDemo')) {
$i18N = SJB_I18N::getInstance();
$str = $i18N->gettext('Backend', 'Error: You don\'t have permissions for it. This is a Demo version of the software.');
SJB_Session::setValue('error', $str);
break;
}
if (SJB_System::getIfTrialModeIsOn() && $_SERVER['REMOTE_ADDR'] != "91.205.51.231") {
$i18N = SJB_I18N::getInstance();
$str = $i18N->gettext('Backend', 'Error: You don\'t have permissions for it. This is a Trial version of the software.');
SJB_Session::setValue('error', $str);
break;
}
SessionStorage::destroy('backup_' . $identifier);
SessionStorage::write('backup_' . $identifier, serialize(array('last_time' => time())));
SJB_Session::unsetValue('restore');
SJB_Session::unsetValue('error');
$backup_type = SJB_Request::getVar('backup_type');
$backupDir = $script_path . 'backup' . $dir_separator;
try {
$this->prepareBackupDir($backupDir);
} catch (Exception $e) {
SJB_Session::setValue('error', $e->getMessage());
exit;
}
switch ($backup_type) {
case 'full':
SessionStorage::write('backup_' . $identifier, serialize(array('last_time' => time())));
$backupDir = $script_path;
$name = 'db.sql';
SJB_Backup::dump($name, $script_path, $identifier);
$d = dir($script_path);
$contentDir = array();
$folders = array('.', '..', 'backup', '.svn', '.settings', '.cache', 'restore', $name);
while (false !== ($entry = $d->read())) {
if (!in_array($entry, $folders)) {
$contentDir[] = $entry;
}
}
$listFilesAndFolders = !empty($contentDir) ? $contentDir : false;
$backupName = 'full_backup_' . date('Y_m_d__H_i') . '.tar.gz';
$export_files_dir_name = '..' . $dir_separator;
if (SJB_Backup::archive($name, $listFilesAndFolders, $backupDir, $export_files_dir_name, $backupName, true, $identifier, 'full')) {
SessionStorage::write('backup_' . $identifier, serialize(array('name' => $backupName)));
}
exit;
break;
case 'database':
SessionStorage::write('backup_' . $identifier, serialize(array('last_time' => time())));
$name = 'db.sql';
$backupName = 'mysqldump_' . date('Y_m_d__H_i') . '.tar.gz';
$export_files_dir_name = '../backup' . $dir_separator;
SJB_Backup::dump($name, $script_path, $identifier);
if (SJB_Backup::archive(false, $name, $script_path, $export_files_dir_name, $backupName, false, $identifier, 'database')) {
SessionStorage::write('backup_' . $identifier, serialize(array('name' => $backupName)));
}
exit;
break;
case 'files':
SessionStorage::write('backup_' . $identifier, serialize(array('last_time' => time())));
$backupDir = $script_path;
$d = dir($script_path);
$contentDir = array();
$folders = array('.', '..', 'backup', '.svn', '.settings', '.cache', 'restore');
while (false !== ($entry = $d->read())) {
if (!in_array($entry, $folders)) {
$contentDir[] = $entry;
}
}
$listFilesAndFolders = !empty($contentDir) ? $contentDir : false;
$backupName = 'backup_' . date('Y_m_d__H_i') . '.tar.gz';
$export_files_dir_name = '..' . $dir_separator;
if (SJB_Backup::archive(false, $listFilesAndFolders, $backupDir, $export_files_dir_name, $backupName, true, $identifier, 'files')) {
SessionStorage::write('backup_' . $identifier, serialize(array('name' => $backupName)));
}
exit;
break;
}
break;
case 'restore':
if (SJB_System::getSystemSettings('isDemo')) {
SJB_Session::setValue('error', 'Error: You don\'t have permissions for it. This is a Demo version of the software.');
exit;
}
if (SJB_System::getIfTrialModeIsOn()) {
SJB_Session::setValue('error', 'Error: You don\'t have permissions for it. This is a Trial version of the software.');
exit;
}
SJB_Session::unsetValue('restore');
SJB_Session::unsetValue('error');
$error = false;
$restoreDir = $script_path . 'restore' . $dir_separator;
try {
$fileName = $this->moveUploadedFile($restoreDir);
$tar = new Archive_Tar($restoreDir . $fileName, 'gz');
$tar->_error_class = 'SJB_PEAR_Exception';
$tar->extractList('db.sql', $restoreDir);
$tar->extract($script_path);
if (is_file($restoreDir . 'db.sql')) {
SJB_Backup::restore_base_tables($restoreDir . 'db.sql');
}
SJB_Cache::getInstance()->clean();
} catch (Exception $ex) {
$error = $ex->getMessage();
}
SJB_Filesystem::delete($restoreDir);
if (is_file($script_path . 'install.php')) {
SJB_Filesystem::delete($script_path . 'install.php');
}
if ($error) {
SJB_Session::setValue('error', $error);
} else {
SJB_Session::setValue('restore', 1);
}
exit;
break;
case 'send_archive':
$name = SJB_Request::getVar('name', false);
$archive_file_path = SJB_Path::combine(SJB_BASE_DIR . 'backup' . $dir_separator, $name);
if ($name) {
SJB_Backup::sendArchiveFile($name, $archive_file_path);
}
break;
case 'check':
$sessionBackup = SessionStorage::read('backup_' . $identifier);
$sessionBackup = $sessionBackup ? unserialize($sessionBackup) : array();
$sessionRestore = SJB_Session::getValue('restore');
$sessionError = SJB_Session::getValue('error');
if (!empty($sessionBackup['name'])) {
$name = $sessionBackup['name'];
SessionStorage::destroy('backup_' . $identifier);
echo SJB_System::getSystemSettings('SITE_URL') . "/backup/?action=send_archive&name={$name}";
exit;
} elseif (!empty($sessionRestore)) {
SJB_Session::unsetValue('restore');
echo SJB_System::getSystemSettings('SITE_URL') . '/backup/#restore';
exit;
} elseif (!empty($sessionError)) {
echo 'Error';
if (SJB_System::getSystemSettings('isDemo')) {
echo ': You don\'t have permissions for it. This is a Demo version of the software.';
}
if (SJB_System::getIfTrialModeIsOn()) {
echo ': You don\'t have permissions for it. This is a Trial version of the software.';
}
exit;
} elseif (!empty($sessionBackup['last_time'])) {
$period = (time() - $sessionBackup['last_time']) / 60;
if ($period < 5) {
echo 1;
} else {
SJB_Session::setValue('error', 'The backup generation process was unexpectedly interrupted. Please try again.');
echo 'error';
}
exit;
} else {
echo 1;
}
exit;
break;
case 'delete_backup':
$name = SJB_Request::getVar('name', false);
if ($name) {
$backup = $script_path . 'backup' . $dir_separator . $name;
if (is_file($backup)) {
SJB_Filesystem::delete($backup);
SJB_Autobackup::deleteFileFromFtp($name);
} else {
$errors['FILE_NOT_FOUND'] = 1;
}
}
$tp->assign('errors', $errors);
$tp->assign('delBackup', 1);
case 'created_backups':
$path = $script_path . 'backup' . $dir_separator;
if (is_dir($path)) {
$di = new DirectoryIterator($path);
$backupsArr = array();
foreach ($di as $file) {
$fileName = $file->getFilename();
if (!$file->isDir() && !$file->isLink() && $fileName != '.htaccess') {
$cTime = $file->getCTime();
$backupsArr[$cTime]['name'] = $fileName;
if (preg_match('/mysqldump/', $fileName)) {
$backupsArr[$cTime]['type'] = 'Site database only';
} elseif (preg_match('/full_backup/', $fileName)) {
$backupsArr[$cTime]['type'] = 'Full site backup';
} elseif (preg_match('/backup/', $fileName)) {
$backupsArr[$cTime]['type'] = 'Site files only';
} else {
$backupsArr[$cTime]['type'] = 'Unknown';
}
$pattern = '/(\\w+)_(\\d+)_(\\d+)_(\\d+)__(\\d+)_(\\d+).tar.gz/i';
$replacement = '$2-$3-$4 $5:$6';
$backupsArr[$cTime]['date'] = preg_replace($pattern, $replacement, $fileName);
}
}
krsort($backupsArr);
$tp->assign('created_backups', $backupsArr);
}
$tp->display('created_backups.tpl');
exit;
break;
case 'error':
$sessionError = SJB_Session::getValue('error');
if (!is_null($sessionError)) {
echo '<p class="error">' . $sessionError . '</p>';
exit;
}
break;
}
if (empty($settings)) {
$settings = SJB_Settings::getSettings();
}
$tp->assign('errors', $errors);
$tp->assign('settings', $settings);
$tp->assign('identifier', $identifier);
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->display('backup.tpl');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$restore = SJB_Request::getVar('restore', false);
$action = SJB_Request::getVar('action_name', 'view_log');
$action = $action == 'search' ? 'view_log' : $action;
$paginator = new SJB_EmailLogPagination();
$display_error = SJB_Request::getVar('display_error', false);
$savedErrors = SJB_Session::getValue(self::EMAIL_ERRORS);
SJB_Session::unsetValue(self::EMAIL_ERRORS);
$this->errors = $savedErrors ? $savedErrors : array();
$message = SJB_Session::getValue(self::EMAIL_LOG_MESSAGE);
SJB_Session::unsetValue(self::EMAIL_LOG_MESSAGE);
switch ($action) {
case 'display_message':
$sid = SJB_Request::getVar('sid', false);
$email = SJB_EmailLogManager::getEmailInfoBySID($sid);
$tp->assign('display_error', $display_error);
$tp->assign('email', $email);
$tp->display('display_log_message.tpl');
return true;
break;
case 'resend':
try {
SJB_Settings::saveSetting(self::DO_NOT_SHOW_ATTACHMENT_NOTIFICATION, SJB_Request::getVar(self::DO_NOT_SHOW_ATTACHMENT_NOTIFICATION));
$this->resendEmails();
SJB_Session::setValue(self::EMAIL_LOG_MESSAGE, 'The message(s) were successfully resent.');
} catch (Exception $e) {
array_push($this->errors, $e->getMessage());
}
SJB_Session::setValue(self::EMAIL_ERRORS, $this->errors);
$searchFields = SJB_Request::getVar('searchFields');
SJB_HelperFunctions::redirect(SJB_HelperFunctions::getSiteUrl() . '/email-log/?sorting_field=' . $paginator->sortingField . '&sorting_order=' . $paginator->sortingOrder . '&items_per_page=' . $paginator->itemsPerPage . $searchFields);
break;
case 'view_log':
$userSID = SJB_Request::getVar('user_sid', false);
if ($userSID) {
$template = 'user_email_log.tpl';
$_REQUEST['username']['equal'] = $userSID;
$userInfo = SJB_UserManager::getUserInfoBySID($userSID);
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($userInfo['user_group_sid']);
$tp->assign('userGroupInfo', $userGroupInfo);
$tp->assign('display_error', $display_error);
$tp->assign('user_info', $userInfo);
$tp->assign('user_sid', $userSID);
}
$email = new SJB_EmailLog($_REQUEST);
$search_form_builder = new SJB_SearchFormBuilder($email);
$criteria_saver = new SJB_EmailLogCriteriaSaver();
if ($restore) {
$_REQUEST = array_merge($_REQUEST, $criteria_saver->getCriteria());
}
$criteria = $search_form_builder->extractCriteriaFromRequestData($_REQUEST, $email);
if (!$userSID) {
$template = 'email_log.tpl';
$search_form_builder->setCriteria($criteria);
$search_form_builder->registerTags($tp);
$tp->display("email_log_search_form.tpl");
}
$order_info = array('sorting_field' => $paginator->sortingField, 'sorting_order' => $paginator->sortingOrder);
$criteria_saver->setSessionForOrderInfo($order_info);
$criteria_saver->setSessionForCurrentPage($paginator->currentPage);
$criteria_saver->setSessionForListingsPerPage($paginator->itemsPerPage);
$searcher = new SJB_EmailLogSearcher(array('limit' => ($paginator->currentPage - 1) * $paginator->itemsPerPage, 'num_rows' => $paginator->itemsPerPage), $paginator->sortingField, $paginator->sortingOrder);
$found_emails = $searcher->getObjectsSIDsByCriteria($criteria);
$criteria_saver->setSession($_REQUEST, $searcher->getFoundObjectSIDs());
foreach ($found_emails as $id => $emailSID) {
$emailInfo = SJB_EmailLogManager::getEmailInfoBySID($emailSID);
$found_emails[$id] = $emailInfo;
$found_emails[$id]['user'] = !empty($emailInfo['username']) ? SJB_UserManager::getUserInfoBySID($emailInfo['username']) : array();
$found_emails[$id]['admin'] = array();
if (!empty($emailInfo['admin'])) {
if (is_numeric($emailInfo['admin'])) {
$found_emails[$id]['admin'] = SJB_SubAdminManager::getSubAdminInfoBySID($emailInfo['admin']);
} else {
$found_emails[$id]['admin']['username'] = '******';
}
}
}
$paginator->setItemsCount($searcher->getAffectedRows());
$searchFields = '';
foreach ($_REQUEST as $key => $val) {
if (is_array($val)) {
foreach ($val as $fieldName => $fieldValue) {
$searchFields .= "&{$key}[{$fieldName}]={$fieldValue}";
}
}
}
$tp->assign(self::DO_NOT_SHOW_ATTACHMENT_NOTIFICATION, SJB_Settings::getSettingByName(self::DO_NOT_SHOW_ATTACHMENT_NOTIFICATION));
$tp->assign('message', $message);
$tp->assign('errors', $this->errors);
$tp->assign("searchFields", $searchFields);
$tp->assign('paginationInfo', $paginator->getPaginationInfo());
$tp->assign("found_emails", $found_emails);
$tp->display($template);
break;
}
}
