X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fdirectory.php;h=9cce167605178ef9b7a322edebff0690614faf94;hb=4eb1c1eb1a9d830151aa6437fefb4e7a590064e8;hp=6d0e1f426828cbd9c6c2695c5e54a9d344c54fca;hpb=d733b39b2db3c92db1d9c28b9b07c74a9d23fa65;p=friendica.git diff --git a/mod/directory.php b/mod/directory.php index 6d0e1f4268..9cce167605 100644 --- a/mod/directory.php +++ b/mod/directory.php @@ -1,37 +1,84 @@ set_pager_itemspage(60); +} function directory_content(&$a) { + $search = ((x($_GET,'search')) ? notags(trim($_GET['search'])) : ''); $tpl .= file_get_contents('view/directory_header.tpl'); - $o .= replace_macros($tpl, array( + + $o .= replace_macros($tpl, array( + '$search' => $search, + '$finding' => (strlen($search) ? '

' . t('Finding: ') . "'" . $search . "'" . '

' : "") )); - $r = q("SELECT `profile`.*, `profile`.`uid` AS `profile_uid`, `user`.`nickname` FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` WHERE `is-default` = 1 AND `publish` = 1"); + if($search) + $search = dbesc($search); + $sql_extra = ((strlen($search)) ? " AND MATCH (`profile`.`name`, `user`.`nickname`, `locality`,`region`,`country-name`,`gender`,`marital`,`sexual`,`about`,`romance`,`work`,`education`) AGAINST ('$search' IN BOOLEAN MODE) " : ""); + + + $r = q("SELECT COUNT(*) AS `total` FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` WHERE `is-default` = 1 AND `publish` = 1 AND `user`.`blocked` = 0 $sql_extra "); + if(count($r)) + $a->set_pager_total($r[0]['total']); + + + + $r = q("SELECT `profile`.*, `profile`.`uid` AS `profile_uid`, `user`.`nickname`, `user`.`timezone` FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` WHERE `is-default` = 1 AND `publish` = 1 AND `user`.`blocked` = 0 $sql_extra ORDER BY `name` ASC LIMIT %d , %d ", + intval($a->pager['start']), + intval($a->pager['itemspage']) + ); if(count($r)) { $tpl = file_get_contents('view/directory_item.tpl'); + if(in_array('small', $a->argv)) + $photo = 'thumb'; + else + $photo = 'photo'; + foreach($r as $rr) { - $profile_link = $a->get_baseurl() . '/profile/' . ((strlen($rr['nickname'])) ? $rr['nickname'] : $rr['profile_uid']); + $profile_link = $a->get_baseurl() . '/profile/' . ((strlen($rr['nickname'])) ? $rr['nickname'] : $rr['profile_uid']); + $details = ''; + if(strlen($rr['locality'])) + $details .= $rr['locality']; + if(strlen($rr['region'])) { + if(strlen($rr['locality'])) + $details .= ', '; + $details .= $rr['region']; + } + if(strlen($rr['country-name'])) { + if(strlen($details)) + $details .= ', '; + $details .= $rr['country-name']; + } + if(strlen($rr['dob'])) { + if(($years = age($rr['dob'],$rr['timezone'],'')) != 0) + $details .= "
Age: $years" ; + } + if(strlen($rr['gender'])) + $details .= '
Gender: ' . $rr['gender']; + $o .= replace_macros($tpl,array( '$id' => $rr['id'], '$profile-link' => $profile_link, - '$photo' => $rr['photo'], + '$photo' => $rr[$photo], '$alt-text' => $rr['name'], '$name' => $rr['name'], - '$details' => $details // FIXME + '$details' => $details )); } $o .= "
\r\n"; + $o .= paginate($a); + } else notice("No entries (some entries may be hidden).");