[FrozenBlast13317]

Hello I'm having issues with a migration. I recently moved from phpbb 3.0 to vBulletin 4.2.3.

The BBCodes from phpbb seem to be in the phpbb format. For example, I see [center:jfheidne] in many posts and such.

Would it be possible to prune these bbcodes or replace them with valid vBulletin bbcodes? Ideally I want to replace.

[Dave]

So in your example [center:jfheidne], jfheidne is the text that has to be centered?

[FrozenBlast13317]

For example,

Bbcodes would show with random letters after them. These letters vary each post even if its the same bbcode.

One code would show [s:kfbskdn]texthere[/s:kfbskdn] where is should be iust an S for strike. The issue here is that there are random letters after the bbcode value that were not here before.

I contacted vBulletin and they said I have to replace these values with vBulletin values.

Heres a post example (in phpbb 3.0 these were centered, but now the center bbcode in vBulletin shows as this:

[center:2lh05fwg]Hey everyone![/center:2lh05fwg][center:2lh05fwg]texthere[/center:2lh05fwg]

The only issue is the :randomcharacters. Anyway to mass remove these?

Looking for the right SQL query to execute, I think.

[Dave]

It's not going to be possible in a SQL query since MySQL doesn't have a regex replace function built-in but a PHP script is possible.

Create a PHP file in the root of your forum with the contents below and then visit it in the browser or execute it through the command line interface.

I recommend executing it against a test database first since I didn't test it.
Also if you have a very big database, it may timeout so you have to run it multiple times after the 360 seconds.
If there are more tags to fix that have the same formatting, change the $tagtofix variable in the script below.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[FrozenBlast13317]

Hey Dave thanks for your reply. I tried executing your php theough browser and through command line, and it didn't have any effect (it did nothing apparently?).

Any ideas? Thanks, it's really appreciated as this is the last issue we have after our impex transfer.

[MarkFL]

Originally Posted by FrozenBlast13317

Hey Dave.

Thanks for your reply. I tried executing your php theough browser and through command line, and it didn't have any effect (it did nothing apparently?).

Any ideas? Thanks, it's really appreciated as this is the last issue we have after our impex transfer.

Try editing one of the posts that doesn't appear to have been fixed...does the post appear to be fixed in the editor? If so, then this is a post caching issue.

[FrozenBlast13317]

Originally Posted by MarkFL

Try editing one of the posts that doesn't appear to have been fixed...does the post appear to be fixed in the editor? If so, then this is a post caching issue.

Hey!

I tried editing one of the posts and the tag looks broken as it was before. I tried clearing post cache but that didn't work unfortunately. Thank you for posting.

--------------- Added 10 Apr 2017 at 00:28 ---------------

Just wanted to update you Dave. It gives me a 500 server error when trying to run the code.

--------------- Added 10 Apr 2017 at 01:04 ---------------

And here was the error code I received

PHP Strict Standards: Only variables should be passed by reference

--------------- Added 10 Apr 2017 at 03:35 ---------------

And this has been solved. Thanks.

[Dave]

Glad you got it working, what was the mistake?

[FrozenBlast13317]

I fiddled with your code a bit but just couldn't seem to get it working. I'm not positive as to what the issue was - however, I managed to find the right replacement code to slap onto the cleaner tool in the impex system. Took a bit of digging. Thanks for all of your help guys.