diff options
Diffstat (limited to 'OpenSim/Data/MySQL/MySQLSimulationData.cs')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLSimulationData.cs | 41 |
1 files changed, 23 insertions, 18 deletions
diff --git a/OpenSim/Data/MySQL/MySQLSimulationData.cs b/OpenSim/Data/MySQL/MySQLSimulationData.cs index e14d775..cdaf5b7 100644 --- a/OpenSim/Data/MySQL/MySQLSimulationData.cs +++ b/OpenSim/Data/MySQL/MySQLSimulationData.cs | |||
@@ -66,7 +66,7 @@ namespace OpenSim.Data.MySQL | |||
66 | Initialise(connectionString); | 66 | Initialise(connectionString); |
67 | } | 67 | } |
68 | 68 | ||
69 | public void Initialise(string connectionString) | 69 | public virtual void Initialise(string connectionString) |
70 | { | 70 | { |
71 | m_connectionString = connectionString; | 71 | m_connectionString = connectionString; |
72 | 72 | ||
@@ -130,7 +130,7 @@ namespace OpenSim.Data.MySQL | |||
130 | 130 | ||
131 | public void Dispose() {} | 131 | public void Dispose() {} |
132 | 132 | ||
133 | public void StoreObject(SceneObjectGroup obj, UUID regionUUID) | 133 | public virtual void StoreObject(SceneObjectGroup obj, UUID regionUUID) |
134 | { | 134 | { |
135 | uint flags = obj.RootPart.GetEffectiveObjectFlags(); | 135 | uint flags = obj.RootPart.GetEffectiveObjectFlags(); |
136 | 136 | ||
@@ -258,7 +258,7 @@ namespace OpenSim.Data.MySQL | |||
258 | } | 258 | } |
259 | } | 259 | } |
260 | 260 | ||
261 | public void RemoveObject(UUID obj, UUID regionUUID) | 261 | public virtual void RemoveObject(UUID obj, UUID regionUUID) |
262 | { | 262 | { |
263 | // m_log.DebugFormat("[REGION DB]: Deleting scene object {0} from {1} in database", obj, regionUUID); | 263 | // m_log.DebugFormat("[REGION DB]: Deleting scene object {0} from {1} in database", obj, regionUUID); |
264 | 264 | ||
@@ -407,7 +407,7 @@ namespace OpenSim.Data.MySQL | |||
407 | } | 407 | } |
408 | } | 408 | } |
409 | 409 | ||
410 | public List<SceneObjectGroup> LoadObjects(UUID regionID) | 410 | public virtual List<SceneObjectGroup> LoadObjects(UUID regionID) |
411 | { | 411 | { |
412 | const int ROWS_PER_QUERY = 5000; | 412 | const int ROWS_PER_QUERY = 5000; |
413 | 413 | ||
@@ -576,7 +576,7 @@ namespace OpenSim.Data.MySQL | |||
576 | } | 576 | } |
577 | } | 577 | } |
578 | 578 | ||
579 | public void StoreTerrain(double[,] ter, UUID regionID) | 579 | public virtual void StoreTerrain(double[,] ter, UUID regionID) |
580 | { | 580 | { |
581 | m_log.Info("[REGION DB]: Storing terrain"); | 581 | m_log.Info("[REGION DB]: Storing terrain"); |
582 | 582 | ||
@@ -605,7 +605,7 @@ namespace OpenSim.Data.MySQL | |||
605 | } | 605 | } |
606 | } | 606 | } |
607 | 607 | ||
608 | public double[,] LoadTerrain(UUID regionID) | 608 | public virtual double[,] LoadTerrain(UUID regionID) |
609 | { | 609 | { |
610 | double[,] terrain = null; | 610 | double[,] terrain = null; |
611 | 611 | ||
@@ -655,7 +655,7 @@ namespace OpenSim.Data.MySQL | |||
655 | return terrain; | 655 | return terrain; |
656 | } | 656 | } |
657 | 657 | ||
658 | public void RemoveLandObject(UUID globalID) | 658 | public virtual void RemoveLandObject(UUID globalID) |
659 | { | 659 | { |
660 | lock (m_dbLock) | 660 | lock (m_dbLock) |
661 | { | 661 | { |
@@ -674,7 +674,7 @@ namespace OpenSim.Data.MySQL | |||
674 | } | 674 | } |
675 | } | 675 | } |
676 | 676 | ||
677 | public void StoreLandObject(ILandObject parcel) | 677 | public virtual void StoreLandObject(ILandObject parcel) |
678 | { | 678 | { |
679 | lock (m_dbLock) | 679 | lock (m_dbLock) |
680 | { | 680 | { |
@@ -731,7 +731,7 @@ namespace OpenSim.Data.MySQL | |||
731 | } | 731 | } |
732 | } | 732 | } |
733 | 733 | ||
734 | public RegionLightShareData LoadRegionWindlightSettings(UUID regionUUID) | 734 | public virtual RegionLightShareData LoadRegionWindlightSettings(UUID regionUUID) |
735 | { | 735 | { |
736 | RegionLightShareData nWP = new RegionLightShareData(); | 736 | RegionLightShareData nWP = new RegionLightShareData(); |
737 | nWP.OnSave += StoreRegionWindlightSettings; | 737 | nWP.OnSave += StoreRegionWindlightSettings; |
@@ -753,7 +753,7 @@ namespace OpenSim.Data.MySQL | |||
753 | { | 753 | { |
754 | //No result, so store our default windlight profile and return it | 754 | //No result, so store our default windlight profile and return it |
755 | nWP.regionID = regionUUID; | 755 | nWP.regionID = regionUUID; |
756 | StoreRegionWindlightSettings(nWP); | 756 | // StoreRegionWindlightSettings(nWP); |
757 | return nWP; | 757 | return nWP; |
758 | } | 758 | } |
759 | else | 759 | else |
@@ -828,7 +828,7 @@ namespace OpenSim.Data.MySQL | |||
828 | return nWP; | 828 | return nWP; |
829 | } | 829 | } |
830 | 830 | ||
831 | public RegionSettings LoadRegionSettings(UUID regionUUID) | 831 | public virtual RegionSettings LoadRegionSettings(UUID regionUUID) |
832 | { | 832 | { |
833 | RegionSettings rs = null; | 833 | RegionSettings rs = null; |
834 | 834 | ||
@@ -866,7 +866,7 @@ namespace OpenSim.Data.MySQL | |||
866 | return rs; | 866 | return rs; |
867 | } | 867 | } |
868 | 868 | ||
869 | public void StoreRegionWindlightSettings(RegionLightShareData wl) | 869 | public virtual void StoreRegionWindlightSettings(RegionLightShareData wl) |
870 | { | 870 | { |
871 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) | 871 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) |
872 | { | 872 | { |
@@ -969,7 +969,7 @@ namespace OpenSim.Data.MySQL | |||
969 | } | 969 | } |
970 | } | 970 | } |
971 | 971 | ||
972 | public void RemoveRegionWindlightSettings(UUID regionID) | 972 | public virtual void RemoveRegionWindlightSettings(UUID regionID) |
973 | { | 973 | { |
974 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) | 974 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) |
975 | { | 975 | { |
@@ -984,7 +984,7 @@ namespace OpenSim.Data.MySQL | |||
984 | } | 984 | } |
985 | } | 985 | } |
986 | 986 | ||
987 | public void StoreRegionSettings(RegionSettings rs) | 987 | public virtual void StoreRegionSettings(RegionSettings rs) |
988 | { | 988 | { |
989 | lock (m_dbLock) | 989 | lock (m_dbLock) |
990 | { | 990 | { |
@@ -1011,7 +1011,7 @@ namespace OpenSim.Data.MySQL | |||
1011 | "use_estate_sun, fixed_sun, sun_position, " + | 1011 | "use_estate_sun, fixed_sun, sun_position, " + |
1012 | "covenant, Sandbox, sunvectorx, sunvectory, " + | 1012 | "covenant, Sandbox, sunvectorx, sunvectory, " + |
1013 | "sunvectorz, loaded_creation_datetime, " + | 1013 | "sunvectorz, loaded_creation_datetime, " + |
1014 | "loaded_creation_id, map_tile_ID) values (?RegionUUID, ?BlockTerraform, " + | 1014 | "loaded_creation_id, map_tile_ID, block_search, casino) values (?RegionUUID, ?BlockTerraform, " + |
1015 | "?BlockFly, ?AllowDamage, ?RestrictPushing, " + | 1015 | "?BlockFly, ?AllowDamage, ?RestrictPushing, " + |
1016 | "?AllowLandResell, ?AllowLandJoinDivide, " + | 1016 | "?AllowLandResell, ?AllowLandJoinDivide, " + |
1017 | "?BlockShowInSearch, ?AgentLimit, ?ObjectBonus, " + | 1017 | "?BlockShowInSearch, ?AgentLimit, ?ObjectBonus, " + |
@@ -1026,7 +1026,7 @@ namespace OpenSim.Data.MySQL | |||
1026 | "?SunPosition, ?Covenant, ?Sandbox, " + | 1026 | "?SunPosition, ?Covenant, ?Sandbox, " + |
1027 | "?SunVectorX, ?SunVectorY, ?SunVectorZ, " + | 1027 | "?SunVectorX, ?SunVectorY, ?SunVectorZ, " + |
1028 | "?LoadedCreationDateTime, ?LoadedCreationID, " + | 1028 | "?LoadedCreationDateTime, ?LoadedCreationID, " + |
1029 | "?TerrainImageID)"; | 1029 | "?TerrainImageID, ?block_search, ?casino)"; |
1030 | 1030 | ||
1031 | FillRegionSettingsCommand(cmd, rs); | 1031 | FillRegionSettingsCommand(cmd, rs); |
1032 | 1032 | ||
@@ -1036,7 +1036,7 @@ namespace OpenSim.Data.MySQL | |||
1036 | } | 1036 | } |
1037 | } | 1037 | } |
1038 | 1038 | ||
1039 | public List<LandData> LoadLandObjects(UUID regionUUID) | 1039 | public virtual List<LandData> LoadLandObjects(UUID regionUUID) |
1040 | { | 1040 | { |
1041 | List<LandData> landData = new List<LandData>(); | 1041 | List<LandData> landData = new List<LandData>(); |
1042 | 1042 | ||
@@ -1315,6 +1315,9 @@ namespace OpenSim.Data.MySQL | |||
1315 | 1315 | ||
1316 | newSettings.TerrainImageID = DBGuid.FromDB(row["map_tile_ID"]); | 1316 | newSettings.TerrainImageID = DBGuid.FromDB(row["map_tile_ID"]); |
1317 | 1317 | ||
1318 | newSettings.GodBlockSearch = Convert.ToBoolean(row["block_search"]); | ||
1319 | newSettings.Casino = Convert.ToBoolean(row["casino"]); | ||
1320 | |||
1318 | return newSettings; | 1321 | return newSettings; |
1319 | } | 1322 | } |
1320 | 1323 | ||
@@ -1644,6 +1647,8 @@ namespace OpenSim.Data.MySQL | |||
1644 | cmd.Parameters.AddWithValue("LoadedCreationDateTime", settings.LoadedCreationDateTime); | 1647 | cmd.Parameters.AddWithValue("LoadedCreationDateTime", settings.LoadedCreationDateTime); |
1645 | cmd.Parameters.AddWithValue("LoadedCreationID", settings.LoadedCreationID); | 1648 | cmd.Parameters.AddWithValue("LoadedCreationID", settings.LoadedCreationID); |
1646 | cmd.Parameters.AddWithValue("TerrainImageID", settings.TerrainImageID); | 1649 | cmd.Parameters.AddWithValue("TerrainImageID", settings.TerrainImageID); |
1650 | cmd.Parameters.AddWithValue("block_search", settings.GodBlockSearch); | ||
1651 | cmd.Parameters.AddWithValue("casino", settings.Casino); | ||
1647 | 1652 | ||
1648 | } | 1653 | } |
1649 | 1654 | ||
@@ -1802,7 +1807,7 @@ namespace OpenSim.Data.MySQL | |||
1802 | cmd.Parameters.AddWithValue("Media", null == s.Media ? null : s.Media.ToXml()); | 1807 | cmd.Parameters.AddWithValue("Media", null == s.Media ? null : s.Media.ToXml()); |
1803 | } | 1808 | } |
1804 | 1809 | ||
1805 | public void StorePrimInventory(UUID primID, ICollection<TaskInventoryItem> items) | 1810 | public virtual void StorePrimInventory(UUID primID, ICollection<TaskInventoryItem> items) |
1806 | { | 1811 | { |
1807 | lock (m_dbLock) | 1812 | lock (m_dbLock) |
1808 | { | 1813 | { |