X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fdirectory.php;h=294a55585df14ed8eca9856edabd395ad1eefb31;hb=d7410f9e47d50d652ae0d33ec0540b894c3dfc13;hp=4695ca6b82b53b27cb27d3e2a914009a272dc97f;hpb=aa047e16d7b95788f1efdf216960e16c09e17754;p=friendica.git diff --git a/mod/directory.php b/mod/directory.php index 4695ca6b82..294a55585d 100644 --- a/mod/directory.php +++ b/mod/directory.php @@ -57,19 +57,19 @@ function directory_content(&$a) { $sql_extra = " AND ((`profile`.`name` LIKE '%$search%') OR (`user`.`nickname` LIKE '%$search%') OR - (`pdesc` LIKE '%$search%') OR - (`locality` LIKE '%$search%') OR - (`region` LIKE '%$search%') OR - (`country-name` LIKE '%$search%') OR - (`gender` LIKE '%$search%') OR - (`marital` LIKE '%$search%') OR - (`sexual` LIKE '%$search%') OR - (`about` LIKE '%$search%') OR - (`romance` LIKE '%$search%') OR - (`work` LIKE '%$search%') OR - (`education` LIKE '%$search%') OR - (`pub_keywords` LIKE '%$search%') OR - (`prv_keywords` LIKE '%$search%'))"; + (`profile`.`pdesc` LIKE '%$search%') OR + (`profile`.`locality` LIKE '%$search%') OR + (`profile`.`region` LIKE '%$search%') OR + (`profile`.`country-name` LIKE '%$search%') OR + (`profile`.`gender` LIKE '%$search%') OR + (`profile`.`marital` LIKE '%$search%') OR + (`profile`.`sexual` LIKE '%$search%') OR + (`profile`.`about` LIKE '%$search%') OR + (`profile`.`romance` LIKE '%$search%') OR + (`profile`.`work` LIKE '%$search%') OR + (`profile`.`education` LIKE '%$search%') OR + (`profile`.`pub_keywords` LIKE '%$search%') OR + (`profile`.`prv_keywords` LIKE '%$search%'))"; } $publish = ((get_config('system','publish_all')) ? '' : " AND `publish` = 1 " ); @@ -86,9 +86,9 @@ function directory_content(&$a) { $limit = intval($a->pager['start']).",".intval($a->pager['itemspage']); $r = $db->q("SELECT `profile`.*, `profile`.`uid` AS `profile_uid`, `user`.`nickname`, `user`.`timezone` , `user`.`page-flags`, - `contact`.`addr` AS faddr, `contact`.`url` AS profile_url FROM `profile` + `contact`.`addr`, `contact`.`url` AS profile_url FROM `profile` LEFT JOIN `user` ON `user`.`uid` = `profile`.`uid` - INNER JOIN `contact` ON `contact`.`uid` = `user`.`uid` + LEFT JOIN `contact` ON `contact`.`uid` = `user`.`uid` WHERE `is-default` = 1 $publish AND `user`.`blocked` = 0 AND `contact`.`self` $sql_extra $order LIMIT ".$limit); if(count($r)) { @@ -102,7 +102,7 @@ function directory_content(&$a) { $community = ''; $itemurl= ''; - $itemurl = (($rr['faddr'] != "") ? $rr['faddr'] : $rr['profile_url']); + $itemurl = (($rr['addr'] != "") ? $rr['addr'] : $rr['profile_url']); $profile_link = z_root() . '/profile/' . ((strlen($rr['nickname'])) ? $rr['nickname'] : $rr['profile_uid']); @@ -130,8 +130,8 @@ function directory_content(&$a) { // show if account is a community account - // ToDo the other should be also respected, but first we need a good translatiion - // and systemwide consistency for displaying the page type + /// @TODO The other page types should be also respected, but first we need a good + /// translatiion and systemwide consistency for displaying the page type if((intval($rr['page-flags']) == PAGE_COMMUNITY) OR (intval($rr['page-flags']) == PAGE_PRVGROUP)) $community = true;