phpBB 3 to punbb convertor ? (Page 1 of 3)

    // Fetch forum info
    $result = $fdb->query('SELECT * FROM '.$_SESSION['php'].$_SESSION['phpnuke'].'categories') or myerror('Unable to fetch categories', __FILE__, __LINE__, $fdb->error());
    while($ob = $fdb->fetch_assoc($result))
    {
        echo $ob['cat_title'].' ('.$ob['cat_id'].")<br>\n"; flush();

        // Dataarray
        $todb = array(
            'id'                    =>        $ob['cat_id'],
            'cat_name'            =>        $ob['cat_title'],    
            'disp_position'    =>     $ob['cat_order'],
        );

        // Save data
        insertdata('categories', $todb, __FILE__, __LINE__);
    }

    // Fetch forum info
    $result = $fdb->query('SELECT * FROM '.$_SESSION['php'].$_SESSION['phpnuke'].'forums where forum_type=0') or myerror('Unable to fetch categories', __FILE__, __LINE__, $fdb->error());
    while($ob = $fdb->fetch_assoc($result))
    {
        echo $ob['forum_name'].' ('.$ob['forum_id'].")<br>\n"; flush();

        // Dataarray
        $todb = array(
            'id'                    =>        $ob['forum_id'],
            'cat_name'            =>        $ob['forum_name'],    
            'disp_position'    =>     $ob['left_id'],
        );

        // Save data
        insertdata('categories', $todb, __FILE__, __LINE__);
    }

    $result = $fdb->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'].$_SESSION['phpnuke'].'posts AS post, '.$_SESSION['php'].$_SESSION['phpnuke'].'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 myerror("Unable to get posts", __FILE__, __LINE__, $fdb->error());

    $result = $fdb->query('SELECT post.post_id, post.post_time, post.poster_id, post.poster_ip, post.topic_id, post.post_subject, post.post_text, users.username FROM '.$_SESSION['php'].$_SESSION['phpnuke'].'posts AS post, '.$_SESSION['php'].'users AS users WHERE post.post_id>'.$start.' AND users.user_id=post.poster_id ORDER BY post.post_id LIMIT '.$_SESSION['limit']) or myerror("Unable to get posts", __FILE__, __LINE__, $fdb->error());

<?php

    // Fetch forum info
    $result = $fdb->query('SELECT * FROM '.$_SESSION['php'].$_SESSION['phpnuke'].'forums WHERE forum_id>'.$start.' AND forum_type != 0 ORDER BY forum_id LIMIT '.$_SESSION['limit']) or myerror('phpBB: Unable to get table: forums', __FILE__, __LINE__, $fdb->error());
    $last_id = -1;
    while($ob = $fdb->fetch_assoc($result))
    {
        $last_id = $ob['forum_id'];
        echo $ob['forum_name'].' ('.$ob['forum_id'].")<br>\n"; flush();

        // Check for anonymous poster id problem
        $ob['forum_last_post_id'] == -1 ? $ob['forum_last_post_id'] = 1 : null;

        // Fetch user info
        $userres = $fdb->query('SELECT users.username, posts.post_time FROM '.$_SESSION['php'].'users AS users, '.$_SESSION['php'].$_SESSION['phpnuke'].'posts AS posts WHERE users.user_id=posts.poster_id AND posts.post_id='.$ob['forum_last_post_id']) or myerror("Unable to fetch user info for forum conversion.", __FILE__, __LINE__, $fdb->error());
        $userinfo = $fdb->fetch_assoc($userres);

        // Change last_post = 0 to null to prevent the time-bug.
        $userinfo['post_time'] == 0 ? $userinfo['post_time'] = 'null' : null;
        $ob['forum_last_post_id'] == 0 ? $ob['forum_last_post_id'] = 'null' : null;

        // Unset variables
        if(!isset($userinfo['username']))
            $userinfo['username'] = 'null';

        // Dataarray
        $todb = array(
            'id'                =>        $ob['forum_id'],
            'forum_name'    =>        $ob['forum_name'],
            'forum_desc'    =>        $ob['forum_desc'],
            'num_topics'    =>        $ob['forum_topics'],
            'num_posts'        =>        $ob['forum_posts'],
            'disp_position'=>        $ob['forum_order'],
            'last_poster'    =>        $userinfo['username'],
            'last_post_id'    =>        $ob['forum_last_post_id'],
            'last_post'        =>        $userinfo['post_time'],
            'cat_id'            =>        $ob['parent_id'],
        );

        // Save data
        insertdata('forums', $todb, __FILE__, __LINE__);
    }

    // We move all subforums into a new category: they'll have to be properly organized by hand
    $db->query('INSERT INTO '.$_SESSION['pun'].'categories (cat_name, disp_position) VALUES ("Subforums", 100)') or myerror('PunBB: Unable to create subforum category', __FILE__, __LINE__, $fdb->error());
    $db->query('UPDATE '.$_SESSION['pun'].'forums AS f LEFT JOIN '.$_SESSION['pun'].'categories AS c ON (f.cat_id = c.id) SET f.cat_id = '.$db->insert_id().' WHERE c.id IS NULL') or myerror('PunBB: Unable to move subforums to new category', __FILE__, __LINE__, $fdb->error());

    convredirect('forum_id', $_SESSION['phpnuke'].'forums', $last_id);

?>

File: /homepages/36/d175509457/htdocs/shadow/punbb/converter/PhpBB/forums.php
Line: 41

Converter reported: Unable to save to database.

Query: INSERT INTO `xxxxxxxxxx`.PUNBB_forums (id,forum_name,forum_desc,num_topics,num_posts,last_poster,last_post_id,last_post,cat_id) VALUES('1','xxxxxxx','xxxxxxxxxxx','16','20','drndadoo','141','1187343698','17')

Database reported: Duplicate entry '1' for key 1 (Errno: 1062)