diff options
author | BlueWall | 2013-12-06 02:52:13 -0500 |
---|---|---|
committer | BlueWall | 2013-12-06 02:52:13 -0500 |
commit | 1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b (patch) | |
tree | 0d1feaac1a3ae79aa11cc435553f086a3d581581 /OpenSim/Data/SQLite/SQLiteUserProfilesData.cs | |
parent | Adding profile partners fix to SQLite and PgSQL drivers (diff) | |
download | opensim-SC_OLD-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.zip opensim-SC_OLD-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.tar.gz opensim-SC_OLD-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.tar.bz2 opensim-SC_OLD-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.tar.xz |
Add support for user preferences (im via email)
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteUserProfilesData.cs | 83 |
1 files changed, 83 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs b/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs index 8c1bcd4..916a226 100644 --- a/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs +++ b/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs | |||
@@ -747,6 +747,89 @@ namespace OpenSim.Data.SQLite | |||
747 | } | 747 | } |
748 | return true; | 748 | return true; |
749 | } | 749 | } |
750 | |||
751 | public bool UpdateUserPreferences(ref UserPreferences pref, ref string result) | ||
752 | { | ||
753 | string query = string.Empty; | ||
754 | |||
755 | query += "UPDATE usersettings SET "; | ||
756 | query += "imviaemail=:ImViaEmail, "; | ||
757 | query += "visible=:Visible "; | ||
758 | query += "WHERE useruuid=:uuid"; | ||
759 | |||
760 | try | ||
761 | { | ||
762 | using (SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand()) | ||
763 | { | ||
764 | cmd.CommandText = query; | ||
765 | cmd.Parameters.AddWithValue(":ImViaEmail", pref.IMViaEmail); | ||
766 | cmd.Parameters.AddWithValue(":Visible", pref.Visible); | ||
767 | cmd.Parameters.AddWithValue(":uuid", pref.UserId.ToString()); | ||
768 | |||
769 | cmd.ExecuteNonQuery(); | ||
770 | } | ||
771 | } | ||
772 | catch (Exception e) | ||
773 | { | ||
774 | m_log.DebugFormat("[PROFILES_DATA]" + | ||
775 | ": AgentInterestsUpdate exception {0}", e.Message); | ||
776 | result = e.Message; | ||
777 | return false; | ||
778 | } | ||
779 | return true; | ||
780 | } | ||
781 | |||
782 | public bool GetUserPreferences(ref UserPreferences pref, ref string result) | ||
783 | { | ||
784 | IDataReader reader = null; | ||
785 | string query = string.Empty; | ||
786 | |||
787 | query += "SELECT imviaemail,visible,email FROM "; | ||
788 | query += "usersettings WHERE "; | ||
789 | query += "useruuid = :Id"; | ||
790 | |||
791 | OSDArray data = new OSDArray(); | ||
792 | |||
793 | try | ||
794 | { | ||
795 | using (SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand()) | ||
796 | { | ||
797 | cmd.CommandText = query; | ||
798 | cmd.Parameters.AddWithValue("?Id", pref.UserId.ToString()); | ||
799 | |||
800 | using (reader = cmd.ExecuteReader(CommandBehavior.SingleRow)) | ||
801 | { | ||
802 | if(reader.Read()) | ||
803 | { | ||
804 | bool.TryParse((string)reader["imviaemail"], out pref.IMViaEmail); | ||
805 | bool.TryParse((string)reader["visible"], out pref.Visible); | ||
806 | pref.EMail = (string)reader["email"]; | ||
807 | } | ||
808 | else | ||
809 | { | ||
810 | query = "INSERT INTO usersettings VALUES "; | ||
811 | query += "(:Id,'false','false', '')"; | ||
812 | |||
813 | using (SqliteCommand put = (SqliteCommand)m_connection.CreateCommand()) | ||
814 | { | ||
815 | put.Parameters.AddWithValue(":Id", pref.UserId.ToString()); | ||
816 | put.ExecuteNonQuery(); | ||
817 | |||
818 | } | ||
819 | } | ||
820 | } | ||
821 | } | ||
822 | } | ||
823 | catch (Exception e) | ||
824 | { | ||
825 | m_log.DebugFormat("[PROFILES_DATA]" + | ||
826 | ": Get preferences exception {0}", e.Message); | ||
827 | result = e.Message; | ||
828 | return false; | ||
829 | } | ||
830 | return true; | ||
831 | } | ||
832 | |||
750 | public bool GetUserAppData(ref UserAppData props, ref string result) | 833 | public bool GetUserAppData(ref UserAppData props, ref string result) |
751 | { | 834 | { |
752 | IDataReader reader = null; | 835 | IDataReader reader = null; |