3 * Name: Forum Directory
4 * Description: Add a directory of forums hosted on your server, with verbose descriptions.
6 * Author: Thomas Willingham <https://beardyunixer.com/profile/beardyunixer>
10 use Friendica\Content\Nav;
11 use Friendica\Content\Pager;
12 use Friendica\Content\Widget;
13 use Friendica\Core\Config;
14 use Friendica\Core\Hook;
15 use Friendica\Core\L10n;
16 use Friendica\Core\Renderer;
17 use Friendica\Database\DBA;
18 use Friendica\Model\Contact;
19 use Friendica\Model\Profile;
20 use Friendica\Util\Strings;
21 use Friendica\Util\Temporal;
23 require_once 'boot.php';
24 require_once 'include/dba.php';
25 require_once 'include/text.php';
27 function forumdirectory_install()
29 Hook::register('app_menu', 'addon/forumdirectory/forumdirectory.php', 'forumdirectory_app_menu');
32 function forumdirectory_uninstall()
34 Hook::unregister('app_menu', 'addon/forumdirectory/forumdirectory.php', 'forumdirectory_app_menu');
37 function forumdirectory_module()
42 function forumdirectory_app_menu(App $a, array &$b)
44 $b['app_menu'][] = '<div class="app-title"><a href="forumdirectory">' . L10n::t('Forum Directory') . '</a></div>';
47 function forumdirectory_init(App $a)
49 $a->page['htmlhead'] .= '<link rel="stylesheet" type="text/css" href="' . $a->getBaseURL() . '/addon/forumdirectory/forumdirectory.css" media="all" />';
52 $a->page['aside'] .= Widget::findPeople();
54 unset($_SESSION['theme']);
58 function forumdirectory_post(App $a)
60 if (!empty($_POST['search'])) {
61 $a->data['search'] = $_POST['search'];
65 function forumdirectory_content(App $a)
67 if ((Config::get('system', 'block_public')) && (!local_user()) && (!remote_user())) {
68 notice(L10n::t('Public access denied.') . EOL);
73 Nav::setSelected('directory');
75 if (!empty($a->data['search'])) {
76 $search = Strings::escapeTags(trim($a->data['search']));
78 $search = (!empty($_GET['search']) ? Strings::escapeTags(trim(rawurldecode($_GET['search']))) : '');
81 $tpl = Renderer::getMarkupTemplate('directory_header.tpl');
84 $gdirpath = Config::get('system', 'directory');
85 if (strlen($gdirpath)) {
86 $globaldir = '<ul><li><div id="global-directory-link"><a href="'
87 . Profile::zrl($gdirpath, true) . '">' . L10n::t('Global Directory') . '</a></div></li></ul>';
92 $o .= Renderer::replaceMacros($tpl, [
94 '$globaldir' => $globaldir,
95 '$desc' => L10n::t('Find on this site'),
97 '$finding' => (strlen($search) ? '<h4>' . L10n::t('Finding: ') . "'" . $search . "'" . '</h4>' : ""),
98 '$sitedir' => L10n::t('Site Directory'),
99 '$submit' => L10n::t('Find')
103 if (strlen($search)) {
104 $sql_extra = " AND MATCH (`profile`.`name`, `user`.`nickname`, `pdesc`, `locality`,`region`,`country-name`,"
105 . "`gender`,`marital`,`sexual`,`about`,`romance`,`work`,`education`,`pub_keywords`,`prv_keywords` )"
106 . " AGAINST ('" . DBA::escape($search) . "' IN BOOLEAN MODE) ";
109 $publish = Config::get('system', 'publish_all') ? '' : " AND `publish` = 1 ";
112 $r = q("SELECT COUNT(*) AS `total` FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid`"
113 . " WHERE `is-default` = 1 $publish AND `user`.`blocked` = 0 AND `page-flags` = 2 $sql_extra ");
114 if (DBA::isResult($r)) {
115 $total = $r[0]['total'];
118 $pager = new Pager($a->query_string, 60);
120 $order = " ORDER BY `name` ASC ";
122 $r = q("SELECT `profile`.*, `profile`.`uid` AS `profile_uid`, `user`.`nickname`, `user`.`timezone` , `user`.`page-flags`"
123 . " FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` WHERE `is-default` = 1 $publish"
124 . " AND `user`.`blocked` = 0 AND `page-flags` = 2 $sql_extra $order LIMIT %d , %d ",
126 $pager->getItemsPerPage()
129 if (DBA::isResult($r)) {
130 if (in_array('small', $a->argv)) {
136 foreach ($r as $rr) {
137 $profile_link = $a->getBaseURL() . '/profile/' . ((strlen($rr['nickname'])) ? $rr['nickname'] : $rr['profile_uid']);
139 $pdesc = (($rr['pdesc']) ? $rr['pdesc'] . '<br />' : '');
142 if (strlen($rr['locality'])) {
143 $details .= $rr['locality'];
146 if (strlen($rr['region'])) {
147 if (strlen($rr['locality'])) {
150 $details .= $rr['region'];
152 if (strlen($rr['country-name'])) {
153 if (strlen($details)) {
156 $details .= $rr['country-name'];
159 if (strlen($rr['dob']) && ($years = Temporal::getAgeByTimezone($rr['dob'], $rr['timezone'], '')) != 0) {
160 $details .= '<br />' . L10n::t('Age: ') . $years;
163 if (strlen($rr['gender'])) {
164 $details .= '<br />' . L10n::t('Gender: ') . $rr['gender'];
167 switch ($rr['page-flags']) {
168 case Contact::PAGE_NORMAL : $page_type = "Personal Profile"; break;
169 case Contact::PAGE_SOAPBOX : $page_type = "Fan Page" ; break;
170 case Contact::PAGE_COMMUNITY: $page_type = "Community Forum" ; break;
171 case Contact::PAGE_FREELOVE : $page_type = "Open Forum" ; break;
172 case Contact::PAGE_PRVGROUP : $page_type = "Private Group" ; break;
178 if (!empty($profile['address'])
179 || !empty($profile['locality'])
180 || !empty($profile['region'])
181 || !empty($profile['postal-code'])
182 || !empty($profile['country-name'])
184 $location = L10n::t('Location:');
187 $gender = !empty($profile['gender']) ? L10n::t('Gender:') : false;
188 $marital = !empty($profile['marital']) ? L10n::t('Status:') : false;
189 $homepage = !empty($profile['homepage']) ? L10n::t('Homepage:') : false;
190 $about = !empty($profile['about']) ? L10n::t('About:') : false;
192 $tpl = Renderer::getMarkupTemplate('forumdirectory_item.tpl', 'addon/forumdirectory/');
194 $entry = Renderer::replaceMacros($tpl, [
196 '$profile_link' => $profile_link,
197 '$photo' => $rr[$photo],
198 '$alt_text' => $rr['name'],
199 '$name' => $rr['name'],
200 '$details' => $pdesc . $details,
201 '$page_type' => $page_type,
202 '$profile' => $profile,
203 '$location' => $location,
204 '$gender' => $gender,
206 '$marital' => $marital,
207 '$homepage' => $homepage,
214 $o .= "<div class=\"directory-end\" ></div>\r\n";
215 $o .= $pager->renderFull($total);
217 info(L10n::t("No entries \x28some entries may be hidden\x29.") . EOL);