aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMike Macgirvin <mike@macgirvin.com>2010-08-13 05:47:16 -0700
committerMike Macgirvin <mike@macgirvin.com>2010-08-13 05:47:16 -0700
commit485708bd9ad86491a371b4d9514835dd1847504e (patch)
tree3af2c9b79b0e0344b4c884c49fb4137941a58361
parente79cb38217a51fb9142d3ba3c0763c9742b28f64 (diff)
downloadvolse-hubzilla-485708bd9ad86491a371b4d9514835dd1847504e.tar.gz
volse-hubzilla-485708bd9ad86491a371b4d9514835dd1847504e.tar.bz2
volse-hubzilla-485708bd9ad86491a371b4d9514835dd1847504e.zip
tweaking sql for netwrk page
-rw-r--r--mod/network.php5
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;