aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLEstateData.cs
diff options
context:
space:
mode:
authorCharles Krinke2009-05-17 18:18:48 +0000
committerCharles Krinke2009-05-17 18:18:48 +0000
commit7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7 (patch)
tree2b8d4a2dac75de73ef32e9ea8631a939d3090233 /OpenSim/Data/MSSQL/MSSQLEstateData.cs
parentThank you kindly, Jonc, for a patch that solves (diff)
downloadopensim-SC_OLD-7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7.zip
opensim-SC_OLD-7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7.tar.gz
opensim-SC_OLD-7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7.tar.bz2
opensim-SC_OLD-7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7.tar.xz
Thank you kindly, StrawberryFride, for a patch that:
Adds maturity & access logic for MSSQL platform to mirror that of MySQL as committed in 9502.
Diffstat (limited to 'OpenSim/Data/MSSQL/MSSQLEstateData.cs')
-rw-r--r--OpenSim/Data/MSSQL/MSSQLEstateData.cs9
1 files changed, 3 insertions, 6 deletions
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
108 { 108 {
109 cmd.Parameters.Add(_Database.CreateParameter("@RegionID", regionID)); 109 cmd.Parameters.Add(_Database.CreateParameter("@RegionID", regionID));
110 110
111 using (IDataReader reader = cmd.ExecuteReader()) 111 using (SqlDataReader reader = cmd.ExecuteReader())
112 { 112 {
113 if (reader.Read()) 113 if (reader.Read())
114 { 114 {
@@ -323,7 +323,7 @@ namespace OpenSim.Data.MSSQL
323 idParameter.Value = es.EstateID; 323 idParameter.Value = es.EstateID;
324 cmd.Parameters.Add(idParameter); 324 cmd.Parameters.Add(idParameter);
325 325
326 using (IDataReader reader = cmd.ExecuteReader()) 326 using (SqlDataReader reader = cmd.ExecuteReader())
327 { 327 {
328 while (reader.Read()) 328 while (reader.Read())
329 { 329 {
@@ -351,7 +351,7 @@ namespace OpenSim.Data.MSSQL
351 { 351 {
352 cmd.Parameters.Add(_Database.CreateParameter("@EstateID", estateID)); 352 cmd.Parameters.Add(_Database.CreateParameter("@EstateID", estateID));
353 353
354 using (IDataReader reader = cmd.ExecuteReader()) 354 using (SqlDataReader reader = cmd.ExecuteReader())
355 { 355 {
356 while (reader.Read()) 356 while (reader.Read())
357 { 357 {
@@ -385,11 +385,8 @@ namespace OpenSim.Data.MSSQL
385 foreach (EstateBan b in es.EstateBans) 385 foreach (EstateBan b in es.EstateBans)
386 { 386 {
387 cmd.Parameters.Add(_Database.CreateParameter("@EstateID", es.EstateID)); 387 cmd.Parameters.Add(_Database.CreateParameter("@EstateID", es.EstateID));
388
389 cmd.Parameters.Add(_Database.CreateParameter("@bannedUUID", b.BannedUserID)); 388 cmd.Parameters.Add(_Database.CreateParameter("@bannedUUID", b.BannedUserID));
390
391 cmd.ExecuteNonQuery(); 389 cmd.ExecuteNonQuery();
392
393 cmd.Parameters.Clear(); 390 cmd.Parameters.Clear();
394 } 391 }
395 } 392 }