aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Framework/Data.MySQL/MySQLManager.cs
diff options
context:
space:
mode:
authorAdam Frisby2007-11-05 01:35:17 +0000
committerAdam Frisby2007-11-05 01:35:17 +0000
commit7896a0c453f75d5a24b6c6ce9df05def25db4daa (patch)
tree1be8b52454fccf4b31f5bb1f9b7e635a9478a06a /OpenSim/Framework/Data.MySQL/MySQLManager.cs
parent* Changed MySQL Syntax on Region Updates for Grid Server. (diff)
downloadopensim-SC_OLD-7896a0c453f75d5a24b6c6ce9df05def25db4daa.zip
opensim-SC_OLD-7896a0c453f75d5a24b6c6ce9df05def25db4daa.tar.gz
opensim-SC_OLD-7896a0c453f75d5a24b6c6ce9df05def25db4daa.tar.bz2
opensim-SC_OLD-7896a0c453f75d5a24b6c6ce9df05def25db4daa.tar.xz
* Temporarily reverted SQL syntax.
Diffstat (limited to 'OpenSim/Framework/Data.MySQL/MySQLManager.cs')
-rw-r--r--OpenSim/Framework/Data.MySQL/MySQLManager.cs6
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