From a8cabbd600f2bf4e3ecd8b48d726f9c1036d9f93 Mon Sep 17 00:00:00 2001
From: MW
Date: Fri, 8 Jun 2007 16:49:24 +0000
Subject: Deleted OpenGridServices folder as the easiest way to reimport the
latest version from trunk
---
.../OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs | 136 ----------------
.../OpenGrid.Framework.Data.MSSQL/MSSQLManager.cs | 171 ---------------------
.../OpenGrid.Framework.Data.MSSQL.csproj | 104 -------------
.../OpenGrid.Framework.Data.MSSQL.csproj.user | 12 --
.../OpenGrid.Framework.Data.MSSQL.dll.build | 45 ------
.../Properties/AssemblyInfo.cs | 35 -----
6 files changed, 503 deletions(-)
delete mode 100644 OpenGridServices/OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs
delete mode 100644 OpenGridServices/OpenGrid.Framework.Data.MSSQL/MSSQLManager.cs
delete mode 100644 OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.csproj
delete mode 100644 OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.csproj.user
delete mode 100644 OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.dll.build
delete mode 100644 OpenGridServices/OpenGrid.Framework.Data.MSSQL/Properties/AssemblyInfo.cs
(limited to 'OpenGridServices/OpenGrid.Framework.Data.MSSQL')
diff --git a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs b/OpenGridServices/OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs
deleted file mode 100644
index 0925df1..0000000
--- a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs
+++ /dev/null
@@ -1,136 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Text;
-using OpenGrid.Framework.Data;
-
-namespace OpenGrid.Framework.Data.MSSQL
-{
- public class SqlGridData : IGridData
- {
- private MSSqlManager database;
-
- ///
- /// Initialises the Grid Interface
- ///
- public void Initialise()
- {
- database = new MSSqlManager("localhost", "db", "user", "password", "false");
- }
-
- ///
- /// Shuts down the grid interface
- ///
- public void Close()
- {
- database.Close();
- }
-
- public string getName()
- {
- return "Sql OpenGridData";
- }
-
- public string getVersion()
- {
- return "0.1";
- }
-
- public SimProfileData[] GetProfilesInRange(uint a, uint b, uint c, uint d)
- {
- return null;
- }
-
- ///
- /// Returns a sim profile from it's location
- ///
- /// Region location handle
- /// Sim profile
- public SimProfileData GetProfileByHandle(ulong handle)
- {
- Dictionary param = new Dictionary();
- 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;
- }
-
- ///
- /// Returns a sim profile from it's UUID
- ///
- /// The region UUID
- /// The sim profile
- public SimProfileData GetProfileByLLUUID(libsecondlife.LLUUID uuid)
- {
- 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.getRow(reader);
- reader.Close();
- result.Dispose();
-
- return row;
- }
-
- public DataResponse AddProfile(SimProfileData profile)
- {
- 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;
- }
- }
-
-
-}
diff --git a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/MSSQLManager.cs b/OpenGridServices/OpenGrid.Framework.Data.MSSQL/MSSQLManager.cs
deleted file mode 100644
index 12c166c..0000000
--- a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/MSSQLManager.cs
+++ /dev/null
@@ -1,171 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Text;
-using System.Data;
-
-using System.Data.SqlClient;
-
-using OpenGrid.Framework.Data;
-
-namespace OpenGrid.Framework.Data.MSSQL
-{
- class MSSqlManager
- {
- IDbConnection dbcon;
-
- ///
- /// Initialises and creates a new Sql connection and maintains it.
- ///
- /// The Sql server being connected to
- /// The name of the Sql database being used
- /// The username logging into the database
- /// The password for the user logging in
- /// Whether to use connection pooling or not, can be one of the following: 'yes', 'true', 'no' or 'false', if unsure use 'false'.
- public MSSqlManager(string hostname, string database, string username, string password, string cpooling)
- {
- try
- {
- string connectionString = "Server=" + hostname + ";Database=" + database + ";User ID=" + username + ";Password=" + password + ";Pooling=" + cpooling + ";";
- dbcon = new SqlConnection(connectionString);
-
- dbcon.Open();
- }
- catch (Exception e)
- {
- throw new Exception("Error initialising Sql Database: " + e.ToString());
- }
- }
-
- ///
- /// Shuts down the database connection
- ///
- public void Close()
- {
- dbcon.Close();
- dbcon = null;
- }
-
- ///
- /// Runs a query with protection against SQL Injection by using parameterised input.
- ///
- /// The SQL string - replace any variables such as WHERE x = "y" with WHERE x = @y
- /// The parameters - index so that @y is indexed as 'y'
- /// A Sql DB Command
- public IDbCommand Query(string sql, Dictionary parameters)
- {
- SqlCommand dbcommand = (SqlCommand)dbcon.CreateCommand();
- dbcommand.CommandText = sql;
- foreach (KeyValuePair param in parameters)
- {
- dbcommand.Parameters.AddWithValue(param.Key, param.Value);
- }
-
- return (IDbCommand)dbcommand;
- }
-
- public SimProfileData getRow(IDataReader reader)
- {
- SimProfileData retval = new SimProfileData();
-
- if (reader.Read())
- {
- // 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; // Needs to be pinged before this can be set.
- retval.serverIP = (string)reader["serverIP"];
- retval.serverPort = (uint)reader["serverPort"];
- retval.serverURI = (string)reader["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"];
-
- // Assets
- retval.regionAssetURI = (string)reader["regionAssetURI"];
- retval.regionAssetRecvKey = (string)reader["regionAssetRecvKey"];
- retval.regionAssetSendKey = (string)reader["regionAssetSendKey"];
-
- // Userserver
- retval.regionUserURI = (string)reader["regionUserURI"];
- retval.regionUserRecvKey = (string)reader["regionUserRecvKey"];
- retval.regionUserSendKey = (string)reader["regionUserSendKey"];
- }
- else
- {
- throw new Exception("No rows to return");
- }
- return retval;
- }
-
- public bool insertRow(SimProfileData profile)
- {
- string sql = "REPLACE INTO regions VALUES (regionHandle, regionName, uuid, regionRecvKey, regionSecret, regionSendKey, regionDataURI, ";
- sql += "serverIP, serverPort, serverURI, locX, locY, locZ, eastOverrideHandle, westOverrideHandle, southOverrideHandle, northOverrideHandle, regionAssetURI, regionAssetRecvKey, ";
- sql += "regionAssetSendKey, regionUserURI, regionUserRecvKey, regionUserSendKey) VALUES ";
-
- sql += "(@regionHandle, @regionName, @uuid, @regionRecvKey, @regionSecret, @regionSendKey, @regionDataURI, ";
- sql += "@serverIP, @serverPort, @serverURI, @locX, @locY, @locZ, @eastOverrideHandle, @westOverrideHandle, @southOverrideHandle, @northOverrideHandle, @regionAssetURI, @regionAssetRecvKey, ";
- sql += "@regionAssetSendKey, @regionUserURI, @regionUserRecvKey, @regionUserSendKey);";
-
- Dictionary parameters = new Dictionary();
-
- parameters["regionHandle"] = profile.regionHandle.ToString();
- parameters["regionName"] = profile.regionName;
- parameters["uuid"] = profile.UUID.ToString();
- parameters["regionRecvKey"] = profile.regionRecvKey;
- parameters["regionSendKey"] = profile.regionSendKey;
- parameters["regionDataURI"] = profile.regionDataURI;
- parameters["serverIP"] = profile.serverIP;
- parameters["serverPort"] = profile.serverPort.ToString();
- parameters["serverURI"] = profile.serverURI;
- parameters["locX"] = profile.regionLocX.ToString();
- parameters["locY"] = profile.regionLocY.ToString();
- parameters["locZ"] = profile.regionLocZ.ToString();
- parameters["eastOverrideHandle"] = profile.regionEastOverrideHandle.ToString();
- parameters["westOverrideHandle"] = profile.regionWestOverrideHandle.ToString();
- parameters["northOverrideHandle"] = profile.regionNorthOverrideHandle.ToString();
- parameters["southOverrideHandle"] = profile.regionSouthOverrideHandle.ToString();
- parameters["regionAssetURI"] = profile.regionAssetURI;
- parameters["regionAssetRecvKey"] = profile.regionAssetRecvKey;
- parameters["regionAssetSendKey"] = profile.regionAssetSendKey;
- parameters["regionUserURI"] = profile.regionUserURI;
- parameters["regionUserRecvKey"] = profile.regionUserRecvKey;
- parameters["regionUserSendKey"] = profile.regionUserSendKey;
-
- bool returnval = false;
-
- try
- {
- IDbCommand result = Query(sql, parameters);
-
- if (result.ExecuteNonQuery() == 1)
- returnval = true;
-
- result.Dispose();
- }
- catch (Exception e)
- {
- return false;
- }
-
- return returnval;
- }
- }
-}
diff --git a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.csproj b/OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.csproj
deleted file mode 100644
index 8d53692..0000000
--- a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.csproj
+++ /dev/null
@@ -1,104 +0,0 @@
-
-
- Local
- 8.0.50727
- 2.0
- {0A563AC1-0000-0000-0000-000000000000}
- Debug
- AnyCPU
-
-
-
- OpenGrid.Framework.Data.MSSQL
- JScript
- Grid
- IE50
- false
- Library
-
- OpenGrid.Framework.Data.MSSQL
-
-
-
-
-
- False
- 285212672
- False
-
-
- TRACE;DEBUG
-
- True
- 4096
- False
- ..\..\bin\
- False
- False
- False
- 4
-
-
-
- False
- 285212672
- False
-
-
- TRACE
-
- False
- 4096
- True
- ..\..\bin\
- False
- False
- False
- 4
-
-
-
-
- System.dll
- False
-
-
- System.Xml.dll
- False
-
-
- System.Data.dll
- False
-
-
- ..\..\bin\libsecondlife.dll
- False
-
-
-
-
- OpenGrid.Framework.Data
- {62CDF671-0000-0000-0000-000000000000}
- {FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}
- False
-
-
-
-
- Code
-
-
- Code
-
-
- Code
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.csproj.user b/OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.csproj.user
deleted file mode 100644
index 9bfaf67..0000000
--- a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.csproj.user
+++ /dev/null
@@ -1,12 +0,0 @@
-
-
- Debug
- AnyCPU
- C:\New Folder\second-life-viewer\opensim-dailys2\opensim26-05\branches\Sugilite\bin\
- 8.0.50727
- ProjectFiles
- 0
-
-
-
-
diff --git a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.dll.build b/OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.dll.build
deleted file mode 100644
index 5b6b75b..0000000
--- a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/OpenGrid.Framework.Data.MSSQL.dll.build
+++ /dev/null
@@ -1,45 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/Properties/AssemblyInfo.cs b/OpenGridServices/OpenGrid.Framework.Data.MSSQL/Properties/AssemblyInfo.cs
deleted file mode 100644
index bbe3cdf..0000000
--- a/OpenGridServices/OpenGrid.Framework.Data.MSSQL/Properties/AssemblyInfo.cs
+++ /dev/null
@@ -1,35 +0,0 @@
-using System.Reflection;
-using System.Runtime.CompilerServices;
-using System.Runtime.InteropServices;
-
-// General Information about an assembly is controlled through the following
-// set of attributes. Change these attribute values to modify the information
-// associated with an assembly.
-[assembly: AssemblyTitle("OpenGrid.Framework.Data.MSSQL")]
-[assembly: AssemblyDescription("")]
-[assembly: AssemblyConfiguration("")]
-[assembly: AssemblyCompany("")]
-[assembly: AssemblyProduct("OpenGrid.Framework.Data.MSSQL")]
-[assembly: AssemblyCopyright("Copyright © 2007")]
-[assembly: AssemblyTrademark("")]
-[assembly: AssemblyCulture("")]
-
-// Setting ComVisible to false makes the types in this assembly not visible
-// to COM components. If you need to access a type in this assembly from
-// COM, set the ComVisible attribute to true on that type.
-[assembly: ComVisible(false)]
-
-// The following GUID is for the ID of the typelib if this project is exposed to COM
-[assembly: Guid("0e1c1ca4-2cf2-4315-b0e7-432c02feea8a")]
-
-// Version information for an assembly consists of the following four values:
-//
-// Major Version
-// Minor Version
-// Build Number
-// Revision
-//
-// You can specify all the values or you can default the Revision and Build Numbers
-// by using the '*' as shown below:
-[assembly: AssemblyVersion("1.0.0.0")]
-[assembly: AssemblyFileVersion("1.0.0.0")]
--
cgit v1.1