Log in

View Full Version : Global rename - is it possible with vBulletin?


yjzone.net
01-27-2007, 09:15 AM
Hi,

I have renamed my vBulletin forum from 'KGadget' to 'YJzone'.

Now, a lot of posts contain the word 'KGadget' and I wish to rename that all to 'YJzone'.

Is there a way/tool/mod which can do this 'global rename' task?

If yes, how can I do it (or where can I download this tool/mod)?

Thanks in advance,

YJ

RedTyger
01-27-2007, 10:46 AM
AdminCP > Styles & Templates > Replacement Variable Manager

ConqSoft
01-27-2007, 11:06 AM
This SQL query should do it if you want to make it a permanent change:

UPDATE post SET pagetext = REPLACE(pagetext,'OldName','NewName')

You may also have to rebuild the post cache after you run the update, which is under AdminCP -> Maintenance -> Update Counters.

Of course, as always, back up your database before doing this.

yjzone.net
01-27-2007, 12:43 PM
Cool, many thanks! :)