From cecc743a874e1f875224965fa546031b64bb4e11 Mon Sep 17 00:00:00 2001
From: Andrew Dunstan <andrew@dunslane.net>
Date: Mon, 11 Oct 2010 17:17:45 +0000
Subject: [PATCH 1/1] record latest status date for member

---
 cgi-bin/pgstatus.pl | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)

diff --git a/cgi-bin/pgstatus.pl b/cgi-bin/pgstatus.pl
index 5896761..c1c338d 100755
--- a/cgi-bin/pgstatus.pl
+++ b/cgi-bin/pgstatus.pl
@@ -331,6 +331,32 @@ $row=$sth->fetchrow_arrayref;
 my ($os, $compiler,$arch) = @$row;
 $sth->finish;
 
+$db->begin_work;
+my $have_status = $db->selectrow_arrayref( q{
+    select 1 
+    from build_status_latest 
+    where sysname = ? and branch = ?
+}, 
+					   undef, $animal, $branch);
+if ($have_status) 
+{
+    $db->do(q{
+	      update build_status_latest
+		  set latest_snapshot = ?
+		  where sysname = ? and branch = ?
+	      },
+	    undef, $dbdate, $animal, $branch);
+}
+else
+{
+    $db->do(q{
+	      insert into build_status_latest
+		  (sysname, brancn, latest_snapshot)
+	      values (?,?,?)
+	      },
+	    undef, $dbdate, $animal, $branch);
+}
+$db->commit;
 
 $db->begin_work;
 $db->do("delete from dashboard_mat");
-- 
2.30.2