commit: d52d8dda5354b945ef6b5916237d93b4d582f97e
Author: Robin H. Johnson <robbat2 <AT> gentoo <DOT> org>
AuthorDate: Mon Dec 10 07:16:22 2018 +0000
Commit: Robin H. Johnson <robbat2 <AT> gentoo <DOT> org>
CommitDate: Mon Dec 10 07:16:22 2018 +0000
URL: https://gitweb.gentoo.org/proj/bouncer.git/commit/?id=d52d8dda
sentry: set last_check timestamp
Signed-off-by: Robin H. Johnson <robbat2 <AT> gentoo.org>
perl/sentry.pl | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/perl/sentry.pl b/perl/sentry.pl
index ad82570..c0cf4ff 100755
--- a/perl/sentry.pl
+++ b/perl/sentry.pl
@@ -31,7 +31,7 @@ my $dbh = DBI->connect( "DBI:mysql:$db:$host",$user,$pass) or
die "Connecting :
$location_sql = qq{SELECT * FROM mirror_locations JOIN mirror_products USING
(product_id) WHERE product_priority > 0 ORDER BY product_priority DESC};
#$mirror_sql = qq{SELECT * FROM mirror_mirrors WHERE mirror_active IN ('1')
ORDER BY mirror_rating DESC, mirror_name};
$mirror_sql = qq{SELECT * FROM mirror_mirrors WHERE mirror_active IN ('1')
ORDER BY RAND()};
-$update_sql = qq{REPLACE mirror_location_mirror_map SET
location_id=?,mirror_id=?,location_active=?};
+$update_sql = qq{REPLACE mirror_location_mirror_map SET location_id=?,
mirror_id=?, location_active=?, last_check=NOW()};
my $location_sth = $dbh->prepare($location_sql);
my $mirror_sth = $dbh->prepare($mirror_sql);
