$dbh->do('INSERT INTO images (id,event,uploadedby,takenby,filename) VALUES (?,?,?,?,?);',
undef, $newid, $event, $user, $takenby, $filename);
+ $dbh->do('UPDATE events SET last_update=CURRENT_TIMESTAMP WHERE id=?',
+ undef, $event);
# Now save the file to disk
$fname = Sesse::pr0n::Common::get_disk_location($r, $newid);
if ($@) {
# Some error occurred, rollback and bomb out
$dbh->rollback;
- dberror($r, "Transaction aborted because $@");
+ error($r, "Transaction aborted because $@");
unlink($fname);
}
}
$dbh->do('DELETE FROM images WHERE event=? AND filename=?;',
undef, $event, $filename)
or dberror($r, "Couldn't remove file");
+ $dbh->do('UPDATE events SET last_update=CURRENT_TIMESTAMP WHERE id=?',
+ undef, $event)
+ or dberror($r, "Couldn't invalidate cache");
$r->status(200);
$r->print("OK");