.title {
color:white;
background-color:black;
}
.red {
color:white;
background-color:red;
}
.green {
color:white;
background-color:green;
}
EOT;
echo "
";
foreach ($changes as $key => $change) {
echo "";
echo "Key: $key | ";
echo "From: {$change[0]} | ";
echo "To: {$change[1]} | ";
echo "
";
$query_sql="SELECT filepath,pid,filename FROM {$CONFIG['TABLE_PICTURES']} WHERE filepath LIKE '%{$change[0]}%'";
$results=cpg_db_query($query_sql);
echo "";
echo "pid | ";
echo "filepath | ";
echo "filename | ";
echo "
";
while ($row = mysql_fetch_assoc($results)) {
$row['filepath']=addslashes(str_replace($change[0],$change[1],$row['filepath']));
$update_sql="UPDATE {$CONFIG['TABLE_PICTURES']} SET filepath='{$row['filepath']}' WHERE pid='{$row['pid']}' LIMIT 1";
$update_results=cpg_db_query($update_sql);
if ($update_results) {
$class="green";
} else {
$class="red";
}
echo "";
echo "{$row["pid"]} | ";
echo "{$row["filepath"]} | ";
echo "{$row["filename"]} | ";
echo "
";
}
}
echo "
";
pagefooter();
ob_end_flush();
?>