From 20d3aa2e77e4ba4c12d2a7332c7ac5f3a8f6b635 Mon Sep 17 00:00:00 2001 From: Friendika Date: Mon, 4 Jul 2011 20:57:07 -0700 Subject: community page --- mod/community.php | 88 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 88 insertions(+) create mode 100644 mod/community.php (limited to 'mod/community.php') diff --git a/mod/community.php b/mod/community.php new file mode 100644 index 000000000..aaa3ad9ed --- /dev/null +++ b/mod/community.php @@ -0,0 +1,88 @@ +' . t('Community') . ''; + if(! $update) { + $o .= ''; + $o .= '
' . "\r\n"; + $o .= "\r\n"; + } + + if(x($a->data,'search')) + $search = notags(trim($a->data['search'])); + else + $search = ((x($_GET,'search')) ? notags(trim(rawurldecode($_GET['search']))) : ''); + + + // Here is the way permissions work in this module... + // Only public wall posts can be shown + // OR your own posts if you are a logged in member + + + $r = q("SELECT COUNT(*) AS `total` + FROM `item` LEFT JOIN `contact` ON `contact`.`id` = `item`.`contact-id` LEFT JOIN `profile` ON `profile`.`uid` = `item`.`uid` + WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 + AND `wall` = 1 AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = '' + AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = '' AND `profile`.`hidewall` = 0 + AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0 AND `profile`.`is-default` = 1 " + ); + + if(count($r)) + $a->set_pager_total($r[0]['total']); + + if(! $r[0]['total']) { + info( t('No results.') . EOL); + return $o; + } + + $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, + `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`, + `contact`.`network`, `contact`.`thumb`, `contact`.`self`, `contact`.`writable`, + `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`, + `user`.`nickname`, `profile`.`hidewall` + FROM `item` LEFT JOIN `contact` ON `contact`.`id` = `item`.`contact-id` + LEFT JOIN `user` ON `user`.`uid` = `item`.`uid` + LEFT JOIN `profile` ON `profile`.`uid` = `item`.`uid` + WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 + AND `wall` = 1 AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = '' + AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = '' AND `profile`.`hidewall` = 0 + AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0 AND `profile`.`is-default` = 1 + ORDER BY `received` DESC LIMIT %d, %d ", + intval($a->pager['start']), + intval($a->pager['itemspage']) + + ); + + // we behave the same in message lists as the search module + + $o .= conversation($a,$r,'search',false); + + $o .= paginate($a); + + $o .= '
' . t('Shared content is covered by the Creative Commons Attribution 3.0 license.') . '
'; + + return $o; +} + -- cgit v1.2.3