aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/MySQLEstateData.cs26
1 files changed, 14 insertions, 12 deletions
diff --git a/OpenSim/Data/MySQL/MySQLEstateData.cs b/OpenSim/Data/MySQL/MySQLEstateData.cs
index f8641bc..78d4446 100644
--- a/OpenSim/Data/MySQL/MySQLEstateData.cs
+++ b/OpenSim/Data/MySQL/MySQLEstateData.cs
@@ -101,8 +101,10 @@ namespace OpenSim.Data.MySQL
101 BindingFlags.DeclaredOnly); 101 BindingFlags.DeclaredOnly);
102 102
103 foreach (FieldInfo f in m_Fields) 103 foreach (FieldInfo f in m_Fields)
104 if(f.Name.Substring(0, 2) == "m_") 104 {
105 if (f.Name.Substring(0, 2) == "m_")
105 m_FieldMap[f.Name.Substring(2)] = f; 106 m_FieldMap[f.Name.Substring(2)] = f;
107 }
106 } 108 }
107 109
108 private string[] FieldList 110 private string[] FieldList
@@ -171,14 +173,14 @@ namespace OpenSim.Data.MySQL
171 173
172 IDataReader r = cmd.ExecuteReader(); 174 IDataReader r = cmd.ExecuteReader();
173 175
174 if(r.Read()) 176 if (r.Read())
175 { 177 {
176 foreach (string name in FieldList) 178 foreach (string name in FieldList)
177 { 179 {
178 if(m_FieldMap[name].GetValue(es) is bool) 180 if (m_FieldMap[name].GetValue(es) is bool)
179 { 181 {
180 int v = Convert.ToInt32(r[name]); 182 int v = Convert.ToInt32(r[name]);
181 if(v != 0) 183 if (v != 0)
182 m_FieldMap[name].SetValue(es, true); 184 m_FieldMap[name].SetValue(es, true);
183 else 185 else
184 m_FieldMap[name].SetValue(es, false); 186 m_FieldMap[name].SetValue(es, false);
@@ -207,9 +209,9 @@ namespace OpenSim.Data.MySQL
207 209
208 foreach (string name in FieldList) 210 foreach (string name in FieldList)
209 { 211 {
210 if(m_FieldMap[name].GetValue(es) is bool) 212 if (m_FieldMap[name].GetValue(es) is bool)
211 { 213 {
212 if((bool)m_FieldMap[name].GetValue(es)) 214 if ((bool)m_FieldMap[name].GetValue(es))
213 cmd.Parameters.AddWithValue("?"+name, "1"); 215 cmd.Parameters.AddWithValue("?"+name, "1");
214 else 216 else
215 cmd.Parameters.AddWithValue("?"+name, "0"); 217 cmd.Parameters.AddWithValue("?"+name, "0");
@@ -283,9 +285,9 @@ namespace OpenSim.Data.MySQL
283 285
284 foreach (string name in FieldList) 286 foreach (string name in FieldList)
285 { 287 {
286 if(m_FieldMap[name].GetValue(es) is bool) 288 if (m_FieldMap[name].GetValue(es) is bool)
287 { 289 {
288 if((bool)m_FieldMap[name].GetValue(es)) 290 if ((bool)m_FieldMap[name].GetValue(es))
289 cmd.Parameters.AddWithValue("?"+name, "1"); 291 cmd.Parameters.AddWithValue("?"+name, "1");
290 else 292 else
291 cmd.Parameters.AddWithValue("?"+name, "0"); 293 cmd.Parameters.AddWithValue("?"+name, "0");
@@ -317,7 +319,7 @@ namespace OpenSim.Data.MySQL
317 319
318 IDataReader r = cmd.ExecuteReader(); 320 IDataReader r = cmd.ExecuteReader();
319 321
320 while(r.Read()) 322 while (r.Read())
321 { 323 {
322 EstateBan eb = new EstateBan(); 324 EstateBan eb = new EstateBan();
323 325
@@ -347,7 +349,7 @@ namespace OpenSim.Data.MySQL
347 349
348 cmd.CommandText = "insert into estateban (EstateID, bannedUUID) values ( ?EstateID, ?bannedUUID )"; 350 cmd.CommandText = "insert into estateban (EstateID, bannedUUID) values ( ?EstateID, ?bannedUUID )";
349 351
350 foreach(EstateBan b in es.EstateBans) 352 foreach (EstateBan b in es.EstateBans)
351 { 353 {
352 cmd.Parameters.AddWithValue("?EstateID", es.EstateID.ToString()); 354 cmd.Parameters.AddWithValue("?EstateID", es.EstateID.ToString());
353 cmd.Parameters.AddWithValue("?bannedUUID", b.bannedUUID.ToString()); 355 cmd.Parameters.AddWithValue("?bannedUUID", b.bannedUUID.ToString());
@@ -372,7 +374,7 @@ namespace OpenSim.Data.MySQL
372 374
373 cmd.CommandText = "insert into "+table+" (EstateID, uuid) values ( ?EstateID, ?uuid )"; 375 cmd.CommandText = "insert into "+table+" (EstateID, uuid) values ( ?EstateID, ?uuid )";
374 376
375 foreach(LLUUID uuid in data) 377 foreach (LLUUID uuid in data)
376 { 378 {
377 cmd.Parameters.AddWithValue("?EstateID", EstateID.ToString()); 379 cmd.Parameters.AddWithValue("?EstateID", EstateID.ToString());
378 cmd.Parameters.AddWithValue("?uuid", uuid.ToString()); 380 cmd.Parameters.AddWithValue("?uuid", uuid.ToString());
@@ -395,7 +397,7 @@ namespace OpenSim.Data.MySQL
395 397
396 IDataReader r = cmd.ExecuteReader(); 398 IDataReader r = cmd.ExecuteReader();
397 399
398 while(r.Read()) 400 while (r.Read())
399 { 401 {
400 // EstateBan eb = new EstateBan(); 402 // EstateBan eb = new EstateBan();
401 403