Support Forum

What version of phpbb are you running?I'm also wondering if you can email me a copy of your database so I can put it on my offline test site. If you can convert the user data base to word press that would help out a ton!

After having a look I think this is something that can be done. It looks fairly straight forward.

This is the phpbb database as I see it:

User: phpbb_users

groups: phpbb_categories

Forums: phpbb_forums

Threads: phpbb_topics

Posts: phpbb_posts

From looking at the converter for SP-Forum v3.x you can change out a few things and possibly get it working. So something along the lines of what is posted below. There are a few more things that would probably need to be changed but I think the gist of it is correct.

this should be fairly straight forward once he converts the user DB over toWP. He will have to use SPF V3.0 and then the v3.0 converter. The converter will need a bit of tweaking but iot can be done.

David Polensky said:

What version of phpbb are you running?I'm also wondering if you can email me a copy of your database so I can put it on my offline test site. If you can convert the user data base to word press that would help out a ton!

After having a look I think this is something that can be done. It looks fairly straight forward.

This is the phpbb database as I see it:

User: phpbb_users

groups: phpbb_categories

Forums: phpbb_forums

Threads: phpbb_topics

Posts: phpbb_posts

From looking at the converter for SP-Forum v3.x you can change out a few things and possibly get it working. So something along the lines of what is posted below. There are a few more things that would probably need to be changed but I think the gist of it is correct.

function mpc_convert_page(){
    global $wpdb;
    
    if($_POST['convert']=='Convert') {
        echo '<div class="wrap">';
        echo 'Beginning conversion process…<br /><br />';
    
        // move over the groups
        echo 'Converting the groups…<br />';
        echo 'Getting the WP-Forum groups…<br />';
        $groups = $wpdb->get_results("SELECT * FROM phpbb_categories ORDER BY sort DESC");
        if ($groups) {
            foreach ($groups as $index => $group) {
                // create SF group
                echo 'Creating Group '.$group->name.'…<br />';
                $groupdata = array();
                $groupdata['group_name'] = substr($group->name, 0, 50);
                $groupdata['group_desc'] = substr('Auto created group during conversion – WP-Forum doesnt use group descriptions', 0, 150);
                $groupdata['group_seq'] = $index + 1;
                $success = mpc_create_group_row($groupdata);
                if (!$success) die('Error creating Simple Forum Groups!!!  Exiting…<br ');
                $gid[$group->id] = $wpdb->insert_id;
            }
            echo 'All groups created…<br /><br />';
        } else {
            echo '<br />No WP-Forum groups defined!!!  Exiting…<br />';
            die();
        }
        
        // move over the forums
        echo 'Converting the forums…<br />';
        echo 'Getting the WP-Forum forums…<br />';
        $forums = $wpdb->get_results("SELECT * FROM phpbb_forums ORDER BY sort DESC");
        if ($forums) {
            foreach ($forums as $index => $forum) {
                // create SF forum
                echo 'Creating Forum '.$forum->name.'…<br />';
                $forumdata = array();
                $forumdata['forum_name'] = substr($forum->name, 0, 75);
                $forumdata['forum_desc'] = substr($forum->description, 0, 150);
                $forumdata['forum_seq'] = $index + 1;
                $forumdata['forum_status'] = 0;
                $forumdata['group_id'] = $gid[$forum->parent_id];
                $success = mpc_create_forum_row($forumdata);            
                if (!$success) die('Error creating Simple Forum Forums!!!  Exiting…<br ');
                $fid[$forum->id] = $wpdb->insert_id;
            }
            echo 'All forums created…<br /><br />';
        } else {
            echo '<br />No WP-Forum forums defined!!!  Exiting…<br />';
            die();
        }

        // move over the topics
        echo 'Converting the topics…<br />';
        echo 'Getting the WP-Forum topics…<br />';
        $topics = $wpdb->get_results("SELECT * FROM phpbb_topics");
        if ($topics) {
            foreach ($topics as $topic) {
                // create SF topic
                echo 'Creating Topic '.$topic->subject.'…<br />';
                if ($topic->status == 'open') $status = 0; else $status = 1;
                $success = mpc_write_topic($topic->subject, $fid[$topic->parent_id], $topic->starter, $topic->date, $topic->views, $status, 0);        
                if (!$success) die('Error creating Simple Forum Topics!!!  Exiting…<br ');
                $tid[$topic->id] = $wpdb->insert_id;
            }
            echo 'All topics created…<br /><br />';
        } else {
            echo '<br />No WP-Forum topics defined!!!  Exiting…<br />';
            die();
        }

        // move over the posts
        echo 'Converting the posts…<br />';
        echo 'Getting the WP-Forum posts…<br />';
        $posts = $wpdb->get_results("SELECT * FROM phpbb_posts");
        if ($posts) {
            foreach ($posts as $post) {
                // create SF post
                echo 'Creating Post '.$post->id.'…<br />';
                $forum_id = $wpdb->get_var("SELECT forum_id FROM ".SFTOPICS." WHERE topic_id='".$tid[$post->parent_id]."'");
                $success = mpc_write_post($post->text, $tid[$post->parent_id], $forum_id, $post->author_id, $post->date, 0);
                if (!$success) die('Error creating Simple Forum Posts!!!  Exiting…<br ');
            }
            echo 'All posts created…<br /><br />';
        } else {
            echo '<br />No WP-Forum posts defined!!!  Exiting…<br />';
            die();
        }

        echo '</div>';

Did anyone get this to work? I have a small PHPbb3 database to migrate to SPF. Any help would be appreciated.