* upgrade_20.php

* -------------------

* begin : Sat Oct 14 2000

* $id upgrade_20.php,v 1.9 2001/03/23 01:32:41 psotfx Exp $

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

include('extension.inc');

include('config.'.$phpEx);

include('includes/constants.'.$phpEx);

}

{

{

$ip_sep = explode(".", $ip);

$return = (( $ip_sep[0] * 0xFFFFFF + $ip_sep[0] ) + ( $ip_sep[1] * 0xFFFF + $ip_sep[1] ) + ( $ip_sep[2] * 0xFF + $ip_sep[2] ) + ( $ip_sep[3] ) );

}

{

$return = sprintf( "%d.%d.%d.%d", ( ( $ip >> 24 ) & 0xFF ), ( ( $ip >> 16 ) & 0xFF ), ( ( $ip >> 8 ) & 0xFF ), ( ( $ip ) & 0xFF ) );

}

return($return);

function convert_date($date_in)

{

// Original phpBB format

list($year, $month, $day) = split("-", $date);

list($hours, $minutes) = split(":", $time);

return($timestamp);

}

//

// Following functions adapted from phpMyAdmin

//

// Returns a string containing the CREATE statement on success

//

function get_table_def($db, $table, $crlf) {

}

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

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

if (!empty($row["Default"])){

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

}

if ($row["Extra"] != ""){

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

}

$schema_create .= ",$crlf";

}

$error = $db->sql_error();

error_die($db, GENERAL_ERROR, "Failed in get_table_content (show keys) : ".$error["message"]);

}

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

$kname=$row['Key_name'];

if (($kname != "PRIMARY") && ($row['Non_unique'] == 0)){

$kname="UNIQUE|$kname";

}

$schema_create .= " KEY $x (" . implode($columns, ", ") . ")";

}

}

$schema_create .= "$crlf);";

return (stripslashes($schema_create));

//

// Get the content of table as a series of INSERT statements.

error_die($db, GENERAL_ERROR, "Failed in get_table_content (select * ) : ".$error["message"]);

}

$i = 0;

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

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

for ($j=0; $j<$db->sql_numfields($result);$j++) {

function output_table_content($content){

echo $content."\n";

return;

}

$quote_end_html = "</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE><!-- BBCode Quote End -->";

$message = str_replace($quote_start_html, "[quote]", $message);

$message = str_replace($quote_end_html, "[/quote]", $message);

// Undo [b] and [i]

$message = preg_replace("#<!-- BBCode Start --><B>(.*?)</B><!-- BBCode End -->#s", "[b]\\1[/b]", $message);

$message = preg_replace("#<!-- BBCode Start --><I>(.*?)</I><!-- BBCode End -->#s", "[i]\\1[/i]", $message);

// Undo [url] (long form)

$message = preg_replace("#<!-- BBCode u2 Start --><A HREF=\"([a-z]+?://)(.*?)\" TARGET=\"_blank\">(.*?)</A><!-- BBCode u2 End -->#s", "[url=\\1\\2]\\3[/url]", $message);

// Undo [url] (short form)

$message = preg_replace("#<!-- BBCode u1 Start --><A HREF=\"([a-z]+?://)(.*?)\" TARGET=\"_blank\">(.*?)</A><!-- BBCode u1 End -->#s", "[url]\\3[/url]", $message);

// Undo [email]

$message = preg_replace("#<!-- BBCode Start --><A HREF=\"mailto:(.*?)\">(.*?)</A><!-- BBCode End -->#s", "[email]\\1[/email]", $message);

$message = preg_replace("#<!-- BBCode Start --><IMG SRC=\"(.*?)\" BORDER=\"0\"><!-- BBCode End -->#s", "[img]\\1[/img]", $message);

// Undo lists (unordered/ordered)

// <li> tags:

$message = str_replace("<!-- BBCode --><LI>", "[*]", $message);

// [list] tags:

$message = str_replace("<!-- BBCode ulist Start --><UL>", "[list]", $message);

// [list=x] tags:

$message = preg_replace("#<!-- BBCode olist Start --><OL TYPE=([A1])>#si", "[list=\\1]", $message);

// [/list] tags:

$message = str_replace("</UL><!-- BBCode ulist End -->", "[/list]", $message);

$message = str_replace("</OL><!-- BBCode olist End -->", "[/list]", $message);

* - Does not distinguish between "www.xxxx.yyyy" and "http://aaaa.bbbb" type URLs.

*

*/

function undo_make_clickable($text) {

$text = preg_replace("#<!-- BBCode auto-link start --><a href=\"(.*?)\" target=\"_blank\">.*?</a><!-- BBCode auto-link end -->#i", "\\1", $text);

$text = preg_replace("#<!-- BBcode auto-mailto start --><a href=\"mailto:(.*?)\">.*?</a><!-- BBCode auto-mailto end -->#i", "\\1", $text);

return $text;

}

//

?>

<?php

{

{

case 'backup':

{

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

{

('".$row["ban_id"]."', '".$row["ban_userid"]."', '".convert_ip($row["ban_ip"])."', '".$row["ban_start"]."', '".$row["ban_end"]."', '".$row["ban_time_type"]."')";

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

if(!$insert_result)

{

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

{

(config_id, sitename, allow_html, allow_bbcode, allow_sig, allow_namechange, selected, posts_per_page, hot_threshold, topics_per_page, allow_theme_create, override_themes, email_sig, email_from, default_lang)

VALUES

('".$row["config_id"]."', '".$row["sitename"]."', '".$row["allow_html"]."', '".$row["allow_bbcode"]."', '".$row["allow_sig"]."', '".$row["allow_namechange"]."', '".$row["selected"]."', '".$row["posts_per_page"]."', '".$row["hot_threshold"]."', '".$row["topics_per_page"]."', '".$row["allow_theme_create"]."', '".$row["override_themes"]."', '".$row["email_sig"]."', '".$row["email_from"]."', '".$row["default_lang"]."')";

// do 2.x first-pass encoding..

$row['post_text'] = bbencode_first_pass($row['post_text'], $uid);

$row['post_text'] = addslashes($row['post_text']);

$sql = "INSERT INTO phpbb_posts

(post_id, topic_id, forum_id, poster_id, post_time, poster_ip, bbcode_uid)

VALUES

} // switch

} // if next

{

common_header();

?>

<INPUT TYPE="HIDDEN" NAME="next" VALUE="backup">

<INPUT TYPE="SUBMIT" VALUE="Next >">

</FORM>

}

?>

</BODY>