aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLUserData.cs
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/MySQLUserData.cs')
-rw-r--r--OpenSim/Data/MySQL/MySQLUserData.cs24
1 files changed, 12 insertions, 12 deletions
diff --git a/OpenSim/Data/MySQL/MySQLUserData.cs b/OpenSim/Data/MySQL/MySQLUserData.cs
index 14d178b..f6a9af3 100644
--- a/OpenSim/Data/MySQL/MySQLUserData.cs
+++ b/OpenSim/Data/MySQL/MySQLUserData.cs
@@ -176,7 +176,7 @@ namespace OpenSim.Data.MySQL
176 176
177 try 177 try
178 { 178 {
179 Dictionary<string, string> param = new Dictionary<string, string>(); 179 Dictionary<string, object> param = new Dictionary<string, object>();
180 param["?first"] = user; 180 param["?first"] = user;
181 param["?second"] = last; 181 param["?second"] = last;
182 182
@@ -209,7 +209,7 @@ namespace OpenSim.Data.MySQL
209 { 209 {
210 int dtvalue = Util.UnixTimeSinceEpoch(); 210 int dtvalue = Util.UnixTimeSinceEpoch();
211 211
212 Dictionary<string, string> param = new Dictionary<string, string>(); 212 Dictionary<string, object> param = new Dictionary<string, object>();
213 param["?ownerID"] = friendlistowner.ToString(); 213 param["?ownerID"] = friendlistowner.ToString();
214 param["?friendID"] = friend.ToString(); 214 param["?friendID"] = friend.ToString();
215 param["?friendPerms"] = perms.ToString(); 215 param["?friendPerms"] = perms.ToString();
@@ -251,7 +251,7 @@ namespace OpenSim.Data.MySQL
251 251
252 public override void RemoveUserFriend(UUID friendlistowner, UUID friend) 252 public override void RemoveUserFriend(UUID friendlistowner, UUID friend)
253 { 253 {
254 Dictionary<string, string> param = new Dictionary<string, string>(); 254 Dictionary<string, object> param = new Dictionary<string, object>();
255 param["?ownerID"] = friendlistowner.ToString(); 255 param["?ownerID"] = friendlistowner.ToString();
256 param["?friendID"] = friend.ToString(); 256 param["?friendID"] = friend.ToString();
257 257
@@ -285,7 +285,7 @@ namespace OpenSim.Data.MySQL
285 285
286 public override void UpdateUserFriendPerms(UUID friendlistowner, UUID friend, uint perms) 286 public override void UpdateUserFriendPerms(UUID friendlistowner, UUID friend, uint perms)
287 { 287 {
288 Dictionary<string, string> param = new Dictionary<string, string>(); 288 Dictionary<string, object> param = new Dictionary<string, object>();
289 param["?ownerID"] = friendlistowner.ToString(); 289 param["?ownerID"] = friendlistowner.ToString();
290 param["?friendID"] = friend.ToString(); 290 param["?friendID"] = friend.ToString();
291 param["?friendPerms"] = perms.ToString(); 291 param["?friendPerms"] = perms.ToString();
@@ -318,7 +318,7 @@ namespace OpenSim.Data.MySQL
318 { 318 {
319 List<FriendListItem> Lfli = new List<FriendListItem>(); 319 List<FriendListItem> Lfli = new List<FriendListItem>();
320 320
321 Dictionary<string, string> param = new Dictionary<string, string>(); 321 Dictionary<string, object> param = new Dictionary<string, object>();
322 param["?ownerID"] = friendlistowner.ToString(); 322 param["?ownerID"] = friendlistowner.ToString();
323 323
324 MySQLSuperManager dbm = GetLockedConnection("GetUserFriendList"); 324 MySQLSuperManager dbm = GetLockedConnection("GetUserFriendList");
@@ -373,7 +373,7 @@ namespace OpenSim.Data.MySQL
373 { 373 {
374 foreach (UUID uuid in uuids) 374 foreach (UUID uuid in uuids)
375 { 375 {
376 Dictionary<string, string> param = new Dictionary<string, string>(); 376 Dictionary<string, object> param = new Dictionary<string, object>();
377 param["?uuid"] = uuid.ToString(); 377 param["?uuid"] = uuid.ToString();
378 IDbCommand result = 378 IDbCommand result =
379 dbm.Manager.Query("select agentOnline,currentHandle from " + m_agentsTableName + 379 dbm.Manager.Query("select agentOnline,currentHandle from " + m_agentsTableName +
@@ -419,7 +419,7 @@ namespace OpenSim.Data.MySQL
419 querysplit = query.Split(' '); 419 querysplit = query.Split(' ');
420 if (querysplit.Length > 1 && querysplit[1].Trim() != String.Empty) 420 if (querysplit.Length > 1 && querysplit[1].Trim() != String.Empty)
421 { 421 {
422 Dictionary<string, string> param = new Dictionary<string, string>(); 422 Dictionary<string, object> param = new Dictionary<string, object>();
423 param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], String.Empty) + "%"; 423 param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], String.Empty) + "%";
424 param["?second"] = objAlphaNumericPattern.Replace(querysplit[1], String.Empty) + "%"; 424 param["?second"] = objAlphaNumericPattern.Replace(querysplit[1], String.Empty) + "%";
425 MySQLSuperManager dbm = GetLockedConnection("GeneratePickerResults"); 425 MySQLSuperManager dbm = GetLockedConnection("GeneratePickerResults");
@@ -461,7 +461,7 @@ namespace OpenSim.Data.MySQL
461 461
462 try 462 try
463 { 463 {
464 Dictionary<string, string> param = new Dictionary<string, string>(); 464 Dictionary<string, object> param = new Dictionary<string, object>();
465 param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], String.Empty) + "%"; 465 param["?first"] = objAlphaNumericPattern.Replace(querysplit[0], String.Empty) + "%";
466 466
467 IDbCommand result = 467 IDbCommand result =
@@ -506,7 +506,7 @@ namespace OpenSim.Data.MySQL
506 MySQLSuperManager dbm = GetLockedConnection("GetUserByUUID"); 506 MySQLSuperManager dbm = GetLockedConnection("GetUserByUUID");
507 try 507 try
508 { 508 {
509 Dictionary<string, string> param = new Dictionary<string, string>(); 509 Dictionary<string, object> param = new Dictionary<string, object>();
510 param["?uuid"] = uuid.ToString(); 510 param["?uuid"] = uuid.ToString();
511 511
512 IDbCommand result = dbm.Manager.Query("SELECT * FROM " + m_usersTableName + " WHERE UUID = ?uuid", param); 512 IDbCommand result = dbm.Manager.Query("SELECT * FROM " + m_usersTableName + " WHERE UUID = ?uuid", param);
@@ -596,7 +596,7 @@ namespace OpenSim.Data.MySQL
596 596
597 try 597 try
598 { 598 {
599 Dictionary<string, string> param = new Dictionary<string, string>(); 599 Dictionary<string, object> param = new Dictionary<string, object>();
600 param["?uuid"] = uuid.ToString(); 600 param["?uuid"] = uuid.ToString();
601 601
602 IDbCommand result = dbm.Manager.Query("SELECT * FROM " + m_agentsTableName + " WHERE UUID = ?uuid", 602 IDbCommand result = dbm.Manager.Query("SELECT * FROM " + m_agentsTableName + " WHERE UUID = ?uuid",
@@ -744,7 +744,7 @@ namespace OpenSim.Data.MySQL
744 MySQLSuperManager dbm = GetLockedConnection("GetUserAppearance"); 744 MySQLSuperManager dbm = GetLockedConnection("GetUserAppearance");
745 try 745 try
746 { 746 {
747 Dictionary<string, string> param = new Dictionary<string, string>(); 747 Dictionary<string, object> param = new Dictionary<string, object>();
748 param["?owner"] = user.ToString(); 748 param["?owner"] = user.ToString();
749 749
750 IDbCommand result = dbm.Manager.Query( 750 IDbCommand result = dbm.Manager.Query(
@@ -825,7 +825,7 @@ namespace OpenSim.Data.MySQL
825 825
826 public Hashtable GetUserAttachments(UUID agentID) 826 public Hashtable GetUserAttachments(UUID agentID)
827 { 827 {
828 Dictionary<string, string> param = new Dictionary<string, string>(); 828 Dictionary<string, object> param = new Dictionary<string, object>();
829 param["?uuid"] = agentID.ToString(); 829 param["?uuid"] = agentID.ToString();
830 830
831 MySQLSuperManager dbm = GetLockedConnection("GetUserAttachments"); 831 MySQLSuperManager dbm = GetLockedConnection("GetUserAttachments");