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