From efd90b56b761219af6425b1c7a2cdd3b6ffb4de2 Mon Sep 17 00:00:00 2001
From: lbsa71
Date: Thu, 27 Dec 2007 21:41:48 +0000
Subject: * Optimized usings * shortened references * Removed redundant 'this'
* Normalized EOF
---
OpenSim/Framework/Data.MySQL/MySQLUserData.cs | 53 +++++++++++++--------------
1 file changed, 25 insertions(+), 28 deletions(-)
(limited to 'OpenSim/Framework/Data.MySQL/MySQLUserData.cs')
diff --git a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
index 4b86d80..2d96f6e 100644
--- a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
+++ b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
@@ -28,6 +28,7 @@
using System;
using System.Collections.Generic;
using System.Data;
+using System.Text.RegularExpressions;
using libsecondlife;
using OpenSim.Framework.Console;
@@ -61,7 +62,7 @@ namespace OpenSim.Framework.Data.MySQL
database =
new MySQLManager(settingHostname, settingDatabase, settingUsername, settingPassword, settingPooling,
settingPort);
-
+
TestTables();
}
@@ -81,7 +82,7 @@ namespace OpenSim.Framework.Data.MySQL
UpgradeAgentsTable(tableList["agents"]);
UpgradeUsersTable(tableList["users"]);
}
-
+
///
/// Create or upgrade the table if necessary
///
@@ -95,8 +96,8 @@ namespace OpenSim.Framework.Data.MySQL
database.ExecuteResourceSql("CreateAgentsTable.sql");
return;
}
- }
-
+ }
+
///
/// Create or upgrade the table if necessary
///
@@ -110,8 +111,8 @@ namespace OpenSim.Framework.Data.MySQL
database.ExecuteResourceSql("CreateUsersTable.sql");
return;
}
- }
-
+ }
+
#endregion
// see IUserData
@@ -144,11 +145,11 @@ namespace OpenSim.Framework.Data.MySQL
}
}
- public List GeneratePickerResults(LLUUID queryID, string query)
+ public List GeneratePickerResults(LLUUID queryID, string query)
{
- List returnlist = new List();
+ List returnlist = new List();
- System.Text.RegularExpressions.Regex objAlphaNumericPattern = new System.Text.RegularExpressions.Regex("[^a-zA-Z0-9]");
+ Regex objAlphaNumericPattern = new Regex("[^a-zA-Z0-9]");
string[] querysplit;
querysplit = query.Split(' ');
@@ -161,21 +162,20 @@ namespace OpenSim.Framework.Data.MySQL
{
lock (database)
{
-
-
IDbCommand result =
- database.Query("SELECT UUID,username,lastname FROM users WHERE username like ?first AND lastname like ?second LIMIT 100", param);
+ database.Query(
+ "SELECT UUID,username,lastname FROM users WHERE username like ?first AND lastname like ?second LIMIT 100",
+ param);
IDataReader reader = result.ExecuteReader();
while (reader.Read())
{
- OpenSim.Framework.AvatarPickerAvatar user = new OpenSim.Framework.AvatarPickerAvatar();
- user.AvatarID = new LLUUID((string)reader["UUID"]);
- user.firstName = (string)reader["username"];
- user.lastName = (string)reader["lastname"];
+ Framework.AvatarPickerAvatar user = new Framework.AvatarPickerAvatar();
+ user.AvatarID = new LLUUID((string) reader["UUID"]);
+ user.firstName = (string) reader["username"];
+ user.lastName = (string) reader["lastname"];
returnlist.Add(user);
-
}
reader.Close();
result.Dispose();
@@ -187,13 +187,9 @@ namespace OpenSim.Framework.Data.MySQL
MainLog.Instance.Error(e.ToString());
return returnlist;
}
-
-
-
}
else if (querysplit.Length == 1)
{
-
try
{
lock (database)
@@ -202,18 +198,19 @@ namespace OpenSim.Framework.Data.MySQL
param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], "") + "%";
IDbCommand result =
- database.Query("SELECT UUID,username,lastname FROM users WHERE username like ?first OR lastname like ?first LIMIT 100", param);
+ database.Query(
+ "SELECT UUID,username,lastname FROM users WHERE username like ?first OR lastname like ?first LIMIT 100",
+ param);
IDataReader reader = result.ExecuteReader();
while (reader.Read())
{
- OpenSim.Framework.AvatarPickerAvatar user = new OpenSim.Framework.AvatarPickerAvatar();
- user.AvatarID = new LLUUID((string)reader["UUID"]);
- user.firstName = (string)reader["username"];
- user.lastName = (string)reader["lastname"];
+ Framework.AvatarPickerAvatar user = new Framework.AvatarPickerAvatar();
+ user.AvatarID = new LLUUID((string) reader["UUID"]);
+ user.firstName = (string) reader["username"];
+ user.lastName = (string) reader["lastname"];
returnlist.Add(user);
-
}
reader.Close();
result.Dispose();
@@ -402,4 +399,4 @@ namespace OpenSim.Framework.Data.MySQL
return "0.1";
}
}
-}
+}
\ No newline at end of file
--
cgit v1.1