From de36b0b19903bcd95cc1ea131733e69b91b81c6b Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Date: Wed, 27 Dec 2017 11:45:46 +0100
Subject: [PATCH 1/1] Ignore old clock positions from the database.

---
 remoteglot.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/remoteglot.pl b/remoteglot.pl
index 00e4707..19f0446 100755
--- a/remoteglot.pl
+++ b/remoteglot.pl
@@ -1275,7 +1275,7 @@ sub find_clock_start {
 	}
 
 	my $id = id_for_pos($pos);
-	my $clock_info = $dbh->selectrow_hashref('SELECT * FROM clock_info WHERE id=?', undef, $id);
+	my $clock_info = $dbh->selectrow_hashref('SELECT * FROM clock_info WHERE id=? AND COALESCE(white_clock_target, black_clock_target) >= EXTRACT(EPOCH FROM (CURRENT_TIMESTAMP - INTERVAL \'1 day\'));', undef, $id);
 	if (defined($clock_info)) {
 		$pos->{'white_clock'} //= $clock_info->{'white_clock'};
 		$pos->{'black_clock'} //= $clock_info->{'black_clock'};
-- 
2.39.2