X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=perl%2FSesse%2Fpr0n%2FRotate.pm;h=0733cecb21f5eed78cbbf36af3f6fca41dfd4398;hp=923e5df1cc5149143569c1773f949eb9f347efbc;hb=ebfa7a13cd167409442120036a159a745acc177b;hpb=2d6536cab108c937e2af49f7dcf15f2230f44d1a diff --git a/perl/Sesse/pr0n/Rotate.pm b/perl/Sesse/pr0n/Rotate.pm index 923e5df..0733cec 100644 --- a/perl/Sesse/pr0n/Rotate.pm +++ b/perl/Sesse/pr0n/Rotate.pm @@ -43,6 +43,8 @@ sub handler { { eval { + $dbh->do('UPDATE events SET last_update=CURRENT_TIMESTAMP WHERE event=( SELECT event FROM images WHERE id=? )', + undef, $id); $dbh->do('INSERT INTO deleted_images SELECT * FROM images WHERE id=?', undef, $id); $dbh->do('DELETE FROM images WHERE id=?',