diff options
author | Charles Krinke | 2009-05-17 18:18:48 +0000 |
---|---|---|
committer | Charles Krinke | 2009-05-17 18:18:48 +0000 |
commit | 7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7 (patch) | |
tree | 2b8d4a2dac75de73ef32e9ea8631a939d3090233 /OpenSim/Data/MSSQL/MSSQLEstateData.cs | |
parent | Thank you kindly, Jonc, for a patch that solves (diff) | |
download | opensim-SC-7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7.zip opensim-SC-7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7.tar.gz opensim-SC-7a8a481f8801d9840a9ec05dd18adb2a1ccaebf7.tar.bz2 opensim-SC-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.cs | 9 |
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 | } |