aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/MySQLUserProfilesData.cs20
1 files changed, 14 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
index dc88f94..8e9f77d 100644
--- a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
+++ b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
@@ -546,6 +546,10 @@ namespace OpenSim.Data.MySQL
546 reader.Read(); 546 reader.Read();
547 notes.Notes = OSD.FromString((string)reader["notes"]); 547 notes.Notes = OSD.FromString((string)reader["notes"]);
548 } 548 }
549 else
550 {
551 notes.Notes = OSD.FromString("");
552 }
549 } 553 }
550 } 554 }
551 } 555 }
@@ -928,15 +932,19 @@ namespace OpenSim.Data.MySQL
928 } 932 }
929 else 933 else
930 { 934 {
935 dbcon.Close();
936 dbcon.Open();
937
938 query = "INSERT INTO usersettings VALUES ";
939 query += "(?uuid,'false','false', ?Email)";
940
931 using (MySqlCommand put = new MySqlCommand(query, dbcon)) 941 using (MySqlCommand put = new MySqlCommand(query, dbcon))
932 { 942 {
933 query = "INSERT INTO usersettings VALUES ";
934 query += "(?Id,'false','false', '')";
935 943
936 lock(Lock) 944 put.Parameters.AddWithValue("?Email", pref.EMail);
937 { 945 put.Parameters.AddWithValue("?uuid", pref.UserId.ToString());
938 put.ExecuteNonQuery(); 946
939 } 947 put.ExecuteNonQuery();
940 } 948 }
941 } 949 }
942 } 950 }