root/admin/admin_db_utilities.php

<?php
/***************************************************************************</span>
<span class="code-comment">*                             admin_db_utilities.php
*                              -------------------
*     begin                : Thu May 31, 2001
*     copyright            : (C) 2001 The phpBB Group
*     email                : support@phpbb.com
*
*     $Id: admin_db_utilities.php,v 1.42.2.11 2005/02/21 18:36:49 acydburn Exp $
*
****************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

/***************************************************************************
*        We will attempt to create a file based backup of all of the data in the
*        users phpBB database.  The resulting file should be able to be imported by
*        the db_restore.php function, or by using the mysql command_line
*
*        Some functions are adapted from the upgrade_20.php script and others
*        adapted from the unoficial phpMyAdmin 2.2.0.
***************************************************************************/

if( !empty($setmodules) )</span>
<span class="code-keyword">{
        $filename = basename(__FILE__);
        $module['general']['backup_db'] = $filename . "?perform=backup";

        $file_uploads = (@phpversion() >= '4.0.0') ? @ini_get('file_uploads') : @get_cfg_var('file_uploads');

        if( (empty($file_uploads) || $file_uploads != 0) && (strtolower($file_uploads) != 'off') && (@phpversion() != '4.0.4pl1') )
        {
                $module['general']['restore_db'] = $filename . "?perform=restore";
        }

        return;
}

define('IN_PHPBB', 1);

//</span>
<span class="code-comment">// Load default header
//
$no_page_header = TRUE;
$root_path = './../';</span>
<span class="code-lang">require($root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
include($root_path . 'phpBB2/includes/sql_parse.'.$phpEx);

//</span>
<span class="code-comment">// Increase maximum execution time, but don't complain about it if it isn't
// allowed.
//
@set_time_limit(0);

// -----------------------</span>
<span class="code-comment">// The following functions are adapted from phpMyAdmin and upgrade_20.php
//
function gzip_PrintFourChars($Val)</span>
<span class="code-keyword">{
    $return = '';
        for ($i = 0; $i < 4; $i ++)
        {
                $return .= chr($Val % 256);
                $Val = floor($Val / 256);
        }
        return $return;
}



/**</span>
<span class="code-comment">* @package acp
*/
class base_extractor
{</span>
<span class="code-keyword">    var $fh;
    var $fp;
    var $write;
    var $close;
    var $store;
    var $download;
    var $time;
    var $format;
    var $run_comp = false;

    function base_extractor($download = false, $store = false, $format, $filename, $time)
    {
        $this->download = $download;
        $this->store = $store;
        $this->time = $time;
        $this->format = $format;

        switch ($format)
        {
            case 'text':
                $ext = '.sql';
                $open = 'fopen';
                $this->write = 'fwrite';
                $this->close = 'fclose';
                $mimetype = 'text/x-sql';
            break;
            case 'bzip2':
                $ext = '.sql.bz2';
                $open = 'bzopen';
                $this->write = 'bzwrite';
                $this->close = 'bzclose';
                $mimetype = 'application/x-bzip2';
            break;
            case 'gzip':
                $ext = '.sql.gz';
                $open = 'gzopen';
                $this->write = 'gzwrite';
                $this->close = 'gzclose';
                $mimetype = 'application/x-gzip';
            break;
        }

        if ($download == true)
        {
            $name = $filename . $ext;
            header('Pragma: no-cache');
            header("Content-Type: $mimetype; name=\"$name\"");
            header("Content-disposition: attachment; filename=$name");

            switch ($format)
            {
                case 'bzip2':
                    ob_start();
                break;

                case 'gzip':
                    if ((isset($_SERVER['HTTP_ACCEPT_ENCODING']) && strpos($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip') !== false) && strpos(strtolower($_SERVER['HTTP_USER_AGENT']), 'msie') === false)
                    {
                        ob_start('ob_gzhandler');
                    }
                    else
                    {
                        $this->run_comp = true;
                    }
                break;
            }
        }

        if ($store == true)
        {
            global $root_path;
            $file = $root_path . 'cache/' . $filename . $ext;

            $this->fp = $open($file, 'w');

            if (!$this->fp)
            {
                trigger_error('Unable to write temporary file to storage folder', E_USER_ERROR);
            }
        }
    }

    function write_end()
    {
        static $close;
        if ($this->store)
        {
            if ($close === null)
            {
                $close = $this->close;
            }
            $close($this->fp);
        }

        // bzip2 must be written all the way at the end
        if ($this->download && $this->format === 'bzip2')
        {
            $c = ob_get_clean();
            echo bzcompress($c);
        }
    }

    function flush($data)
    {
        static $write;
        if ($this->store === true)
        {
            if ($write === null)
            {
                $write = $this->write;
            }
            $write($this->fp, $data);
        }

        if ($this->download === true)
        {
            if ($this->format === 'bzip2' || $this->format === 'text' || ($this->format === 'gzip' && !$this->run_comp))
            {
                echo $data;
            }

            // we can write the gzip data as soon as we get it
            if ($this->format === 'gzip')
            {
                if ($this->run_comp)
                {
                    echo gzencode($data);
                }
                else
                {
                    ob_flush();
                    flush();
                }
            }
        }
    }
}

/**</span>
<span class="code-comment">* @package acp
*/
class mysql_extractor extends base_extractor
{</span>
<span class="code-keyword">    function write_start($table_prefix)
    {
        $sql_data = "#\n";
        $sql_data .= "# TBDevSZ Backup Script\n";
        $sql_data .= "# Dump of tables for $table_prefix\n";
        $sql_data .= "# DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";
        $sql_data .= "#\n";
        $this->flush($sql_data);
    }

    function write_table($table_name)
    {
        global $db;
        static $new_extract;

        if ($new_extract === null)
        {
            if ($db->sql_layer === 'mysqli' || version_compare($db->mysql_version, '3.23.20', '>='))
            {
                $new_extract = true;
            }
            else
            {
                $new_extract = false;
            }
        }

        if ($new_extract)
        {
            $this->new_write_table($table_name);
        }
        else
        {
            $this->old_write_table($table_name);
        }
    }

    function write_data($table_name)
    {
        global $db;
        if ($db->sql_layer === 'mysqli')
        {
            $this->write_data_mysqli($table_name);
        }
        else
        {
            $this->write_data_mysql($table_name);
        }
    }

    function write_data_mysqli($table_name)
    {
        global $db;
        $sql = "SELECT *
            FROM $table_name";
        $result = mysqli_query($db->db_connect_id, $sql, MYSQLI_USE_RESULT);
        if ($result != false)
        {
            $fields_cnt = mysqli_num_fields($result);

            // Get field information
            $field = mysqli_fetch_fields($result);
            $field_set = array();

            for ($j = 0; $j < $fields_cnt; $j++)
            {
                $field_set[] = $field[$j]->name;
            }

            $search            = array("\\", "'", "\x00", "\x0a", "\x0d", "\x1a", '"');
            $replace        = array("\\\\", "\\'", '\0', '\n', '\r', '\Z', '\\"');
            $fields            = implode(', ', $field_set);
            $sql_data        = 'INSERT INTO ' . $table_name . ' (' . $fields . ') VALUES ';
            $first_set        = true;
            $query_len        = 0;
            $max_len        = get_usable_memory();

            while ($row = mysqli_fetch_row($result))
            {
                $values    = array();
                if ($first_set)
                {
                    $query = $sql_data . '(';
                }
                else
                {
                    $query  .= ',(';
                }

                for ($j = 0; $j < $fields_cnt; $j++)
                {
                    if (!isset($row[$j]) || is_null($row[$j]))
                    {
                        $values[$j] = 'NULL';
                    }
                    else if (($field[$j]->flags & 32768) && !($field[$j]->flags & 1024))
                    {
                        $values[$j] = $row[$j];
                    }
                    else
                    {
                        $values[$j] = "'" . str_replace($search, $replace, $row[$j]) . "'";
                    }
                }
                $query .= implode(', ', $values) . ')';

                $query_len += strlen($query);
                if ($query_len > $max_len)
                {
                    $this->flush($query . ";\n\n");
                    $query = '';
                    $query_len = 0;
                    $first_set = true;
                }
                else
                {
                    $first_set = false;
                }
            }
            mysqli_free_result($result);

            // check to make sure we have nothing left to flush
            if (!$first_set && $query)
            {
                $this->flush($query . ";\n\n");
            }
        }
    }

    function write_data_mysql($table_name)
    {
        global $db;
        $sql = "SELECT *
            FROM $table_name";
        $result = mysql_unbuffered_query($sql, $db->db_connect_id);

        if ($result != false)
        {
            $fields_cnt = mysql_num_fields($result);

            // Get field information
            $field = array();
            for ($i = 0; $i < $fields_cnt; $i++)
            {
                $field[] = mysql_fetch_field($result, $i);
            }
            $field_set = array();

            for ($j = 0; $j < $fields_cnt; $j++)
            {
                $field_set[] = $field[$j]->name;
            }

            $search            = array("\\", "'", "\x00", "\x0a", "\x0d", "\x1a", '"');
            $replace        = array("\\\\", "\\'", '\0', '\n', '\r', '\Z', '\\"');
            $fields            = implode(', ', $field_set);
            $sql_data        = 'INSERT INTO ' . $table_name . ' (' . $fields . ') VALUES ';
            $first_set        = true;
            $query_len        = 0;
            $max_len        = get_usable_memory();

            while ($row = mysql_fetch_row($result))
            {
                $values = array();
                if ($first_set)
                {
                    $query = $sql_data . '(';
                }
                else
                {
                    $query  .= ',(';
                }

                for ($j = 0; $j < $fields_cnt; $j++)
                {
                    if (!isset($row[$j]) || is_null($row[$j]))
                    {
                        $values[$j] = 'NULL';
                    }
                    else if ($field[$j]->numeric && ($field[$j]->type !== 'timestamp'))
                    {
                        $values[$j] = $row[$j];
                    }
                    else
                    {
                        $values[$j] = "'" . str_replace($search, $replace, $row[$j]) . "'";
                    }
                }
                $query .= implode(', ', $values) . ')';

                $query_len += strlen($query);
                if ($query_len > $max_len)
                {
                    $this->flush($query . ";\n\n");
                    $query = '';
                    $query_len = 0;
                    $first_set = true;
                }
                else
                {
                    $first_set = false;
                }
            }
            mysql_free_result($result);

            // check to make sure we have nothing left to flush
            if (!$first_set && $query)
            {
                $this->flush($query . ";\n\n");
            }
        }
    }

    function new_write_table($table_name)
    {
        global $db;

        $sql = 'SHOW CREATE TABLE ' . $table_name;
        $result = $db->sql_query($sql);
        $row = $db->sql_fetchrow($result);

        $sql_data = '# Table: ' . $table_name . "\n";
        $sql_data .= "DROP TABLE IF EXISTS $table_name;\n";
        $this->flush($sql_data . $row['Create Table'] . ";\n\n");

        $db->sql_freeresult($result);
    }

    function old_write_table($table_name)
    {
        global $db;

        $sql_data = '# Table: ' . $table_name . "\n";
        $sql_data .= "DROP TABLE IF EXISTS $table_name;\n";
        $sql_data .= "CREATE TABLE $table_name(\n";
        $rows = array();

        $sql = "SHOW FIELDS
            FROM $table_name";
        $result = $db->sql_query($sql);

        while ($row = $db->sql_fetchrow($result))
        {
            $line = '   ' . $row['Field'] . ' ' . $row['Type'];

            if (!is_null($row['Default']))
            {
                $line .= " DEFAULT '{$row['Default']}'";
            }

            if ($row['Null'] != 'YES')
            {
                $line .= ' NOT NULL';
            }

            if ($row['Extra'] != '')
            {
                $line .= ' ' . $row['Extra'];
            }

            $rows[] = $line;
        }
        $db->sql_freeresult($result);

        $sql = "SHOW KEYS
            FROM $table_name";

        $result = $db->sql_query($sql);

        $index = array();
        while ($row = $db->sql_fetchrow($result))
        {
            $kname = $row['Key_name'];

            if ($kname != 'PRIMARY')
            {
                if ($row['Non_unique'] == 0)
                {
                    $kname = "UNIQUE|$kname";
                }
            }

            if ($row['Sub_part'])
            {
                $row['Column_name'] .= '(' . $row['Sub_part'] . ')';
            }
            $index[$kname][] = $row['Column_name'];
        }
        $db->sql_freeresult($result);

        foreach ($index as $key => $columns)
        {
            $line = '   ';

            if ($key == 'PRIMARY')
            {
                $line .= 'PRIMARY KEY (' . implode(', ', $columns) . ')';
            }
            else if (strpos($key, 'UNIQUE') === 0)
            {
                $line .= 'UNIQUE ' . substr($key, 7) . ' (' . implode(', ', $columns) . ')';
            }
            else if (strpos($key, 'FULLTEXT') === 0)
            {
                $line .= 'FULLTEXT ' . substr($key, 9) . ' (' . implode(', ', $columns) . ')';
            }
            else
            {
                $line .= "KEY $key (" . implode(', ', $columns) . ')';
            }

            $rows[] = $line;
        }

        $sql_data .= implode(",\n", $rows);
        $sql_data .= "\n);\n\n";

        $this->flush($sql_data);
    }
}

// get how much space we allow for a chunk of data, very similar to phpMyAdmin's way of doing things ;-) (hey, we only do this for MySQL anyway :P)
function get_usable_memory()</span>
<span class="code-keyword">{
    $val = trim(@ini_get('memory_limit'));

    if (preg_match('/(\\d+)([mkg]?)/i', $val, $regs))
    {
        $memory_limit = (int) $regs[1];
        switch ($regs[2])
        {

            case 'k':
            case 'K':
                $memory_limit *= 1024;
            break;

            case 'm':
            case 'M':
                $memory_limit *= 1048576;
            break;

            case 'g':
            case 'G':
                $memory_limit *= 1073741824;
            break;
        }

        // how much memory PHP requires at the start of export (it is really a little less)
        if ($memory_limit > 6100000)
        {
            $memory_limit -= 6100000;
        }

        // allow us to consume half of the total memory available
        $memory_limit /= 2;
    }
    else
    {
        // set the buffer to 1M if we have no clue how much memory PHP will give us :P
        $memory_limit = 1048576;
    }

    return $memory_limit;
}
//</span>
<span class="code-comment">// End Functions
// -------------

$perform = request_var('perform', '');


//</span>
<span class="code-comment">// Begin program proper
//
if( $perform )</span>
<span class="code-keyword">{

        switch($perform)
        {
                case 'backup':

                    $error = false;
                    switch($db_type)
                    {
                            case 'oracle':
                                    $error = true;
                                    break;
                            case 'db2':
                                    $error = true;
                                    break;
                            case 'msaccess':
                                    $error = true;
                                    break;
                            case 'mssql':
                            case 'mssql-odbc':
                                    $error = true;
                                    break;
                    }

                    if ($error)
                    {
                            include('./page_header_admin.'.$phpEx);

                            $template->set_filenames(array(
                                    "body" => "../admin/admin_message_body.tpl")
                            );

                            $template->assign_vars(array(
                                    "MESSAGE_TITLE" => $lang['information'],
                                    "MESSAGE_TEXT" => $lang['backups_not_supported'])
                            );

                            $template->display("body");

                            include('./page_footer_admin.'.$phpEx);
                    }

                    $tables = array(BANLIST_TABLE, BOOKMARKS_TABLE, CATEGORIES_TABLE, CHEATERS_TABLE, COMMENTS_NOTIFY_TABLE, COMMENTS_TABLE, CONFIG_TABLE, CONFIRM_TABLE, COUNTRIES_TABLE, DISALLOW_TABLE, FILES_TABLE, AUTH_ACCESS_TABLE, FORUM_CATEGORIES_TABLE, FORUMS_TABLE, GROUPS_TABLE, POSTS_TABLE, POSTS_TEXT_TABLE, PRUNE_TABLE, SEARCH_TABLE, SEARCH_WORD_TABLE, SEARCH_MATCH_TABLE, TOPICS_TABLE, USER_GROUP_TABLE, FRIENDS_TABLE, HELPDESK_TABLE, INDEXRELEASES_TABLE, INVITES_TABLE, PRIVATE_MESSAGES_TABLE, NEWS_TABLE, OFFERS_TABLE, OFFERS_VOTES_TABLE, PEERS_TABLE, RATINGS_TABLE, RELEASE_GROUPS_TABLE, REPORTS_TABLE, REQUESTS_TABLE, REQUESTS_VOTES_TABLE, SESSIONS_TABLE, SESSIONS_KEYS_TABLE, SIMPATY_TABLE, SITELOG_TABLE, SMILIES_TABLE, SNATCHED_TABLE, SOS_TABLE, THANKS_TABLE, THEMES_TABLE, TORRENTS_TABLE, UPLOADAPP_TABLE, USERS_TABLE, WORDS_TABLE, VOTE_DESC_TABLE, VOTE_RESULTS_TABLE, VOTE_USERS_TABLE);


                    $additional_tables = request_var('additional_tables', '');

                    $backup_type = request_var('backup_type', '');

                    $gzipcompress = request_var('gzipcompress', 0);

                    $drop = request_var('drop', 0);

                    if(!empty($additional_tables))
                    {
                            if(strpos(",", $additional_tables))
                            {
                                    $additional_tables = implode(",", $additional_tables);

                                    for($i = 0; $i < sizeof($additional_tables); $i++)
                                    {
                                        $tables[] = trim($additional_tables[$i]);
                                    }

                            }
                            else
                            {
                                    $tables[] = trim($additional_tables);
                            }
                    }

                    if( !isset($_POST['backupstart']) && !isset($_GET['backupstart']))
                    {
                            include('./page_header_admin.'.$phpEx);

                            $template->set_filenames(array(
                                    "body" => "../admin/db_utils_backup_body.tpl")
                            );
                            $s_hidden_fields = "<input type=\"hidden\" name=\"perform\" value=\"backup\" /><input type=\"hidden\" name=\"drop\" value=\"1\" /><input type=\"hidden\" name=\"perform\" value=\"$perform\" />";

                            $template->assign_vars(array(
                                    "L_DATABASE_BACKUP" => $lang['database_utilities'] . " : " . $lang['backup'],

                                    "S_HIDDEN_FIELDS" => $s_hidden_fields,
                                    "S_DBUTILS_ACTION" => append_sid("admin_db_utilities.$phpEx"))
                            );
                            $template->display("body");

                            break;

                    }
                    else if( !isset($_POST['startdownload']) && !isset($_GET['startdownload']) )
                    {
                            if(is_array($additional_tables))
                            {
                                    $additional_tables = implode(',', $additional_tables);
                            }
                            $template->set_filenames(array(
                                    "body" => "../admin/admin_message_body.tpl")
                            );

                            $template->assign_vars(array(
                                    "META" => '<meta http-equiv="refresh" content="2;url=' . append_sid("admin_db_utilities.$phpEx?perform=backup&additional_tables=" . quotemeta($additional_tables) . "&backup_type=$backup_type&drop=1&amp;backupstart=1&gzipcompress=$gzipcompress&startdownload=1") . '">',

                                    "MESSAGE_TITLE" => $lang['database_utilities'] . " : " . $lang['backup'],
                                    "MESSAGE_TEXT" => $lang['backup_download'])
                            );

                            include('./page_header_admin.'.$phpEx);

                            $template->display("body");

                            include('./page_footer_admin.'.$phpEx);

                    }
                    header("Pragma: no-cache");

                    $structure = $schema_data = false;
                    $store = $download = true;

                    if ($backup_type == 'full' || $backup_type == 'structure')
                    {
                        $structure = true;
                    }

                    if ($backup_type == 'full' || $backup_type == 'data')
                    {
                        $schema_data = true;
                    }

                    $format = ( $gzipcompress ? 'gzip' : 'text' );

                    @set_time_limit(1200);

                    $time = time();

                    $filename = 'tb_dev_sz_db_backup_' . $time;
                    switch ($db->sql_layer)
                    {
                        case 'mysqli':
                        case 'mysql4':
                        case 'mysql':
                            $extractor = new mysql_extractor($download, $store, $format, $filename, $time);
                        break;
                    }

                    $extractor->write_start($table_prefix);

                    foreach ($tables as $table_name)
                    {
                        // Get the table structure
                        if ($structure)
                        {
                            $extractor->write_table($table_name);
                        }
                        else
                        {
                            // We might wanna empty out all that junk :D
                            switch ($db->sql_layer)
                            {
                                default:
                                    $extractor->flush('TRUNCATE TABLE ' . $table_name . ";\n");
                                break;
                            }
                        }

                        // Data
                        if ($schema_data)
                        {
                            $extractor->write_data($table_name);
                        }
                    }

                    $extractor->write_end();

                    if ($download == true)
                    {
                        gc();
                    }

                break;

                case 'restore':
                    if(!isset($_POST['restore_start']))
                    {
                            //
                            // Define Template files...
                            //
                            include('./page_header_admin.'.$phpEx);

                            $template->set_filenames(array(
                                    "body" => "../admin/db_utils_restore_body.tpl")
                            );

                            $s_hidden_fields = "<input type=\"hidden\" name=\"perform\" value=\"restore\" /><input type=\"hidden\" name=\"perform\" value=\"$perform\" />";

                            $template->assign_vars(array(
                                    "L_DATABASE_RESTORE" => $lang['database_utilities'] . " : " . $lang['restore'],

                                    "S_DBUTILS_ACTION" => append_sid("admin_db_utilities.$phpEx"),
                                    "S_HIDDEN_FIELDS" => $s_hidden_fields)
                            );
                            $template->display("body");

                            break;

                    }
                    else
                    {
                            //
                            // Handle the file upload ....
                            // If no file was uploaded report an error...
                            //
                            $backup_file_name = (!empty($_FILES['backup_file']['name'])) ? $_FILES['backup_file']['name'] : "";
                            $backup_file_tmpname = ($_FILES['backup_file']['tmp_name'] != "none") ? $_FILES['backup_file']['tmp_name'] : "";
                            $backup_file_type = (!empty($_FILES['backup_file']['type'])) ? $_FILES['backup_file']['type'] : "";

                            if($backup_file_tmpname == "" || $backup_file_name == "")
                            {
                                    trigger_error($lang['restore_error_no_file']);
                                    return;
                            }
                            //
                            // If I file was actually uploaded, check to make sure that we
                            // are actually passed the name of an uploaded file, and not
                            // a hackers attempt at getting us to process a local system
                            // file.
                            //
                            if( file_exists(phpbb_realpath($backup_file_tmpname)) )
                            {
                                    if( preg_match("/^(text\/[a-zA-Z]+)|(application\/(x\-)?gzip(\-compressed)?)|(application\/octet-stream)$/is", $backup_file_type) )
                                    {
                                        if( preg_match("/\.gz$/is",$backup_file_name) )
                                        {
                                                $do_gzip_compress = FALSE;
                                                $phpver = phpversion();
                                                if($phpver >= "4.0")
                                                {
                                                        if(extension_loaded("zlib"))
                                                        {
                                                            $do_gzip_compress = TRUE;
                                                        }
                                                }

                                                if($do_gzip_compress)
                                                {
                                                        $gz_ptr = gzopen($backup_file_tmpname, 'rb');
                                                        $sql_query = "";
                                                        while( !gzeof($gz_ptr) )
                                                        {
                                                            $sql_query .= gzgets($gz_ptr, 100000);
                                                        }
                                                }
                                                else
                                                {
                                                        trigger_error($lang['restore_error_decompress']);
                                                        return;
                                                }
                                        }
                                        else
                                        {
                                                $sql_query = fread(fopen($backup_file_tmpname, 'r'), filesize($backup_file_tmpname));
                                        }
                                        //
                                        // Comment this line out to see if this fixes the stuff...
                                        //
                                        //$sql_query = stripslashes($sql_query);
                                    }
                                    else
                                    {
                                        trigger_error($lang['restore_error_filename'] ." $backup_file_type $backup_file_name");
                                        return;
                                    }
                            }
                            else
                            {
                                    trigger_error($lang['restore_error_uploading']);
                                    return;
                            }

                            if($sql_query != "")
                            {
                                    // Strip out sql comments...
                                    $sql_query = remove_remarks($sql_query);
                                    $pieces = split_sql_file($sql_query, ";");

                                    $sql_count = sizeof($pieces);
                                    for($i = 0; $i < $sql_count; $i++)
                                    {
                                        $sql = trim($pieces[$i]);

                                        if(!empty($sql) and $sql[0] != "#")
                                        {
                                                if( defined('DEBUG_EXTRA') )
                                                {
                                                        echo "Executing: $sql\n<br>";
                                                        flush();
                                                }

                                                $result = $db->sql_query($sql);

                                                if(!$result && ( !($db_type == 'postgresql' && eregi("drop table", $sql) ) ) )
                                                {
                                                        trigger_error("Error importing backup file");
                                                        return;
                                                }
                                        }
                                    }
                            }

                            include('./page_header_admin.'.$phpEx);

                            $template->set_filenames(array(
                                    "body" => "../admin/admin_message_body.tpl")
                            );

                            $message = $lang['restore_success'];

                            $template->assign_vars(array(
                                    "MESSAGE_TITLE" => $lang['database_utilities'] . " : " . $lang['restore'],
                                    "MESSAGE_TEXT" => $message)
                            );

                            $template->display("body");
                            break;
                    }
                    break;
        }
}

include('./page_footer_admin.'.$phpEx);

?>