From e189b3056fff7223f6474bc26af559ef32891fa6 Mon Sep 17 00:00:00 2001
From: Melanie
Date: Sun, 10 Jan 2010 02:13:55 +0000
Subject: Add last_seen field to regions table

---
 OpenSim/Data/MySQL/Resources/006_GridStore.sql | 5 +++++
 OpenSim/Services/GridService/GridService.cs    | 2 ++
 2 files changed, 7 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/006_GridStore.sql

diff --git a/OpenSim/Data/MySQL/Resources/006_GridStore.sql b/OpenSim/Data/MySQL/Resources/006_GridStore.sql
new file mode 100644
index 0000000..91322d6
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/006_GridStore.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE `regions` ADD COLUMN `last_seen` integer NOT NULL DEFAULT 0;
+
+COMMIT;
diff --git a/OpenSim/Services/GridService/GridService.cs b/OpenSim/Services/GridService/GridService.cs
index 3ae51e4..9bf986e 100644
--- a/OpenSim/Services/GridService/GridService.cs
+++ b/OpenSim/Services/GridService/GridService.cs
@@ -139,6 +139,7 @@ namespace OpenSim.Services.GridService
 
             try
             {
+                rdata.Data["last_seen"] = Util.UnixTimeSinceEpoch();
                 m_Database.Store(rdata);
             }
             catch (Exception e)
@@ -164,6 +165,7 @@ namespace OpenSim.Services.GridService
                 int flags = Convert.ToInt32(region.Data["flags"]);
                 flags &= ~(int)OpenSim.Data.RegionFlags.RegionOnline;
                 region.Data["flags"] = flags.ToString();
+                region.Data["last_seen"] = Util.UnixTimeSinceEpoch();
                 try
                 {
                     m_Database.Store(region);
-- 
cgit v1.1