diff options
| author | Diva Canto | 2010-03-01 21:35:46 -0800 |
|---|---|---|
| committer | Diva Canto | 2010-03-01 21:35:46 -0800 |
| commit | 53a82864687431d295ab3e18ad1bfe9ed1a2229f (patch) | |
| tree | 2b8c62c8e20929d47c7e2f428f94865f8e697089 /OpenSim | |
| parent | Friends rights under control. (diff) | |
| download | opensim-SC_OLD-53a82864687431d295ab3e18ad1bfe9ed1a2229f.zip opensim-SC_OLD-53a82864687431d295ab3e18ad1bfe9ed1a2229f.tar.gz opensim-SC_OLD-53a82864687431d295ab3e18ad1bfe9ed1a2229f.tar.bz2 opensim-SC_OLD-53a82864687431d295ab3e18ad1bfe9ed1a2229f.tar.xz | |
Changed the query in GetFriends in SQLite to match the one in MySql.
Diffstat (limited to 'OpenSim')
| -rw-r--r-- | OpenSim/Data/SQLite/SQLiteFriendsData.cs | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/OpenSim/Data/SQLite/SQLiteFriendsData.cs b/OpenSim/Data/SQLite/SQLiteFriendsData.cs index 399680d..0b12182 100644 --- a/OpenSim/Data/SQLite/SQLiteFriendsData.cs +++ b/OpenSim/Data/SQLite/SQLiteFriendsData.cs | |||
| @@ -46,7 +46,7 @@ namespace OpenSim.Data.SQLite | |||
| 46 | { | 46 | { |
| 47 | SqliteCommand cmd = new SqliteCommand(); | 47 | SqliteCommand cmd = new SqliteCommand(); |
| 48 | 48 | ||
| 49 | cmd.CommandText = String.Format("select a.*,b.Flags as TheirFlags from {0} as a left join {0} as b on a.PrincipalID = b.Friend and a.Friend = b.PrincipalID where a.PrincipalID = :PrincipalID and b.Flags is not null", m_Realm); | 49 | cmd.CommandText = String.Format("select a.*,case when b.Flags is null then -1 else b.Flags end as TheirFlags from {0} as a left join {0} as b on a.PrincipalID = b.Friend and a.Friend = b.PrincipalID where a.PrincipalID = :PrincipalID", m_Realm); |
| 50 | cmd.Parameters.Add(":PrincipalID", userID.ToString()); | 50 | cmd.Parameters.Add(":PrincipalID", userID.ToString()); |
| 51 | 51 | ||
| 52 | return DoQuery(cmd); | 52 | return DoQuery(cmd); |