diff options
| author | Adam Frisby | 2007-11-05 01:35:17 +0000 |
|---|---|---|
| committer | Adam Frisby | 2007-11-05 01:35:17 +0000 |
| commit | 7896a0c453f75d5a24b6c6ce9df05def25db4daa (patch) | |
| tree | 1be8b52454fccf4b31f5bb1f9b7e635a9478a06a | |
| parent | * Changed MySQL Syntax on Region Updates for Grid Server. (diff) | |
| download | opensim-SC-7896a0c453f75d5a24b6c6ce9df05def25db4daa.zip opensim-SC-7896a0c453f75d5a24b6c6ce9df05def25db4daa.tar.gz opensim-SC-7896a0c453f75d5a24b6c6ce9df05def25db4daa.tar.bz2 opensim-SC-7896a0c453f75d5a24b6c6ce9df05def25db4daa.tar.xz | |
* Temporarily reverted SQL syntax.
| -rw-r--r-- | OpenSim/Framework/Data.MySQL/MySQLManager.cs | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Framework/Data.MySQL/MySQLManager.cs b/OpenSim/Framework/Data.MySQL/MySQLManager.cs index ca57f9d..502b47c 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 | "INSERT INTO regions (regionHandle, regionName, uuid, regionRecvKey, regionSecret, regionSendKey, regionDataURI, "; | 604 | "REPLACE 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,8 +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 | //sql += "ON DUPLICATE KEY UPDATE;"; |
| 616 | 616 | ||
| 617 | Dictionary<string, string> parameters = new Dictionary<string, string>(); | 617 | Dictionary<string, string> parameters = new Dictionary<string, string>(); |
| 618 | 618 | ||