diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLUserProfilesData.cs | 20 |
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 | } |