Turn your Forum Off-Line!
Backup the Db and Add DROP TABLE / DROP VIEW
- then make a copy and keep it safe.
Find and copy these two tables to an editor - Wordpad?
Table structure for table `ip_posts_text`
Dump the data for table `ip_posts_text`
Using "Search and Replace"
Find [hide] replace with nothing
Find [/hide] replace with nothing
Save As "TEXT ONLY FORMAT" - SQL the file to the database.
You will need to clear all caches in the ACP > Configuration > Clear Cache - (These Two) etc:
1. If you click yes, all files in main cache folder will be permanently deleted
2. If you click yes, precompiled posts field in posts table will be permanently deleted.
3. Possibly Clear the browser cache and Cookies too.
Be aware that Editors can truncate large files - Make sure the end of the edited file is the same as before you started editing it.