Importing Custom BBCodes from PHPBB3 Broken, SQL Query Help Needed

[محروم.كوم]

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,

Code:
[airliners]1746000[/airliners]
becomes

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

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

Code:
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!
__DEFINE_LIKE_SHARE__