O'Reilly logo

Building Forums with vBulletin by Kathy Kingsley-Hughes, Adrian Kingsley-Hughes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Global Post Text Find and Replace

This is something that many board administrators want to do but aren't sure how—messing with the database directly seems dangerous to many. It is quite simple though, and you can do it all through the AdminCP.

Log into the AdminCP, and in the left-hand menu click on Import & Maintenance followed by Execute SQL Query. If you are greeted with a message that says: You are not authorized to execute SQL queries you will need to add your user ID number to the line: $canrunqueries = ''; in the includes/config.php file. For example, if your user ID is 1, this line will become: $canrunqueries = '1';

Now you can run queries. To carry out a find and replace on all the post data in your board, you will need to run an SQL query ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required