From f95b6081cba084d1b067acea99c0effa2b3bf42c Mon Sep 17 00:00:00 2001
From: MW
Date: Thu, 24 May 2007 12:35:32 +0000
Subject: Renamed the new Directories. (removed the "-Source" from the end of
them)
---
.../OpenGrid.Framework.Data.MySQL/MySQLGridData.cs | 193 ---------------------
1 file changed, 193 deletions(-)
delete mode 100644 OpenGridServices-Source/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs
(limited to 'OpenGridServices-Source/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs')
diff --git a/OpenGridServices-Source/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs b/OpenGridServices-Source/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs
deleted file mode 100644
index 46183b4..0000000
--- a/OpenGridServices-Source/OpenGrid.Framework.Data.MySQL/MySQLGridData.cs
+++ /dev/null
@@ -1,193 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Text;
-using OpenGrid.Framework.Data;
-
-namespace OpenGrid.Framework.Data.MySQL
-{
- public class MySQLGridData : IGridData
- {
- private MySQLManager database;
-
- ///
- /// Initialises the Grid Interface
- ///
- public void Initialise()
- {
- database = new MySQLManager("localhost", "database", "username", "password", "false");
- }
-
- ///
- /// Shuts down the grid interface
- ///
- public void Close()
- {
- database.Close();
- }
-
- public string getName()
- {
- return "MySql OpenGridData";
- }
-
- public string getVersion()
- {
- return "0.1";
- }
-
- public SimProfileData[] GetProfilesInRange(uint xmin, uint ymin, uint xmax, uint ymax)
- {
- try
- {
- lock (database)
- {
- Dictionary param = new Dictionary();
- param["?xmin"] = xmin.ToString();
- param["?ymin"] = ymin.ToString();
- param["?xmax"] = xmax.ToString();
- param["?ymax"] = ymax.ToString();
-
- System.Data.IDbCommand result = database.Query("SELECT * FROM regions WHERE locX >= ?xmin AND locX <= ?xmax AND locY >= ?ymin AND locY <= ?ymax", param);
- System.Data.IDataReader reader = result.ExecuteReader();
-
- SimProfileData row;
-
- List rows = new List();
-
- while ((row = database.getSimRow(reader)) != null)
- {
- rows.Add(row);
- }
- reader.Close();
- result.Dispose();
-
- return rows.ToArray();
-
- }
- }
- catch (Exception e)
- {
- Console.WriteLine(e.ToString());
- return null;
- }
- }
-
- ///
- /// Returns a sim profile from it's location
- ///
- /// Region location handle
- /// Sim profile
- public SimProfileData GetProfileByHandle(ulong handle)
- {
- try
- {
- lock (database)
- {
- Dictionary param = new Dictionary();
- param["?handle"] = handle.ToString();
-
- System.Data.IDbCommand result = database.Query("SELECT * FROM regions WHERE regionHandle = ?handle", param);
- System.Data.IDataReader reader = result.ExecuteReader();
-
- SimProfileData row = database.getSimRow(reader);
- reader.Close();
- result.Dispose();
-
- return row;
- }
- }
- catch (Exception e)
- {
- Console.WriteLine(e.ToString());
- return null;
- }
- }
-
- ///
- /// Returns a sim profile from it's UUID
- ///
- /// The region UUID
- /// The sim profile
- public SimProfileData GetProfileByLLUUID(libsecondlife.LLUUID uuid)
- {
- try
- {
- lock (database)
- {
- Dictionary param = new Dictionary();
- 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.getSimRow(reader);
- reader.Close();
- result.Dispose();
-
- return row;
- }
- }
- catch (Exception e)
- {
- Console.WriteLine(e.ToString());
- return null;
- }
- }
-
- public DataResponse AddProfile(SimProfileData profile)
- {
- lock (database)
- {
- if (database.insertRow(profile))
- {
- return DataResponse.RESPONSE_OK;
- }
- else
- {
- return DataResponse.RESPONSE_ERROR;
- }
- }
- }
-
- ///
- /// DEPRECIATED. Attempts to authenticate a region by comparing a shared secret.
- ///
- /// The UUID of the challenger
- /// The attempted regionHandle of the challenger
- /// The secret
- /// Whether the secret and regionhandle match the database entry for UUID
- public bool AuthenticateSim(libsecondlife.LLUUID uuid, ulong handle, string authkey)
- {
- bool throwHissyFit = false; // Should be true by 1.0
-
- if (throwHissyFit)
- throw new Exception("CRYPTOWEAK AUTHENTICATE: Refusing to authenticate due to replay potential.");
-
- SimProfileData data = GetProfileByLLUUID(uuid);
-
- return (handle == data.regionHandle && authkey == data.regionSecret);
- }
-
- ///
- /// NOT YET FUNCTIONAL. Provides a cryptographic authentication of a region
- ///
- /// This requires a security audit.
- ///
- ///
- ///
- ///
- ///
- public bool AuthenticateSim(libsecondlife.LLUUID uuid, ulong handle, string authhash, string challenge)
- {
- System.Security.Cryptography.SHA512Managed HashProvider = new System.Security.Cryptography.SHA512Managed();
- System.Text.ASCIIEncoding TextProvider = new ASCIIEncoding();
-
- byte[] stream = TextProvider.GetBytes(uuid.ToStringHyphenated() + ":" + handle.ToString() + ":" + challenge);
- byte[] hash = HashProvider.ComputeHash(stream);
-
- return false;
- }
- }
-
-
-}
--
cgit v1.1