[ Closed ] Converter: PhpBB2 -> PunBB1.1 v2.0b3 (Page 3 of 4)

diff -ru ../phpbb_to_pubb/_posts.php /home/z0rglub/work/www/phpbb_to_pubb/_posts.php
--- ../phpbb_to_pubb/_posts.php Mon Jan  5 19:36:42 2004
+++ /home/z0rglub/work/www/phpbb_to_pubb/_posts.php     Sat Apr 17 12:19:20 2004
@@ -1,7 +1,7 @@
 <?^M
        $start = (int)$_GET['posts'];^M
        echo "\n<br>Converting posts: $start...<br>"; flush();^M
-       $result = mysql_query('SELECT post.post_id, post.post_time, post.poster_id, post.poster_ip, post.topic_id, text.post_subject, text.post_text, users.username FROM '.$_SESSION['php'].'posts AS post, '.$_SESSION['php'].'posts_text AS text, '.$_SESSION['php'].'users AS users WHERE post.post_id>'.$start.' AND post.post_id=text.post_id AND users.user_id=post.poster_id ORDER BY post.post_id LIMIT '.$_SESSION['limit']) or die(error("Unable to get posts", __FILE__, __LINE__, mysql_error(), "true"));^M
+       $result = mysql_query('SELECT post.post_id, post.post_time, post.poster_id, post.poster_ip, post.topic_id, text.post_subject, text.post_text, post.post_username, users.username FROM '.$_SESSION['php'].'posts AS post, '.$_SESSION['php'].'posts_text AS text, '.$_SESSION['php'].'users AS users WHERE post.post_id>'.$start.' AND post.post_id=text.post_id AND users.user_id=post.poster_id ORDER BY post.post_id LIMIT '.$_SESSION['limit']) or die(error("Unable to get posts", __FILE__, __LINE__, mysql_error(), "true"));^M
        $last_id;^M
        while($ob = mysql_fetch_assoc($result)){^M
                //printr($ob);          ^M
@@ -9,16 +9,25 @@
                echo $ob['post_id'].' ('.$ob['username'].")<br>\n"; flush();^M
 ^M
                // Save to database^M
-               mysql_query('INSERT INTO '.$_SESSION['pun'].'posts^M
-                       (id, poster, poster_id, posted, poster_ip, message, topic_id) VALUES(^M
-                       \''.$ob['post_id'].'\',^M
-                       \''.html_stuff($ob['username']).'\',^M
-                       \''.$ob['poster_id'].'\',^M
-                       \''.$ob['post_time'].'\',^M
-                       \''.decode_ip($ob['poster_ip']).'\',^M
-                       \''.convert_posts($ob['post_text']).'\',^M
-                       \''.$ob['topic_id'].'\'^M
-                       )') or die(error("PunBB: Unable to save post<br>", __FILE__, __LINE__, mysql_error(), "true"));^M
+               $query = 'INSERT INTO '.$_SESSION['pun'].'posts';^M
+               $query.= '(id, poster, poster_id, posted, poster_ip, message, topic_id) VALUES(';^M
+               $query.= "'".$ob['post_id']."',";^M
+               if ( $ob['poster_id'] != -1 )^M
+               {^M
+                 $query.= "'".html_stuff($ob['username'])."',";^M
+                 $query.= "'".$ob['poster_id']."',";^M
+               }^M
+               else^M
+               {^M
+                 $query.= "'".addslashes( $ob['post_username'] )."',";^M
+                 $query.= '1,';^M
+               }^M
+               $query.= "'".$ob['post_time']."',";^M
+               $query.= "'".decode_ip($ob['poster_ip'])."',";^M
+               $query.= "'".convert_posts($ob['post_text'])."',";^M
+               $query.= "'".$ob['topic_id']."'";^M
+               $query.= ');';^M
+                mysql_query( $query ) or die(error("PunBB: Unable to save post<br>", __FILE__, __LINE__, mysql_error(), "true"));^M
        }^M
 ^M
        // More topics?^M
@@ -27,4 +36,4 @@
                $location = '<script type="text/javascript">window.location="index.php?page='.$_GET['page'].'&posts='.$last_id.'"</script>';^M
        else^M
                $location = '<script type="text/javascript">window.location="index.php?page='.++$_GET['page'].'"</script>';^M
-?>
\ No newline at end of file
+?>^M

diff -ru ../phpbb_to_pubb/_topics.php /home/z0rglub/work/www/phpbb_to_pubb/_topics.php
--- ../phpbb_to_pubb/_topics.php        Mon Jan  5 21:03:18 2004
+++ /home/z0rglub/work/www/phpbb_to_pubb/_topics.php    Sat Apr 17 00:29:11 2004
@@ -17,6 +17,17 @@
                        $last['poster'] = $ob['username'];^M
                }^M
 ^M
+                if ( $ob['topic_poster'] == -1 )^M
+               {^M
+                 $query = 'SELECT post_username';^M
+                 $query.= ' FROM '.$_SESSION['php'].'posts';^M
+                 $query.= ' WHERE post_id = '.$ob['topic_first_post_id'];^M
+                 $query.= ';';^M
+                 $result = mysql_query( $query ) or die( error( 'Unable to retrieve first anonymous username to this topic', __FILE__, __LINE__, mysql_error(), "true" ) );^M
+                 $row = mysql_fetch_array( $result );^M
+                 $ob['username'] = $row['post_username'];^M
+               }^M
+^M
                // Save to database^M
                mysql_query('INSERT INTO '.$_SESSION['pun'].'topics^M
                        (id, poster, subject, posted, num_views, num_replies, last_post, last_post_id, last_poster, sticky, closed, forum_id) VALUES(^M
@@ -55,4 +66,4 @@
                $location = '<script type="text/javascript">window.location="index.php?page='.$_GET['page'].'&topics='.$last_id.'"</script>';^M
        else^M
                $location = '<script type="text/javascript">window.location="index.php?page='.++$_GET['page'].'"</script>';^M
-?>
\ No newline at end of file
+?>^M

@$db->query($sql);