diff options
Diffstat (limited to 'OpenSim/Framework/Data.MySQL/MySQLDataStore.cs')
-rw-r--r-- | OpenSim/Framework/Data.MySQL/MySQLDataStore.cs | 33 |
1 files changed, 7 insertions, 26 deletions
diff --git a/OpenSim/Framework/Data.MySQL/MySQLDataStore.cs b/OpenSim/Framework/Data.MySQL/MySQLDataStore.cs index 7929c0d..d9a39a3 100644 --- a/OpenSim/Framework/Data.MySQL/MySQLDataStore.cs +++ b/OpenSim/Framework/Data.MySQL/MySQLDataStore.cs | |||
@@ -156,9 +156,9 @@ namespace OpenSim.Framework.Data.MySQL | |||
156 | // MainLog.Instance.Verbose("DATASTORE", "Ignoring Physical obj: " + obj.UUID + " in region: " + regionUUID); | 156 | // MainLog.Instance.Verbose("DATASTORE", "Ignoring Physical obj: " + obj.UUID + " in region: " + regionUUID); |
157 | } | 157 | } |
158 | } | 158 | } |
159 | } | ||
160 | 159 | ||
161 | Commit(); | 160 | Commit(); |
161 | } | ||
162 | } | 162 | } |
163 | 163 | ||
164 | public void RemoveObject(LLUUID obj, LLUUID regionUUID) | 164 | public void RemoveObject(LLUUID obj, LLUUID regionUUID) |
@@ -198,9 +198,9 @@ namespace OpenSim.Framework.Data.MySQL | |||
198 | // Remove prim row | 198 | // Remove prim row |
199 | row.Delete(); | 199 | row.Delete(); |
200 | } | 200 | } |
201 | } | ||
202 | 201 | ||
203 | Commit(); | 202 | Commit(); |
203 | } | ||
204 | } | 204 | } |
205 | 205 | ||
206 | /// <summary> | 206 | /// <summary> |
@@ -418,57 +418,38 @@ namespace OpenSim.Framework.Data.MySQL | |||
418 | { | 418 | { |
419 | lock (m_dataSet) | 419 | lock (m_dataSet) |
420 | { | 420 | { |
421 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 1"); | ||
422 | DataTable land = m_landTable; | 421 | DataTable land = m_landTable; |
423 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 2"); | ||
424 | DataTable landaccesslist = m_landAccessListTable; | 422 | DataTable landaccesslist = m_landAccessListTable; |
425 | 423 | ||
426 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 3"); | ||
427 | DataRow landRow = land.Rows.Find(Util.ToRawUuidString(parcel.landData.globalID)); | 424 | DataRow landRow = land.Rows.Find(Util.ToRawUuidString(parcel.landData.globalID)); |
428 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 4"); | ||
429 | if (landRow == null) | 425 | if (landRow == null) |
430 | { | 426 | { |
431 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 5"); | ||
432 | landRow = land.NewRow(); | 427 | landRow = land.NewRow(); |
433 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 6"); | ||
434 | fillLandRow(landRow, parcel.landData, regionUUID); | 428 | fillLandRow(landRow, parcel.landData, regionUUID); |
435 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 7"); | ||
436 | land.Rows.Add(landRow); | 429 | land.Rows.Add(landRow); |
437 | } | 430 | } |
438 | else | 431 | else |
439 | { | 432 | { |
440 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 8"); | ||
441 | fillLandRow(landRow, parcel.landData, regionUUID); | 433 | fillLandRow(landRow, parcel.landData, regionUUID); |
442 | } | 434 | } |
443 | 435 | ||
444 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 9"); | ||
445 | using ( | 436 | using ( |
446 | MySqlCommand cmd = | 437 | MySqlCommand cmd = |
447 | new MySqlCommand("delete from landaccesslist where LandUUID=?LandUUID", m_connection)) | 438 | new MySqlCommand("delete from landaccesslist where LandUUID=?LandUUID", m_connection)) |
448 | { | 439 | { |
449 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 10"); | ||
450 | cmd.Parameters.Add(new MySqlParameter("?LandUUID", Util.ToRawUuidString(parcel.landData.globalID))); | 440 | cmd.Parameters.Add(new MySqlParameter("?LandUUID", Util.ToRawUuidString(parcel.landData.globalID))); |
451 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 11"); | ||
452 | cmd.ExecuteNonQuery(); | 441 | cmd.ExecuteNonQuery(); |
453 | } | 442 | } |
454 | 443 | ||
455 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 12"); | ||
456 | int i = 0; | ||
457 | foreach (ParcelManager.ParcelAccessEntry entry in parcel.landData.parcelAccessList) | 444 | foreach (ParcelManager.ParcelAccessEntry entry in parcel.landData.parcelAccessList) |
458 | { | 445 | { |
459 | i++; | ||
460 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 12:1:" + i); | ||
461 | DataRow newAccessRow = landaccesslist.NewRow(); | 446 | DataRow newAccessRow = landaccesslist.NewRow(); |
462 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 12:2:" + i); | ||
463 | fillLandAccessRow(newAccessRow, entry, parcel.landData.globalID); | 447 | fillLandAccessRow(newAccessRow, entry, parcel.landData.globalID); |
464 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 12:3:" + i); | ||
465 | landaccesslist.Rows.Add(newAccessRow); | 448 | landaccesslist.Rows.Add(newAccessRow); |
466 | } | 449 | } |
467 | } | ||
468 | 450 | ||
469 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 13"); | ||
470 | Commit(); | 451 | Commit(); |
471 | MainLog.Instance.Verbose("DATASTORE", "Tedd debug: 14"); | 452 | } |
472 | } | 453 | } |
473 | 454 | ||
474 | public List<LandData> LoadLandObjects(LLUUID regionUUID) | 455 | public List<LandData> LoadLandObjects(LLUUID regionUUID) |
@@ -536,8 +517,6 @@ namespace OpenSim.Framework.Data.MySQL | |||
536 | m_connection.Open(); | 517 | m_connection.Open(); |
537 | } | 518 | } |
538 | 519 | ||
539 | lock (m_dataSet) | ||
540 | { | ||
541 | // DisplayDataSet(m_dataSet, "Region DataSet"); | 520 | // DisplayDataSet(m_dataSet, "Region DataSet"); |
542 | 521 | ||
543 | m_primDataAdapter.Update(m_primTable); | 522 | m_primDataAdapter.Update(m_primTable); |
@@ -553,12 +532,14 @@ namespace OpenSim.Framework.Data.MySQL | |||
553 | m_landAccessListDataAdapter.Update(m_landAccessListTable); | 532 | m_landAccessListDataAdapter.Update(m_landAccessListTable); |
554 | 533 | ||
555 | m_dataSet.AcceptChanges(); | 534 | m_dataSet.AcceptChanges(); |
556 | } | ||
557 | } | 535 | } |
558 | 536 | ||
559 | public void Shutdown() | 537 | public void Shutdown() |
560 | { | 538 | { |
561 | Commit(); | 539 | lock (m_dataSet) |
540 | { | ||
541 | Commit(); | ||
542 | } | ||
562 | } | 543 | } |
563 | 544 | ||
564 | /*********************************************************************** | 545 | /*********************************************************************** |