From 67a7d440d9c8b37acfe2aa7c062f453680c45384 Mon Sep 17 00:00:00 2001 From: friendica Date: Tue, 13 Nov 2012 02:57:15 -0800 Subject: usability improvements --- mod/acl.php | 34 +++++++++++++++++----------------- mod/connections.php | 12 ++++-------- 2 files changed, 21 insertions(+), 25 deletions(-) (limited to 'mod') diff --git a/mod/acl.php b/mod/acl.php index 33b7b22c8..630f1e209 100644 --- a/mod/acl.php +++ b/mod/acl.php @@ -139,10 +139,10 @@ function acl_init(&$a){ ); } elseif($type == 'a') { - $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url`, `attag` FROM `contact` - WHERE `uid` = %d AND `pending` = 0 - $sql_extra2 - ORDER BY `name` ASC ", + $r = q("SELECT abook_id as id, xchan_name as name, xchan_addr as nick, xchan_photo_s as micro, xchan_network as network, xchan_url as url, xchan_addr as attag FROM abook left join xchan on abook_xchan = xchan_hash + WHERE abook_channel = %d + $sql_extra3 + ORDER BY xchan_name ASC ", intval(local_user()) ); } @@ -160,17 +160,17 @@ function acl_init(&$a){ if($type == 'm' || $type == 'a' || $type == 'x') { $x = array(); - $x['query'] = $search; - $x['photos'] = array(); - $x['links'] = array(); + $x['query'] = $search; + $x['photos'] = array(); + $x['links'] = array(); $x['suggestions'] = array(); - $x['data'] = array(); + $x['data'] = array(); if(count($r)) { foreach($r as $g) { - $x['photos'][] = $g['micro']; - $x['links'][] = $g['url']; + $x['photos'][] = $g['micro']; + $x['links'][] = $g['url']; $x['suggestions'][] = (($type === 'x') ? '@' : '') . $g['name']; - $x['data'][] = intval($g['id']); + $x['data'][] = intval($g['id']); } } echo json_encode($x); @@ -180,13 +180,13 @@ function acl_init(&$a){ if(count($r)) { foreach($r as $g){ $contacts[] = array( - "type" => "c", - "photo" => $g['micro'], - "name" => $g['name'], - "id" => intval($g['id']), + "type" => "c", + "photo" => $g['micro'], + "name" => $g['name'], + "id" => intval($g['id']), "network" => $g['network'], - "link" => $g['url'], - "nick" => ($g['attag']) ? $g['attag'] : $g['nick'], + "link" => $g['url'], + "nick" => $g['nick'], ); } } diff --git a/mod/connections.php b/mod/connections.php index 8286fabec..d5b4a650c 100644 --- a/mod/connections.php +++ b/mod/connections.php @@ -544,7 +544,7 @@ EOT; $search_txt = dbesc(protect_sprintf(preg_quote($search))); $searching = true; } - $sql_extra .= (($searching) ? " AND xchan_name '$search_txt' " : ""); + $sql_extra .= (($searching) ? protect_sprintf(" AND xchan_name like '%$search_txt%' ") : ""); if($nets) $sql_extra .= sprintf(" AND xchan_network = '%s' ", dbesc($nets)); @@ -573,12 +573,8 @@ EOT; foreach($r as $rr) { - $url = "magic/{$rr['abook_id']}"; - $sparkle = ' class="sparkle" '; - - $contacts[] = array( - 'img_hover' => sprintf( t('Visit %s\'s profile [%s]'),$rr['xchan_name'],$rr['xchan_url']), + 'img_hover' => sprintf( t('%1$s [%2$s]'),$rr['xchan_name'],$rr['xchan_url']), 'edit_hover' => t('Edit contact'), 'photo_menu' => contact_photo_menu($rr), 'id' => $rr['abook_id'], @@ -588,8 +584,8 @@ EOT; 'name' => $rr['xchan_name'], 'username' => $rr['xchan_name'], 'sparkle' => $sparkle, - 'itemurl' => $rr['xchan_url'], - 'url' => $url, + 'edit' => z_root() . '/connections/' . $rr['abook_id'], + 'url' => $rr['xchan_url'], 'network' => network_to_name($rr['network']), ); } -- cgit v1.2.3