function do_backup()
{
if ($_POST['xsrf_token'] != $_SESSION['xsrf_token']) {
trigger_error('XSRF code incorrect', E_USER_ERROR);
}
// By David Walsh
$return = 'CREATE DATABASE `lhsmath-bak` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;' . "\n" . 'USE `lhsmath-bak`;' . "\n\n\n";
$tables = array();
$result = DB::queryRaw('SHOW TABLES');
while ($row = mysqli_fetch_row($result)) {
$tables[] = $row[0];
}
foreach ($tables as $table) {
$result = DB::queryRaw('SELECT * FROM ' . $table);
$num_fields = mysqli_num_fields($result);
$return .= 'DROP TABLE IF EXISTS ' . $table . ';';
$row2 = mysqli_fetch_row(DB::queryRaw('SHOW CREATE TABLE ' . $table));
$return .= "\n\n" . $row2[1] . ";\n\n";
for ($i = 0; $i < $num_fields; $i++) {
while ($row = mysqli_fetch_row($result)) {
$return .= 'INSERT INTO ' . $table . ' VALUES(';
for ($j = 0; $j < $num_fields; $j++) {
$row[$j] = addslashes($row[$j]);
$row[$j] = str_replace("\n", "\\n", $row[$j]);
if (isset($row[$j])) {
$return .= '"' . $row[$j] . '"';
} else {
$return .= '""';
}
if ($j < $num_fields - 1) {
$return .= ',';
}
}
$return .= ");\n";
}
}
$return .= "\n\n\n";
}
// LMT, also
global $DB_DATABASE, $LMT_DB_DATABASE;
DB::useDB($LMT_DB_DATABASE);
$return .= 'CREATE DATABASE `lmt-bak` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;' . "\n" . 'USE `lmt-bak`;' . "\n\n\n";
$tables = array();
$result = DB::queryRaw('SHOW TABLES');
while ($row = mysqli_fetch_row($result)) {
$tables[] = $row[0];
}
foreach ($tables as $table) {
$result = DB::queryRaw('SELECT * FROM ' . $table);
$num_fields = mysqli_num_fields($result);
$return .= 'DROP TABLE IF EXISTS ' . $table . ';';
$row2 = mysqli_fetch_row(DB::queryRaw('SHOW CREATE TABLE ' . $table));
$return .= "\n\n" . $row2[1] . ";\n\n";
for ($i = 0; $i < $num_fields; $i++) {
while ($row = mysqli_fetch_row($result)) {
$return .= 'INSERT INTO ' . $table . ' VALUES(';
for ($j = 0; $j < $num_fields; $j++) {
$row[$j] = addslashes($row[$j]);
$row[$j] = str_replace("\n", "\\n", $row[$j]);
if (isset($row[$j])) {
$return .= '"' . $row[$j] . '"';
} else {
$return .= '""';
}
if ($j < $num_fields - 1) {
$return .= ',';
}
}
$return .= ");\n";
}
}
$return .= "\n\n\n";
}
DB::useDB($DB_DATABASE);
// switch back database
//save file
$filename = 'db-backup-' . time() . '-' . generate_code(4) . '.sql';
file_put_contents($filename, $return);
$order = 1 + DB::queryFirstField('SELECT MAX(order_num) FROM files WHERE category=%i', $category_id);
$display_name = 'Database Backup: ' . date('Y-m-d');
DB::insert('files', array('name' => $display_name, 'filename' => $filename, 'permissions' => 'A', 'category' => '0', 'order_num' => $order));
alert('The file "' . $display_name . '" has been added', 1);
header('Location: Database');
}
require_once '../.lib/functions.php';
$being_included = false;
} else {
DB::useDB('lhsmath');
}
restrict_access('X');
// Will restrict to non-logged-in: redirects logged in users back home.
page_title('Log In');
if (isset($_POST['do_login'])) {
process_login_form();
} else {
show_login_form('');
}
global $DB_DATABASE;
//I don't know why we need this when in the global scope, but we do
DB::useDB($DB_DATABASE);
//Because it can be included from lmt pages, which uses db $LMT_DATABASE.
/*
* show_login_form($email)
*
* Shows the login page, keeping the email from the previous login attempt if specified.
*/
function show_login_form($email)
{
// Assemble the page, and send.
echo <<<HEREDOC
<h1>Log In</h1>
<form id="login" method="post" action="{$_SERVER['REQUEST_URI']}">
<table>
<tr>
<td>Email Address: </td>
<?php
/*
* .lib/lmt-functions.php
* LHS Math Club Website
*/
// include regular functions and all of its stuff
require_once __DIR__ . '/functions.php';
//class LMT_DB extends DB{}; LMT_DB::useDB('lmt');
DB::useDB('lmt');
// except use the LMT db
// include scoring
require_once PATH::lib() . '/lmt-scoring.php';
//
// DEFAULT ACTIONS:
//
// Replace the custom error handler with this one
function lmt_custom_errors($errno, $errstr, $errfile, $errline)
{
$rh = fopen(PATH::errfile(), 'a+');
fwrite($rh, date(DATE_RFC822) . ' Error [' . $errno . '] on line ' . $errline . ' in ' . $errfile . ': ' . $errstr . "\n");
fclose($rh);
global $miniature_page;
if (isset($miniature_page)) {
$miniature_page = '?Mini';
}
if (headers_sent()) {
echo '<meta http-equiv="refresh" content="0;url=' . URL::root() . '/LMT/Error' . $miniature_page . '">';
} else {
if (isset($_GET['xsrf_token'])) {
header('Location: ' . URL::root() . '/LMT/Error' . $miniature_page);
