Announcement

Collapse
No announcement yet.

WBB -> VB Converter ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • WBB -> VB Converter ?

    Has anyone came up with this converter yet?

    I was Running a Free Board Called WBB( VB's Clone) but i want to get off it now..cause..WBB has more bugs than Gardens, and they just suck period. I Just Recently purchased a VB, and i know i'll get my moneys worth. But i just dont want to lose any posts from my WBB Board when i switch to VB..

    So if theres a converter out there, Can someone help me out

    i'd really appreciate it

    thanks

  • #2
    This is not available at the moment - though you might want to check at vBulletin.org in case there is an unofficial one available.

    Comment


    • #3
      WBB is pretty close to an exact copy of VB. I would just upload the new files overtip of the new one, and it might just work.

      Comment


      • #4
        Nah, won't work at all, database is totally different.

        I wrote a script that imports the threads and posts, but thats it. I am working on users right now.

        Here it is:

        PHP Code:
        <?php

        $dbfrom 
        "old_db"// can be the same as $dbto
        $dbto "new_db";
        $dbhost "localhost";
        $dbuser "username";
        $dbpass "password";

        $conn mysql_connect($dbhost$dbuser$dbpass) or die("failed to connect");

        # do ALL of the threads first
        mysql_select_db($dbfrom);
        $sql "SELECT * FROM bb1_threads";
        $result mysql_db_query($dbfrom$sql) or die("failed to do query ".__LINE__);
        $numrows mysql_num_rows($result);

        for (
        $i=0$i<$numrows$i++)
        {
            
        mysql_select_db($dbto);
            
        $a mysql_fetch_array($result);
            
            
        $sql "INSERT INTO thread(threadid, title, lastpost, forumid, pollid, open, replycount, postusername, postuserid, lastposter, dateline, views, iconid, notes, visible, sticky, votenum, votetotal, attach) VALUES ('$a[2]', '$a[3]', '$a[9]', '$a[0]', '0', '1', '$a[7]', '$a[5]', '0', '$a[6]', '".time()."', '$a[8]', '0', '', '1', '0', '0', '0', '0')";
            
        mysql_db_query($dbto$sql) or die("failed query ".__LINE__);
        }

        # now that thats done, do the posts
        mysql_select_db($dbfrom);
        $sql "SELECT * FROM bb1_posts";
        $result mysql_db_query($dbfrom$sql) or die("failed to do query".__LINE__);
        $numrows mysql_num_rows($result);

        for (
        $i=0$i<$numrows$i++)
        {
            
        mysql_select_db($dbto);
            
        $a mysql_fetch_array($result);
            
            
        $sql "INSERT INTO post(postid, threadid, username, userid, title, dateline, attachmentid, pagetext, allowsmilie, showsignature, ipaddress, iconid, visible, edituserid, editdate) VALUES ('$a[2]', '$a[1]', '', '$a[3]', '$a[7]', '".time()."', '0', '$a[8]', '$a[10]', '$a[11]', '$a[12]', '0', '1', '$a[6]', '$a[5]')";
            
        mysql_db_query($dbto$sql) or die("failed query ".__LINE__);
        }

        ?>
        Tell me if you have any luck with it. It worked decently for me.

        -Vic

        Comment


        • #5
          thanks, i'll try that script out..

          if you get done or find a way for the members converter
          can you post it here or contact me

          [email protected]
          or
          AIM: o0keyw0rdz0o

          Thanks

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X