Strip bbcode from posts with mysql query

[Scathefire]

Hello,

I am wanting to remove formatting from post text such as font, size, and color.

sample text

I need to preserve things such as bold/italic/underline. So the above text would turn out like:

sample text


Is there a database query I could run on the posts table that would accomplish this? Can someone provide an example?

[kh99]

I don't know if there's an easy way to do it using a query, but you can use a small php script. Borrowing a nice script that Adrian posted in this thread https://vborg.vbsupport.ru/showthread.php?t=266166 , you could do something like this:

PHP Code:

<?php

error_reporting(E_ALL ^ E_NOTICE ^ 8192);

require('./global.php');

$result = $vbulletin->db->query_read("SELECT postid, pagetext FROM " . TABLE_PREFIX . "post");

while ($post = $vbulletin->db->fetch_array($result)) {    
$new = preg_replace("#\[/?(color|size|font)(=\s*\"?.*?\"?\s*)?]#i", '', $post['pagetext']);
   if ($new != $post['pagetext'])
   {
       $vbulletin->db->query_write(fetch_query_sql(
           array('pagetext' => $new),
           'post',
           'WHERE postid = ' . $post['postid']
       ));
   }
}  

die('Done');

(I tried this out, but you'd probably want to back up the db before running this, just in case).