From 11e3c3fe829a6862e90e6bf752cc2555cdc1c2ab Mon Sep 17 00:00:00 2001
From: Adam Frisby
Date: Fri, 4 May 2007 04:03:04 +0000
Subject: MySQL could now work in theory. Any testers?

---
 OpenGrid.Framework.Data.MySQL/MySQLManager.cs | 28 +++++++++++++++++++++++++--
 1 file changed, 26 insertions(+), 2 deletions(-)

(limited to 'OpenGrid.Framework.Data.MySQL/MySQLManager.cs')

diff --git a/OpenGrid.Framework.Data.MySQL/MySQLManager.cs b/OpenGrid.Framework.Data.MySQL/MySQLManager.cs
index 1d912e7..ec69549 100644
--- a/OpenGrid.Framework.Data.MySQL/MySQLManager.cs
+++ b/OpenGrid.Framework.Data.MySQL/MySQLManager.cs
@@ -73,9 +73,33 @@ namespace OpenGrid.Framework.Data.MySQL
 
             if (reader.Read())
             {
-                retval.regionLocX = (uint)reader["locX"];
+                // Region Main
+                retval.regionHandle = (ulong)reader["regionHandle"];
+                retval.regionName = (string)reader["regionName"];
+                retval.UUID = new libsecondlife.LLUUID((string)reader["uuid"]);
+
+                // Secrets
+                retval.regionRecvKey = (string)reader["regionRecvKey"];
+                retval.regionSecret = (string)reader["regionSecret"];
+                retval.regionSendKey = (string)reader["regionSendKey"];
+
+                // Region Server
                 retval.regionDataURI = (string)reader["regionDataURI"];
-                
+                retval.regionOnline = false;
+                retval.serverIP = "";
+                retval.serverPort = 0;
+                retval.serverURI = "";
+
+                // Location
+                retval.regionLocX = (uint)((int)reader["locX"]);
+                retval.regionLocY = (uint)((int)reader["locY"]);
+                retval.regionLocZ = (uint)((int)reader["locZ"]);
+
+                // Neighbours - 0 = No Override
+                retval.regionEastOverrideHandle = (ulong)reader["eastOverrideHandle"];
+                retval.regionWestOverrideHandle = (ulong)reader["westOverrideHandle"];
+                retval.regionSouthOverrideHandle = (ulong)reader["southOverrideHandle"];
+                retval.regionNorthOverrideHandle = (ulong)reader["northOverrideHandle"];
             }
             else
             {
-- 
cgit v1.1