diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/PGSQL/PGSQLFriendsData.cs | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Data/PGSQL/PGSQLFriendsData.cs b/OpenSim/Data/PGSQL/PGSQLFriendsData.cs index a841353..58dffed 100644 --- a/OpenSim/Data/PGSQL/PGSQLFriendsData.cs +++ b/OpenSim/Data/PGSQL/PGSQLFriendsData.cs | |||
@@ -50,7 +50,7 @@ namespace OpenSim.Data.PGSQL | |||
50 | } | 50 | } |
51 | } | 51 | } |
52 | 52 | ||
53 | 53 | ||
54 | public override bool Delete(string principalID, string friend) | 54 | public override bool Delete(string principalID, string friend) |
55 | { | 55 | { |
56 | UUID princUUID = UUID.Zero; | 56 | UUID princUUID = UUID.Zero; |
@@ -97,7 +97,7 @@ namespace OpenSim.Data.PGSQL | |||
97 | using (NpgsqlCommand cmd = new NpgsqlCommand()) | 97 | using (NpgsqlCommand cmd = new NpgsqlCommand()) |
98 | { | 98 | { |
99 | 99 | ||
100 | cmd.CommandText = String.Format("select a.*,case when b.\"Flags\" is null then '-1' else b.\"Flags\" end as \"TheirFlags\" from {0} as a " + | 100 | cmd.CommandText = String.Format("select a.*,case when b.\"Flags\" is null then '-1' else b.\"Flags\" end as \"TheirFlags\" from {0} as a " + |
101 | " left join {0} as b on a.\"PrincipalID\" = b.\"Friend\" and a.\"Friend\" = b.\"PrincipalID\" " + | 101 | " left join {0} as b on a.\"PrincipalID\" = b.\"Friend\" and a.\"Friend\" = b.\"PrincipalID\" " + |
102 | " where a.\"PrincipalID\" = :PrincipalID", m_Realm); | 102 | " where a.\"PrincipalID\" = :PrincipalID", m_Realm); |
103 | cmd.Parameters.Add(m_database.CreateParameter("PrincipalID", principalID.ToString())); | 103 | cmd.Parameters.Add(m_database.CreateParameter("PrincipalID", principalID.ToString())); |
@@ -111,6 +111,6 @@ namespace OpenSim.Data.PGSQL | |||
111 | { | 111 | { |
112 | return GetFriends(principalID); | 112 | return GetFriends(principalID); |
113 | } | 113 | } |
114 | 114 | ||
115 | } | 115 | } |
116 | } | 116 | } |