[SUPPORT] vBulletin 3.0.x to phpBB

[D¡cky]

The vBulletin 3.0.x convertor will transfer the following:

• Forums and subforums. Subforums are placed into a new category.
• Topics
• Posts
• Users
  
• Groups
  
• Ranks
  
• Private messages
  
• Topics watch
  
• Polls
  
• Banned list
  
• Censored words

This convertor should work for all 3.0.x versions.

Download

[justinkim]

Tried converting a vBulletin DB tonight. Everything seems to have worked well except PMs. I have 5,150 PMs in my vBulletin DB and only 3,093 seem to have been converted.

[D¡cky]

vBulletin has two pm tables, a vb3_pm and a vb3_pmtext. The vb3_pm table has a lot of duplicate pm's. I am not sure why, but I used the vb3_pmtext table for the conversion. This table seems to contain all the pm's.

You may end up with even less pm's than what shows in the vb3_pmtext table as I did not convert pm's for users that are no longer a member of the board.

[justinkim]

I've only checked a few accounts so far, but all of the accounts I've checked are missing PMs. I've checked the VB database to make sure that the missing PM's are there (which they are).

I've also set the PM quota to be very high.

Thanks for your help and for writing the converter!

[D¡cky]

Are you looking at the vb3_pmtext table?
Are both the sender and receiver members of your vB board?

Keep in mind too that the user id's are different between vB and phpBB. The user id's are one higher in phpBB than vB.

[justinkim]

I did check the count of messages in the VB pmtext table and phpbb_privmsgs, and the is a difference of 29 messages. This doesn't account for all of the missing messages.

[justinkim]

Are you looking at the vb3_pmtext table?
Are both the sender and receiver members of your vB board?

Yes.

I checked the last 40 or so messages in the VB board and then checked to see if they made it to phpbb in the DB (they hadn't). I also checked the phpBB account inboxes some of those messages should have been in to make sure I didn't miss them in my queries.

There also appear to be at least a few dupes in the phpBB PM tables.

[D¡cky]

See if this works any better

conv_pm.php

Right click on the link and save to your vb3_2phpbb directory.

Then run just the pm conversion section of the convertor.

I think the id's were getting confused.

[{S'PORT}_Skillz]

Dicky,

I love you. Will be testing this out tomorrow after I get home from work. Hopefully everything works perfectly!

Thanks man! You rock!

[justinkim]

That link redirects me to http://portal.tds.net/. You may have to zip it.

[D¡cky]

That link redirects me to http://portal.tds.net/. You may have to zip it.

Try it now

conv_pm.zip

[justinkim]

Success! The new conv_pm.php file did it!

[D¡cky]

Thank you for testing. The package will be updated tonight.

[justinkim]

No, thank you for the converter and for getting me out from under the jackbooted heel of VB.

[c_erck]

The script has a number of issues...

For one you have a logic error / typo in conv_users at line 230

Code: Select all

         else
            if ($users_left == 0)
            {
               $users_left = $user_default;
            }
         {
            $sql = "SELECT m.*, mf.*, mtf.* FROM " . VB3_MEMBERS_TABLE . " m, ".VB3_MEMBERS_FIELD_TABLE." mf, ".VB3_MEMBERS_TEXTFIELD_TABLE." mtf WHERE m.userid = mf.userid AND m.userid = mtf.userid LIMIT $user_loc,$users_left ";   // on the last pass only what is left
         }


should be

Code: Select all

         else
         {
            if ($users_left == 0)
            {
               $users_left = $user_default;
            }

            $sql = "SELECT m.*, mf.*, mtf.* FROM " . VB3_MEMBERS_TABLE . " m, ".VB3_MEMBERS_FIELD_TABLE." mf, ".VB3_MEMBERS_TEXTFIELD_TABLE." mtf WHERE m.userid = mf.userid AND m.userid = mtf.userid LIMIT $user_loc,$users_left ";   // on the last pass only what is left
         }


This causes a number of users to be droped.

Another minor correction around line 131

Code: Select all

      $sql = "SELECT joindate FROM " . VB3_MEMBERS_TABLE . " where userid = 1";


Change to

Code: Select all

      $sql = "SELECT MIN(joindate) as joindate FROM " . VB3_MEMBERS_TABLE ;



Forum conversion causes all sorts of problems since it's not regarding forum categories at all, but I haven't gotten that far yet.