Help with cleaner.php after migration

[Jean Pierre]

Hello everyone, I have a problem with my forum that I recently migrated from MyBB 1.8.5 to vBulletin 4.2.3

MyBB uses some different bbcodes to vBulletin, therefore, they have no format in posts, and therefore, the appearance thereof looks very bad.

This is solved using the file cleaner.php has so far helped me solve simple bbcodes; however, there are some bbcodes they are giving me problems as alignment, for example:

[align=center]some text[/align]
[align=left]another text this is a [b]bold[/b][/align]
[align=right]This is a text in [b]bold[/b] and this is a image[img]https://vborg.vbsupport.ru/[/img][/align]

I wonder how to fix the alignment shown in the example above, without affecting other bbcodes; I only want to have a proper alignment in vBulletin as their bbcodes alignment are:

[center]some text[/center]
[left]another text this is a [b]bold[/b][/left]
[right]This is a text in [b]bold[/b] and this is a image [img]https://vborg.vbsupport.ru/[/img][/right]

Please, help me. Thanks.

[Zachery]

Can you give me the sample data from the database?

[Jean Pierre]

Hello, thanks for your answer, Do you need the data of a complete post, of the database?
If so, I put here the code that I found in one of many posts that exist in my forum, where still the BBcode of alignment of MyBB persist.

[align=center][b][color=#000000]En esta ocasi?n quer?a hacerles muestra del nuevo tr?iler del GTA V.
Hace unos d?as se estreno a nivel mundial y se confirma lo que todos esper?bamos, estamos ante un Juegasoo..!![/color][/b][/align]

[align=center][img]https://vborg.vbsupport.ru/external/2015/09/18.jpg[/img]
[/align]

I suppose that I need to put a script in the archive cleaner.php to solve this, I hope you can help me please, thanks you in advanced.

[Jean Pierre]

Please, I really need help with this, anyone can help me?
Zachery thank you, I'm still waiting your reply.

[Dave]

It's rather tricky to do this due to the tags all using the "align" bbcode. It's possible with preg_match/replace rules but this will take a while to make. Your best shot would be to create a thread in the "paid services" section.

[Seven Skins]

Easiest way will be if you completely remove these align tags. By doing this all your text will be aligned to left .

You can run a query to remove these tags e.g.

UPDATE post SET pagetext = REPLACE(pagetext,'[align=center]','');
UPDATE post SET pagetext = REPLACE(pagetext,'[/align]','');