diff options
| author | Melanie | 2010-02-09 07:05:38 +0000 |
|---|---|---|
| committer | Melanie | 2010-02-09 07:05:38 +0000 |
| commit | 1dfcf683307c24f4810961f52e0e643a59ef8d8c (patch) | |
| tree | 18bf0faf02a6296d7067a77b0004fbca088d8381 /OpenSim/Data/MySQL/MySQLFriendsData.cs | |
| parent | Add license header and change branded namespace to generic (diff) | |
| download | opensim-SC-1dfcf683307c24f4810961f52e0e643a59ef8d8c.zip opensim-SC-1dfcf683307c24f4810961f52e0e643a59ef8d8c.tar.gz opensim-SC-1dfcf683307c24f4810961f52e0e643a59ef8d8c.tar.bz2 opensim-SC-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.cs | 2 |
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); |