]> git.mxchange.org Git - friendica.git/blob - mod/community.php
Merge pull request #6280 from MrPetovan/bug/4738-fix-message-list-query
[friendica.git] / mod / community.php
1 <?php
2 /**
3  * @file mod/community.php
4  */
5
6 use Friendica\App;
7 use Friendica\Content\Nav;
8 use Friendica\Content\Pager;
9 use Friendica\Core\ACL;
10 use Friendica\Core\Config;
11 use Friendica\Core\L10n;
12 use Friendica\Core\PConfig;
13 use Friendica\Core\Renderer;
14 use Friendica\Database\DBA;
15 use Friendica\Model\Contact;
16 use Friendica\Model\Item;
17
18 function community_init(App $a)
19 {
20         if (!local_user()) {
21                 unset($_SESSION['theme']);
22                 unset($_SESSION['mobile-theme']);
23         }
24 }
25
26 function community_content(App $a, $update = 0)
27 {
28         $o = '';
29
30         if (Config::get('system', 'block_public') && !local_user() && !remote_user()) {
31                 notice(L10n::t('Public access denied.') . EOL);
32                 return;
33         }
34
35         $page_style = Config::get('system', 'community_page_style');
36
37         if ($page_style == CP_NO_INTERNAL_COMMUNITY) {
38                 notice(L10n::t('Access denied.') . EOL);
39                 return;
40         }
41
42         $accounttype = null;
43
44         if ($a->argc > 2) {
45                 switch ($a->argv[2]) {
46                         case 'person':
47                                 $accounttype = Contact::ACCOUNT_TYPE_PERSON;
48                                 break;
49                         case 'organisation':
50                                 $accounttype = Contact::ACCOUNT_TYPE_ORGANISATION;
51                                 break;
52                         case 'news':
53                                 $accounttype = Contact::ACCOUNT_TYPE_NEWS;
54                                 break;
55                         case 'community':
56                                 $accounttype = Contact::ACCOUNT_TYPE_COMMUNITY;
57                                 break;
58                 }
59         }
60
61         if ($a->argc > 1) {
62                 $content = $a->argv[1];
63         } else {
64                 if (!empty(Config::get('system', 'singleuser'))) {
65                         // On single user systems only the global page does make sense
66                         $content = 'global';
67                 } else {
68                         // When only the global community is allowed, we use this as default
69                         $content = $page_style == CP_GLOBAL_COMMUNITY ? 'global' : 'local';
70                 }
71         }
72
73         if (!in_array($content, ['local', 'global'])) {
74                 notice(L10n::t('Community option not available.') . EOL);
75                 return;
76         }
77
78         // Check if we are allowed to display the content to visitors
79         if (!local_user()) {
80                 $available = $page_style == CP_USERS_AND_GLOBAL;
81
82                 if (!$available) {
83                         $available = ($page_style == CP_USERS_ON_SERVER) && ($content == 'local');
84                 }
85
86                 if (!$available) {
87                         $available = ($page_style == CP_GLOBAL_COMMUNITY) && ($content == 'global');
88                 }
89
90                 if (!$available) {
91                         notice(L10n::t('Not available.') . EOL);
92                         return;
93                 }
94         }
95
96         require_once 'include/conversation.php';
97
98         if (!$update) {
99                 $tabs = [];
100
101                 if ((local_user() || in_array($page_style, [CP_USERS_AND_GLOBAL, CP_USERS_ON_SERVER])) && empty(Config::get('system', 'singleuser'))) {
102                         $tabs[] = [
103                                 'label' => L10n::t('Local Community'),
104                                 'url' => 'community/local',
105                                 'sel' => $content == 'local' ? 'active' : '',
106                                 'title' => L10n::t('Posts from local users on this server'),
107                                 'id' => 'community-local-tab',
108                                 'accesskey' => 'l'
109                         ];
110                 }
111
112                 if (local_user() || in_array($page_style, [CP_USERS_AND_GLOBAL, CP_GLOBAL_COMMUNITY])) {
113                         $tabs[] = [
114                                 'label' => L10n::t('Global Community'),
115                                 'url' => 'community/global',
116                                 'sel' => $content == 'global' ? 'active' : '',
117                                 'title' => L10n::t('Posts from users of the whole federated network'),
118                                 'id' => 'community-global-tab',
119                                 'accesskey' => 'g'
120                         ];
121                 }
122
123                 $tab_tpl = Renderer::getMarkupTemplate('common_tabs.tpl');
124                 $o .= Renderer::replaceMacros($tab_tpl, ['$tabs' => $tabs]);
125
126                 Nav::setSelected('community');
127
128                 // We need the editor here to be able to reshare an item.
129                 if (local_user()) {
130                         $x = [
131                                 'is_owner' => true,
132                                 'allow_location' => $a->user['allow_location'],
133                                 'default_location' => $a->user['default-location'],
134                                 'nickname' => $a->user['nickname'],
135                                 'lockstate' => (is_array($a->user) && (strlen($a->user['allow_cid']) || strlen($a->user['allow_gid']) || strlen($a->user['deny_cid']) || strlen($a->user['deny_gid'])) ? 'lock' : 'unlock'),
136                                 'acl' => ACL::getFullSelectorHTML($a->user, true),
137                                 'bang' => '',
138                                 'visitor' => 'block',
139                                 'profile_uid' => local_user(),
140                         ];
141                         $o .= status_editor($a, $x, 0, true);
142                 }
143         }
144
145         // check if we serve a mobile device and get the user settings accordingly
146         if ($a->is_mobile) {
147                 $itemspage_network = PConfig::get(local_user(), 'system', 'itemspage_mobile_network', 20);
148         } else {
149                 $itemspage_network = PConfig::get(local_user(), 'system', 'itemspage_network', 40);
150         }
151
152         // now that we have the user settings, see if the theme forces
153         // a maximum item number which is lower then the user choice
154         if (($a->force_max_items > 0) && ($a->force_max_items < $itemspage_network)) {
155                 $itemspage_network = $a->force_max_items;
156         }
157
158         $pager = new Pager($a->query_string, $itemspage_network);
159
160         $r = community_getitems($pager->getStart(), $pager->getItemsPerPage(), $content, $accounttype);
161
162         if (!DBA::isResult($r)) {
163                 info(L10n::t('No results.') . EOL);
164                 return $o;
165         }
166
167         $maxpostperauthor = (int) Config::get('system', 'max_author_posts_community_page');
168
169         if (($maxpostperauthor != 0) && ($content == 'local')) {
170                 $count = 1;
171                 $previousauthor = "";
172                 $numposts = 0;
173                 $s = [];
174
175                 do {
176                         foreach ($r as $item) {
177                                 if ($previousauthor == $item["author-link"]) {
178                                         ++$numposts;
179                                 } else {
180                                         $numposts = 0;
181                                 }
182                                 $previousauthor = $item["author-link"];
183
184                                 if (($numposts < $maxpostperauthor) && (count($s) < $pager->getItemsPerPage())) {
185                                         $s[] = $item;
186                                 }
187                         }
188                         if (count($s) < $pager->getItemsPerPage()) {
189                                 $r = community_getitems($pager->getStart() + ($count * $pager->getItemsPerPage()), $pager->getItemsPerPage(), $content, $accounttype);
190                         }
191                 } while ((count($s) < $pager->getItemsPerPage()) && ( ++$count < 50) && (count($r) > 0));
192         } else {
193                 $s = $r;
194         }
195
196         $o .= conversation($a, $s, $pager, 'community', $update, false, 'commented', local_user());
197
198         if (!$update) {
199                 $o .= $pager->renderMinimal(count($r));
200         }
201
202         $t = Renderer::getMarkupTemplate("community.tpl");
203         return Renderer::replaceMacros($t, [
204                 '$content' => $o,
205                 '$header' => '',
206                 '$show_global_community_hint' => ($content == 'global') && Config::get('system', 'show_global_community_hint'),
207                 '$global_community_hint' => L10n::t("This community stream shows all public posts received by this node. They may not reflect the opinions of this node’s users.")
208         ]);
209 }
210
211 function community_getitems($start, $itemspage, $content, $accounttype)
212 {
213         if ($content == 'local') {
214                 if (!is_null($accounttype)) {
215                         $sql_accounttype = " AND `user`.`account-type` = ?";
216                         $values = [$accounttype, $start, $itemspage];
217                 } else {
218                         $sql_accounttype = "";
219                         $values = [$start, $itemspage];
220                 }
221
222                 $r = DBA::p("SELECT `item`.`uri`, `author`.`url` AS `author-link` FROM `thread`
223                         INNER JOIN `user` ON `user`.`uid` = `thread`.`uid` AND NOT `user`.`hidewall`
224                         INNER JOIN `item` ON `item`.`id` = `thread`.`iid`
225                         INNER JOIN `contact` AS `author` ON `author`.`id`=`item`.`author-id`
226                         WHERE `thread`.`visible` AND NOT `thread`.`deleted` AND NOT `thread`.`moderated`
227                         AND NOT `thread`.`private` AND `thread`.`wall` AND `thread`.`origin` $sql_accounttype
228                         ORDER BY `thread`.`commented` DESC LIMIT ?, ?", $values);
229                 return DBA::toArray($r);
230         } elseif ($content == 'global') {
231                 if (!is_null($accounttype)) {
232                         $condition = ["`uid` = ? AND `owner`.`contact-type` = ?", 0, $accounttype];
233                 } else {
234                         $condition = ['uid' => 0];
235                 }
236
237                 $r = Item::selectThreadForUser(0, ['uri'], $condition, ['order' => ['commented' => true], 'limit' => [$start, $itemspage]]);
238                 return DBA::toArray($r);
239         }
240
241         // Should never happen
242         return [];
243 }