The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Find and replace query
Hi,
I was wondering is there was some sort of an sql query I could run through the admin panel to find and replace test on the site... In short I merged another forum into mine and not I would like to replace the "old-forum.com" text in all the posts, hopefully by running a query instead of opening each and every post to edit the text to my current domain. making any sense? --------------- Added [DATE]1266007312[/DATE] at [TIME]1266007312[/TIME] --------------- anyone know the solution to this? |
#2
|
|||
|
|||
I assume that there is no solution to this..?
|
#3
|
|||
|
|||
I don't think there is a way to do it inside of the forums.
If it was me I'd run a replace command through phpmyadmin or export, replace and import. |
#4
|
|||
|
|||
Admin CP -> Maintenance -> Execute SQL Query
UPDATE post SET pagetext = REPLACE(pagetext, 'old-forum.com', 'new-forum.com') Be sure to do a backup first just in case you make a mistake. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|