aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL
diff options
context:
space:
mode:
authorDiva Canto2009-10-05 10:31:41 -0700
committerDiva Canto2009-10-05 10:31:41 -0700
commit62ea6b6383329961c820b4109af3ae943823f27b (patch)
tree16b46a5070420584684954878c6778baf753b30a /OpenSim/Data/MSSQL
parentMore debug messages if things go wrong. (diff)
parentminor: remove mono compile warning (diff)
downloadopensim-SC_OLD-62ea6b6383329961c820b4109af3ae943823f27b.zip
opensim-SC_OLD-62ea6b6383329961c820b4109af3ae943823f27b.tar.gz
opensim-SC_OLD-62ea6b6383329961c820b4109af3ae943823f27b.tar.bz2
opensim-SC_OLD-62ea6b6383329961c820b4109af3ae943823f27b.tar.xz
Merge branch 'master' of ssh://diva@opensimulator.org/var/git/opensim
Diffstat (limited to 'OpenSim/Data/MSSQL')
-rw-r--r--OpenSim/Data/MSSQL/MSSQLLegacyRegionData.cs20
1 files changed, 10 insertions, 10 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLLegacyRegionData.cs b/OpenSim/Data/MSSQL/MSSQLLegacyRegionData.cs
index adedcce..e2ae5cb 100644
--- a/OpenSim/Data/MSSQL/MSSQLLegacyRegionData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLLegacyRegionData.cs
@@ -575,7 +575,7 @@ ELSE
575 /// <returns></returns> 575 /// <returns></returns>
576 public List<LandData> LoadLandObjects(UUID regionUUID) 576 public List<LandData> LoadLandObjects(UUID regionUUID)
577 { 577 {
578 List<LandData> landDataForRegion = new List<LandData>(); 578 List<LandData> LandDataForRegion = new List<LandData>();
579 579
580 string sql = "select * from land where RegionUUID = @RegionUUID"; 580 string sql = "select * from land where RegionUUID = @RegionUUID";
581 581
@@ -588,30 +588,30 @@ ELSE
588 { 588 {
589 while (readerLandData.Read()) 589 while (readerLandData.Read())
590 { 590 {
591 landDataForRegion.Add(BuildLandData(readerLandData)); 591 LandDataForRegion.Add(BuildLandData(readerLandData));
592 } 592 }
593 } 593 }
594 } 594 }
595 595
596 //Retrieve all accesslist data for all landdata 596 //Retrieve all accesslist data for all landdata
597 foreach (LandData landData in landDataForRegion) 597 foreach (LandData LandData in LandDataForRegion)
598 { 598 {
599 sql = "select * from landaccesslist where LandUUID = @LandUUID"; 599 sql = "select * from landaccesslist where LandUUID = @LandUUID";
600 using (AutoClosingSqlCommand cmdAccessList = _Database.Query(sql)) 600 using (AutoClosingSqlCommand cmdAccessList = _Database.Query(sql))
601 { 601 {
602 cmdAccessList.Parameters.Add(_Database.CreateParameter("@LandUUID", landData.GlobalID)); 602 cmdAccessList.Parameters.Add(_Database.CreateParameter("@LandUUID", LandData.GlobalID));
603 using (SqlDataReader readerAccessList = cmdAccessList.ExecuteReader()) 603 using (SqlDataReader readerAccessList = cmdAccessList.ExecuteReader())
604 { 604 {
605 while (readerAccessList.Read()) 605 while (readerAccessList.Read())
606 { 606 {
607 landData.ParcelAccessList.Add(BuildLandAccessData(readerAccessList)); 607 LandData.ParcelAccessList.Add(BuildLandAccessData(readerAccessList));
608 } 608 }
609 } 609 }
610 } 610 }
611 } 611 }
612 612
613 //Return data 613 //Return data
614 return landDataForRegion; 614 return LandDataForRegion;
615 } 615 }
616 616
617 /// <summary> 617 /// <summary>
@@ -624,7 +624,7 @@ ELSE
624 //As the delete landaccess is already in the mysql code 624 //As the delete landaccess is already in the mysql code
625 625
626 //Delete old values 626 //Delete old values
627 RemoveLandObject(parcel.landData.GlobalID); 627 RemoveLandObject(parcel.LandData.GlobalID);
628 628
629 //Insert new values 629 //Insert new values
630 string sql = @"INSERT INTO [land] 630 string sql = @"INSERT INTO [land]
@@ -634,7 +634,7 @@ VALUES
634 634
635 using (AutoClosingSqlCommand cmd = _Database.Query(sql)) 635 using (AutoClosingSqlCommand cmd = _Database.Query(sql))
636 { 636 {
637 cmd.Parameters.AddRange(CreateLandParameters(parcel.landData, parcel.regionUUID)); 637 cmd.Parameters.AddRange(CreateLandParameters(parcel.LandData, parcel.RegionUUID));
638 638
639 cmd.ExecuteNonQuery(); 639 cmd.ExecuteNonQuery();
640 } 640 }
@@ -643,9 +643,9 @@ VALUES
643 643
644 using (AutoClosingSqlCommand cmd = _Database.Query(sql)) 644 using (AutoClosingSqlCommand cmd = _Database.Query(sql))
645 { 645 {
646 foreach (ParcelManager.ParcelAccessEntry parcelAccessEntry in parcel.landData.ParcelAccessList) 646 foreach (ParcelManager.ParcelAccessEntry parcelAccessEntry in parcel.LandData.ParcelAccessList)
647 { 647 {
648 cmd.Parameters.AddRange(CreateLandAccessParameters(parcelAccessEntry, parcel.regionUUID)); 648 cmd.Parameters.AddRange(CreateLandAccessParameters(parcelAccessEntry, parcel.RegionUUID));
649 649
650 cmd.ExecuteNonQuery(); 650 cmd.ExecuteNonQuery();
651 cmd.Parameters.Clear(); 651 cmd.Parameters.Clear();