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