diff options
Diffstat (limited to 'OpenSim/Framework/Data.MySQL')
-rw-r--r-- | OpenSim/Framework/Data.MySQL/MySQLDataStore.cs | 10 | ||||
-rw-r--r-- | OpenSim/Framework/Data.MySQL/MySQLGridData.cs | 6 | ||||
-rw-r--r-- | OpenSim/Framework/Data.MySQL/MySQLManager.cs | 12 | ||||
-rw-r--r-- | OpenSim/Framework/Data.MySQL/MySQLUserData.cs | 6 | ||||
-rw-r--r-- | OpenSim/Framework/Data.MySQL/Properties/AssemblyInfo.cs | 30 |
5 files changed, 46 insertions, 18 deletions
diff --git a/OpenSim/Framework/Data.MySQL/MySQLDataStore.cs b/OpenSim/Framework/Data.MySQL/MySQLDataStore.cs index 8055448..26985b3 100644 --- a/OpenSim/Framework/Data.MySQL/MySQLDataStore.cs +++ b/OpenSim/Framework/Data.MySQL/MySQLDataStore.cs | |||
@@ -485,7 +485,7 @@ namespace OpenSim.Framework.Data.MySQL | |||
485 | foreach (DataColumn column in table.Columns) | 485 | foreach (DataColumn column in table.Columns) |
486 | Debug.Write(column.ColumnName + " = " + | 486 | Debug.Write(column.ColumnName + " = " + |
487 | row[column, DataRowVersion.Original] + ", "); | 487 | row[column, DataRowVersion.Original] + ", "); |
488 | Debug.WriteLine(""); | 488 | Debug.WriteLine(String.Empty); |
489 | } | 489 | } |
490 | //--- Display the current values, if there are any. | 490 | //--- Display the current values, if there are any. |
491 | if (row.HasVersion(DataRowVersion.Current)) | 491 | if (row.HasVersion(DataRowVersion.Current)) |
@@ -494,9 +494,9 @@ namespace OpenSim.Framework.Data.MySQL | |||
494 | foreach (DataColumn column in table.Columns) | 494 | foreach (DataColumn column in table.Columns) |
495 | Debug.Write(column.ColumnName + " = " + | 495 | Debug.Write(column.ColumnName + " = " + |
496 | row[column, DataRowVersion.Current] + ", "); | 496 | row[column, DataRowVersion.Current] + ", "); |
497 | Debug.WriteLine(""); | 497 | Debug.WriteLine(String.Empty); |
498 | } | 498 | } |
499 | Debug.WriteLine(""); | 499 | Debug.WriteLine(String.Empty); |
500 | } | 500 | } |
501 | } | 501 | } |
502 | } | 502 | } |
@@ -1313,7 +1313,7 @@ namespace OpenSim.Framework.Data.MySQL | |||
1313 | private MySqlCommand createUpdateCommand(string table, string pk, DataTable dt) | 1313 | private MySqlCommand createUpdateCommand(string table, string pk, DataTable dt) |
1314 | { | 1314 | { |
1315 | string sql = "update " + table + " set "; | 1315 | string sql = "update " + table + " set "; |
1316 | string subsql = ""; | 1316 | string subsql = String.Empty; |
1317 | foreach (DataColumn col in dt.Columns) | 1317 | foreach (DataColumn col in dt.Columns) |
1318 | { | 1318 | { |
1319 | if (subsql.Length > 0) | 1319 | if (subsql.Length > 0) |
@@ -1341,7 +1341,7 @@ namespace OpenSim.Framework.Data.MySQL | |||
1341 | private string defineTable(DataTable dt) | 1341 | private string defineTable(DataTable dt) |
1342 | { | 1342 | { |
1343 | string sql = "create table " + dt.TableName + "("; | 1343 | string sql = "create table " + dt.TableName + "("; |
1344 | string subsql = ""; | 1344 | string subsql = String.Empty; |
1345 | foreach (DataColumn col in dt.Columns) | 1345 | foreach (DataColumn col in dt.Columns) |
1346 | { | 1346 | { |
1347 | if (subsql.Length > 0) | 1347 | if (subsql.Length > 0) |
diff --git a/OpenSim/Framework/Data.MySQL/MySQLGridData.cs b/OpenSim/Framework/Data.MySQL/MySQLGridData.cs index 7cfac12..c8c4ab0 100644 --- a/OpenSim/Framework/Data.MySQL/MySQLGridData.cs +++ b/OpenSim/Framework/Data.MySQL/MySQLGridData.cs | |||
@@ -219,8 +219,8 @@ namespace OpenSim.Framework.Data.MySQL | |||
219 | if (querysplit.Length == 2) | 219 | if (querysplit.Length == 2) |
220 | { | 220 | { |
221 | Dictionary<string, string> param = new Dictionary<string, string>(); | 221 | Dictionary<string, string> param = new Dictionary<string, string>(); |
222 | param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], "") + "%"; | 222 | param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], String.Empty) + "%"; |
223 | param["?second"] = objAlphaNumericPattern.Replace(querysplit[1], "") + "%"; | 223 | param["?second"] = objAlphaNumericPattern.Replace(querysplit[1], String.Empty) + "%"; |
224 | try | 224 | try |
225 | { | 225 | { |
226 | lock (database) | 226 | lock (database) |
@@ -258,7 +258,7 @@ namespace OpenSim.Framework.Data.MySQL | |||
258 | lock (database) | 258 | lock (database) |
259 | { | 259 | { |
260 | Dictionary<string, string> param = new Dictionary<string, string>(); | 260 | Dictionary<string, string> param = new Dictionary<string, string>(); |
261 | param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], "") + "%"; | 261 | param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], System.String.Empty) + "%"; |
262 | 262 | ||
263 | IDbCommand result = | 263 | IDbCommand result = |
264 | database.Query( | 264 | database.Query( |
diff --git a/OpenSim/Framework/Data.MySQL/MySQLManager.cs b/OpenSim/Framework/Data.MySQL/MySQLManager.cs index 7645df3..15ccf5f 100644 --- a/OpenSim/Framework/Data.MySQL/MySQLManager.cs +++ b/OpenSim/Framework/Data.MySQL/MySQLManager.cs | |||
@@ -323,7 +323,7 @@ namespace OpenSim.Framework.Data.MySQL | |||
323 | 323 | ||
324 | // World Map Addition | 324 | // World Map Addition |
325 | string tempRegionMap = reader["regionMapTexture"].ToString(); | 325 | string tempRegionMap = reader["regionMapTexture"].ToString(); |
326 | if (tempRegionMap != "") | 326 | if (tempRegionMap != String.Empty) |
327 | { | 327 | { |
328 | retval.regionMapTextureID = new LLUUID(tempRegionMap); | 328 | retval.regionMapTextureID = new LLUUID(tempRegionMap); |
329 | } | 329 | } |
@@ -572,12 +572,12 @@ namespace OpenSim.Framework.Data.MySQL | |||
572 | parameters["?homeLookAtZ"] = homeLookAtZ.ToString(); | 572 | parameters["?homeLookAtZ"] = homeLookAtZ.ToString(); |
573 | parameters["?created"] = created.ToString(); | 573 | parameters["?created"] = created.ToString(); |
574 | parameters["?lastLogin"] = lastlogin.ToString(); | 574 | parameters["?lastLogin"] = lastlogin.ToString(); |
575 | parameters["?userInventoryURI"] = ""; | 575 | parameters["?userInventoryURI"] = String.Empty; |
576 | parameters["?userAssetURI"] = ""; | 576 | parameters["?userAssetURI"] = String.Empty; |
577 | parameters["?profileCanDoMask"] = "0"; | 577 | parameters["?profileCanDoMask"] = "0"; |
578 | parameters["?profileWantDoMask"] = "0"; | 578 | parameters["?profileWantDoMask"] = "0"; |
579 | parameters["?profileAboutText"] = ""; | 579 | parameters["?profileAboutText"] = String.Empty; |
580 | parameters["?profileFirstText"] = ""; | 580 | parameters["?profileFirstText"] = String.Empty; |
581 | parameters["?profileImage"] = LLUUID.Zero.ToString(); | 581 | parameters["?profileImage"] = LLUUID.Zero.ToString(); |
582 | parameters["?profileFirstImage"] = LLUUID.Zero.ToString(); | 582 | parameters["?profileFirstImage"] = LLUUID.Zero.ToString(); |
583 | parameters["?webLoginKey"] = LLUUID.Random().ToString(); | 583 | parameters["?webLoginKey"] = LLUUID.Random().ToString(); |
@@ -612,7 +612,7 @@ namespace OpenSim.Framework.Data.MySQL | |||
612 | { | 612 | { |
613 | bool GRID_ONLY_UPDATE_NECESSARY_DATA = false; | 613 | bool GRID_ONLY_UPDATE_NECESSARY_DATA = false; |
614 | 614 | ||
615 | string sql = ""; | 615 | string sql = String.Empty; |
616 | if (GRID_ONLY_UPDATE_NECESSARY_DATA) | 616 | if (GRID_ONLY_UPDATE_NECESSARY_DATA) |
617 | { | 617 | { |
618 | sql += "INSERT INTO "; | 618 | sql += "INSERT INTO "; |
diff --git a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs index 76ad551..f637db6 100644 --- a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs +++ b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs | |||
@@ -347,8 +347,8 @@ namespace OpenSim.Framework.Data.MySQL | |||
347 | if (querysplit.Length == 2) | 347 | if (querysplit.Length == 2) |
348 | { | 348 | { |
349 | Dictionary<string, string> param = new Dictionary<string, string>(); | 349 | Dictionary<string, string> param = new Dictionary<string, string>(); |
350 | param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], "") + "%"; | 350 | param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], String.Empty) + "%"; |
351 | param["?second"] = objAlphaNumericPattern.Replace(querysplit[1], "") + "%"; | 351 | param["?second"] = objAlphaNumericPattern.Replace(querysplit[1], String.Empty) + "%"; |
352 | try | 352 | try |
353 | { | 353 | { |
354 | lock (database) | 354 | lock (database) |
@@ -386,7 +386,7 @@ namespace OpenSim.Framework.Data.MySQL | |||
386 | lock (database) | 386 | lock (database) |
387 | { | 387 | { |
388 | Dictionary<string, string> param = new Dictionary<string, string>(); | 388 | Dictionary<string, string> param = new Dictionary<string, string>(); |
389 | param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], "") + "%"; | 389 | param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], String.Empty) + "%"; |
390 | 390 | ||
391 | IDbCommand result = | 391 | IDbCommand result = |
392 | database.Query( | 392 | database.Query( |
diff --git a/OpenSim/Framework/Data.MySQL/Properties/AssemblyInfo.cs b/OpenSim/Framework/Data.MySQL/Properties/AssemblyInfo.cs index 7024bfa..b33d319 100644 --- a/OpenSim/Framework/Data.MySQL/Properties/AssemblyInfo.cs +++ b/OpenSim/Framework/Data.MySQL/Properties/AssemblyInfo.cs | |||
@@ -1,3 +1,31 @@ | |||
1 | /* | ||
2 | * Copyright (c) Contributors, http://opensimulator.org/ | ||
3 | * See CONTRIBUTORS.TXT for a full list of copyright holders. | ||
4 | * | ||
5 | * Redistribution and use in source and binary forms, with or without | ||
6 | * modification, are permitted provided that the following conditions are met: | ||
7 | * * Redistributions of source code must retain the above copyright | ||
8 | * notice, this list of conditions and the following disclaimer. | ||
9 | * * Redistributions in binary form must reproduce the above copyright | ||
10 | * notice, this list of conditions and the following disclaimer in the | ||
11 | * documentation and/or other materials provided with the distribution. | ||
12 | * * Neither the name of the OpenSim Project nor the | ||
13 | * names of its contributors may be used to endorse or promote products | ||
14 | * derived from this software without specific prior written permission. | ||
15 | * | ||
16 | * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY | ||
17 | * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED | ||
18 | * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE | ||
19 | * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY | ||
20 | * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES | ||
21 | * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; | ||
22 | * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND | ||
23 | * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT | ||
24 | * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS | ||
25 | * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | ||
26 | * | ||
27 | */ | ||
28 | |||
1 | using System.Reflection; | 29 | using System.Reflection; |
2 | using System.Runtime.InteropServices; | 30 | using System.Runtime.InteropServices; |
3 | 31 | ||
@@ -10,7 +38,7 @@ using System.Runtime.InteropServices; | |||
10 | [assembly : AssemblyConfiguration("")] | 38 | [assembly : AssemblyConfiguration("")] |
11 | [assembly : AssemblyCompany("")] | 39 | [assembly : AssemblyCompany("")] |
12 | [assembly : AssemblyProduct("OpenSim.Framework.Data.MySQL")] | 40 | [assembly : AssemblyProduct("OpenSim.Framework.Data.MySQL")] |
13 | [assembly : AssemblyCopyright("Copyright © 2007")] | 41 | [assembly : AssemblyCopyright("Copyright © OpenSimulator.org Developers 2007-2008")] |
14 | [assembly : AssemblyTrademark("")] | 42 | [assembly : AssemblyTrademark("")] |
15 | [assembly : AssemblyCulture("")] | 43 | [assembly : AssemblyCulture("")] |
16 | 44 | ||