// ... 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');
}
