diff options
Diffstat (limited to 'OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs')
-rw-r--r-- | OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs index e87305c..ec27534 100644 --- a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs +++ b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | |||
@@ -796,7 +796,7 @@ namespace OpenSim.Data.PGSQL | |||
796 | public OSDArray GetUserImageAssets(UUID avatarId) | 796 | public OSDArray GetUserImageAssets(UUID avatarId) |
797 | { | 797 | { |
798 | OSDArray data = new OSDArray(); | 798 | OSDArray data = new OSDArray(); |
799 | string query = "SELECT \"snapshotuuid\" FROM {0} WHERE \"creatoruuid\" = :Id"; | 799 | string query = "SELECT snapshotuuid FROM {0} WHERE creatoruuid = :Id"; |
800 | 800 | ||
801 | try | 801 | try |
802 | { | 802 | { |
@@ -804,7 +804,7 @@ namespace OpenSim.Data.PGSQL | |||
804 | { | 804 | { |
805 | dbcon.Open(); | 805 | dbcon.Open(); |
806 | 806 | ||
807 | using (NpgsqlCommand cmd = new NpgsqlCommand(string.Format (query,"\"classifieds\""), dbcon)) | 807 | using (NpgsqlCommand cmd = new NpgsqlCommand(string.Format (query, "classifieds"), dbcon)) |
808 | { | 808 | { |
809 | cmd.Parameters.Add(m_database.CreateParameter("Id", avatarId)); | 809 | cmd.Parameters.Add(m_database.CreateParameter("Id", avatarId)); |
810 | 810 | ||
@@ -823,7 +823,7 @@ namespace OpenSim.Data.PGSQL | |||
823 | dbcon.Close(); | 823 | dbcon.Close(); |
824 | dbcon.Open(); | 824 | dbcon.Open(); |
825 | 825 | ||
826 | using (NpgsqlCommand cmd = new NpgsqlCommand(string.Format (query,"\"userpicks\""), dbcon)) | 826 | using (NpgsqlCommand cmd = new NpgsqlCommand(string.Format (query, "userpicks"), dbcon)) |
827 | { | 827 | { |
828 | cmd.Parameters.Add(m_database.CreateParameter("Id", avatarId)); | 828 | cmd.Parameters.Add(m_database.CreateParameter("Id", avatarId)); |
829 | 829 | ||
@@ -842,9 +842,9 @@ namespace OpenSim.Data.PGSQL | |||
842 | dbcon.Close(); | 842 | dbcon.Close(); |
843 | dbcon.Open(); | 843 | dbcon.Open(); |
844 | 844 | ||
845 | query = "SELECT \"profileImage\", \"profileFirstImage\" FROM \"userprofile\" WHERE \"useruuid\" = :Id"; | 845 | query = "SELECT profileImage, profileFirstImage FROM userprofile WHERE useruuid = :Id"; |
846 | 846 | ||
847 | using (NpgsqlCommand cmd = new NpgsqlCommand(string.Format (query,"\"userpicks\""), dbcon)) | 847 | using (NpgsqlCommand cmd = new NpgsqlCommand(string.Format (query, "userpicks"), dbcon)) |
848 | { | 848 | { |
849 | cmd.Parameters.Add(m_database.CreateParameter("Id", avatarId)); | 849 | cmd.Parameters.Add(m_database.CreateParameter("Id", avatarId)); |
850 | 850 | ||