diff options
author | Justin Clarke Casey | 2009-01-07 18:46:27 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2009-01-07 18:46:27 +0000 |
commit | 8d035b196df31ddb41e4917a757e83acdbb03d78 (patch) | |
tree | 777605603b47b20075b13fd56317667b29b36185 /OpenSim/Data/MySQL/MySQLGridData.cs | |
parent | * refactor: Remove MakeHttpRequest wrapper method from Scene in favour of a d... (diff) | |
download | opensim-SC-8d035b196df31ddb41e4917a757e83acdbb03d78.zip opensim-SC-8d035b196df31ddb41e4917a757e83acdbb03d78.tar.gz opensim-SC-8d035b196df31ddb41e4917a757e83acdbb03d78.tar.bz2 opensim-SC-8d035b196df31ddb41e4917a757e83acdbb03d78.tar.xz |
* Apply http://opensimulator.org/mantis/view.php?id=2948
* This fixes adding and updating user profiles in MySQL on platforms that have a commas as a decimal separator
* Thanks Tommil!
Diffstat (limited to 'OpenSim/Data/MySQL/MySQLGridData.cs')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLGridData.cs | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/MySQLGridData.cs b/OpenSim/Data/MySQL/MySQLGridData.cs index da01ad3..437747b 100644 --- a/OpenSim/Data/MySQL/MySQLGridData.cs +++ b/OpenSim/Data/MySQL/MySQLGridData.cs | |||
@@ -245,7 +245,7 @@ namespace OpenSim.Data.MySQL | |||
245 | 245 | ||
246 | try | 246 | try |
247 | { | 247 | { |
248 | Dictionary<string, string> param = new Dictionary<string, string>(); | 248 | Dictionary<string, object> param = new Dictionary<string, object>(); |
249 | param["?xmin"] = xmin.ToString(); | 249 | param["?xmin"] = xmin.ToString(); |
250 | param["?ymin"] = ymin.ToString(); | 250 | param["?ymin"] = ymin.ToString(); |
251 | param["?xmax"] = xmax.ToString(); | 251 | param["?xmax"] = xmax.ToString(); |
@@ -294,7 +294,7 @@ namespace OpenSim.Data.MySQL | |||
294 | 294 | ||
295 | try | 295 | try |
296 | { | 296 | { |
297 | Dictionary<string, string> param = new Dictionary<string, string>(); | 297 | Dictionary<string, object> param = new Dictionary<string, object>(); |
298 | param["?name"] = namePrefix + "%"; | 298 | param["?name"] = namePrefix + "%"; |
299 | 299 | ||
300 | IDbCommand result = | 300 | IDbCommand result = |
@@ -339,7 +339,7 @@ namespace OpenSim.Data.MySQL | |||
339 | 339 | ||
340 | try | 340 | try |
341 | { | 341 | { |
342 | Dictionary<string, string> param = new Dictionary<string, string>(); | 342 | Dictionary<string, object> param = new Dictionary<string, object>(); |
343 | param["?handle"] = handle.ToString(); | 343 | param["?handle"] = handle.ToString(); |
344 | 344 | ||
345 | IDbCommand result = dbm.Manager.Query("SELECT * FROM regions WHERE regionHandle = ?handle", param); | 345 | IDbCommand result = dbm.Manager.Query("SELECT * FROM regions WHERE regionHandle = ?handle", param); |
@@ -374,7 +374,7 @@ namespace OpenSim.Data.MySQL | |||
374 | 374 | ||
375 | try | 375 | try |
376 | { | 376 | { |
377 | Dictionary<string, string> param = new Dictionary<string, string>(); | 377 | Dictionary<string, object> param = new Dictionary<string, object>(); |
378 | param["?uuid"] = uuid.ToString(); | 378 | param["?uuid"] = uuid.ToString(); |
379 | 379 | ||
380 | IDbCommand result = dbm.Manager.Query("SELECT * FROM regions WHERE uuid = ?uuid", param); | 380 | IDbCommand result = dbm.Manager.Query("SELECT * FROM regions WHERE uuid = ?uuid", param); |
@@ -409,7 +409,7 @@ namespace OpenSim.Data.MySQL | |||
409 | 409 | ||
410 | try | 410 | try |
411 | { | 411 | { |
412 | Dictionary<string, string> param = new Dictionary<string, string>(); | 412 | Dictionary<string, object> param = new Dictionary<string, object>(); |
413 | // Add % because this is a like query. | 413 | // Add % because this is a like query. |
414 | param["?regionName"] = regionName + "%"; | 414 | param["?regionName"] = regionName + "%"; |
415 | // Order by statement will return shorter matches first. Only returns one record or no record. | 415 | // Order by statement will return shorter matches first. Only returns one record or no record. |
@@ -546,7 +546,7 @@ namespace OpenSim.Data.MySQL | |||
546 | 546 | ||
547 | try | 547 | try |
548 | { | 548 | { |
549 | Dictionary<string, string> param = new Dictionary<string, string>(); | 549 | Dictionary<string, object> param = new Dictionary<string, object>(); |
550 | param["?x"] = x.ToString(); | 550 | param["?x"] = x.ToString(); |
551 | param["?y"] = y.ToString(); | 551 | param["?y"] = y.ToString(); |
552 | IDbCommand result = | 552 | IDbCommand result = |