mod/community.php

   1 <?php
   2
   3 function community_init(&$a) {
   4         if(! local_user()) {
   5                 unset($_SESSION['theme']);
   6                 unset($_SESSION['mobile-theme']);
   7         }
   8
   9
  10 }
  11
  12
  13 function community_content(&$a, $update = 0) {
  14
  15         $o = '';
  16
  17         // Currently the community page isn't able to handle update requests
  18         if ($update)
  19                 return;
  20
  21         if((get_config('system','block_public')) && (! local_user()) && (! remote_user())) {
  22                 notice( t('Public access denied.') . EOL);
  23                 return;
  24         }
  25
  26         if(get_config('system','community_page_style') == CP_NO_COMMUNITY_PAGE) {
  27                 notice( t('Not available.') . EOL);
  28                 return;
  29         }
  30
  31         require_once("include/bbcode.php");
  32         require_once('include/security.php');
  33         require_once('include/conversation.php');
  34
  35
  36         $o .= '<h3>' . t('Community') . '</h3>';
  37         if(! $update) {
  38                 nav_set_selected('community');
  39         }
  40
  41         if(x($a->data,'search'))
  42                 $search = notags(trim($a->data['search']));
  43         else
  44                 $search = ((x($_GET,'search')) ? notags(trim(rawurldecode($_GET['search']))) : '');
  45
  46
  47         // Here is the way permissions work in this module...
  48         // Only public posts can be shown
  49         // OR your own posts if you are a logged in member
  50
  51         if(get_config('system', 'old_pager')) {
  52                 $r = qu("SELECT COUNT(distinct(`item`.`uri`)) AS `total`
  53                         FROM `item` INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
  54                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
  55                         INNER JOIN `user` ON `user`.`uid` = `item`.`uid` AND `user`.`hidewall` = 0
  56                         WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
  57                         AND `item`.`allow_cid` = ''  AND `item`.`allow_gid` = ''
  58                         AND `item`.`deny_cid`  = '' AND `item`.`deny_gid`  = ''
  59                         AND `item`.`private` = 0 AND `item`.`wall` = 1"
  60                 );
  61
  62                 if (dbm::is_result($r))
  63                         $a->set_pager_total($r[0]['total']);
  64
  65                 if(! $r[0]['total']) {
  66                         info( t('No results.') . EOL);
  67                         return $o;
  68                 }
  69
  70         }
  71
  72         $r = community_getitems($a->pager['start'], $a->pager['itemspage']);
  73
  74         if(! dbm::is_result($r)) {
  75                 info( t('No results.') . EOL);
  76                 return $o;
  77         }
  78
  79         $maxpostperauthor = get_config('system','max_author_posts_community_page');
  80
  81         if ($maxpostperauthor != 0) {
  82                 $count = 1;
  83                 $previousauthor = "";
  84                 $numposts = 0;
  85                 $s = array();
  86
  87                 do {
  88                         foreach ($r AS $row=>$item) {
  89                                 if ($previousauthor == $item["author-link"])
  90                                         ++$numposts;
  91                                 else
  92                                         $numposts = 0;
  93
  94                                 $previousauthor = $item["author-link"];
  95
  96                                 if (($numposts < $maxpostperauthor) AND (sizeof($s) < $a->pager['itemspage']))
  97                                         $s[] = $item;
  98                         }
  99                         if ((sizeof($s) < $a->pager['itemspage']))
 100                                 $r = community_getitems($a->pager['start'] + ($count * $a->pager['itemspage']), $a->pager['itemspage']);
 101
 102                 } while ((sizeof($s) < $a->pager['itemspage']) AND (++$count < 50) AND (sizeof($r) > 0));
 103         } else
 104                 $s = $r;
 105
 106         // we behave the same in message lists as the search module
 107
 108         $o .= conversation($a,$s,'community',$update);
 109
 110         if(!get_config('system', 'old_pager')) {
 111                 $o .= alt_pager($a,count($r));
 112         } else {
 113                 $o .= paginate($a);
 114         }
 115
 116         return $o;
 117 }
 118
 119 function community_getitems($start, $itemspage) {
 120         if (get_config('system','community_page_style') == CP_GLOBAL_COMMUNITY)
 121                 return(community_getpublicitems($start, $itemspage));
 122
 123         $r = qu("SELECT %s
 124                 FROM `thread` FORCE INDEX (`wall_private_received`)
 125                 INNER JOIN `user` ON `user`.`uid` = `thread`.`uid` AND NOT `user`.`hidewall`
 126                 INNER JOIN `item` ON `item`.`id` = `thread`.`iid`
 127                 AND `item`.`allow_cid` = ''  AND `item`.`allow_gid` = ''
 128                 AND `item`.`deny_cid`  = '' AND `item`.`deny_gid`  = ''
 129                 %s AND `contact`.`self`
 130                 WHERE `thread`.`visible` AND NOT `thread`.`deleted` AND NOT `thread`.`moderated`
 131                 AND NOT `thread`.`private` AND `thread`.`wall`
 132                 ORDER BY `thread`.`received` DESC LIMIT %d, %d",
 133                 item_fieldlists(), item_joins(),
 134                 intval($start), intval($itemspage)
 135         );
 136
 137         return($r);
 138
 139 }
 140
 141 function community_getpublicitems($start, $itemspage) {
 142
 143         $r = qu("SELECT %s
 144                 FROM `thread`
 145                 INNER JOIN `item` ON `item`.`id` = `thread`.`iid` %s
 146                 WHERE `thread`.`uid` = 0
 147                 ORDER BY `thread`.`created` DESC LIMIT %d, %d",
 148                 item_fieldlists(), item_joins(),
 149                 intval($start), intval($itemspage)
 150         );
 151
 152         return($r);
 153 }