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 /OpenSim | |
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.
Diffstat (limited to 'OpenSim')
-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 | ||