// ... where we have *_id_seq if (!in_array($tablename, $TABLENAME_NOINDEX)) { $DB->Execute("SELECT setval('" . $tablename . "_id_seq',max(id)) FROM " . $tablename); } } break; } } if (isset($_GET['is_sure'])) { set_time_limit(0); if (!empty($_GET['gz'])) { $LMS->DatabaseCreate(TRUE, FALSE); } else { $LMS->DatabaseCreate(FALSE, FALSE); } $db = $_GET['db']; if (file_exists($CONFIG['directories']['backup_dir'] . '/iNET-lms-' . $db . '.sql')) { DBLoad($CONFIG['directories']['backup_dir'] . '/iNET-lms-' . $db . '.sql'); } elseif (extension_loaded('zlib') && file_exists($CONFIG['directories']['backup_dir'] . '/iNET-lms-' . $db . '.sql.gz')) { DBLoad($CONFIG['directories']['backup_dir'] . '/iNET-lms-' . $db . '.sql.gz'); } include MODULES_DIR . '/dblist.php'; // $SESSION->redirect('?m='.$SESSION->get('lastmodule')); } else { $layout['pagetitle'] = trans('Database Backup Recovery'); $SMARTY->display('header.html'); echo '<H1>' . trans('Database Backup Recovery') . '</H1>'; echo '<P>' . trans('Are you sure, you want to recover database created at $a?', date('Y/m/d H:i.s', $_GET['db'])) . '</P>'; echo '<A href="?m=dbrecover&db=' . $_GET['db'] . '&is_sure=1">' . trans('Yes, I am sure.') . '</A>'; $SMARTY->display('footer.html'); }
} } break; } if ($SYSLOG) { $SYSLOG->AddMessage(SYSLOG_RES_DBBACKUP, SYSLOG_OPER_DBBACKUPRECOVER, array('filename' => $filename), null); } } if (isset($_GET['is_sure'])) { set_time_limit(0); if (!empty($_GET['gz'])) { $LMS->DatabaseCreate(TRUE, FALSE); } else { $LMS->DatabaseCreate(FALSE, FALSE); } $db = $_GET['db']; if (file_exists(ConfigHelper::getConfig('directories.backup_dir') . '/lms-' . $db . '.sql')) { DBLoad(ConfigHelper::getConfig('directories.backup_dir') . '/lms-' . $db . '.sql'); } elseif (extension_loaded('zlib') && file_exists(ConfigHelper::getConfig('directories.backup_dir') . '/lms-' . $db . '.sql.gz')) { DBLoad(ConfigHelper::getConfig('directories.backup_dir') . '/lms-' . $db . '.sql.gz'); } include MODULES_DIR . '/dblist.php'; // $SESSION->redirect('?m='.$SESSION->get('lastmodule')); } else { $layout['pagetitle'] = trans('Database Backup Recovery'); $SMARTY->display('clearheader.html'); echo '<H1>' . trans('Database Backup Recovery') . '</H1>'; echo '<P>' . trans('Are you sure, you want to recover database created at $a?', date('Y/m/d H:i.s', $_GET['db'])) . '</P>'; echo '<A href="?m=dbrecover&db=' . $_GET['db'] . '&is_sure=1">' . trans('Yes, I am sure.') . '</A>'; $SMARTY->display('clearfooter.html'); }