]> git.mxchange.org Git - friendica.git/blob - mod/contacts.php
0c53736220d974986470ea4a7cd08ab10b3d3dd0
[friendica.git] / mod / contacts.php
1 <?php
2
3 require_once('include/Contact.php');
4 require_once('include/socgraph.php');
5 require_once('include/contact_selectors.php');
6
7 function contacts_init(&$a) {
8         if(! local_user())
9                 return;
10
11         $contact_id = 0;
12
13         if(($a->argc == 2) && intval($a->argv[1])) {
14                 $contact_id = intval($a->argv[1]);
15                 $r = q("SELECT * FROM `contact` WHERE `uid` = %d and `id` = %d LIMIT 1",
16                         intval(local_user()),
17                         intval($contact_id)
18                 );
19                 if(! count($r)) {
20                         $contact_id = 0;
21                 }
22         }
23
24         require_once('include/group.php');
25         require_once('include/contact_widgets.php');
26
27         if(! x($a->page,'aside'))
28                 $a->page['aside'] = '';
29
30         if($contact_id) {
31                         $a->data['contact'] = $r[0];
32                         $vcard_widget = replace_macros(get_markup_template("vcard-widget.tpl"),array(
33                                 '$name' => $a->data['contact']['name'],
34                                 '$photo' => $a->data['contact']['photo']
35                         ));
36                         $follow_widget = '';
37         }
38         else {
39                 $vcard_widget = '';
40                 if (isset($_GET['add']))
41                         $follow_widget = follow_widget($_GET['add']);
42                 else
43                         $follow_widget = follow_widget();
44         }
45
46         $groups_widget .= group_side('contacts','group',false,0,$contact_id);
47         $findpeople_widget .= findpeople_widget();
48         $networks_widget .= networks_widget('contacts',$_GET['nets']);
49         $a->page['aside'] .= replace_macros(get_markup_template("contacts-widget-sidebar.tpl"),array(
50                 '$vcard_widget' => $vcard_widget,
51                 '$follow_widget' => $follow_widget,
52                 '$groups_widget' => $groups_widget,
53                 '$findpeople_widget' => $findpeople_widget,
54                 '$networks_widget' => $networks_widget
55         ));
56
57         $base = $a->get_baseurl();
58         $tpl = get_markup_template("contacts-head.tpl");
59         $a->page['htmlhead'] .= replace_macros($tpl,array(
60                 '$baseurl' => $a->get_baseurl(true),
61                 '$base' => $base
62         ));
63
64         $tpl = get_markup_template("contacts-end.tpl");
65         $a->page['end'] .= replace_macros($tpl,array(
66                 '$baseurl' => $a->get_baseurl(true),
67                 '$base' => $base
68         ));
69
70
71 }
72
73 function contacts_batch_actions(&$a){
74         $contacts_id = $_POST['contact_batch'];
75         if (!is_array($contacts_id)) return;
76         
77         $orig_records = q("SELECT * FROM `contact` WHERE `id` IN (%s) AND `uid` = %d AND `self` = 0",
78                 implode(",", $contacts_id),
79                 intval(local_user())
80         );
81         
82         $count_actions=0;
83         foreach($orig_records as $orig_record) {
84                 $contact_id = $orig_record['id'];
85                 if (x($_POST, 'contacts_batch_update')) {
86                         _contact_update($contact_id);
87                         $count_actions++;
88                 }
89                 if (x($_POST, 'contacts_batch_block')) {
90                         $r  = _contact_block($contact_id, $orig_record);
91                         if ($r) $count_actions++;
92                 }
93                 if (x($_POST, 'contacts_batch_ignore')) {
94                         $r = _contact_ignore($contact_id, $orig_record);
95                         if ($r) $count_actions++;
96                 }
97                 if (x($_POST, 'contacts_batch_archive')) {
98                         $r = _contact_archive($contact_id, $orig_record);
99                         if ($r) $count_actions++;
100                 }
101                 if (x($_POST, 'contacts_batch_drop')) {
102                         _contact_drop($contact_id, $orig_record);
103                         $count_actions++;
104                 }
105         }
106         if ($count_actions>0) {
107                 info ( sprintf( tt("%d contact edited.", "%d contacts edited", $count_actions), $count_actions) );
108         }
109         
110         if(x($_SESSION,'return_url'))
111                 goaway($a->get_baseurl(true) . '/' . $_SESSION['return_url']);
112         else
113                 goaway($a->get_baseurl(true) . '/contacts');
114
115 }
116
117
118 function contacts_post(&$a) {
119
120         if(! local_user())
121                 return;
122
123         if ($a->argv[1]==="batch") {
124                 contacts_batch_actions($a);
125                 return;
126         }
127
128         $contact_id = intval($a->argv[1]);
129         if(! $contact_id)
130                 return;
131
132         $orig_record = q("SELECT * FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
133                 intval($contact_id),
134                 intval(local_user())
135         );
136
137         if(! count($orig_record)) {
138                 notice( t('Could not access contact record.') . EOL);
139                 goaway($a->get_baseurl(true) . '/contacts');
140                 return; // NOTREACHED
141         }
142
143         call_hooks('contact_edit_post', $_POST);
144
145         $profile_id = intval($_POST['profile-assign']);
146         if($profile_id) {
147                 $r = q("SELECT `id` FROM `profile` WHERE `id` = %d AND `uid` = %d LIMIT 1",
148                         intval($profile_id),
149                         intval(local_user())
150                 );
151                 if(! count($r)) {
152                         notice( t('Could not locate selected profile.') . EOL);
153                         return;
154                 }
155         }
156
157         $hidden = intval($_POST['hidden']);
158
159         $notify = intval($_POST['notify']);
160
161         $fetch_further_information = intval($_POST['fetch_further_information']);
162
163         $priority = intval($_POST['poll']);
164         if($priority > 5 || $priority < 0)
165                 $priority = 0;
166
167         $info = fix_mce_lf(escape_tags(trim($_POST['info'])));
168
169         $r = q("UPDATE `contact` SET `profile-id` = %d, `priority` = %d , `info` = '%s',
170                 `hidden` = %d, `notify_new_posts` = %d, `fetch_further_information` = %d WHERE `id` = %d AND `uid` = %d",
171                 intval($profile_id),
172                 intval($priority),
173                 dbesc($info),
174                 intval($hidden),
175                 intval($notify),
176                 intval($fetch_further_information),
177                 intval($contact_id),
178                 intval(local_user())
179         );
180         if($r)
181                 info( t('Contact updated.') . EOL);
182         else
183                 notice( t('Failed to update contact record.') . EOL);
184
185         $r = q("select * from contact where id = %d and uid = %d limit 1",
186                 intval($contact_id),
187                 intval(local_user())
188         );
189         if($r && count($r))
190                 $a->data['contact'] = $r[0];
191
192         return;
193
194 }
195
196 /*contact actions*/
197 function _contact_update($contact_id) {
198         // pull feed and consume it, which should subscribe to the hub.
199         proc_run('php',"include/poller.php","$contact_id"); 
200 }
201 function _contact_block($contact_id, $orig_record) {
202         $blocked = (($orig_record['blocked']) ? 0 : 1);
203         $r = q("UPDATE `contact` SET `blocked` = %d WHERE `id` = %d AND `uid` = %d",
204                 intval($blocked),
205                 intval($contact_id),
206                 intval(local_user())
207         );
208         return $r;
209
210 }
211 function _contact_ignore($contact_id, $orig_record) {
212         $readonly = (($orig_record['readonly']) ? 0 : 1);
213         $r = q("UPDATE `contact` SET `readonly` = %d WHERE `id` = %d AND `uid` = %d",
214                 intval($readonly),
215                 intval($contact_id),
216                 intval(local_user())
217         );
218         return $r;
219 }
220 function _contact_archive($contact_id, $orig_record) {
221         $archived = (($orig_record['archive']) ? 0 : 1);
222         $r = q("UPDATE `contact` SET `archive` = %d WHERE `id` = %d AND `uid` = %d",
223                 intval($archived),
224                 intval($contact_id),
225                 intval(local_user())
226         );
227         if ($archived) {
228                 q("UPDATE `item` SET `private` = 2 WHERE `contact-id` = %d AND `uid` = %d", intval($contact_id), intval(local_user()));
229         }
230         return $r;
231 }
232 function _contact_drop($contact_id, $orig_record) {
233         require_once('include/Contact.php');
234         $a = get_app();
235
236         terminate_friendship($a->user,$a->contact,$orig_record);
237         contact_remove($orig_record['id']);
238 }
239
240
241 function contacts_content(&$a) {
242
243         $sort_type = 0;
244         $o = '';
245         nav_set_selected('contacts');
246
247
248         if(! local_user()) {
249                 notice( t('Permission denied.') . EOL);
250                 return;
251         }
252
253         if($a->argc == 3) {
254
255                 $contact_id = intval($a->argv[1]);
256                 if(! $contact_id)
257                         return;
258
259                 $cmd = $a->argv[2];
260
261                 $orig_record = q("SELECT * FROM `contact` WHERE `id` = %d AND `uid` = %d AND `self` = 0 LIMIT 1",
262                         intval($contact_id),
263                         intval(local_user())
264                 );
265
266                 if(! count($orig_record)) {
267                         notice( t('Could not access contact record.') . EOL);
268                         goaway($a->get_baseurl(true) . '/contacts');
269                         return; // NOTREACHED
270                 }
271                 
272                 if($cmd === 'update') {
273                         _contact_update($contact_id);
274                         goaway($a->get_baseurl(true) . '/contacts/' . $contact_id);
275                         // NOTREACHED
276                 }
277
278                 if($cmd === 'block') {
279                         $r = _contact_block($contact_id, $orig_record[0]);
280                         if($r) {
281                                 info( (($blocked) ? t('Contact has been blocked') : t('Contact has been unblocked')) . EOL );
282                         }
283                         
284                         goaway($a->get_baseurl(true) . '/contacts/' . $contact_id);
285                         return; // NOTREACHED
286                 }
287
288                 if($cmd === 'ignore') {
289                         $r = _contact_ignore($contact_id, $orig_record[0]);
290                         if($r) {
291                                 info( (($readonly) ? t('Contact has been ignored') : t('Contact has been unignored')) . EOL );
292                         }
293                         
294                         goaway($a->get_baseurl(true) . '/contacts/' . $contact_id);
295                         return; // NOTREACHED
296                 }
297
298
299                 if($cmd === 'archive') {
300                         $r = _contact_archive($contact_id, $orig_record[0]);
301                         if($r) {
302                                 info( (($archived) ? t('Contact has been archived') : t('Contact has been unarchived')) . EOL );
303                         }                       
304                         
305                         goaway($a->get_baseurl(true) . '/contacts/' . $contact_id);
306                         return; // NOTREACHED
307                 }
308
309                 if($cmd === 'drop') {
310
311                         // Check if we should do HTML-based delete confirmation
312                         if($_REQUEST['confirm']) {
313                                 // <form> can't take arguments in its "action" parameter
314                                 // so add any arguments as hidden inputs
315                                 $query = explode_querystring($a->query_string);
316                                 $inputs = array();
317                                 foreach($query['args'] as $arg) {
318                                         if(strpos($arg, 'confirm=') === false) {
319                                                 $arg_parts = explode('=', $arg);
320                                                 $inputs[] = array('name' => $arg_parts[0], 'value' => $arg_parts[1]);
321                                         }
322                                 }
323
324                                 $a->page['aside'] = '';
325                                 return replace_macros(get_markup_template('confirm.tpl'), array(
326                                         '$method' => 'get',
327                                         '$message' => t('Do you really want to delete this contact?'),
328                                         '$extra_inputs' => $inputs,
329                                         '$confirm' => t('Yes'),
330                                         '$confirm_url' => $query['base'],
331                                         '$confirm_name' => 'confirmed',
332                                         '$cancel' => t('Cancel'),
333                                 ));
334                         }
335                         // Now check how the user responded to the confirmation query
336                         if($_REQUEST['canceled']) {
337                                 if(x($_SESSION,'return_url'))
338                                         goaway($a->get_baseurl(true) . '/' . $_SESSION['return_url']);
339                                 else
340                                         goaway($a->get_baseurl(true) . '/contacts');
341                         }
342
343                         _contact_drop($contact_id, $orig_record[0]);
344                         info( t('Contact has been removed.') . EOL );
345                         if(x($_SESSION,'return_url'))
346                                 goaway($a->get_baseurl(true) . '/' . $_SESSION['return_url']);
347                         else
348                                 goaway($a->get_baseurl(true) . '/contacts');
349                         return; // NOTREACHED
350                 }
351         }
352
353
354
355         $_SESSION['return_url'] = $a->query_string;
356
357         if((x($a->data,'contact')) && (is_array($a->data['contact']))) {
358
359                 $contact_id = $a->data['contact']['id'];
360                 $contact = $a->data['contact'];
361
362                 $editselect = 'none';
363                 if( feature_enabled(local_user(),'richtext') )
364                         $editselect = 'exact';
365
366                 $a->page['htmlhead'] .= replace_macros(get_markup_template('contact_head.tpl'), array(
367                         '$baseurl' => $a->get_baseurl(true),
368                         '$editselect' => $editselect,
369                 ));
370                 $a->page['end'] .= replace_macros(get_markup_template('contact_end.tpl'), array(
371                         '$baseurl' => $a->get_baseurl(true),
372                         '$editselect' => $editselect,
373                 ));
374
375                 require_once('include/contact_selectors.php');
376
377                 $tpl = get_markup_template("contact_edit.tpl");
378
379                 switch($contact['rel']) {
380                         case CONTACT_IS_FRIEND:
381                                 $dir_icon = 'images/lrarrow.gif';
382                                 $relation_text = t('You are mutual friends with %s');
383                                 break;
384                         case CONTACT_IS_FOLLOWER;
385                                 $dir_icon = 'images/larrow.gif';
386                                 $relation_text = t('You are sharing with %s');
387                                 break;
388         
389                         case CONTACT_IS_SHARING;
390                                 $dir_icon = 'images/rarrow.gif';
391                                 $relation_text = t('%s is sharing with you');
392                                 break;
393                         default:
394                                 break;
395                 }
396
397                 $relation_text = sprintf($relation_text,$contact['name']);
398
399                 if(($contact['network'] === NETWORK_DFRN) && ($contact['rel'])) {
400                         $url = "redir/{$contact['id']}";
401                         $sparkle = ' class="sparkle" ';
402                 }
403                 else { 
404                         $url = $contact['url'];
405                         $sparkle = '';
406                 }
407
408                 $insecure = t('Private communications are not available for this contact.');
409
410                 $last_update = (($contact['last-update'] == '0000-00-00 00:00:00') 
411                                 ? t('Never') 
412                                 : datetime_convert('UTC',date_default_timezone_get(),$contact['last-update'],'D, j M Y, g:i A'));
413
414                 if($contact['last-update'] !== '0000-00-00 00:00:00')
415                         $last_update .= ' ' . (($contact['last-update'] == $contact['success_update']) ? t("\x28Update was successful\x29") : t("\x28Update was not successful\x29"));
416
417                 $lblsuggest = (($contact['network'] === NETWORK_DFRN) ? t('Suggest friends') : '');
418
419                 $poll_enabled = (($contact['network'] !== NETWORK_DIASPORA) ? true : false);
420
421                 $nettype = sprintf( t('Network type: %s'),network_to_name($contact['network']));
422
423                 $common = count_common_friends(local_user(),$contact['id']);
424                 $common_text = (($common) ? sprintf( tt('%d contact in common','%d contacts in common', $common),$common) : '');
425
426                 $polling = (($contact['network'] === NETWORK_MAIL | $contact['network'] === NETWORK_FEED) ? 'polling' : ''); 
427
428                 $x = count_all_friends(local_user(), $contact['id']);
429                 $all_friends = (($x) ? t('View all contacts') : '');
430
431                 // tabs
432                 $tabs = array(
433                         array(
434                                 'label' => (($contact['blocked']) ? t('Unblock') : t('Block') ),
435                                 'url'   => $a->get_baseurl(true) . '/contacts/' . $contact_id . '/block',
436                                 'sel'   => '',
437                                 'title' => t('Toggle Blocked status'),
438                         ),
439                         array(
440                                 'label' => (($contact['readonly']) ? t('Unignore') : t('Ignore') ),
441                                 'url'   => $a->get_baseurl(true) . '/contacts/' . $contact_id . '/ignore',
442                                 'sel'   => '',
443                                 'title' => t('Toggle Ignored status'),
444                         ),
445
446                         array(
447                                 'label' => (($contact['archive']) ? t('Unarchive') : t('Archive') ),
448                                 'url'   => $a->get_baseurl(true) . '/contacts/' . $contact_id . '/archive',
449                                 'sel'   => '',
450                                 'title' => t('Toggle Archive status'),
451                         ),
452                         array(
453                                 'label' => t('Repair'),
454                                 'url'   => $a->get_baseurl(true) . '/crepair/' . $contact_id,
455                                 'sel'   => '',
456                                 'title' => t('Advanced Contact Settings'),
457                         )
458                 );
459                 $tab_tpl = get_markup_template('common_tabs.tpl');
460                 $tab_str = replace_macros($tab_tpl, array('$tabs' => $tabs));
461
462                 $lost_contact = (($contact['archive'] && $contact['term-date'] != '0000-00-00 00:00:00' && $contact['term-date'] < datetime_convert('','','now')) ? t('Communications lost with this contact!') : '');
463
464                 $o .= replace_macros($tpl, array(
465                         '$header' => t('Contact Editor'),
466                         '$tab_str' => $tab_str,
467                         '$submit' => t('Submit'),
468                         '$lbl_vis1' => t('Profile Visibility'),
469                         '$lbl_vis2' => sprintf( t('Please choose the profile you would like to display to %s when viewing your profile securely.'), $contact['name']),
470                         '$lbl_info1' => t('Contact Information / Notes'),
471                         '$infedit' => t('Edit contact notes'),
472                         '$common_text' => $common_text,
473                         '$common_link' => $a->get_baseurl(true) . '/common/loc/' . local_user() . '/' . $contact['id'],
474                         '$all_friends' => $all_friends,
475                         '$relation_text' => $relation_text,
476                         '$visit' => sprintf( t('Visit %s\'s profile [%s]'),$contact['name'],$contact['url']),
477                         '$blockunblock' => t('Block/Unblock contact'),
478                         '$ignorecont' => t('Ignore contact'),
479                         '$lblcrepair' => t("Repair URL settings"),
480                         '$lblrecent' => t('View conversations'),
481                         '$lblsuggest' => $lblsuggest,
482                         '$delete' => t('Delete contact'),
483                         '$nettype' => $nettype,
484                         '$poll_interval' => contact_poll_interval($contact['priority'],(! $poll_enabled)),
485                         '$poll_enabled' => $poll_enabled,
486                         '$lastupdtext' => t('Last update:'),
487                         '$lost_contact' => $lost_contact,
488                         '$updpub' => t('Update public posts'),
489                         '$last_update' => $last_update,
490                         '$udnow' => t('Update now'),
491                         '$profile_select' => contact_profile_assign($contact['profile-id'],(($contact['network'] !== NETWORK_DFRN) ? true : false)),
492                         '$contact_id' => $contact['id'],
493                         '$block_text' => (($contact['blocked']) ? t('Unblock') : t('Block') ),
494                         '$ignore_text' => (($contact['readonly']) ? t('Unignore') : t('Ignore') ),
495                         '$insecure' => (($contact['network'] !== NETWORK_DFRN && $contact['network'] !== NETWORK_MAIL && $contact['network'] !== NETWORK_FACEBOOK && $contact['network'] !== NETWORK_DIASPORA) ? $insecure : ''),
496                         '$info' => $contact['info'],
497                         '$blocked' => (($contact['blocked']) ? t('Currently blocked') : ''),
498                         '$ignored' => (($contact['readonly']) ? t('Currently ignored') : ''),
499                         '$archived' => (($contact['archive']) ? t('Currently archived') : ''),
500                         '$hidden' => array('hidden', t('Hide this contact from others'), ($contact['hidden'] == 1), t('Replies/likes to your public posts <strong>may</strong> still be visible')),
501                         '$notify' => array('notify', t('Notification for new posts'), ($contact['notify_new_posts'] == 1), t('Send a notification of every new post of this contact')),
502                         '$fetch_further_information' => array('fetch_further_information', t('Fetch further information for feeds'), ($contact['fetch_further_information'] == 1), t('Fetch further information for feeds')),
503                         '$photo' => $contact['photo'],
504                         '$name' => $contact['name'],
505                         '$dir_icon' => $dir_icon,
506                         '$alt_text' => $alt_text,
507                         '$sparkle' => $sparkle,
508                         '$url' => $url,
509
510                 ));
511
512                 $arr = array('contact' => $contact,'output' => $o);
513
514                 call_hooks('contact_edit', $arr);
515
516                 return $arr['output'];
517
518         }
519
520         $blocked = false;
521         $hidden = false;
522         $ignored = false;
523         $all = false;
524
525         if(($a->argc == 2) && ($a->argv[1] === 'all')) {
526                 $sql_extra = '';
527                 $all = true;
528         }
529         elseif(($a->argc == 2) && ($a->argv[1] === 'blocked')) {
530                 $sql_extra = " AND `blocked` = 1 ";
531                 $blocked = true;
532         }
533         elseif(($a->argc == 2) && ($a->argv[1] === 'hidden')) {
534                 $sql_extra = " AND `hidden` = 1 ";
535                 $hidden = true;
536         }
537         elseif(($a->argc == 2) && ($a->argv[1] === 'ignored')) {
538                 $sql_extra = " AND `readonly` = 1 ";
539                 $ignored = true;
540         }
541         elseif(($a->argc == 2) && ($a->argv[1] === 'archived')) {
542                 $sql_extra = " AND `archive` = 1 ";
543                 $archived = true;
544         }
545         else
546                 $sql_extra = " AND `blocked` = 0 ";
547
548         $search = ((x($_GET,'search')) ? notags(trim($_GET['search'])) : '');
549         $nets = ((x($_GET,'nets')) ? notags(trim($_GET['nets'])) : '');
550
551         $tabs = array(
552                 array(
553                         'label' => t('Suggestions'),
554                         'url'   => $a->get_baseurl(true) . '/suggest', 
555                         'sel'   => '',
556                         'title' => t('Suggest potential friends'),
557                 ),
558                 array(
559                         'label' => t('All Contacts'),
560                         'url'   => $a->get_baseurl(true) . '/contacts/all', 
561                         'sel'   => ($all) ? 'active' : '',
562                         'title' => t('Show all contacts'),
563                 ),
564                 array(
565                         'label' => t('Unblocked'),
566                         'url'   => $a->get_baseurl(true) . '/contacts',
567                         'sel'   => ((! $all) && (! $blocked) && (! $hidden) && (! $search) && (! $nets) && (! $ignored) && (! $archived)) ? 'active' : '',
568                         'title' => t('Only show unblocked contacts'),
569                 ),
570
571                 array(
572                         'label' => t('Blocked'),
573                         'url'   => $a->get_baseurl(true) . '/contacts/blocked',
574                         'sel'   => ($blocked) ? 'active' : '',
575                         'title' => t('Only show blocked contacts'),
576                 ),
577
578                 array(
579                         'label' => t('Ignored'),
580                         'url'   => $a->get_baseurl(true) . '/contacts/ignored',
581                         'sel'   => ($ignored) ? 'active' : '',
582                         'title' => t('Only show ignored contacts'),
583                 ),
584
585                 array(
586                         'label' => t('Archived'),
587                         'url'   => $a->get_baseurl(true) . '/contacts/archived',
588                         'sel'   => ($archived) ? 'active' : '',
589                         'title' => t('Only show archived contacts'),
590                 ),
591
592                 array(
593                         'label' => t('Hidden'),
594                         'url'   => $a->get_baseurl(true) . '/contacts/hidden',
595                         'sel'   => ($hidden) ? 'active' : '',
596                         'title' => t('Only show hidden contacts'),
597                 ),
598
599         );
600
601         $tab_tpl = get_markup_template('common_tabs.tpl');
602         $t = replace_macros($tab_tpl, array('$tabs'=>$tabs));
603
604
605
606         $searching = false;
607         if($search) {
608                 $search_hdr = $search;
609                 $search_txt = dbesc(protect_sprintf(preg_quote($search)));
610                 $searching = true;
611         }
612         $sql_extra .= (($searching) ? " AND (name REGEXP '$search_txt' OR url REGEXP '$search_txt'  OR nick REGEXP '$search_txt') " : "");
613
614         if($nets)
615                 $sql_extra .= sprintf(" AND network = '%s' ", dbesc($nets));
616  
617         $sql_extra2 = ((($sort_type > 0) && ($sort_type <= CONTACT_IS_FRIEND)) ? sprintf(" AND `rel` = %d ",intval($sort_type)) : ''); 
618
619         
620         $r = q("SELECT COUNT(*) AS `total` FROM `contact` 
621                 WHERE `uid` = %d AND `self` = 0 AND `pending` = 0 $sql_extra $sql_extra2 ",
622                 intval($_SESSION['uid']));
623         if(count($r)) {
624                 $a->set_pager_total($r[0]['total']);
625                 $total = $r[0]['total'];
626         }
627
628
629         $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `self` = 0 AND `pending` = 0 $sql_extra $sql_extra2 ORDER BY `name` ASC LIMIT %d , %d ",
630                 intval($_SESSION['uid']),
631                 intval($a->pager['start']),
632                 intval($a->pager['itemspage'])
633         );
634
635         $contacts = array();
636
637         if(count($r)) {
638
639                 foreach($r as $rr) {
640
641                         switch($rr['rel']) {
642                                 case CONTACT_IS_FRIEND:
643                                         $dir_icon = 'images/lrarrow.gif';
644                                         $alt_text = t('Mutual Friendship');
645                                         break;
646                                 case  CONTACT_IS_FOLLOWER;
647                                         $dir_icon = 'images/larrow.gif';
648                                         $alt_text = t('is a fan of yours');
649                                         break;
650                                 case CONTACT_IS_SHARING;
651                                         $dir_icon = 'images/rarrow.gif';
652                                         $alt_text = t('you are a fan of');
653                                         break;
654                                 default:
655                                         break;
656                         }
657                         if(($rr['network'] === 'dfrn') && ($rr['rel'])) {
658                                 $url = "redir/{$rr['id']}";
659                                 $sparkle = ' class="sparkle" ';
660                         }
661                         else { 
662                                 $url = $rr['url'];
663                                 $sparkle = '';
664                         }
665
666
667                         $contacts[] = array(
668                                 'img_hover' => sprintf( t('Visit %s\'s profile [%s]'),$rr['name'],$rr['url']),
669                                 'edit_hover' => t('Edit contact'),
670                                 'photo_menu' => contact_photo_menu($rr),
671                                 'id' => $rr['id'],
672                                 'alt_text' => $alt_text,
673                                 'dir_icon' => $dir_icon,
674                                 'thumb' => $rr['thumb'], 
675                                 'name' => $rr['name'],
676                                 'username' => $rr['name'],
677                                 'sparkle' => $sparkle,
678                                 'itemurl' => $rr['url'],
679                                 'url' => $url,
680                                 'network' => network_to_name($rr['network']),
681                         );
682                 }
683
684                 
685
686         }
687         
688         $tpl = get_markup_template("contacts-template.tpl");
689         $o .= replace_macros($tpl, array(
690                 '$baseurl' => $a->get_baseurl(),
691                 '$header' => t('Contacts') . (($nets) ? ' - ' . network_to_name($nets) : ''),
692                 '$tabs' => $t,
693                 '$total' => $total,
694                 '$search' => $search_hdr,
695                 '$desc' => t('Search your contacts'),
696                 '$finding' => (($searching) ? t('Finding: ') . "'" . $search . "'" : ""),
697                 '$submit' => t('Find'),
698                 '$cmd' => $a->cmd,
699                 '$contacts' => $contacts,
700                 '$contact_drop_confirm' => t('Do you really want to delete this contact?'),
701                 '$batch_actions' => array(
702                         'contacts_batch_update' => t('Update'),
703                         'contacts_batch_block' => t('Block')."/".t("Unblock"),
704                         "contacts_batch_ignore" => t('Ignore')."/".t("Unignore"),
705                         "contacts_batch_archive" => t('Archive')."/".t("Unarchive"),
706                         "contacts_batch_drop" => t('Delete'),
707                 ),
708                 '$paginate' => paginate($a),
709
710         )); 
711         
712         return $o;
713 }