diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLManager.cs | 6 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/002_GridStore.sql | 5 |
2 files changed, 9 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/MySQLManager.cs b/OpenSim/Data/MySQL/MySQLManager.cs index ad022a5..139d57f 100644 --- a/OpenSim/Data/MySQL/MySQLManager.cs +++ b/OpenSim/Data/MySQL/MySQLManager.cs | |||
@@ -436,6 +436,7 @@ namespace OpenSim.Data.MySQL | |||
436 | // World Map Addition | 436 | // World Map Addition |
437 | UUID.TryParse((string)reader["regionMapTexture"], out retval.regionMapTextureID); | 437 | UUID.TryParse((string)reader["regionMapTexture"], out retval.regionMapTextureID); |
438 | UUID.TryParse((string)reader["owner_uuid"], out retval.owner_uuid); | 438 | UUID.TryParse((string)reader["owner_uuid"], out retval.owner_uuid); |
439 | retval.maturity = Convert.ToUInt32(reader["access"]); | ||
439 | } | 440 | } |
440 | else | 441 | else |
441 | { | 442 | { |
@@ -976,13 +977,13 @@ namespace OpenSim.Data.MySQL | |||
976 | // server for the UUID of the region's owner (master avatar). It consists of the addition of the column and value to the relevant sql, | 977 | // server for the UUID of the region's owner (master avatar). It consists of the addition of the column and value to the relevant sql, |
977 | // as well as the related parameterization | 978 | // as well as the related parameterization |
978 | sql += | 979 | sql += |
979 | "regionAssetSendKey, regionUserURI, regionUserRecvKey, regionUserSendKey, regionMapTexture, serverHttpPort, serverRemotingPort, owner_uuid, originUUID) VALUES "; | 980 | "regionAssetSendKey, regionUserURI, regionUserRecvKey, regionUserSendKey, regionMapTexture, serverHttpPort, serverRemotingPort, owner_uuid, originUUID, access) VALUES "; |
980 | 981 | ||
981 | sql += "(?regionHandle, ?regionName, ?uuid, ?regionRecvKey, ?regionSecret, ?regionSendKey, ?regionDataURI, "; | 982 | sql += "(?regionHandle, ?regionName, ?uuid, ?regionRecvKey, ?regionSecret, ?regionSendKey, ?regionDataURI, "; |
982 | sql += | 983 | sql += |
983 | "?serverIP, ?serverPort, ?serverURI, ?locX, ?locY, ?locZ, ?eastOverrideHandle, ?westOverrideHandle, ?southOverrideHandle, ?northOverrideHandle, ?regionAssetURI, ?regionAssetRecvKey, "; | 984 | "?serverIP, ?serverPort, ?serverURI, ?locX, ?locY, ?locZ, ?eastOverrideHandle, ?westOverrideHandle, ?southOverrideHandle, ?northOverrideHandle, ?regionAssetURI, ?regionAssetRecvKey, "; |
984 | sql += | 985 | sql += |
985 | "?regionAssetSendKey, ?regionUserURI, ?regionUserRecvKey, ?regionUserSendKey, ?regionMapTexture, ?serverHttpPort, ?serverRemotingPort, ?owner_uuid, ?originUUID)"; | 986 | "?regionAssetSendKey, ?regionUserURI, ?regionUserRecvKey, ?regionUserSendKey, ?regionMapTexture, ?serverHttpPort, ?serverRemotingPort, ?owner_uuid, ?originUUID, ?access)"; |
986 | 987 | ||
987 | if (GRID_ONLY_UPDATE_NECESSARY_DATA) | 988 | if (GRID_ONLY_UPDATE_NECESSARY_DATA) |
988 | { | 989 | { |
@@ -1023,6 +1024,7 @@ namespace OpenSim.Data.MySQL | |||
1023 | parameters["?serverRemotingPort"] = regiondata.remotingPort.ToString(); | 1024 | parameters["?serverRemotingPort"] = regiondata.remotingPort.ToString(); |
1024 | parameters["?owner_uuid"] = regiondata.owner_uuid.ToString(); | 1025 | parameters["?owner_uuid"] = regiondata.owner_uuid.ToString(); |
1025 | parameters["?originUUID"] = regiondata.originUUID.ToString(); | 1026 | parameters["?originUUID"] = regiondata.originUUID.ToString(); |
1027 | parameters["?access"] = regiondata.maturity.ToString(); | ||
1026 | 1028 | ||
1027 | bool returnval = false; | 1029 | bool returnval = false; |
1028 | 1030 | ||
diff --git a/OpenSim/Data/MySQL/Resources/002_GridStore.sql b/OpenSim/Data/MySQL/Resources/002_GridStore.sql new file mode 100644 index 0000000..bda43d0 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/002_GridStore.sql | |||
@@ -0,0 +1,5 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | ALTER TABLE regions add column access integer unsigned default 1; | ||
4 | |||
5 | COMMIT; | ||