##############################################################################
# Save the following code as a php file, and put it into the root folder of #
# your ZenPhoto installation. Make sure all the prefixes are right in the #
# MySQL queries. Enjoy! #
##############################################################################
Title/Desc Sync
0) {
echo ":: ".$filename." :: ".$no_num_results." occurances
";
}
$sub_query = "UPDATE `zp_images`
SET `title` = '".$title."'
WHERE `title` = '".$no_title."'
AND `filename` = '".$filename."'";
$sub_result = mysql_query($sub_query);
if (!$sub_result) {
$error = 1;
}
}
echo "Updated titles (".$num_results.")... ";
if ($error) {
echo "ERROR";
} else {
echo "OK";
}
echo "
";
$error = null;
//} END TITLE
//{ DESCRIPTION
// query the database
mysql_select_db($conf['mysql_database']);
$query = "SELECT DISTINCT `filename`, `desc`
FROM `zp_images`
WHERE NOT `desc` = ''
GROUP BY `filename`";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=0; $i < $num_results; $i++)
{
$row = mysql_fetch_array($result);
$filename = htmlspecialchars( stripslashes($row["filename"]));
$desc = htmlspecialchars( addslashes($row["desc"]));
$no_query = "SELECT `id`
FROM `zp_images`
WHERE `filename` = '".$filename."'
AND `desc` = ''";
$no_results = mysql_query($no_query);
$no_num_results = mysql_num_rows($no_results);
if ($no_num_results > 0) {
echo ":: ".$filename." :: ".$no_num_results." occurances
";
}
$sub_query = "UPDATE `zp_images`
SET `desc` = '".$desc."'
WHERE `desc` = ''
AND `filename` = '".$filename."'";
$sub_result = mysql_query($sub_query);
echo mysql_error();
if (!$sub_result) {
$error = 1;
}
}
echo "Updated description (".$num_results.")... ";
if ($error) {
echo "ERROR";
} else {
echo "OK";
}
echo "
";
//} END DESCRIPTION
?>