");
}
echo "Updating " . $album . " (" . $aid .")
";
$flist = $_SERVER['DOCUMENT_ROOT'] . $image_base . $_GET['flist'];
$myfile = fopen($flist, "r") or die("Unable to open " . $flist);
$county = 0;
$countn = 0;
while(!feof($myfile))
{
$row=fgets($myfile);
if (trim($row) != "")
{
$field = str_getcsv($row);
$field[1] = trim($field[1]);
$field[2] = htmlentities(trim($field[2]));
$field[3] = htmlentities(trim($field[3]));
$field[4] = trim($field[4]);
$sql = "SELECT filename FROM cpg16x_pictures WHERE aid = \"" . $aid . "\" AND filename = \"" . $field[0] . "\"";
$result = mysqli_query($conn,$sql);
if (mysqli_num_rows($result) == 0)
{
echo $field[0] . " not found in " . $album . "
";
$countn++;
}
else
{
$sql = "UPDATE cpg16x_pictures SET title=\"" . $field[1] . "\", caption=\"" . $field[2] . "\", keywords=\"" . $field[3] . "\" WHERE aid = \"" . $aid . "\" AND filename=\"" . $field[0] . "\"";
if (mysqli_query($conn,$sql))
{
echo $field[0] . " updated
";
$county++;
}
else
{
echo "Error updating " . $field[0] . ": " . mysqli_error($conn) . "
";
$countn++;
}
}
}
}
fclose($myfile);
mysqli_close($conn);
if ($county > 0)
{
echo $county . " images updated.
";
}
if ($countn > 0)
{
echo $countn . " images failed to update.
";
}
?>