- if( ( $file_uploads != 0 || empty($file_uploads) ) && strtolower($file_uploads) != 'off' && @phpversion() != '4.0.4pl1' )

- switch($mode)

- $tables = array('search_wordlist', 'search_wordmatch', 'auth_access', 'banlist', 'categories', 'config', 'disallow', 'forums', 'forum_prune', 'groups', 'posts', 'posts_text', 'privmsgs', 'privmsgs_text', 'ranks', 'search_results', 'search_results', 'sessions', 'smilies', 'themes', 'themes_name', 'topics', 'topics_watch', 'user_group', 'users', 'vote_desc', 'vote_results', 'vote_voters', 'words');

- $additional_tables = ( isset($HTTP_POST_VARS['additional_tables']) ) ? $HTTP_POST_VARS['additional_tables'] : ( ( isset($HTTP_GET_VARS['additional_tables']) ) ? $HTTP_GET_VARS['additional_tables'] : '' );

-

- $backup_type = ( isset($HTTP_POST_VARS['backup_type']) ) ? $HTTP_POST_VARS['backup_type'] : ( ( isset($HTTP_GET_VARS['backup_type']) ) ? $HTTP_GET_VARS['backup_type'] : '' );

-

- $ignoresearch = ( !empty($HTTP_POST_VARS['ignoresearch']) ) ? $HTTP_POST_VARS['ignoresearch'] : ( ( !empty($HTTP_GET_VARS['ignoresearch']) ) ? $HTTP_GET_VARS['ignoresearch'] : 0 );

-

- $gzipcompress = ( !empty($HTTP_POST_VARS['gzipcompress']) ) ? $HTTP_POST_VARS['gzipcompress'] : ( ( !empty($HTTP_GET_VARS['gzipcompress']) ) ? $HTTP_GET_VARS['gzipcompress'] : 0 );

-

- if ( !empty($additional_tables) )

- {

- $additional_tables = explode(', ', $additional_tables);

-

- for($i = 0; $i < count($additional_tables); $i++)

- {

- $tables[] = trim($additional_tables[$i]);

- }

- unset($additional_tables);

- }

-

- if ( !isset($HTTP_POST_VARS['backupstart']) && !isset($HTTP_GET_VARS['backupstart']))

- $s_hidden_fields = '<input type="hidden" name="mode" value="backup" /><input type="hidden" name="drop" value="1" /><input type="hidden" name="mode" value="$mode" />';

-

-<form method="post" action="<?php echo "admin_db_utilities.$phpEx$SID&amp;mode=$mode"; ?>"><table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

- <td class="row1"><?php echo $lang['Backup_type']; ?></td>

- <td class="row2"><input type="radio" name="backup_type" value="full" checked="checked" /> <?php echo $lang['Full_backup']; ?>&nbsp;&nbsp;<input type="radio" name="backup_type" value="structure" /> <?php echo $lang['Structure_only']; ?>&nbsp;&nbsp;<input type="radio" name="backup_type" value="data" /> <?php echo $lang['Data_only']; ?></td>

- <td class="row1"><?php echo $lang['Include_search_index']; ?><br /><span class="gensmall"><?php echo $lang['Include_search_index_explain']; ?></span></td>

- <td class="row2"><input type="radio" name="ignoresearch" value="0" /> <?php echo $lang['No']; ?>&nbsp;&nbsp;<input type="radio" name="ignoresearch" value="1" checked="checked" /> <?php echo $lang['Yes']; ?></td>

- <td class="row1"><?php echo $lang['Additional_tables']; ?><br /><span class="gensmall"><?php echo $lang['Additional_tables_explain']; ?></span></td>

- <td class="row2"><input type="text" name="additional_tables" size="40" /></td>

- if ( extension_loaded('zlib') )

- <td class="row1"><?php echo $lang['Gzip_compress']; ?></td>

- <td class="row2"><input type="radio" name="gzipcompress" value="0" checked="checked" /> <?php echo $lang['No']; ?>&nbsp;&nbsp;<input type="radio" name="gzipcompress" value="1" /> <?php echo $lang['Yes']; ?></td>

- <td class="cat" colspan="2" align="center"><?php echo $s_hidden_fields; ?><input type="submit" name="backupstart" value="<?php echo $lang['Start_backup']; ?>" class="mainoption" /></td>

- $template->assign_vars(array(

- "META" => "<meta http-equiv=\"refresh\" content=\"0;url=admin_db_utilities.$phpEx?mode=backup&amp;additional_tables=" . quotemeta($additional_tables) . "&amp;backup_type=$backup_type&amp;drop=1&amp;backupstart=1&amp;gzipcompress=$gzipcompress&amp;startdownload=1\">",

-

- "MESSAGE_TITLE" => $lang['Database_Utilities'] . " : " . $lang['Backup'],

- "MESSAGE_TEXT" => $lang['Backup_download'])

- );

-

- include('page_header_admin.php');

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

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

- $do_gzip_compress = FALSE;

- if( $gzipcompress )

- $phpver = phpversion();

- if($phpver >= "4.0")

- if(extension_loaded("zlib"))

- {

- $do_gzip_compress = TRUE;

- }

- if($do_gzip_compress)

- {

- @ob_start();

- @ob_implicit_flush(0);

- header("Content-Type: text/x-delimtext; name=\"phpbb_db_backup.sql.gz\"");

- header("Content-disposition: attachment; filename=phpbb_db_backup.sql.gz");

- }

- else

- {

- header("Content-Type: text/x-delimtext; name=\"phpbb_db_backup.sql\"");

- header("Content-disposition: attachment; filename=phpbb_db_backup.sql");

- }

- echo "#\n# TABLE: " . $table_prefix . $table_name . "\n#\n";

- echo $table_def_function($table_prefix . $table_name, "\n") . "\n";

- $table_content_function($table_prefix . $table_name, "output_table_content");

- if ( $do_gzip_compress )

- $Size = ob_get_length();

- $Crc = crc32(ob_get_contents());

- $contents = gzcompress(ob_get_contents());

- ob_end_clean();

- echo "\x1f\x8b\x08\x00\x00\x00\x00\x00".substr($contents, 0, strlen($contents) - 4).gzip_PrintFourChars($Crc).gzip_PrintFourChars($Size);

- exit;

-

- break;

-

- case 'restore':

- if ( !isset($restore_start) )

- $s_hidden_fields = '<input type="hidden" name="mode" value="restore" /><input type="hidden" name="mode" value="$mode" />';

- page_header($lang['DB_Restore']);

-

-?>

-<h1><?php echo $lang['DB_Restore']; ?></h1>

-<p><?php echo $lang['Restore_explain']; ?></p>

-<form enctype="multipart/form-data" method="post" action="<?php echo "admin_db_utilities.$phpEx$SID&amp;mode=$mode"; ?>"><table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

- <th colspan="2"><?php echo $lang['Select_file']; ?></th>

- </tr>

- <tr>

- <td class="row1"><?php echo $lang['Upload_file']; ?>: </td>

- <td class="row2"><input type="file" name="backup_file" /></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $lang['Local_backup_file']; ?>: <br /><span class="gensmall"><?php echo $lang['Local_backup_file_explain']; ?></span></td>

- <td class="row2"><input type="text" name="local_file" size="40" /></td>

- </tr>

- <tr>

- <td class="cat" colspan="2" align="center"><input type="submit" name="restore_start" value="<?php echo $lang['Start_Restore']; ?>" class="mainoption" /></td>

- </trs>

-</table><?php echo $s_hidden_fields; ?></form>

-<?php

- break;

- }

- else

- $backup_file_name = (!empty($HTTP_POST_FILES['backup_file']['name'])) ? $HTTP_POST_FILES['backup_file']['name'] : "";

- $backup_file_tmpname = ($HTTP_POST_FILES['backup_file']['tmp_name'] != "none") ? $HTTP_POST_FILES['backup_file']['tmp_name'] : "";

- $backup_file_type = (!empty($HTTP_POST_FILES['backup_file']['type'])) ? $HTTP_POST_FILES['backup_file']['type'] : "";

- if ( $backup_file_tmpname == "" || $backup_file_name == "" )

- //

- // 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($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

- {

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

- message_die(ERROR, $lang['Restore_Error_decompress']);

- }

- }

- 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

- {

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

- message_die(ERROR, $lang['Restore_Error_filename'] ." $backup_file_type $backup_file_name");

- }

- else

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

- message_die(ERROR, $lang['Restore_Error_uploading']);

- if($sql_query != "")

- $pieces = split_sql_file($sql_query, ";");

- if(!empty($sql) and $sql[0] != "#")

- if(DEBUG == 1)

- {

- echo "Executing: $sql\n<br>";

- flush();

- }

-

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

-

- if(!$result && ( !(SQL_LAYER == 'postgresql' && eregi("drop table", $sql) ) ) )

- {

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

- // echo "~~$sql~~";

- message_die(ERROR, "Error importing backup file", "", __LINE__, __FILE__, $sql);

- }

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

- $message = $lang['Restore_success'];

- $template->assign_vars(array(

- "MESSAGE_TITLE" => $lang['Database_Utilities'] . " : " . $lang['Restore'],

- "MESSAGE_TEXT" => $message)

- );

- break;

- }

- break;

-

-// The following functions are adapted from phpMyAdmin and upgrade_20.php

-function gzip_PrintFourChars($Val)

- for ($i = 0; $i < 4; $i ++)

- $return .= chr($Val % 256);

- $Val = floor($Val / 256);

- return $return;

-}

- global $drop, $db;

- if ($drop == 1)

- {

- $schema_create .= "DROP TABLE $table;$crlf";

- } // end if

- global $drop, $db;

- if ($drop == 1)

- {

- $schema_create .= "DROP TABLE IF EXISTS $table;$crlf";

- }

-

- if (!$result)

- {

- message_die(GENERAL_ERROR, "Failed in get_table_content (select *)", "", __LINE__, __FILE__, "SELECT * FROM $table");

- }

-

- while($row = $db->sql_fetchrow($result))

- if (!$result)

- {

- message_die(GENERAL_ERROR, "Failed in get_table_content (select *)", "", __LINE__, __FILE__, "SELECT * FROM $table");

- }

-

- if($db->sql_numrows($result) > 0)

- {

- $schema_insert = "\n#\n# Table Data for $table\n#\n";

- }

- else

- {

- $schema_insert = "";

- }

-

- $handler($schema_insert);

-

-

- while ($row = $db->sql_fetchrow($result))

- $table_list = '(';

- $num_fields = $db->sql_numfields($result);

- //

- // Grab the list of field names.

- //

- for ($j = 0; $j < $num_fields; $j++)

- {

- $table_list .= $db->sql_fieldname($j, $result) . ', ';

- }

- //

- // Get rid of the last comma

- //

- $table_list = ereg_replace(', $', '', $table_list);

- $table_list .= ')';

- //

- // Start building the SQL statement.

- //

- $schema_insert = "INSERT INTO $table $table_list VALUES(";

- //

- // Loop through the rows and fill in data for each column

- //

- for ($j = 0; $j < $num_fields; $j++)

- if(!isset($row[$j]))

- {

- //

- // If there is no data for the column set it to null.

- // There was a problem here with an extra space causing the

- // sql file not to reimport if the last column was null in

- // any table. Should be fixed now :) JLH

- //

- $schema_insert .= ' NULL,';

- }

- elseif ($row[$j] != '')

- $schema_insert .= ' \'' . addslashes($row[$j]) . '\',';

- else

- $schema_insert .= '\'\',';

- //

- // Get rid of the the last comma.

- //

- $schema_insert = ereg_replace(',$', '', $schema_insert);

- $schema_insert .= ');';

- //

- // Go ahead and send the insert statement to the handler function.

- //

- $handler(trim($schema_insert));

-

- return(true);