From: Steinar H. Gunderson <sesse@debian.org>
Date: Fri, 5 Jan 2007 21:19:41 +0000 (+0100)
Subject: Make sure rotation and selection invalidate the listing cache.
X-Git-Url: https://git.sesse.net/?p=pr0n;a=commitdiff_plain;h=b9c62b0e96eb2b04cf0f4355174831606f982f18

Make sure rotation and selection invalidate the listing cache.
---

diff --git a/perl/Sesse/pr0n/Index.pm b/perl/Sesse/pr0n/Index.pm
index de0e3bf..41b4db1 100644
--- a/perl/Sesse/pr0n/Index.pm
+++ b/perl/Sesse/pr0n/Index.pm
@@ -159,6 +159,7 @@ sub handler {
 		# Print out all thumbnails
 		if ($rot == 1) {
 			$r->print("    <form method=\"post\" action=\"/rotate\">\n");
+			$r->print("      <input type=\"hidden\" name=\"event\" value=\"$event\" />\n");
 		
 			while (my $ref = $q->fetchrow_hashref()) {
 				my $imgsz = "";
diff --git a/perl/Sesse/pr0n/Rotate.pm b/perl/Sesse/pr0n/Rotate.pm
index 59103e7..9cf18d8 100644
--- a/perl/Sesse/pr0n/Rotate.pm
+++ b/perl/Sesse/pr0n/Rotate.pm
@@ -63,6 +63,10 @@ sub handler {
 			}
 		}
 	}
+	
+	my $event = $apr->param('event');
+	$dbh->do('UPDATE events SET last_update=CURRENT_TIMESTAMP WHERE id=?', undef, $event)
+		or dberror($r, "Cache invalidation failed");
 
 	Sesse::pr0n::Common::footer($r);
 
diff --git a/perl/Sesse/pr0n/Select.pm b/perl/Sesse/pr0n/Select.pm
index 777e02b..21dca6a 100644
--- a/perl/Sesse/pr0n/Select.pm
+++ b/perl/Sesse/pr0n/Select.pm
@@ -44,6 +44,9 @@ sub handler {
 		}
 	}
 
+	$dbh->do('UPDATE events SET last_update=CURRENT_TIMESTAMP WHERE id=?', undef, $event)
+		or dberror($r, "Cache invalidation failed");
+
 	Sesse::pr0n::Common::footer($r);
 
 	return Apache2::Const::OK;