The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
I migrated from phpbb and I have lots of wrong links in posts, that point to the non-existant viewtopic.php page (same thing as showthread.php in vB).
I would like to remove all those links from posts. What SQL queries do I need to run? Any help would be greatly appreciated. |
#2
|
||||
|
||||
![]()
It's best to ask these sort of questions in the importing forums at http://www.vbulletin.com
|
#3
|
|||
|
|||
![]()
[sql]UPDATE post SET pagetext = REPLACE (pagetext,'old-string','new-string') WHERE pagetext LIKE '%old-string%';[/sql]
Just edit the above and replace 'old-string' (twice) with the link you want to replace, and 'new-string' with the new link. |
#4
|
|||
|
|||
![]()
It works. Thanks very much Marco.
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|