diff options
-rw-r--r-- | OpenSim/Data/MySQL/MySQLUserProfilesData.cs | 2 | ||||
-rw-r--r-- | OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | 2 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteUserProfilesData.cs | 4 |
3 files changed, 4 insertions, 4 deletions
diff --git a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs index 16637c3..2669aca 100644 --- a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs +++ b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs | |||
@@ -836,7 +836,7 @@ namespace OpenSim.Data.MySQL | |||
836 | 836 | ||
837 | const string queryB = "SELECT `profileImage`, `profileFirstImage` FROM `userprofile` WHERE `useruuid` = ?Id"; | 837 | const string queryB = "SELECT `profileImage`, `profileFirstImage` FROM `userprofile` WHERE `useruuid` = ?Id"; |
838 | 838 | ||
839 | using (MySqlCommand cmd = new MySqlCommand(string.Format (queryB,"`userpicks`"), dbcon)) | 839 | using (MySqlCommand cmd = new MySqlCommand(queryB, dbcon)) |
840 | { | 840 | { |
841 | cmd.Parameters.AddWithValue("?Id", avatarId.ToString()); | 841 | cmd.Parameters.AddWithValue("?Id", avatarId.ToString()); |
842 | 842 | ||
diff --git a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs index 75a51e2..5800de9 100644 --- a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs +++ b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | |||
@@ -845,7 +845,7 @@ namespace OpenSim.Data.PGSQL | |||
845 | 845 | ||
846 | query = "SELECT \"profileImage\", \"profileFirstImage\" FROM \"userprofile\" WHERE \"useruuid\" = :Id"; | 846 | query = "SELECT \"profileImage\", \"profileFirstImage\" FROM \"userprofile\" WHERE \"useruuid\" = :Id"; |
847 | 847 | ||
848 | using (NpgsqlCommand cmd = new NpgsqlCommand(string.Format(query, "\"userpicks\""), dbcon)) | 848 | using (NpgsqlCommand cmd = new NpgsqlCommand(query, dbcon)) |
849 | { | 849 | { |
850 | cmd.Parameters.Add(m_database.CreateParameter("Id", avatarId)); | 850 | cmd.Parameters.Add(m_database.CreateParameter("Id", avatarId)); |
851 | 851 | ||
diff --git a/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs b/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs index 13aac79..2f22d54 100644 --- a/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs +++ b/OpenSim/Data/SQLite/SQLiteUserProfilesData.cs | |||
@@ -926,7 +926,7 @@ namespace OpenSim.Data.SQLite | |||
926 | { | 926 | { |
927 | using (SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand()) | 927 | using (SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand()) |
928 | { | 928 | { |
929 | cmd.CommandText = query; | 929 | cmd.CommandText = string.Format(query, "\"classifieds\""); |
930 | cmd.Parameters.AddWithValue(":Id", avatarId.ToString()); | 930 | cmd.Parameters.AddWithValue(":Id", avatarId.ToString()); |
931 | 931 | ||
932 | using (reader = cmd.ExecuteReader(CommandBehavior.SingleRow)) | 932 | using (reader = cmd.ExecuteReader(CommandBehavior.SingleRow)) |
@@ -940,7 +940,7 @@ namespace OpenSim.Data.SQLite | |||
940 | 940 | ||
941 | using (SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand()) | 941 | using (SqliteCommand cmd = (SqliteCommand)m_connection.CreateCommand()) |
942 | { | 942 | { |
943 | cmd.CommandText = query; | 943 | cmd.CommandText = string.Format(query, "\"userpicks\""); |
944 | cmd.Parameters.AddWithValue(":Id", avatarId.ToString()); | 944 | cmd.Parameters.AddWithValue(":Id", avatarId.ToString()); |
945 | 945 | ||
946 | using (reader = cmd.ExecuteReader(CommandBehavior.SingleRow)) | 946 | using (reader = cmd.ExecuteReader(CommandBehavior.SingleRow)) |