Eccolo, grazie!
codice:
<?
include("config.inc.php");
$db = mysql_connect($db_host, $db_user, $db_password) or die ('Connessione HOST fallita: ' . mysql_error());
mysql_select_db($db_name, $db) or die ('Selezione DB fallita: ' . mysql_error());
$query = "SELECT post_id, post_text FROM forumfanta_posts";
$result = mysql_query($query, $db);
$i=0;
while ($row = mysql_fetch_array($result)) {
$oldid = $row['post_id'];
$message = $row['post_text'];
/* echo di controllo */
echo "<font color = red>".$i." - ID: ".$oldid."=".$row['post_id']."</font> - Old: ".$message." | ";
$message = str_replace("\[/COLOR\]", "\[/color\]", $message);
$message = str_replace('[/SIZE]', '[/size]', $message);
/* echo di controllo post-mod */
echo "Messaggio new: ".$message."
";
/* UPDATE */
$queryupdate = "UPDATE forumfanta_posts SET post_text = '$message' WHERE post_id = '$oldid'";
mysql_query($queryupdate, $db);
$i++;
}
echo "Concluso. Modificati ".$i." posts";
?>