From bcb672e7ff859168b639ffffc38553bbcf7e918c Mon Sep 17 00:00:00 2001 From: Fabio Comuni Date: Tue, 25 Oct 2011 15:01:58 +0200 Subject: autocomplete contacts nickname while writting in a comment box. --- mod/acl.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'mod') diff --git a/mod/acl.php b/mod/acl.php index f2d2456a6..d87c8de77 100644 --- a/mod/acl.php +++ b/mod/acl.php @@ -13,6 +13,7 @@ function acl_init(&$a){ if ($search!=""){ $sql_extra = "AND `name` LIKE '%%".dbesc($search)."%%'"; + $sql_extra2 = "AND (`name` LIKE '%%".dbesc($search)."%%' OR `nick` LIKE '%%".dbesc($search)."%%')"; } // count groups and contacts @@ -59,9 +60,9 @@ function acl_init(&$a){ } - $r = q("SELECT `id`, `name`, `micro`, `network`, `url` FROM `contact` + $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url` FROM `contact` WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 AND `notify` != '' - $sql_extra + $sql_extra2 ORDER BY `name` ASC ", intval(local_user()) ); @@ -73,6 +74,7 @@ function acl_init(&$a){ "id" => intval($g['id']), "network" => $g['network'], "link" => $g['url'], + "nick" => $g['nick'], ); } -- cgit v1.2.3