Announcement

Collapse
No announcement yet.

Importing Custom BBCodes from PHPBB3 Broken, SQL Query Help Needed

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!

  • #2
    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
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Related Topics

    Collapse

    Working...
    X