Announcement

Collapse
No announcement yet.

Replace Text/Impex Issue

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

  • prisoner 24601
    replied
    Very shiny. That seems to have worked.

    Thank you very much.

    Leave a comment:


  • Jerry
    replied
    Ah I see it now, it's semi colons between the uid and the url, as well as colons.

    Updating it now.

    Leave a comment:


  • prisoner 24601
    replied
    I just created a new database, downloaded a new copy of vBulletin 3.7 and installed, downloaded a new copy of IMPEX (1.8.9) and installed and ran the whole shebang.

    Same problem.

    By "phpbb 3 parsed" you mean the files in impex\systems\phpbb3, yes?

    Leave a comment:


  • Jerry
    replied
    I have just updated the phpBB3 parsed to deal with the new url tags.

    Leave a comment:


  • prisoner 24601
    started a topic Replace Text/Impex Issue

    Replace Text/Impex Issue

    Jake Bunce sent me this way.

    I'll recapitulate and make a couple corrections because vBulletin is actually changing what I type:

    =========

    This may be basic, but I'm a n00b.

    I recently installed vBulletin 3.7. Shiny. I then IMPEX'd a phpBB 3.0 forum.

    However, after IMPEXing, vBulletin nastily added text in some places. Particularly to links. So, all the links people posted are now in the form of ...

    [url=http://server.com;randomletters]Link[/url;randomletters]

    I'd like to run an SQL query to find and replace ...

    ;randomletters]

    with just ...

    ]

    (At least for this example. I've also got other text mishaps.)

    I have found a bit of SQL code in another thread ...

    UPDATE post
    SET pagetext = REPLACE(pagetext,'OLD TEXT','NEW TEXT')

    But this would only replace specific fulltext, not a random snippet where the only constants are ";" at the beginning and "]" at the end, like I'm wanting.

    I'm sure there are a few variables that I could use to change 'OLD TEXT' and 'NEW TEXT', but I'm a n00b and my Google-Fu is lacking for this.

    Thanks in advance!

    ===========

    I looked at this further with phpMyAdmin.

    Actual example of what's being added in the SQL code is my screenshot. I can't write it because vBulletin and phpBB changes it if I actually type it in a post.

    If you type "&# 58;" without the space in vBulletin or phpBB (like in a post), you get ":". G'head and try it and hit preview. Magic!

    See the "&# 58;" (space added)? The eight characters after this (14vj0iuv, in this example) and before the left bracket (]) are random. The "&# 58;" (space added) characters are only visable in the SQL -- but are consistent on all links.

    It's also not happening for all links. I dunno why. However, I do think that if I can find a way to do a global search and replace in SQL for those "&# 58;random]" (space added) with "]" I'd be fine.
    Attached Files
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X