diff options
author | MW | 2008-06-29 11:48:58 +0000 |
---|---|---|
committer | MW | 2008-06-29 11:48:58 +0000 |
commit | f3f31744abaf8a9df952a0d547faa59035b46ff3 (patch) | |
tree | d400f1ef6854d9f7b57007f92e774b5c7b1a1c81 | |
parent | couple of small fixes to try to fix support for multiple inventory servers in... (diff) | |
download | opensim-SC-f3f31744abaf8a9df952a0d547faa59035b46ff3.zip opensim-SC-f3f31744abaf8a9df952a0d547faa59035b46ff3.tar.gz opensim-SC-f3f31744abaf8a9df952a0d547faa59035b46ff3.tar.bz2 opensim-SC-f3f31744abaf8a9df952a0d547faa59035b46ff3.tar.xz |
patch and files from mantis #1630, Thanks Melanie
-rw-r--r-- | OpenSim/Data/MSSQL/MSSQLDataStore.cs | 9 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/MySQLDataStore.cs | 183 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/005_RegionStore.sql | 40 | ||||
-rw-r--r-- | OpenSim/Data/Null/NullDataStore.cs | 9 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/Resources/004_RegionStore.sql | 38 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteRegionData.cs | 9 | ||||
-rw-r--r-- | OpenSim/Framework/Communications/CommunicationsManager.cs | 2 | ||||
-rw-r--r-- | OpenSim/Framework/RegionSettings.cs | 300 | ||||
-rw-r--r-- | OpenSim/Region/Environment/Interfaces/IRegionDataStore.cs | 3 | ||||
-rw-r--r-- | OpenSim/Region/Storage/OpenSim.DataStore.MSSQL/MSSQLDataStore.cs | 9 |
10 files changed, 600 insertions, 2 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLDataStore.cs b/OpenSim/Data/MSSQL/MSSQLDataStore.cs index 17a52a8..4cb2b45 100644 --- a/OpenSim/Data/MSSQL/MSSQLDataStore.cs +++ b/OpenSim/Data/MSSQL/MSSQLDataStore.cs | |||
@@ -151,6 +151,15 @@ namespace OpenSim.Data.MSSQL | |||
151 | } | 151 | } |
152 | } | 152 | } |
153 | 153 | ||
154 | public void StoreRegionSettings(RegionSettings rs) | ||
155 | { | ||
156 | } | ||
157 | |||
158 | public RegionSettings LoadRegionSettings(LLUUID regionUUID) | ||
159 | { | ||
160 | return null; | ||
161 | } | ||
162 | |||
154 | /// <summary> | 163 | /// <summary> |
155 | /// | 164 | /// |
156 | /// </summary> | 165 | /// </summary> |
diff --git a/OpenSim/Data/MySQL/MySQLDataStore.cs b/OpenSim/Data/MySQL/MySQLDataStore.cs index 87bce10..35e0ab7 100644 --- a/OpenSim/Data/MySQL/MySQLDataStore.cs +++ b/OpenSim/Data/MySQL/MySQLDataStore.cs | |||
@@ -54,6 +54,7 @@ namespace OpenSim.Data.MySQL | |||
54 | private const string m_landSelect = "select * from land"; | 54 | private const string m_landSelect = "select * from land"; |
55 | private const string m_landAccessListSelect = "select * from landaccesslist"; | 55 | private const string m_landAccessListSelect = "select * from landaccesslist"; |
56 | private const string m_regionBanListSelect = "select * from regionban"; | 56 | private const string m_regionBanListSelect = "select * from regionban"; |
57 | private const string m_regionSettingsSelect = "select * from regionsettings"; | ||
57 | 58 | ||
58 | 59 | ||
59 | /// <summary> | 60 | /// <summary> |
@@ -70,6 +71,7 @@ namespace OpenSim.Data.MySQL | |||
70 | private MySqlDataAdapter m_landDataAdapter; | 71 | private MySqlDataAdapter m_landDataAdapter; |
71 | private MySqlDataAdapter m_landAccessListDataAdapter; | 72 | private MySqlDataAdapter m_landAccessListDataAdapter; |
72 | private MySqlDataAdapter m_regionBanListDataAdapter; | 73 | private MySqlDataAdapter m_regionBanListDataAdapter; |
74 | private MySqlDataAdapter m_regionSettingsDataAdapter; | ||
73 | 75 | ||
74 | private DataTable m_primTable; | 76 | private DataTable m_primTable; |
75 | private DataTable m_shapeTable; | 77 | private DataTable m_shapeTable; |
@@ -78,6 +80,7 @@ namespace OpenSim.Data.MySQL | |||
78 | private DataTable m_landTable; | 80 | private DataTable m_landTable; |
79 | private DataTable m_landAccessListTable; | 81 | private DataTable m_landAccessListTable; |
80 | private DataTable m_regionBanListTable; | 82 | private DataTable m_regionBanListTable; |
83 | private DataTable m_regionSettingsTable; | ||
81 | 84 | ||
82 | /// <value>Temporary attribute while this is experimental</value> | 85 | /// <value>Temporary attribute while this is experimental</value> |
83 | private bool persistPrimInventories; | 86 | private bool persistPrimInventories; |
@@ -134,6 +137,8 @@ namespace OpenSim.Data.MySQL | |||
134 | MySqlCommand regionBanListSelectCmd = new MySqlCommand(m_regionBanListSelect, m_connection); | 137 | MySqlCommand regionBanListSelectCmd = new MySqlCommand(m_regionBanListSelect, m_connection); |
135 | m_regionBanListDataAdapter = new MySqlDataAdapter(regionBanListSelectCmd); | 138 | m_regionBanListDataAdapter = new MySqlDataAdapter(regionBanListSelectCmd); |
136 | 139 | ||
140 | MySqlCommand regionSettingsSelectCmd = new MySqlCommand(m_regionSettingsSelect, m_connection); | ||
141 | m_regionSettingsDataAdapter = new MySqlDataAdapter(regionSettingsSelectCmd); | ||
137 | 142 | ||
138 | lock (m_dataSet) | 143 | lock (m_dataSet) |
139 | { | 144 | { |
@@ -175,6 +180,11 @@ namespace OpenSim.Data.MySQL | |||
175 | m_dataSet.Tables.Add(m_regionBanListTable); | 180 | m_dataSet.Tables.Add(m_regionBanListTable); |
176 | SetupRegionBanCommands(m_regionBanListDataAdapter, m_connection); | 181 | SetupRegionBanCommands(m_regionBanListDataAdapter, m_connection); |
177 | m_regionBanListDataAdapter.Fill(m_regionBanListTable); | 182 | m_regionBanListDataAdapter.Fill(m_regionBanListTable); |
183 | |||
184 | m_regionSettingsTable = createRegionSettingsTable(); | ||
185 | m_dataSet.Tables.Add(m_regionSettingsTable); | ||
186 | SetupRegionSettingsCommands(m_regionSettingsDataAdapter, m_connection); | ||
187 | m_regionSettingsDataAdapter.Fill(m_regionSettingsTable); | ||
178 | } | 188 | } |
179 | } | 189 | } |
180 | /// <summary> | 190 | /// <summary> |
@@ -640,6 +650,41 @@ namespace OpenSim.Data.MySQL | |||
640 | } | 650 | } |
641 | } | 651 | } |
642 | 652 | ||
653 | public RegionSettings LoadRegionSettings(LLUUID regionUUID) | ||
654 | { | ||
655 | lock(m_dataSet) | ||
656 | { | ||
657 | DataTable regionsettings = m_regionSettingsTable; | ||
658 | string searchExp = "regionUUID = '" + regionUUID.ToString() + "'"; | ||
659 | DataRow[] rawsettings = regionsettings.Select(searchExp); | ||
660 | if(rawsettings.Length == 0) | ||
661 | return null; | ||
662 | DataRow row = rawsettings[0]; | ||
663 | |||
664 | return buildRegionSettings(row); | ||
665 | } | ||
666 | } | ||
667 | |||
668 | public void StoreRegionSettings(RegionSettings rs) | ||
669 | { | ||
670 | lock (m_dataSet) | ||
671 | { | ||
672 | DataTable regionsettings = m_dataSet.Tables["regionsettings"]; | ||
673 | |||
674 | DataRow settingsRow = regionsettings.Rows.Find(rs.RegionUUID.ToString()); | ||
675 | if (settingsRow == null) | ||
676 | { | ||
677 | settingsRow = regionsettings.NewRow(); | ||
678 | fillRegionSettingsRow(settingsRow, rs); | ||
679 | regionsettings.Rows.Add(settingsRow); | ||
680 | } | ||
681 | else | ||
682 | { | ||
683 | fillRegionSettingsRow(settingsRow, rs); | ||
684 | } | ||
685 | } | ||
686 | } | ||
687 | |||
643 | /// <summary> | 688 | /// <summary> |
644 | /// Load (fetch?) a region banlist | 689 | /// Load (fetch?) a region banlist |
645 | /// </summary> | 690 | /// </summary> |
@@ -839,6 +884,49 @@ namespace OpenSim.Data.MySQL | |||
839 | } | 884 | } |
840 | 885 | ||
841 | /// <summary> | 886 | /// <summary> |
887 | /// Create the "regionsettings" table | ||
888 | /// </summary> | ||
889 | /// <returns></returns> | ||
890 | private static DataTable createRegionSettingsTable() | ||
891 | { | ||
892 | DataTable regionsettings = new DataTable("regionsettings"); | ||
893 | createCol(regionsettings, "regionUUID", typeof(String)); | ||
894 | createCol(regionsettings, "block_terraform", typeof (Int32)); | ||
895 | createCol(regionsettings, "block_fly", typeof (Int32)); | ||
896 | createCol(regionsettings, "allow_damage", typeof (Int32)); | ||
897 | createCol(regionsettings, "restrict_pushing", typeof (Int32)); | ||
898 | createCol(regionsettings, "allow_land_resell", typeof (Int32)); | ||
899 | createCol(regionsettings, "allow_land_join_divide", typeof (Int32)); | ||
900 | createCol(regionsettings, "block_show_in_search", typeof (Int32)); | ||
901 | createCol(regionsettings, "agent_limit", typeof (Int32)); | ||
902 | createCol(regionsettings, "object_bonus", typeof (Double)); | ||
903 | createCol(regionsettings, "maturity", typeof (Int32)); | ||
904 | createCol(regionsettings, "disable_scripts", typeof (Int32)); | ||
905 | createCol(regionsettings, "disable_collisions", typeof (Int32)); | ||
906 | createCol(regionsettings, "disable_physics", typeof (Int32)); | ||
907 | createCol(regionsettings, "terrain_texture_1", typeof(String)); | ||
908 | createCol(regionsettings, "terrain_texture_2", typeof(String)); | ||
909 | createCol(regionsettings, "terrain_texture_3", typeof(String)); | ||
910 | createCol(regionsettings, "terrain_texture_4", typeof(String)); | ||
911 | createCol(regionsettings, "elevation_1_nw", typeof (Double)); | ||
912 | createCol(regionsettings, "elevation_2_nw", typeof (Double)); | ||
913 | createCol(regionsettings, "elevation_1_ne", typeof (Double)); | ||
914 | createCol(regionsettings, "elevation_2_ne", typeof (Double)); | ||
915 | createCol(regionsettings, "elevation_1_se", typeof (Double)); | ||
916 | createCol(regionsettings, "elevation_2_se", typeof (Double)); | ||
917 | createCol(regionsettings, "elevation_1_sw", typeof (Double)); | ||
918 | createCol(regionsettings, "elevation_2_sw", typeof (Double)); | ||
919 | createCol(regionsettings, "water_height", typeof (Double)); | ||
920 | createCol(regionsettings, "terrain_raise_limit", typeof (Double)); | ||
921 | createCol(regionsettings, "terrain_lower_limit", typeof (Double)); | ||
922 | createCol(regionsettings, "use_estate_sun", typeof (Int32)); | ||
923 | createCol(regionsettings, "fixed_sun", typeof (Int32)); | ||
924 | createCol(regionsettings, "sun_position", typeof (Double)); | ||
925 | createCol(regionsettings, "covenant", typeof(String)); | ||
926 | return regionsettings; | ||
927 | } | ||
928 | |||
929 | /// <summary> | ||
842 | /// Create the "regionban" table | 930 | /// Create the "regionban" table |
843 | /// </summary> | 931 | /// </summary> |
844 | /// <returns></returns> | 932 | /// <returns></returns> |
@@ -1205,6 +1293,47 @@ namespace OpenSim.Data.MySQL | |||
1205 | return taskItem; | 1293 | return taskItem; |
1206 | } | 1294 | } |
1207 | 1295 | ||
1296 | private static RegionSettings buildRegionSettings(DataRow row) | ||
1297 | { | ||
1298 | RegionSettings newSettings = new RegionSettings(); | ||
1299 | |||
1300 | newSettings.RegionUUID = new LLUUID((string) row["regionUUID"]); | ||
1301 | newSettings.BlockTerraform = Convert.ToBoolean(row["block_terraform"]); | ||
1302 | newSettings.AllowDamage = Convert.ToBoolean(row["allow_damage"]); | ||
1303 | newSettings.BlockFly = Convert.ToBoolean(row["block_fly"]); | ||
1304 | newSettings.RestrictPushing = Convert.ToBoolean(row["restrict_pushing"]); | ||
1305 | newSettings.AllowLandResell = Convert.ToBoolean(row["allow_land_resell"]); | ||
1306 | newSettings.AllowLandJoinDivide = Convert.ToBoolean(row["allow_land_join_divide"]); | ||
1307 | newSettings.BlockShowInSearch = Convert.ToBoolean(row["block_show_in_search"]); | ||
1308 | newSettings.AgentLimit = Convert.ToInt32(row["agent_limit"]); | ||
1309 | newSettings.ObjectBonus = Convert.ToDouble(row["object_bonus"]); | ||
1310 | newSettings.Maturity = Convert.ToInt32(row["maturity"]); | ||
1311 | newSettings.DisableScripts = Convert.ToBoolean(row["disable_scripts"]); | ||
1312 | newSettings.DisableCollisions = Convert.ToBoolean(row["disable_collisions"]); | ||
1313 | newSettings.DisablePhysics = Convert.ToBoolean(row["disable_physics"]); | ||
1314 | newSettings.TerrainTexture1 = new LLUUID((String) row["terrain_texture_1"]); | ||
1315 | newSettings.TerrainTexture2 = new LLUUID((String) row["terrain_texture_2"]); | ||
1316 | newSettings.TerrainTexture3 = new LLUUID((String) row["terrain_texture_3"]); | ||
1317 | newSettings.TerrainTexture4 = new LLUUID((String) row["terrain_texture_4"]); | ||
1318 | newSettings.Elevation1NW = Convert.ToDouble(row["elevation_1_nw"]); | ||
1319 | newSettings.Elevation2NW = Convert.ToDouble(row["elevation_2_nw"]); | ||
1320 | newSettings.Elevation1NE = Convert.ToDouble(row["elevation_1_ne"]); | ||
1321 | newSettings.Elevation2NE = Convert.ToDouble(row["elevation_2_ne"]); | ||
1322 | newSettings.Elevation1SE = Convert.ToDouble(row["elevation_1_se"]); | ||
1323 | newSettings.Elevation2SE = Convert.ToDouble(row["elevation_2_se"]); | ||
1324 | newSettings.Elevation1SW = Convert.ToDouble(row["elevation_1_sw"]); | ||
1325 | newSettings.Elevation2SW = Convert.ToDouble(row["elevation_2_sw"]); | ||
1326 | newSettings.WaterHeight = Convert.ToDouble(row["water_height"]); | ||
1327 | newSettings.TerrainRaiseLimit = Convert.ToDouble(row["terrain_raise_limit"]); | ||
1328 | newSettings.TerrainLowerLimit = Convert.ToDouble(row["terrain_lower_limit"]); | ||
1329 | newSettings.UseEstateSun = Convert.ToBoolean(row["use_estate_sun"]); | ||
1330 | newSettings.FixedSun = Convert.ToBoolean(row["fixed_sun"]); | ||
1331 | newSettings.SunPosition = Convert.ToDouble(row["sun_position"]); | ||
1332 | newSettings.Covenant = new LLUUID((String) row["covenant"]); | ||
1333 | |||
1334 | return newSettings; | ||
1335 | } | ||
1336 | |||
1208 | /// <summary> | 1337 | /// <summary> |
1209 | /// | 1338 | /// |
1210 | /// </summary> | 1339 | /// </summary> |
@@ -1425,6 +1554,46 @@ namespace OpenSim.Data.MySQL | |||
1425 | /// <summary> | 1554 | /// <summary> |
1426 | /// | 1555 | /// |
1427 | /// </summary> | 1556 | /// </summary> |
1557 | private static void fillRegionSettingsRow(DataRow row, RegionSettings settings) | ||
1558 | { | ||
1559 | row["regionUUID"] = settings.RegionUUID.ToString(); | ||
1560 | row["block_terraform"] = settings.BlockTerraform; | ||
1561 | row["block_fly"] = settings.BlockFly; | ||
1562 | row["allow_damage"] = settings.AllowDamage; | ||
1563 | row["restrict_pushing"] = settings.RestrictPushing; | ||
1564 | row["allow_land_resell"] = settings.AllowLandResell; | ||
1565 | row["allow_land_join_divide"] = settings.AllowLandJoinDivide; | ||
1566 | row["block_show_in_search"] = settings.BlockShowInSearch; | ||
1567 | row["agent_limit"] = settings.AgentLimit; | ||
1568 | row["object_bonus"] = settings.ObjectBonus; | ||
1569 | row["maturity"] = settings.Maturity; | ||
1570 | row["disable_scripts"] = settings.DisableScripts; | ||
1571 | row["disable_collisions"] = settings.DisableCollisions; | ||
1572 | row["disable_physics"] = settings.DisablePhysics; | ||
1573 | row["terrain_texture_1"] = settings.TerrainTexture1.ToString(); | ||
1574 | row["terrain_texture_2"] = settings.TerrainTexture2.ToString(); | ||
1575 | row["terrain_texture_3"] = settings.TerrainTexture3.ToString(); | ||
1576 | row["terrain_texture_4"] = settings.TerrainTexture4.ToString(); | ||
1577 | row["elevation_1_nw"] = settings.Elevation1NW; | ||
1578 | row["elevation_2_nw"] = settings.Elevation2NW; | ||
1579 | row["elevation_1_ne"] = settings.Elevation1NE; | ||
1580 | row["elevation_2_ne"] = settings.Elevation2NE; | ||
1581 | row["elevation_1_se"] = settings.Elevation1SE; | ||
1582 | row["elevation_2_se"] = settings.Elevation2SE; | ||
1583 | row["elevation_1_sw"] = settings.Elevation1SW; | ||
1584 | row["elevation_2_sw"] = settings.Elevation2SW; | ||
1585 | row["water_height"] = settings.WaterHeight; | ||
1586 | row["terrain_raise_limit"] = settings.TerrainRaiseLimit; | ||
1587 | row["terrain_lower_limit"] = settings.TerrainLowerLimit; | ||
1588 | row["use_estate_sun"] = settings.UseEstateSun; | ||
1589 | row["fixed_sun"] = settings.FixedSun; | ||
1590 | row["sun_position"] = settings.SunPosition; | ||
1591 | row["covenant"] = settings.Covenant.ToString(); | ||
1592 | } | ||
1593 | |||
1594 | /// <summary> | ||
1595 | /// | ||
1596 | /// </summary> | ||
1428 | /// <param name="row"></param> | 1597 | /// <param name="row"></param> |
1429 | /// <param name="land"></param> | 1598 | /// <param name="land"></param> |
1430 | /// <param name="regionUUID"></param> | 1599 | /// <param name="regionUUID"></param> |
@@ -1865,6 +2034,20 @@ namespace OpenSim.Data.MySQL | |||
1865 | da.DeleteCommand = delete; | 2034 | da.DeleteCommand = delete; |
1866 | } | 2035 | } |
1867 | 2036 | ||
2037 | private void SetupRegionSettingsCommands(MySqlDataAdapter da, MySqlConnection conn) | ||
2038 | { | ||
2039 | da.InsertCommand = createInsertCommand("regionsettings", m_regionSettingsTable); | ||
2040 | da.InsertCommand.Connection = conn; | ||
2041 | |||
2042 | da.UpdateCommand = createUpdateCommand("regionsettings", "regionUUID = ?regionUUID", m_regionSettingsTable); | ||
2043 | da.UpdateCommand.Connection = conn; | ||
2044 | |||
2045 | MySqlCommand delete = new MySqlCommand("delete from regionsettings where regionUUID = ?regionUUID"); | ||
2046 | delete.Parameters.Add(createMySqlParameter("regionUUID", typeof(String))); | ||
2047 | delete.Connection = conn; | ||
2048 | da.DeleteCommand = delete; | ||
2049 | } | ||
2050 | |||
1868 | /// <summary> | 2051 | /// <summary> |
1869 | /// | 2052 | /// |
1870 | /// </summary> | 2053 | /// </summary> |
diff --git a/OpenSim/Data/MySQL/Resources/005_RegionStore.sql b/OpenSim/Data/MySQL/Resources/005_RegionStore.sql new file mode 100644 index 0000000..c4a9527 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/005_RegionStore.sql | |||
@@ -0,0 +1,40 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | create table regionsettings ( | ||
4 | regionUUID char(36) not null, | ||
5 | block_terraform integer not null, | ||
6 | block_fly integer not null, | ||
7 | allow_damage integer not null, | ||
8 | restrict_pushing integer not null, | ||
9 | allow_land_resell integer not null, | ||
10 | allow_land_join_divide integer not null, | ||
11 | block_show_in_search integer not null, | ||
12 | agent_limit integer not null, | ||
13 | object_bonus float not null, | ||
14 | maturity integer not null, | ||
15 | disable_scripts integer not null, | ||
16 | disable_collisions integer not null, | ||
17 | disable_physics integer not null, | ||
18 | terrain_texture_1 char(36) not null, | ||
19 | terrain_texture_2 char(36) not null, | ||
20 | terrain_texture_3 char(36) not null, | ||
21 | terrain_texture_4 char(36) not null, | ||
22 | elevation_1_nw float not null, | ||
23 | elevation_2_nw float not null, | ||
24 | elevation_1_ne float not null, | ||
25 | elevation_2_ne float not null, | ||
26 | elevation_1_se float not null, | ||
27 | elevation_2_se float not null, | ||
28 | elevation_1_sw float not null, | ||
29 | elevation_2_sw float not null, | ||
30 | water_height float not null, | ||
31 | terrain_raise_limit float not null, | ||
32 | terrain_lower_limit float not null, | ||
33 | use_estate_sun integer not null, | ||
34 | fixed_sun integer not null, | ||
35 | sun_position float not null, | ||
36 | covenant char(36), | ||
37 | primary key(regionUUID) | ||
38 | ); | ||
39 | |||
40 | COMMIT; | ||
diff --git a/OpenSim/Data/Null/NullDataStore.cs b/OpenSim/Data/Null/NullDataStore.cs index 51e13d6..422c0c6 100644 --- a/OpenSim/Data/Null/NullDataStore.cs +++ b/OpenSim/Data/Null/NullDataStore.cs | |||
@@ -43,6 +43,15 @@ namespace OpenSim.Data.Null | |||
43 | return; | 43 | return; |
44 | } | 44 | } |
45 | 45 | ||
46 | public void StoreRegionSettings(RegionSettings rs) | ||
47 | { | ||
48 | } | ||
49 | |||
50 | public RegionSettings LoadRegionSettings(LLUUID regionUUID) | ||
51 | { | ||
52 | return null; | ||
53 | } | ||
54 | |||
46 | public void StoreObject(SceneObjectGroup obj, LLUUID regionUUID) | 55 | public void StoreObject(SceneObjectGroup obj, LLUUID regionUUID) |
47 | { | 56 | { |
48 | } | 57 | } |
diff --git a/OpenSim/Data/SQLite/Resources/004_RegionStore.sql b/OpenSim/Data/SQLite/Resources/004_RegionStore.sql new file mode 100644 index 0000000..de328cb --- /dev/null +++ b/OpenSim/Data/SQLite/Resources/004_RegionStore.sql | |||
@@ -0,0 +1,38 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | create table regionsettings ( | ||
4 | regionUUID char(36) not null, | ||
5 | block_terraform integer not null, | ||
6 | block_fly integer not null, | ||
7 | allow_damage integer not null, | ||
8 | restrict_pushing integer not null, | ||
9 | allow_land_resell integer not null, | ||
10 | allow_land_join_divide integer not null, | ||
11 | block_show_in_search integer not null, | ||
12 | agent_limit integer not null, | ||
13 | object_bonus float not null, | ||
14 | maturity integer not null, | ||
15 | disable_scripts integer not null, | ||
16 | disable_collisions integer not null, | ||
17 | disable_physics integer not null, | ||
18 | terrain_texture_1 char(36) not null, | ||
19 | terrain_texture_2 char(36) not null, | ||
20 | terrain_texture_3 char(36) not null, | ||
21 | terrain_texture_4 char(36) not null, | ||
22 | elevation_1_nw float not null, | ||
23 | elevation_2_nw float not null, | ||
24 | elevation_1_ne float not null, | ||
25 | elevation_2_ne float not null, | ||
26 | elevation_1_se float not null, | ||
27 | elevation_2_se float not null, | ||
28 | elevation_1_sw float not null, | ||
29 | elevation_2_sw float not null, | ||
30 | water_height float not null, | ||
31 | terrain_raise_limit float not null, | ||
32 | terrain_lower_limit float not null, | ||
33 | use_estate_sun integer not null, | ||
34 | fixed_sun integer not null, | ||
35 | sun_position float not null, | ||
36 | covenant char(36)); | ||
37 | |||
38 | COMMIT; | ||
diff --git a/OpenSim/Data/SQLite/SQLiteRegionData.cs b/OpenSim/Data/SQLite/SQLiteRegionData.cs index 13d444e..effee9b 100644 --- a/OpenSim/Data/SQLite/SQLiteRegionData.cs +++ b/OpenSim/Data/SQLite/SQLiteRegionData.cs | |||
@@ -214,6 +214,15 @@ namespace OpenSim.Data.SQLite | |||
214 | } | 214 | } |
215 | } | 215 | } |
216 | 216 | ||
217 | public void StoreRegionSettings(RegionSettings rs) | ||
218 | { | ||
219 | } | ||
220 | |||
221 | public RegionSettings LoadRegionSettings(LLUUID regionUUID) | ||
222 | { | ||
223 | return null; | ||
224 | } | ||
225 | |||
217 | /// <summary> | 226 | /// <summary> |
218 | /// Adds an object into region storage | 227 | /// Adds an object into region storage |
219 | /// </summary> | 228 | /// </summary> |
diff --git a/OpenSim/Framework/Communications/CommunicationsManager.cs b/OpenSim/Framework/Communications/CommunicationsManager.cs index 45f692b..ccd6491 100644 --- a/OpenSim/Framework/Communications/CommunicationsManager.cs +++ b/OpenSim/Framework/Communications/CommunicationsManager.cs | |||
@@ -134,7 +134,7 @@ namespace OpenSim.Framework.Communications | |||
134 | 134 | ||
135 | public bool TryGetInventoryService(string host, out IInventoryServices inventoryService) | 135 | public bool TryGetInventoryService(string host, out IInventoryServices inventoryService) |
136 | { | 136 | { |
137 | if ((host == string.Empty) | (host == "default")) | 137 | if ((host == string.Empty) || (host == "default")) |
138 | { | 138 | { |
139 | host = m_defaultInventoryHost; | 139 | host = m_defaultInventoryHost; |
140 | } | 140 | } |
diff --git a/OpenSim/Framework/RegionSettings.cs b/OpenSim/Framework/RegionSettings.cs new file mode 100644 index 0000000..caadfd4 --- /dev/null +++ b/OpenSim/Framework/RegionSettings.cs | |||
@@ -0,0 +1,300 @@ | |||
1 | /* | ||
2 | * Copyright (c) Contributors, http://opensimulator.org/ | ||
3 | * See CONTRIBUTORS.TXT for a full list of copyright holders. | ||
4 | * | ||
5 | * Redistribution and use in source and binary forms, with or without | ||
6 | * modification, are permitted provided that the following conditions are met: | ||
7 | * * Redistributions of source code must retain the above copyright | ||
8 | * notice, this list of conditions and the following disclaimer. | ||
9 | * * Redistributions in binary form must reproduce the above copyright | ||
10 | * notice, this list of conditions and the following disclaimer in the | ||
11 | * documentation and/or other materials provided with the distribution. | ||
12 | * * Neither the name of the OpenSim Project nor the | ||
13 | * names of its contributors may be used to endorse or promote products | ||
14 | * derived from this software without specific prior written permission. | ||
15 | * | ||
16 | * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY | ||
17 | * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED | ||
18 | * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE | ||
19 | * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY | ||
20 | * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES | ||
21 | * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; | ||
22 | * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND | ||
23 | * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT | ||
24 | * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS | ||
25 | * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | ||
26 | */ | ||
27 | |||
28 | using System; | ||
29 | using libsecondlife; | ||
30 | using log4net; | ||
31 | |||
32 | namespace OpenSim.Framework | ||
33 | { | ||
34 | public class RegionSettings | ||
35 | { | ||
36 | private LLUUID m_RegionUUID; | ||
37 | |||
38 | public LLUUID RegionUUID | ||
39 | { | ||
40 | get { return m_RegionUUID; } | ||
41 | set { m_RegionUUID = value; } | ||
42 | } | ||
43 | |||
44 | private bool m_BlockTerraform; | ||
45 | |||
46 | public bool BlockTerraform | ||
47 | { | ||
48 | get { return m_BlockTerraform; } | ||
49 | set { m_BlockTerraform = value; } | ||
50 | } | ||
51 | |||
52 | private bool m_BlockFly; | ||
53 | |||
54 | public bool BlockFly | ||
55 | { | ||
56 | get { return m_BlockFly; } | ||
57 | set { m_BlockFly = value; } | ||
58 | } | ||
59 | |||
60 | private bool m_AllowDamage; | ||
61 | |||
62 | public bool AllowDamage | ||
63 | { | ||
64 | get { return m_AllowDamage; } | ||
65 | set { m_AllowDamage = value; } | ||
66 | } | ||
67 | |||
68 | private bool m_RestrictPushing; | ||
69 | |||
70 | public bool RestrictPushing | ||
71 | { | ||
72 | get { return m_RestrictPushing; } | ||
73 | set { m_RestrictPushing = value; } | ||
74 | } | ||
75 | |||
76 | private bool m_AllowLandResell; | ||
77 | |||
78 | public bool AllowLandResell | ||
79 | { | ||
80 | get { return m_AllowLandResell; } | ||
81 | set { m_AllowLandResell = value; } | ||
82 | } | ||
83 | |||
84 | private bool m_AllowLandJoinDivide; | ||
85 | |||
86 | public bool AllowLandJoinDivide | ||
87 | { | ||
88 | get { return m_AllowLandJoinDivide; } | ||
89 | set { m_AllowLandJoinDivide = value; } | ||
90 | } | ||
91 | |||
92 | private bool m_BlockShowInSearch; | ||
93 | |||
94 | public bool BlockShowInSearch | ||
95 | { | ||
96 | get { return m_BlockShowInSearch; } | ||
97 | set { m_BlockShowInSearch = value; } | ||
98 | } | ||
99 | |||
100 | private int m_AgentLimit; | ||
101 | |||
102 | public int AgentLimit | ||
103 | { | ||
104 | get { return m_AgentLimit; } | ||
105 | set { m_AgentLimit = value; } | ||
106 | } | ||
107 | |||
108 | private double m_ObjectBonus; | ||
109 | |||
110 | public double ObjectBonus | ||
111 | { | ||
112 | get { return m_ObjectBonus; } | ||
113 | set { m_ObjectBonus = value; } | ||
114 | } | ||
115 | |||
116 | private int m_Maturity; | ||
117 | |||
118 | public int Maturity | ||
119 | { | ||
120 | get { return m_Maturity; } | ||
121 | set { m_Maturity = value; } | ||
122 | } | ||
123 | |||
124 | private bool m_DisableScripts; | ||
125 | |||
126 | public bool DisableScripts | ||
127 | { | ||
128 | get { return m_DisableScripts; } | ||
129 | set { m_DisableScripts = value; } | ||
130 | } | ||
131 | |||
132 | private bool m_DisableCollisions; | ||
133 | |||
134 | public bool DisableCollisions | ||
135 | { | ||
136 | get { return m_DisableCollisions; } | ||
137 | set { m_DisableCollisions = value; } | ||
138 | } | ||
139 | |||
140 | private bool m_DisablePhysics; | ||
141 | |||
142 | public bool DisablePhysics | ||
143 | { | ||
144 | get { return m_DisablePhysics; } | ||
145 | set { m_DisablePhysics = value; } | ||
146 | } | ||
147 | |||
148 | private LLUUID m_TerrainTexture1; | ||
149 | |||
150 | public LLUUID TerrainTexture1 | ||
151 | { | ||
152 | get { return m_TerrainTexture1; } | ||
153 | set { m_TerrainTexture1 = value; } | ||
154 | } | ||
155 | |||
156 | private LLUUID m_TerrainTexture2; | ||
157 | |||
158 | public LLUUID TerrainTexture2 | ||
159 | { | ||
160 | get { return m_TerrainTexture2; } | ||
161 | set { m_TerrainTexture2 = value; } | ||
162 | } | ||
163 | |||
164 | private LLUUID m_TerrainTexture3; | ||
165 | |||
166 | public LLUUID TerrainTexture3 | ||
167 | { | ||
168 | get { return m_TerrainTexture3; } | ||
169 | set { m_TerrainTexture3 = value; } | ||
170 | } | ||
171 | |||
172 | private LLUUID m_TerrainTexture4; | ||
173 | |||
174 | public LLUUID TerrainTexture4 | ||
175 | { | ||
176 | get { return m_TerrainTexture4; } | ||
177 | set { m_TerrainTexture4 = value; } | ||
178 | } | ||
179 | |||
180 | private double m_Elevation1NW; | ||
181 | |||
182 | public double Elevation1NW | ||
183 | { | ||
184 | get { return m_Elevation1NW; } | ||
185 | set { m_Elevation1NW = value; } | ||
186 | } | ||
187 | |||
188 | private double m_Elevation2NW; | ||
189 | |||
190 | public double Elevation2NW | ||
191 | { | ||
192 | get { return m_Elevation2NW; } | ||
193 | set { m_Elevation2NW = value; } | ||
194 | } | ||
195 | |||
196 | private double m_Elevation1NE; | ||
197 | |||
198 | public double Elevation1NE | ||
199 | { | ||
200 | get { return m_Elevation1NE; } | ||
201 | set { m_Elevation1NE = value; } | ||
202 | } | ||
203 | |||
204 | private double m_Elevation2NE; | ||
205 | |||
206 | public double Elevation2NE | ||
207 | { | ||
208 | get { return m_Elevation2NE; } | ||
209 | set { m_Elevation2NE = value; } | ||
210 | } | ||
211 | |||
212 | private double m_Elevation1SE; | ||
213 | |||
214 | public double Elevation1SE | ||
215 | { | ||
216 | get { return m_Elevation1SE; } | ||
217 | set { m_Elevation1SE = value; } | ||
218 | } | ||
219 | |||
220 | private double m_Elevation2SE; | ||
221 | |||
222 | public double Elevation2SE | ||
223 | { | ||
224 | get { return m_Elevation2SE; } | ||
225 | set { m_Elevation2SE = value; } | ||
226 | } | ||
227 | |||
228 | private double m_Elevation1SW; | ||
229 | |||
230 | public double Elevation1SW | ||
231 | { | ||
232 | get { return m_Elevation1SW; } | ||
233 | set { m_Elevation1SW = value; } | ||
234 | } | ||
235 | |||
236 | private double m_Elevation2SW; | ||
237 | |||
238 | public double Elevation2SW | ||
239 | { | ||
240 | get { return m_Elevation2SW; } | ||
241 | set { m_Elevation2SW = value; } | ||
242 | } | ||
243 | |||
244 | private double m_WaterHeight; | ||
245 | |||
246 | public double WaterHeight | ||
247 | { | ||
248 | get { return m_WaterHeight; } | ||
249 | set { m_WaterHeight = value; } | ||
250 | } | ||
251 | |||
252 | private double m_TerrainRaiseLimit; | ||
253 | |||
254 | public double TerrainRaiseLimit | ||
255 | { | ||
256 | get { return m_TerrainRaiseLimit; } | ||
257 | set { m_TerrainRaiseLimit = value; } | ||
258 | } | ||
259 | |||
260 | private double m_TerrainLowerLimit; | ||
261 | |||
262 | public double TerrainLowerLimit | ||
263 | { | ||
264 | get { return m_TerrainLowerLimit; } | ||
265 | set { m_TerrainLowerLimit = value; } | ||
266 | } | ||
267 | |||
268 | private bool m_UseEstateSun; | ||
269 | |||
270 | public bool UseEstateSun | ||
271 | { | ||
272 | get { return m_UseEstateSun; } | ||
273 | set { m_UseEstateSun = value; } | ||
274 | } | ||
275 | |||
276 | private bool m_FixedSun; | ||
277 | |||
278 | public bool FixedSun | ||
279 | { | ||
280 | get { return m_FixedSun; } | ||
281 | set { m_FixedSun = value; } | ||
282 | } | ||
283 | |||
284 | private double m_SunPosition; | ||
285 | |||
286 | public double SunPosition | ||
287 | { | ||
288 | get { return m_SunPosition; } | ||
289 | set { m_SunPosition = value; } | ||
290 | } | ||
291 | |||
292 | private LLUUID m_Covenant; | ||
293 | |||
294 | public LLUUID Covenant | ||
295 | { | ||
296 | get { return m_Covenant; } | ||
297 | set { m_Covenant = value; } | ||
298 | } | ||
299 | } | ||
300 | } | ||
diff --git a/OpenSim/Region/Environment/Interfaces/IRegionDataStore.cs b/OpenSim/Region/Environment/Interfaces/IRegionDataStore.cs index 0ea2c03..c189f95 100644 --- a/OpenSim/Region/Environment/Interfaces/IRegionDataStore.cs +++ b/OpenSim/Region/Environment/Interfaces/IRegionDataStore.cs | |||
@@ -76,7 +76,8 @@ namespace OpenSim.Region.Environment.Interfaces | |||
76 | void AddToRegionBanlist(RegionBanListItem item); | 76 | void AddToRegionBanlist(RegionBanListItem item); |
77 | void RemoveFromRegionBanlist(RegionBanListItem item); | 77 | void RemoveFromRegionBanlist(RegionBanListItem item); |
78 | 78 | ||
79 | 79 | void StoreRegionSettings(RegionSettings rs); | |
80 | RegionSettings LoadRegionSettings(LLUUID regionUUID); | ||
80 | 81 | ||
81 | void Shutdown(); | 82 | void Shutdown(); |
82 | } | 83 | } |
diff --git a/OpenSim/Region/Storage/OpenSim.DataStore.MSSQL/MSSQLDataStore.cs b/OpenSim/Region/Storage/OpenSim.DataStore.MSSQL/MSSQLDataStore.cs index 145d5eb..8db5d7d 100644 --- a/OpenSim/Region/Storage/OpenSim.DataStore.MSSQL/MSSQLDataStore.cs +++ b/OpenSim/Region/Storage/OpenSim.DataStore.MSSQL/MSSQLDataStore.cs | |||
@@ -124,6 +124,15 @@ namespace OpenSim.DataStore.MSSQL | |||
124 | } | 124 | } |
125 | } | 125 | } |
126 | 126 | ||
127 | public void StoreRegionSettings(RegionSettings rs) | ||
128 | { | ||
129 | } | ||
130 | |||
131 | public RegionSettings LoadRegionSettings(LLUUID regionUUID) | ||
132 | { | ||
133 | return null; | ||
134 | } | ||
135 | |||
127 | public void StoreObject(SceneObjectGroup obj, LLUUID regionUUID) | 136 | public void StoreObject(SceneObjectGroup obj, LLUUID regionUUID) |
128 | { | 137 | { |
129 | lock (ds) | 138 | lock (ds) |