aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/SQLiteFriendsData.cs
diff options
context:
space:
mode:
authorDiva Canto2010-03-01 21:35:46 -0800
committerDiva Canto2010-03-01 21:35:46 -0800
commit53a82864687431d295ab3e18ad1bfe9ed1a2229f (patch)
tree2b8c62c8e20929d47c7e2f428f94865f8e697089 /OpenSim/Data/SQLite/SQLiteFriendsData.cs
parentFriends rights under control. (diff)
downloadopensim-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 '')
-rw-r--r--OpenSim/Data/SQLite/SQLiteFriendsData.cs2
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);