From 7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7 Mon Sep 17 00:00:00 2001 From: Charles Krinke Date: Sun, 17 May 2009 18:18:48 +0000 Subject: Thank you kindly, StrawberryFride, for a patch that: Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502. --- OpenSim/Data/MSSQL/MSSQLEstateData.cs | 9 +++------ 1 file changed, 3 insertions(+), 6 deletions(-) (limited to 'OpenSim/Data/MSSQL/MSSQLEstateData.cs') diff --git a/OpenSim/Data/MSSQL/MSSQLEstateData.cs b/OpenSim/Data/MSSQL/MSSQLEstateData.cs index 3002fe3..1b0151d 100644 --- a/OpenSim/Data/MSSQL/MSSQLEstateData.cs +++ b/OpenSim/Data/MSSQL/MSSQLEstateData.cs @@ -108,7 +108,7 @@ namespace OpenSim.Data.MSSQL { cmd.Parameters.Add(_Database.CreateParameter("@RegionID", regionID)); - using (IDataReader reader = cmd.ExecuteReader()) + using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { @@ -323,7 +323,7 @@ namespace OpenSim.Data.MSSQL idParameter.Value = es.EstateID; cmd.Parameters.Add(idParameter); - using (IDataReader reader = cmd.ExecuteReader()) + using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { @@ -351,7 +351,7 @@ namespace OpenSim.Data.MSSQL { cmd.Parameters.Add(_Database.CreateParameter("@EstateID", estateID)); - using (IDataReader reader = cmd.ExecuteReader()) + using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { @@ -385,11 +385,8 @@ namespace OpenSim.Data.MSSQL foreach (EstateBan b in es.EstateBans) { cmd.Parameters.Add(_Database.CreateParameter("@EstateID", es.EstateID)); - cmd.Parameters.Add(_Database.CreateParameter("@bannedUUID", b.BannedUserID)); - cmd.ExecuteNonQuery(); - cmd.Parameters.Clear(); } } -- cgit v1.1