diff options
Diffstat (limited to 'OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs')
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs index ccab57b..eac9826 100644 --- a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs +++ b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs | |||
@@ -186,7 +186,7 @@ namespace OpenSim.Framework.Data.MSSQL | |||
186 | lock (database) | 186 | lock (database) |
187 | { | 187 | { |
188 | Dictionary<string, string> param = new Dictionary<string, string>(); | 188 | Dictionary<string, string> param = new Dictionary<string, string>(); |
189 | param["uuid"] = uuid.ToStringHyphenated(); | 189 | param["uuid"] = uuid.ToString(); |
190 | 190 | ||
191 | IDbCommand result = database.Query("SELECT * FROM users WHERE UUID = @uuid", param); | 191 | IDbCommand result = database.Query("SELECT * FROM users WHERE UUID = @uuid", param); |
192 | IDataReader reader = result.ExecuteReader(); | 192 | IDataReader reader = result.ExecuteReader(); |
@@ -241,7 +241,7 @@ namespace OpenSim.Framework.Data.MSSQL | |||
241 | lock (database) | 241 | lock (database) |
242 | { | 242 | { |
243 | Dictionary<string, string> param = new Dictionary<string, string>(); | 243 | Dictionary<string, string> param = new Dictionary<string, string>(); |
244 | param["uuid"] = uuid.ToStringHyphenated(); | 244 | param["uuid"] = uuid.ToString(); |
245 | 245 | ||
246 | IDbCommand result = database.Query("SELECT * FROM agents WHERE UUID = @uuid", param); | 246 | IDbCommand result = database.Query("SELECT * FROM agents WHERE UUID = @uuid", param); |
247 | IDataReader reader = result.ExecuteReader(); | 247 | IDataReader reader = result.ExecuteReader(); |
@@ -321,7 +321,7 @@ namespace OpenSim.Framework.Data.MSSQL | |||
321 | "profileImage = @profileImage," + | 321 | "profileImage = @profileImage," + |
322 | "profileFirstImage = @profileFirstImage where " + | 322 | "profileFirstImage = @profileFirstImage where " + |
323 | "UUID = @keyUUUID;", database.getConnection()); | 323 | "UUID = @keyUUUID;", database.getConnection()); |
324 | SqlParameter param1 = new SqlParameter("@uuid", user.UUID.ToStringHyphenated()); | 324 | SqlParameter param1 = new SqlParameter("@uuid", user.UUID.ToString()); |
325 | SqlParameter param2 = new SqlParameter("@username", user.username); | 325 | SqlParameter param2 = new SqlParameter("@username", user.username); |
326 | SqlParameter param3 = new SqlParameter("@lastname", user.surname); | 326 | SqlParameter param3 = new SqlParameter("@lastname", user.surname); |
327 | SqlParameter param4 = new SqlParameter("@passwordHash", user.passwordHash); | 327 | SqlParameter param4 = new SqlParameter("@passwordHash", user.passwordHash); |
@@ -341,9 +341,9 @@ namespace OpenSim.Framework.Data.MSSQL | |||
341 | SqlParameter param18 = new SqlParameter("@profileWantDoMask", Convert.ToInt32(user.profileWantDoMask)); | 341 | SqlParameter param18 = new SqlParameter("@profileWantDoMask", Convert.ToInt32(user.profileWantDoMask)); |
342 | SqlParameter param19 = new SqlParameter("@profileAboutText", user.profileAboutText); | 342 | SqlParameter param19 = new SqlParameter("@profileAboutText", user.profileAboutText); |
343 | SqlParameter param20 = new SqlParameter("@profileFirstText", user.profileFirstText); | 343 | SqlParameter param20 = new SqlParameter("@profileFirstText", user.profileFirstText); |
344 | SqlParameter param21 = new SqlParameter("@profileImage", libsecondlife.LLUUID.Zero.ToStringHyphenated()); | 344 | SqlParameter param21 = new SqlParameter("@profileImage", libsecondlife.LLUUID.Zero.ToString()); |
345 | SqlParameter param22 = new SqlParameter("@profileFirstImage", libsecondlife.LLUUID.Zero.ToStringHyphenated()); | 345 | SqlParameter param22 = new SqlParameter("@profileFirstImage", libsecondlife.LLUUID.Zero.ToString()); |
346 | SqlParameter param23 = new SqlParameter("@keyUUUID", user.UUID.ToStringHyphenated()); | 346 | SqlParameter param23 = new SqlParameter("@keyUUUID", user.UUID.ToString()); |
347 | command.Parameters.Add(param1); | 347 | command.Parameters.Add(param1); |
348 | command.Parameters.Add(param2); | 348 | command.Parameters.Add(param2); |
349 | command.Parameters.Add(param3); | 349 | command.Parameters.Add(param3); |