diff options
| author | Adam Frisby | 2007-11-04 23:31:35 +0000 |
|---|---|---|
| committer | Adam Frisby | 2007-11-04 23:31:35 +0000 |
| commit | 181dd8d8dcc26dfb3267e114ef8cdc08b9f45694 (patch) | |
| tree | ecda8d7af7bc51031c842a735c90f80116fd0ec0 | |
| parent | Some more refactoring (diff) | |
| download | opensim-SC_OLD-181dd8d8dcc26dfb3267e114ef8cdc08b9f45694.zip opensim-SC_OLD-181dd8d8dcc26dfb3267e114ef8cdc08b9f45694.tar.gz opensim-SC_OLD-181dd8d8dcc26dfb3267e114ef8cdc08b9f45694.tar.bz2 opensim-SC_OLD-181dd8d8dcc26dfb3267e114ef8cdc08b9f45694.tar.xz | |
* Changed MySQL Syntax on Region Updates for Grid Server.
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Framework/Data.MySQL/MySQLManager.cs | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/OpenSim/Framework/Data.MySQL/MySQLManager.cs b/OpenSim/Framework/Data.MySQL/MySQLManager.cs index 778da06..ca57f9d 100644 --- a/OpenSim/Framework/Data.MySQL/MySQLManager.cs +++ b/OpenSim/Framework/Data.MySQL/MySQLManager.cs | |||
| @@ -601,7 +601,7 @@ namespace OpenSim.Framework.Data.MySQL | |||
| 601 | public bool insertRegion(RegionProfileData regiondata) | 601 | public bool insertRegion(RegionProfileData regiondata) |
| 602 | { | 602 | { |
| 603 | string sql = | 603 | string sql = |
| 604 | "REPLACE INTO regions (regionHandle, regionName, uuid, regionRecvKey, regionSecret, regionSendKey, regionDataURI, "; | 604 | "INSERT INTO regions (regionHandle, regionName, uuid, regionRecvKey, regionSecret, regionSendKey, regionDataURI, "; |
| 605 | sql += | 605 | sql += |
| 606 | "serverIP, serverPort, serverURI, locX, locY, locZ, eastOverrideHandle, westOverrideHandle, southOverrideHandle, northOverrideHandle, regionAssetURI, regionAssetRecvKey, "; | 606 | "serverIP, serverPort, serverURI, locX, locY, locZ, eastOverrideHandle, westOverrideHandle, southOverrideHandle, northOverrideHandle, regionAssetURI, regionAssetRecvKey, "; |
| 607 | sql += | 607 | sql += |
| @@ -611,7 +611,8 @@ namespace OpenSim.Framework.Data.MySQL | |||
| 611 | sql += | 611 | sql += |
| 612 | "?serverIP, ?serverPort, ?serverURI, ?locX, ?locY, ?locZ, ?eastOverrideHandle, ?westOverrideHandle, ?southOverrideHandle, ?northOverrideHandle, ?regionAssetURI, ?regionAssetRecvKey, "; | 612 | "?serverIP, ?serverPort, ?serverURI, ?locX, ?locY, ?locZ, ?eastOverrideHandle, ?westOverrideHandle, ?southOverrideHandle, ?northOverrideHandle, ?regionAssetURI, ?regionAssetRecvKey, "; |
| 613 | sql += | 613 | sql += |
| 614 | "?regionAssetSendKey, ?regionUserURI, ?regionUserRecvKey, ?regionUserSendKey, ?regionMapTexture, ?serverHttpPort, ?serverRemotingPort);"; | 614 | "?regionAssetSendKey, ?regionUserURI, ?regionUserRecvKey, ?regionUserSendKey, ?regionMapTexture, ?serverHttpPort, ?serverRemotingPort)"; |
| 615 | sql += "ON DUPLICATE KEY UPDATE;"; | ||
| 615 | 616 | ||
| 616 | Dictionary<string, string> parameters = new Dictionary<string, string>(); | 617 | Dictionary<string, string> parameters = new Dictionary<string, string>(); |
| 617 | 618 | ||