diff options
| author | Mike Macgirvin <mike@macgirvin.com> | 2010-08-13 05:47:16 -0700 |
|---|---|---|
| committer | Mike Macgirvin <mike@macgirvin.com> | 2010-08-13 05:47:16 -0700 |
| commit | 485708bd9ad86491a371b4d9514835dd1847504e (patch) | |
| tree | 3af2c9b79b0e0344b4c884c49fb4137941a58361 | |
| parent | e79cb38217a51fb9142d3ba3c0763c9742b28f64 (diff) | |
| download | volse-hubzilla-485708bd9ad86491a371b4d9514835dd1847504e.tar.gz volse-hubzilla-485708bd9ad86491a371b4d9514835dd1847504e.tar.bz2 volse-hubzilla-485708bd9ad86491a371b4d9514835dd1847504e.zip | |
tweaking sql for netwrk page
| -rw-r--r-- | mod/network.php | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/mod/network.php b/mod/network.php index 1a68304e8..b005e8cf3 100644 --- a/mod/network.php +++ b/mod/network.php @@ -65,8 +65,7 @@ function network_content(&$a, $update = false) { // that belongs to you, hence you can see all of it. We will filter by group if // desired. - - $sql_extra = ''; + $sql_extra = " AND `item`.`parent` IN ( SELECT `parent` FROM `item` WHERE `id` = `parent` AND `type` IN ('wall', 'photo', 'remote' )) "; if($group) { $r = q("SELECT `name`, `id` FROM `group` WHERE `id` = %d AND `uid` = %d LIMIT 1", @@ -81,7 +80,7 @@ function network_content(&$a, $update = false) { $contacts = expand_groups(array($group)); $contact_str = implode(',',$contacts); - $sql_extra = dbesc(" AND `item`.`parent` IN ( SELECT `parent` FROM `item` WHERE `id` = `parent` AND `contact-id` IN ( $contact_str )) "); + $sql_extra = dbesc(" AND `item`.`parent` IN ( SELECT `parent` FROM `item` WHERE `id` = `parent` AND `type` IN ('wall', 'photo', 'remote') AND `contact-id` IN ( $contact_str )) "); $o = '<h4>' . t('Group: ') . $r[0]['name'] . '</h4>' . $o; |