UPDATE `mybb_posts` SET `message` = REPLACE (`message`, 'current', 'new') WHERE `message` LIKE '%current%'; 

UPDATE `mybb_posts` SET `message` = REPLACE (`message`, '<p>', '') WHERE `message` LIKE '%<p>%';

UPDATE `mybb_posts` SET `message` = REPLACE (`message`, '</p>', '') WHERE `message` LIKE '%</p>%'; 

Quote:  Please wait.........

SUCCESSFULY UPDATED ROWS: 5632

Quote:[ID 5154] ERROR WHILE EXECUTING QUERY!

<?php


	/**
	* PASS INFORMATIONS HERE
	*/
        $mysql_db_hostname = "localhost";
        $mysql_db_user = "user";
        $mysql_db_password = "password";
        $mysql_db_database = "database";
	//Tables to parse
	
	//RUN 1 - POSTS
	$table = 'mybb_posts'; //insert table name in which column to parse exists
	$id = 'pid'; //insert primary key column name for this table here
	$text = 'message'; //insert column name to parse here
	
	//RUN 2 USER SIGNATURES;
	//$table = 'mybb_users'; 
	//$id = 'uid'; 
	//$text = 'signature'; 
	
	//RUN 3 USERS PRIVATE MESSAGES
	//$table = 'mybb_privatemessages'; 
	//$id = 'pmid'; 
	//$text = 'message'; 
	
	//RUN 4 POOLS QUESTIONS
	//$table = 'mybb_polls'; 
	//$id = 'pid'; 
	//$text = 'question'; 
	
	//RUN 5 POOLS OPTIONS
	//$table = 'mybb_polls'; 
	//$id = 'pid'; 
	//$text = 'options';
	
	/**
	* END OF PASS INFORMATIONS HERE
	*/
	
	
	
    /**
	* CONNECTING TO DATABASE
	*/
    $con = @mysqli_connect($mysql_db_hostname, $mysql_db_user, $mysql_db_password,$mysql_db_database);   
    
    if (!$con) {
		echo 'shieeeeet somting went wrung - database not connected';
        trigger_error('Could not connect to MySQL: ' . mysqli_connect_error());
		exit();
    }

	/* change character set to utf8 */
	if (!$con->set_charset("utf8")) {
		printf("Error loading character set utf8: %s\n", $con->error);
		$con->close();
		exit();
	}
	/**
	* END OF CONNECTING TO DATABASE
	*/
	
	
	
	/**
	* REQUIRED INCLUDE FROM phpbb3
	*/
	define('IN_PHPBB', true);
	$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
	$phpEx = substr(strrchr(__FILE__, '.'), 1);
	include($phpbb_root_path . 'common.' . $phpEx);
	include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
	
	if (!defined('IN_PHPBB'))
	{
		$con->close();
		exit;
	}

	if (!class_exists('message_parser'))
	{
		// The following lines are for extensions which include message_parser.php
		// while $phpbb_root_path and $phpEx are out of the script scope
		// which may lead to the 'Undefined variable' and 'failed to open stream' errors
		if (!isset($phpbb_root_path))
		{
			global $phpbb_root_path;
		}
    
		if (!isset($phpEx))
		{
			global $phpEx;
		}
    
		include($phpbb_root_path . 'includes/message_parser.' . $phpEx);
	}
	/**
	* END OF REQUIRED INCLUDE FROM PHPBB3
	*/

	//DEBUG MODE COMMANDS
	ini_set('display_errors', 1);
	ini_set('display_startup_errors', 1);
	error_reporting(E_ALL);


	
	
	
	$sql = "SELECT " . $id . "," . $text . " FROM " . $table ;
    
	$var = array();
	$result = mysqli_query($con, $sql);
	while($obj = mysqli_fetch_object($result)) {
        $var[] = $obj;
    }
	
	$updated_rows_count = 0;
	
	echo "Please wait...";
	for ($i = 0; $i < count($var); $i++)
	{
	   
	   $parse = new parse_message($var[$i]->$text);
	   $parse->decode_message();
	   $parse->message = str_replace("'", "''", $parse->message);
	   //echo $parse->message;
	   
	   $update_query = "UPDATE `" . $table . "` SET `" . $text . "` = '" . $parse->message . "' WHERE `" . $id . "` = " . $var[$i]->$id;
	   //echo $update_query;
	   
	   $update = mysqli_query($con, $update_query);
	   
	   if ( mysqli_affected_rows($con) == -1 ) echo '<br />[ID ' . $var[$i]->$id . '] ERROR WHILE EXECUTING QUERY!<br />';
	   else $updated_rows_count += mysqli_affected_rows($con);
	   
	   if($i%1000 == 0) echo '.';
	}
	
	echo "<br /><br />SUCCESSFULY UPDATED ROWS: " . $updated_rows_count;
	
	$con->close();
?>