- $dbh->do('UPDATE events SET last_update=CURRENT_TIMESTAMP WHERE event=( SELECT event FROM images WHERE id=? )',
+ $dbh->do('UPDATE last_picture_cache SET last_update=CURRENT_TIMESTAMP WHERE (vhost,event)=( SELECT vhost,event FROM images WHERE id=? )',
undef, $id);
$dbh->do('INSERT INTO deleted_images SELECT * FROM images WHERE id=?',
undef, $id);
$dbh->do('INSERT INTO deleted_images SELECT * FROM images WHERE id=?',
- undef, $id);
+ undef, $id);
+ $dbh->do('DELETE FROM exif_info WHERE image=?',
+ undef, $id);
$dbh->do('DELETE FROM images WHERE id=?',
$dbh->do('DELETE FROM images WHERE id=?',
- undef, $id);
+ undef, $id);
};
if ($@) {
# Some error occurred, rollback and bomb out
$dbh->rollback;
};
if ($@) {
# Some error occurred, rollback and bomb out
$dbh->rollback;
- dberror($r, "Transaction aborted because $@");
+ return dberror($r, "Transaction aborted because $@");
}
}
}
}
- $r->print(" <p>Deleted image `$id'.</p>\n");
+ $io->print(" <p>Deleted image `$id'.</p>\n");
}
}
}
}
}
}
+
+ my $event = $r->param('event');
+ $dbh->do('UPDATE last_picture_cache SET last_update=CURRENT_TIMESTAMP WHERE vhost=? AND event=?', undef, Sesse::pr0n::Common::get_server_name($r), $event)
+ or return dberror($r, "Cache invalidation failed");