Importing Custom BBCodes from PHPBB3 Broken, SQL Query Help Needed

[nycaviation]

Hello,

I am importing a board from PHPBB3 which had a few custom BBCodes in use.

For some reason, impex appends random characters into these bbcodes in posts.

For example,

[airliners]1746000[/airliners]

becomes

[airliners:212cgqdu]1746000[/airliners:212cgqdu]

I attempted to fix this by modifying an SQL query found in another thread...

UPDATE 
    post 
SET 
    pagetext = replace( pagetext, substring( pagetext, locate( '[airliners', pagetext ) , 17 ) , '[airliners' ) 
WHERE 
    LOCATE( '[airliners', pagetext ) >0

...but this still left two stray characters.

Can anyone help please?

Thanks!

[Wayne Luke]

The best way to clean up BBCode and HTML is with cleaner.php. You can find the documentation here:

http://www.vbulletin.com/docs/html/impex_cleaner