diff options
| author | friendica <info@friendica.com> | 2013-09-02 20:51:04 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2013-09-02 20:51:04 -0700 |
| commit | c646388cd974e8f5128ec6d191301029a13db5e2 (patch) | |
| tree | 3125328b41713af28e5763ee8feaf637df7cbb28 /mod | |
| parent | 615bf237330519f0d21fccfe6a8f69b5bb4c0f69 (diff) | |
| download | volse-hubzilla-c646388cd974e8f5128ec6d191301029a13db5e2.tar.gz volse-hubzilla-c646388cd974e8f5128ec6d191301029a13db5e2.tar.bz2 volse-hubzilla-c646388cd974e8f5128ec6d191301029a13db5e2.zip | |
fix mod/search_ac (sort of)
Diffstat (limited to 'mod')
| -rw-r--r-- | mod/search_ac.php | 15 |
1 files changed, 8 insertions, 7 deletions
diff --git a/mod/search_ac.php b/mod/search_ac.php index 5bc3c1c0b..308f42f76 100644 --- a/mod/search_ac.php +++ b/mod/search_ac.php @@ -27,18 +27,19 @@ function search_ac_init(&$a){ // Priority to people searches if ($search) { - $people_sql_extra = protect_sprintf(" AND `name` LIKE '%". dbesc($search) . "%' "); + $people_sql_extra = protect_sprintf(" AND `xchan_name` LIKE '%". dbesc($search) . "%' "); $tag_sql_extra = protect_sprintf(" AND term LIKE '%". dbesc($search) . "%' "); } - $r = q("SELECT `id`, `name`, `micro`, `url` FROM `contact` - WHERE `uid` = %d AND `pending` = 0 - $people_sql_extra - ORDER BY `name` ASC ", - intval(local_user()) + + $r = q("SELECT abook_id as id, xchan_hash as hash, xchan_name as name, xchan_photo_s as micro, xchan_url as url, xchan_addr as nick, abook_their_perms + FROM abook left join xchan on abook_xchan = xchan_hash + WHERE abook_channel = %d AND not ( abook_flags & %d ) $people_sql_extra order by xchan_name asc" , + intval(local_user()), + intval(ABOOK_FLAG_SELF|ABOOK_FLAG_BLOCKED|ABOOK_FLAG_PENDING|ABOOK_FLAG_ARCHIVED) ); - if(count($r)) { + if($r) { foreach($r as $g) { $x['photos'][] = $g['micro']; $x['links'][] = $g['url']; |