aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLFriendsData.cs
diff options
context:
space:
mode:
authorMelanie2010-02-09 07:05:38 +0000
committerMelanie2010-02-09 07:05:38 +0000
commit1dfcf683307c24f4810961f52e0e643a59ef8d8c (patch)
tree18bf0faf02a6296d7067a77b0004fbca088d8381 /OpenSim/Data/MySQL/MySQLFriendsData.cs
parentAdd license header and change branded namespace to generic (diff)
downloadopensim-SC_OLD-1dfcf683307c24f4810961f52e0e643a59ef8d8c.zip
opensim-SC_OLD-1dfcf683307c24f4810961f52e0e643a59ef8d8c.tar.gz
opensim-SC_OLD-1dfcf683307c24f4810961f52e0e643a59ef8d8c.tar.bz2
opensim-SC_OLD-1dfcf683307c24f4810961f52e0e643a59ef8d8c.tar.xz
Add the friends service skel and correct some namespace issues
Diffstat (limited to 'OpenSim/Data/MySQL/MySQLFriendsData.cs')
-rw-r--r--OpenSim/Data/MySQL/MySQLFriendsData.cs2
1 files changed, 1 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/MySQLFriendsData.cs b/OpenSim/Data/MySQL/MySQLFriendsData.cs
index e416eea..7a43bb6 100644
--- a/OpenSim/Data/MySQL/MySQLFriendsData.cs
+++ b/OpenSim/Data/MySQL/MySQLFriendsData.cs
@@ -59,7 +59,7 @@ namespace OpenSim.Data.MySQL
59 { 59 {
60 MySqlCommand cmd = new MySqlCommand(); 60 MySqlCommand cmd = new MySqlCommand();
61 61
62 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", m_Realm); 62 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);
63 cmd.Parameters.AddWithValue("?PrincipalID", principalID.ToString()); 63 cmd.Parameters.AddWithValue("?PrincipalID", principalID.ToString());
64 64
65 return DoQuery(cmd); 65 return DoQuery(cmd);