*

***************************************************************************/

{

$filename = basename(__FILE__);

$file_uploads = @ini_get('file_uploads');

{

$module['DB']['DB_Restore'] = $filename . "$SID&mode=restore";

}

}

define('IN_PHPBB', 1);

// Load default header

$phpbb_root_path = '../';

require($phpbb_root_path . 'extension.inc');

require('pagestart.' . $phpEx);

include($phpbb_root_path . 'includes/functions_admin.'.$phpEx);

// Increase maximum execution time, but don't complain about it if it isn't

// allowed.

@set_time_limit(1200);

// Begin program proper

{

case 'backup':

{

{

case 'oracle':

$db_type = 'Oracle';

break;

}

break;

}

{

page_header($user->lang['DB_Backup']);

</tr>

<?php

{

?>

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

<td class="row2"><input type="radio" name="compress" value="none" checked="checked" /> <?php echo $user->lang['None']; ?><?php

{

}

{

?>&nbsp;&nbsp;<input type="radio" name="compress" value="bzip" />.bz2<?php

break;

}

{

$meta = "<meta http-equiv=\"refresh\" content=\"0;url=admin_database.$phpEx?mode=backup&amp;type=$backup_type&amp;tables=" . quotemeta($additional_tables) . "&amp;search=$search&amp;store=" . quotemeta($store_path) . "&amp;compress=$compress&amp;backupstart=1&amp;startdownload=1\">";

page_header($user->lang['DB_Backup'], $meta);

page_message($user->lang['DB_Backup'], $message);

page_footer();

}

@sort($tables);

{

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

echo "#\n# DATE : " . gmdate("d-m-Y H:i:s", time()) . " GMT\n";

echo "#\n";

{

echo "\n" . pg_get_sequences("\n", $backup_type);

}

{

$table_name = $tables[$i];

{

$table_def_function = "get_table_def_" . SQL_LAYER;

$table_content_function = "get_table_content_" . SQL_LAYER;

$table_content_function = "get_table_content_mysql";

}

{

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

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

}

{

//

// Skip search table data?

//

{

$table_content_function($table_name, "output_table_content");

}

//

// Flush the buffer, send the file

//

{

case 'gzip':

$extension = 'sql.gz';

case 'zip':

$extension = 'zip';

$zip = new zipfile;

ob_end_clean();

$contents = $zip->file();

break;

add_admin_log('log_db_backup');

{

header("Pragma: no-cache");

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

}

else

{

{

message_die(ERROR, 'Could not open backup file');

}

{

message_die(ERROR, 'Could not write backup file content');

}

fclose($fp);

unset($contents);

}

exit;

break;

case 'restore':

{

//

// Handle the file upload ....

// If no file was uploaded report an error...

//

{

$file_tmpname = './../' . str_replace('\\\\', '/', $_POST['local']);

$filename = substr($file_tmpname, strrpos($file_tmpname, '/'));

}

else

{

}

{

}

$ext = substr($filename, strrpos($filename, '.') + 1);

{

}

{

}

$sql_query = '';

{

case 'gz':

$fp = gzopen($file_tmpname, 'rb');

{

$sql_query .= gzgets($fp, 100000);

}

$sql_query = bzdecompress(fread(fopen($file_tmpname, 'rb'), filesize($file_tmpname)));

break;

default;

$sql_query = fread(fopen($file_tmpname, 'r'), filesize($file_tmpname));

}

{

// Strip out sql comments...

$sql_query = remove_remarks($sql_query);

{

$sql = trim($pieces[$i]);

{

$db->sql_query($sql);

}

add_admin_log('log_db_restore');

}

//

echo $user->lang['Supported_extensions'];

$types = ': <u>sql</u>';

{

$types .= ', <u>sql.gz</u>';

}

{

$types .= ', <u>bz2</u>';

}

break;

default:

exit;

}

$tables = array();

$result = mysql_list_tables($db->dbname, $db->db_connect_id);

{

do

{

{

$tables[] = $row[0];

}

}

}

return $tables;

$seq = $db->sql_query($get_seq_sql);

{

$return_val = "# No Sequences Found $crlf";

$get_props_sql = "SELECT * FROM $sequence";

$seq_props = $db->sql_query($get_props_sql);

{

$row1 = $db->sql_fetchrow($seq_props);

{

$row['last_value'] = 1;

}

} // End if numrows > 0

{

$return_val .= "SELECT NEXTVALE('$sequence'); $crlf";

unset($row['last_value']);

ORDER BY a.attnum";

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

{

message_die(GENERAL_ERROR, "Failed in get_table_def (show fields)", "", __LINE__, __FILE__, $field_query);

} // end if..

ORDER BY index_name, tab_name, column_name ";

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

{

message_die(GENERAL_ERROR, "Failed in get_table_def (show fields)", "", __LINE__, __FILE__, $sql_pri_keys);

}

{

if ($row['primary_key'] == 't')

{

$field_query = "SHOW FIELDS FROM $table";

$key_query = "SHOW KEYS FROM $table";

// If the user has selected to drop existing tables when doing a restore.

// Then we add the statement to drop the tables....

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

$schema_create .= "CREATE TABLE $table($crlf";

// Ok lets grab the fields...

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

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

{

$schema_create .= ' ' . $row['Field'] . ' ' . $row['Type'];

{

$schema_create .= ' DEFAULT \'' . $row['Default'] . '\'';

}

{

$schema_create .= ' NOT NULL';

}

{

$schema_create .= ' ' . $row['Extra'];

}

{

$kname = $row['Key_name'];

{

$kname = "UNIQUE|$kname";

}

{

$index[$kname] = array();

}

$index[$kname][] = $row['Column_name'];

}

{

$schema_create .= ", $crlf";

{

$schema_create .= ' PRIMARY KEY (' . implode($columns, ', ') . ')';

}

$schema_create .= "$crlf);";

{

return(stripslashes($schema_create));

}

{

global $db;

// Grab all of the data from current table.

$result = $db->sql_query("SELECT * FROM $table");

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

$iRec = 0;

{

unset($schema_vals);

unset($schema_fields);

unset($schema_insert);

// Build the SQL statement to recreate the data.

for($i = 0; $i < $i_num_fields; $i++)

{

$strVal = $row[$aryName[$i]];

{

$strQuote = "'";

$strEmpty = "";

$strVal = addslashes($strVal);

}

{

if ($empty($strVal))

{

$schema_vals .= " $strQuote$strVal$strQuote,";

$schema_fields .= " $aryName[$i],";

}

// Take the ordered fields and their associated data and build it

// into a valid sql statement to recreate that field in the data.

$schema_insert = "INSERT INTO $table ($schema_fields) VALUES($schema_vals);";

$handler(trim($schema_insert));

function get_table_content_mysql($table, $handler)

{

global $db;

// Grab the data from the table.

$result = $db->sql_query("SELECT * FROM $table");

// Loop through the resulting rows and build the sql statement.

$schema_insert = "";

{

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

//

// Get rid of the last comma

//

$table_list .= ')';

//

// Start building the SQL statement.

//

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

{

{

//

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

//

// Get rid of the the last comma.

//

$schema_insert .= ');';

//

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

//

$handler(trim($schema_insert));

}

}

return true;

var $eof_ctrl_dir = "\x50\x4b\x05\x06\x00\x00\x00\x00";

var $old_offset = 0;

{

if ($timearray['year'] < 1980)

{

$timearray['seconds'] = 0;

}

}

{

$name = str_replace('\\', '/', $name);

$hexdtime = '\x' . $dtime[6] . $dtime[7]

. '\x' . $dtime[4] . $dtime[5]

. '\x' . $dtime[2] . $dtime[3]

$cdrec .= pack('V', $crc); // crc32

$cdrec .= pack('V', $c_len); // compressed filesize

$cdrec .= pack('V', $unc_len); // uncompressed filesize

$this -> old_offset = $new_offset;

$cdrec .= $name;

pack('V', strlen($data)) . // offset to start of central dir

"\x00\x00"; // .zip file comment length

}

}

//