Search and Replace in post and user table

This hack do a simple search and replace over your post table (pagetext column) and user table (signature column).

I needed to run a search and replace on an old URL we were using and find the replace query for it and put a little frontend around it.

Please feel free to add your comments on this.

Its tested on a vB 2.2.5 with about ~2000 user and ~410000 posts.


If you like to add it to your admin CP open index.php and find:

PHP Code:

makenavselect("Announcements");
//++++ 

and replace it with

PHP Code:

makenavselect("Announcements");
//++++
makenavoption("Start","replace_in_posts.php?action=modify");
makenavselect("Search and Replace");
//++++ 

Upload the attached file to your /admin/ folder.

THIS HACKS DOES A SEARCH AND REPLACE OVER YOUR POST AND USER TABLE!!! DON'T USE THIS HACK IF YOU DON'T HAVE A BACKUP OF YOUR DATABASE! I'M NOT RESPONSIBLE FOR ANY DAMAGE YOU PUT TO YOUR DATABASE BY USING THIS HACK!!!

[the_sisko]

Sreenshot

[Xenon]

not bad sisko, i'm sure many users can use this

[Floris]

I know I certainly want this. Thank you! Will use it later tonight..

[Dean C]

im a bit confused as to what this does...?

[FleaBag]

This is cool for updating redundant smilie code.

[Streicher]

Originally posted by Mist
im a bit confused as to what this does...?

This hack does a Search & Replace through your post table. For example you want to replace the word "infopop" with "vBulletin" in all the postings in your forum, you simply can use this hack. It works also with parts of URL's. You need only seconds for it.

I love it.

[The Ghost]

I searched so long for this hack! We've imported Posts from a DCForum, so we have a many bad urls........

thx thx thx! Great Hack!!

[Chris M]

Cool

Satan

[MalaK_3araby]

the_Sisko

I have always wanted this .. i need to do mass Find/Replace for tags that i used once but not any more ..

a BIG Thank You ..

* installs *