Semi-functional (in theory!)

2 files changed, 32 insertions, 4 deletions

diff --git a/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs b/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs
index 65a0fff..7a78800 100644
--- a/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs
+++ b/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs
@@ -15,15 +15,40 @@ namespace OpenGrid.Framework.Data.MySQL
         }

         public SimProfileData GetProfileByHandle(ulong handle)

         {

-            return new SimProfileData();

+            Dictionary<string,string> param = new Dictionary<string,string>();

+            param["handle"] = handle.ToString();

+

+            System.Data.IDbCommand result = database.Query("SELECT * FROM regions WHERE handle = @handle", param);

+            System.Data.IDataReader reader = result.ExecuteReader();

+

+            SimProfileData row = database.getRow( reader );

+            reader.Close();

+            result.Dispose();

+

+            return row;

         }

         public SimProfileData GetProfileByLLUUID(libsecondlife.LLUUID uuid)

         {

-            return new SimProfileData();

+            Dictionary<string, string> param = new Dictionary<string, string>();

+            param["uuid"] = uuid.ToStringHyphenated();

+

+            System.Data.IDbCommand result = database.Query("SELECT * FROM regions WHERE uuid = @uuid", param);

+            System.Data.IDataReader reader = result.ExecuteReader();

+

+            SimProfileData row = database.getRow(reader);

+            reader.Close();

+            result.Dispose();

+

+            return row;

         }

         public bool AuthenticateSim(libsecondlife.LLUUID uuid, ulong handle, string authkey)

         {

-            throw new Exception("CRYPTOWEAK AUTHENTICATE: Refusing to authenticate due to replay potential.");

+            bool throwHissyFit = false; // Should be true by 1.0

+

+            if (throwHissyFit)

+                throw new Exception("CRYPTOWEAK AUTHENTICATE: Refusing to authenticate due to replay potential.");

+

+            return true;

         }

 

         /// <summary>

diff --git a/OpenGrid.Framework.Data.MySQL/MySQLManager.cs b/OpenGrid.Framework.Data.MySQL/MySQLManager.cs
index 30ad314..1d912e7 100644
--- a/OpenGrid.Framework.Data.MySQL/MySQLManager.cs
+++ b/OpenGrid.Framework.Data.MySQL/MySQLManager.cs
@@ -9,6 +9,8 @@ using MySql.Data;
 using MySql.Data.Types;

 using MySql.Data.MySqlClient;

 

+using OpenGrid.Framework.Data;

+

 namespace OpenGrid.Framework.Data.MySQL

 {

     class MySQLManager

@@ -71,7 +73,8 @@ namespace OpenGrid.Framework.Data.MySQL
 

             if (reader.Read())

             {

-                //retval.regionDataURI = reader["regionDataURI"];

+                retval.regionLocX = (uint)reader["locX"];

+                retval.regionDataURI = (string)reader["regionDataURI"];

                 

             }

             else