diff options
author | Melanie | 2013-12-07 01:08:49 +0000 |
---|---|---|
committer | Melanie | 2013-12-07 01:08:49 +0000 |
commit | 6d6b9ab791a6a759b2a3a8469569f536b3525894 (patch) | |
tree | 9b3a1a63f8b6bd4596d11904be04e667747601c7 /OpenSim/Data/PGSQL | |
parent | Merge branch 'master' into careminster (diff) | |
parent | Adding profile partners fix to SQLite and PgSQL drivers (diff) | |
download | opensim-SC-6d6b9ab791a6a759b2a3a8469569f536b3525894.zip opensim-SC-6d6b9ab791a6a759b2a3a8469569f536b3525894.tar.gz opensim-SC-6d6b9ab791a6a759b2a3a8469569f536b3525894.tar.bz2 opensim-SC-6d6b9ab791a6a759b2a3a8469569f536b3525894.tar.xz |
Merge branch 'master' into careminster
Conflicts:
OpenSim/Region/ClientStack/Linden/Caps/BunchOfCaps/BunchOfCaps.cs
OpenSim/Region/ClientStack/Linden/UDP/LLClientView.cs
OpenSim/Region/Framework/Scenes/ScenePresence.cs
Diffstat (limited to 'OpenSim/Data/PGSQL')
-rw-r--r-- | OpenSim/Data/PGSQL/PGSQLRegionData.cs | 2 | ||||
-rw-r--r-- | OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | 2 |
2 files changed, 1 insertions, 3 deletions
diff --git a/OpenSim/Data/PGSQL/PGSQLRegionData.cs b/OpenSim/Data/PGSQL/PGSQLRegionData.cs index 8a46559..b3076f0 100644 --- a/OpenSim/Data/PGSQL/PGSQLRegionData.cs +++ b/OpenSim/Data/PGSQL/PGSQLRegionData.cs | |||
@@ -376,7 +376,7 @@ namespace OpenSim.Data.PGSQL | |||
376 | 376 | ||
377 | private List<RegionData> Get(int regionFlags, UUID scopeID) | 377 | private List<RegionData> Get(int regionFlags, UUID scopeID) |
378 | { | 378 | { |
379 | string sql = "SELECT * FROM " + m_Realm + " WHERE (flags & " + regionFlags.ToString() + ") <> 0"; | 379 | string sql = "SELECT * FROM " + m_Realm + " WHERE (\"flags\" & " + regionFlags.ToString() + ") <> 0"; |
380 | if (scopeID != UUID.Zero) | 380 | if (scopeID != UUID.Zero) |
381 | sql += " AND \"ScopeID\" = :scopeID"; | 381 | sql += " AND \"ScopeID\" = :scopeID"; |
382 | 382 | ||
diff --git a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs index e3cbf7f..f4e41b4 100644 --- a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs +++ b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | |||
@@ -715,7 +715,6 @@ namespace OpenSim.Data.PGSQL | |||
715 | string query = string.Empty; | 715 | string query = string.Empty; |
716 | 716 | ||
717 | query += "UPDATE userprofile SET "; | 717 | query += "UPDATE userprofile SET "; |
718 | query += "profilePartner=:profilePartner, "; | ||
719 | query += "profileURL=:profileURL, "; | 718 | query += "profileURL=:profileURL, "; |
720 | query += "profileImage=:image, "; | 719 | query += "profileImage=:image, "; |
721 | query += "profileAboutText=:abouttext,"; | 720 | query += "profileAboutText=:abouttext,"; |
@@ -731,7 +730,6 @@ namespace OpenSim.Data.PGSQL | |||
731 | using (NpgsqlCommand cmd = new NpgsqlCommand(query, dbcon)) | 730 | using (NpgsqlCommand cmd = new NpgsqlCommand(query, dbcon)) |
732 | { | 731 | { |
733 | cmd.Parameters.AddWithValue("profileURL", props.WebUrl); | 732 | cmd.Parameters.AddWithValue("profileURL", props.WebUrl); |
734 | cmd.Parameters.AddWithValue("profilePartner", props.PartnerId.ToString()); | ||
735 | cmd.Parameters.AddWithValue("image", props.ImageId.ToString()); | 733 | cmd.Parameters.AddWithValue("image", props.ImageId.ToString()); |
736 | cmd.Parameters.AddWithValue("abouttext", props.AboutText); | 734 | cmd.Parameters.AddWithValue("abouttext", props.AboutText); |
737 | cmd.Parameters.AddWithValue("firstlifeimage", props.FirstLifeImageId.ToString()); | 735 | cmd.Parameters.AddWithValue("firstlifeimage", props.FirstLifeImageId.ToString()); |