From 181dd8d8dcc26dfb3267e114ef8cdc08b9f45694 Mon Sep 17 00:00:00 2001
From: Adam Frisby
Date: Sun, 4 Nov 2007 23:31:35 +0000
Subject: * Changed MySQL Syntax on Region Updates for Grid Server.
---
OpenSim/Framework/Data.MySQL/MySQLManager.cs | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)
(limited to 'OpenSim')
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
public bool insertRegion(RegionProfileData regiondata)
{
string sql =
- "REPLACE INTO regions (regionHandle, regionName, uuid, regionRecvKey, regionSecret, regionSendKey, regionDataURI, ";
+ "INSERT INTO regions (regionHandle, regionName, uuid, regionRecvKey, regionSecret, regionSendKey, regionDataURI, ";
sql +=
"serverIP, serverPort, serverURI, locX, locY, locZ, eastOverrideHandle, westOverrideHandle, southOverrideHandle, northOverrideHandle, regionAssetURI, regionAssetRecvKey, ";
sql +=
@@ -611,7 +611,8 @@ namespace OpenSim.Framework.Data.MySQL
sql +=
"?serverIP, ?serverPort, ?serverURI, ?locX, ?locY, ?locZ, ?eastOverrideHandle, ?westOverrideHandle, ?southOverrideHandle, ?northOverrideHandle, ?regionAssetURI, ?regionAssetRecvKey, ";
sql +=
- "?regionAssetSendKey, ?regionUserURI, ?regionUserRecvKey, ?regionUserSendKey, ?regionMapTexture, ?serverHttpPort, ?serverRemotingPort);";
+ "?regionAssetSendKey, ?regionUserURI, ?regionUserRecvKey, ?regionUserSendKey, ?regionMapTexture, ?serverHttpPort, ?serverRemotingPort)";
+ sql += "ON DUPLICATE KEY UPDATE;";
Dictionary<string, string> parameters = new Dictionary<string, string>();
--
cgit v1.1