aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data')
-rw-r--r--OpenSim/Data/MySQL/MySQLUserProfilesData.cs20
-rw-r--r--OpenSim/Data/SQLite/SQLiteUserProfilesData.cs3
2 files changed, 16 insertions, 7 deletions
diff --git a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
index dca80c3..13e0a57 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 }
@@ -927,15 +931,19 @@ namespace OpenSim.Data.MySQL
927 } 931 }
928 else 932 else
929 { 933 {
934 dbcon.Close();
935 dbcon.Open();
936
937 query = "INSERT INTO usersettings VALUES ";
938 query += "(?uuid,'false','false', ?Email)";
939
930 using (MySqlCommand put = new MySqlCommand(query, dbcon)) 940 using (MySqlCommand put = new MySqlCommand(query, dbcon))
931 { 941 {
932 query = "INSERT INTO usersettings VALUES ";
933 query += "(?Id,'false','false', '')";
934 942
935 lock(Lock) 943 put.Parameters.AddWithValue("?Email", pref.EMail);
936 { 944 put.Parameters.AddWithValue("?uuid", pref.UserId.ToString());
937 put.ExecuteNonQuery(); 945
938 } 946 put.ExecuteNonQuery();
939 } 947 }
940 } 948 }
941 } 949 }
diff --git a/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs b/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs
index 70ce07c..0a6c625 100644
--- a/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs
+++ b/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs
@@ -810,11 +810,12 @@ namespace OpenSim.Data.SQLite
810 else 810 else
811 { 811 {
812 query = "INSERT INTO usersettings VALUES "; 812 query = "INSERT INTO usersettings VALUES ";
813 query += "(:Id,'false','false', '')"; 813 query += "(:Id,'false','false', :Email)";
814 814
815 using (SqliteCommand put = (SqliteCommand)m_connection.CreateCommand()) 815 using (SqliteCommand put = (SqliteCommand)m_connection.CreateCommand())
816 { 816 {
817 put.Parameters.AddWithValue(":Id", pref.UserId.ToString()); 817 put.Parameters.AddWithValue(":Id", pref.UserId.ToString());
818 put.Parameters.AddWithValue(":Email", pref.EMail);
818 put.ExecuteNonQuery(); 819 put.ExecuteNonQuery();
819 820
820 } 821 }