Chris Fay & Jennie Fay’s Webportal

<?php
/*
 * cleanseWordpressPosts.php
 * Script used to replace various characters displayed in posts with appropriate values
 * Written by: Chris Fay
 * 6/14/2008
 *
 * To Use: First backup your database!
 * Run the script in test mode to see what data would be cleansed
 * Change testmode to false to allow script to cleanse database 
 *
 * If you need other characters clensed then simply duplicte one of the lines that look like:
 *
 * $cleansed = str_replace("“", "", $cleansed, $count4); 
 *
 * .. and if using the example above replace the “ with the string you want to replace
 * and inside the double quotes add the value you want to replace with. 
 */
 
$dbhost = 'localhost';
$dbuser = 'dbUserNameHere'; //replace dbUserNameHere with your username
$dbpass = 'dbPasswordHere'; //replace dbPasswordHere with your user's password
$dbname = 'dbNam'; //replace dbName with the database name you want to connect to
define('TESTMODE', true); //leave true to get information on what would be updated - the database
						  //will not be touched if set to true - change to false to allow the script to modify the datbase
 
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
mysql_select_db($dbname);
 
//loop through each record, cleanse it, then re-insert it
$query  = "SELECT id, post_content FROM wp_posts";
$result = mysql_query($query);
 
if(TESTMODE) {
	echo "**** TEST MODE: No data will be modified in your database ****<br /><br />";
}
 
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{	
	$id = $row['id'];
	$unclensed = $row['post_content'];
 
	echo "Cleansing id: $id<br />";	
 
    $cleansed = str_replace("’", "'", $unclensed, $count1); 
	$cleansed = str_replace("ÂÃ", "", $cleansed, $count2); 
	$cleansed = str_replace("â€", "", $cleansed, $count3); 		
	$cleansed = str_replace("“", "", $cleansed, $count4);
	$cleansed = str_replace("…", ".", $cleansed, $count5);
	$cleansed = str_replace("’", "'", $cleansed, $count6);
	$cleansed = str_replace("â„¢", "'", $cleansed, $count7);
	$cleansed = str_replace("Å“", "", $cleansed, $count8);
	$cleansed = str_replace("˜", "'", $cleansed, $count9);
	$cleansed = str_replace("¦¦", "", $cleansed, $count10);
	$cleansed = str_replace("¦", "", $cleansed, $count11);
	$cleansed = str_replace("â€Â", " ", $cleansed, $count12);
 
	$escaped = mysql_escape_string($cleansed);
 
	if(TESTMODE) {
		echo "ID: $id would have been cleansed. <br>";
		echo "Cleanse count for each string:<br />"
			."’: $count1<br />"
			."ÂÃ: $count2<br />"
			."â€: $count3<br />"
			."“: $count4<br />"
			."…: $count5<br />"
			."’: $count6<br />"
			."â„¢: $count7<br />"
			."Å“: $count8<br />"
			."˜: $count9<br />"
			."¦¦: $count10<br />"
			."¦: $count11<br />"					  
			."â€Â: $count12<br />";
 
		$query2 = "update wp_posts set post_content = '".$escaped."' where id = '".$id."'";	  	
		echo "The insert query we'd be using:<br /> $query2<br /><br />";
	} else {
		echo "ID: $id clensed. <br>"
			."Inserting data into table<br />";
 
		$query2 = "update wp_posts set post_content = '".$escaped."' where id = '".$id."'";	  	
		mysql_query($query2) or die('Error, insert query failed');
		echo "Post cleansed and updated<br /><br />";	    
	}
} //end while
 
echo "All finished...<br />";
 
mysql_close($conn);
?>