include/acl_selectors.php

   1 <?php
   2
   3 require_once("include/contact_selectors.php");
   4 require_once("include/features.php");
   5
   6 /**
   7  *
   8  */
   9
  10 /**
  11  * @package acl_selectors
  12  */
  13 function group_select($selname,$selclass,$preselected = false,$size = 4) {
  14
  15         $a = get_app();
  16
  17         $o = '';
  18
  19         $o .= "<select name=\"{$selname}[]\" id=\"$selclass\" class=\"$selclass\" multiple=\"multiple\" size=\"$size\" >\r\n";
  20
  21         $r = q("SELECT * FROM `group` WHERE `deleted` = 0 AND `uid` = %d ORDER BY `name` ASC",
  22                 intval(local_user())
  23         );
  24
  25
  26         $arr = array('group' => $r, 'entry' => $o);
  27
  28         // e.g. 'network_pre_group_deny', 'profile_pre_group_allow'
  29
  30         call_hooks($a->module . '_pre_' . $selname, $arr);
  31
  32         if(count($r)) {
  33                 foreach($r as $rr) {
  34                         if((is_array($preselected)) && in_array($rr['id'], $preselected))
  35                                 $selected = " selected=\"selected\" ";
  36                         else
  37                                 $selected = '';
  38
  39                         $trimmed = mb_substr($rr['name'],0,12);
  40
  41                         $o .= "<option value=\"{$rr['id']}\" $selected title=\"{$rr['name']}\" >$trimmed</option>\r\n";
  42                 }
  43
  44         }
  45         $o .= "</select>\r\n";
  46
  47         call_hooks($a->module . '_post_' . $selname, $o);
  48
  49
  50         return $o;
  51 }
  52
  53
  54 function contact_selector($selname, $selclass, $preselected = false, $options) {
  55
  56         $a = get_app();
  57
  58         $mutual = false;
  59         $networks = null;
  60         $single = false;
  61         $exclude = false;
  62         $size = 4;
  63
  64         if(is_array($options)) {
  65                 if(x($options,'size'))
  66                         $size = $options['size'];
  67
  68                 if(x($options,'mutual_friends'))
  69                         $mutual = true;
  70                 if(x($options,'single'))
  71                         $single = true;
  72                 if(x($options,'multiple'))
  73                         $single = false;
  74                 if(x($options,'exclude'))
  75                         $exclude = $options['exclude'];
  76
  77                 if(x($options,'networks')) {
  78                         switch($options['networks']) {
  79                                 case 'DFRN_ONLY':
  80                                         $networks = array('dfrn');
  81                                         break;
  82                                 case 'PRIVATE':
  83                                         if(is_array($a->user) && $a->user['prvnets'])
  84                                                 $networks = array('dfrn','mail','dspr');
  85                                         else
  86                                                 $networks = array('dfrn','face','mail', 'dspr');
  87                                         break;
  88                                 case 'TWO_WAY':
  89                                         if(is_array($a->user) && $a->user['prvnets'])
  90                                                 $networks = array('dfrn','mail','dspr');
  91                                         else
  92                                                 $networks = array('dfrn','face','mail','dspr','stat');
  93                                         break;
  94                                 default:
  95                                         break;
  96                         }
  97                 }
  98         }
  99
 100         $x = array('options' => $options, 'size' => $size, 'single' => $single, 'mutual' => $mutual, 'exclude' => $exclude, 'networks' => $networks);
 101
 102         call_hooks('contact_select_options', $x);
 103
 104         $o = '';
 105
 106         $sql_extra = '';
 107
 108         if($x['mutual']) {
 109                 $sql_extra .= sprintf(" AND `rel` = %d ", intval(CONTACT_IS_FRIEND));
 110         }
 111
 112         if(intval($x['exclude']))
 113                 $sql_extra .= sprintf(" AND `id` != %d ", intval($x['exclude']));
 114
 115         if(is_array($x['networks']) && count($x['networks'])) {
 116                 for($y = 0; $y < count($x['networks']) ; $y ++)
 117                         $x['networks'][$y] = "'" . dbesc($x['networks'][$y]) . "'";
 118                 $str_nets = implode(',',$x['networks']);
 119                 $sql_extra .= " AND `network` IN ( $str_nets ) ";
 120         }
 121
 122         $tabindex = (x($options, 'tabindex') ? "tabindex=\"" . $options["tabindex"] . "\"" : "");
 123
 124         if($x['single'])
 125                 $o .= "<select name=\"$selname\" id=\"$selclass\" class=\"$selclass\" size=\"" . $x['size'] . "\" $tabindex >\r\n";
 126         else
 127                 $o .= "<select name=\"{$selname}[]\" id=\"$selclass\" class=\"$selclass\" multiple=\"multiple\" size=\"" . $x['size'] . "$\" $tabindex >\r\n";
 128
 129         $r = q("SELECT `id`, `name`, `url`, `network` FROM `contact`
 130                 WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 AND `archive` = 0 AND `notify` != ''
 131                 $sql_extra
 132                 ORDER BY `name` ASC ",
 133                 intval(local_user())
 134         );
 135
 136
 137         $arr = array('contact' => $r, 'entry' => $o);
 138
 139         // e.g. 'network_pre_contact_deny', 'profile_pre_contact_allow'
 140
 141         call_hooks($a->module . '_pre_' . $selname, $arr);
 142
 143         if(count($r)) {
 144                 foreach($r as $rr) {
 145                         if((is_array($preselected)) && in_array($rr['id'], $preselected))
 146                                 $selected = " selected=\"selected\" ";
 147                         else
 148                                 $selected = '';
 149
 150                         $trimmed = mb_substr($rr['name'],0,20);
 151
 152                         $o .= "<option value=\"{$rr['id']}\" $selected title=\"{$rr['name']}|{$rr['url']}\" >$trimmed</option>\r\n";
 153                 }
 154
 155         }
 156
 157         $o .= "</select>\r\n";
 158
 159         call_hooks($a->module . '_post_' . $selname, $o);
 160
 161         return $o;
 162 }
 163
 164
 165
 166 function contact_select($selname, $selclass, $preselected = false, $size = 4, $privmail = false, $celeb = false, $privatenet = false, $tabindex = null) {
 167
 168         require_once("include/bbcode.php");
 169
 170         $a = get_app();
 171
 172         $o = '';
 173
 174         // When used for private messages, we limit correspondence to mutual DFRN/Friendica friends and the selector
 175         // to one recipient. By default our selector allows multiple selects amongst all contacts.
 176
 177         $sql_extra = '';
 178
 179         if($privmail || $celeb) {
 180                 $sql_extra .= sprintf(" AND `rel` = %d ", intval(CONTACT_IS_FRIEND));
 181         }
 182
 183         if($privmail) {
 184                 $sql_extra .= " AND `network` IN ( 'dfrn', 'dspr' ) ";
 185         }
 186         elseif($privatenet) {
 187                 $sql_extra .= " AND `network` IN ( 'dfrn', 'mail', 'face', 'dspr' ) ";
 188         }
 189
 190         $tabindex = ($tabindex > 0 ? "tabindex=\"$tabindex\"" : "");
 191
 192         if($privmail)
 193                 $o .= "<select name=\"$selname\" id=\"$selclass\" class=\"$selclass\" size=\"$size\" $tabindex >\r\n";
 194         else
 195                 $o .= "<select name=\"{$selname}[]\" id=\"$selclass\" class=\"$selclass\" multiple=\"multiple\" size=\"$size\" $tabindex >\r\n";
 196
 197         $r = q("SELECT `id`, `name`, `url`, `network` FROM `contact`
 198                 WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 AND `archive` = 0 AND `notify` != ''
 199                 $sql_extra
 200                 ORDER BY `name` ASC ",
 201                 intval(local_user())
 202         );
 203
 204
 205         $arr = array('contact' => $r, 'entry' => $o);
 206
 207         // e.g. 'network_pre_contact_deny', 'profile_pre_contact_allow'
 208
 209         call_hooks($a->module . '_pre_' . $selname, $arr);
 210
 211         if(count($r)) {
 212                 foreach($r as $rr) {
 213                         if((is_array($preselected)) && in_array($rr['id'], $preselected))
 214                                 $selected = " selected=\"selected\" ";
 215                         else
 216                                 $selected = '';
 217
 218                         if($privmail)
 219                                 $trimmed = GetProfileUsername($rr['url'], $rr['name'], false);
 220                         else
 221                                 $trimmed = mb_substr($rr['name'],0,20);
 222
 223                         $o .= "<option value=\"{$rr['id']}\" $selected title=\"{$rr['name']}|{$rr['url']}\" >$trimmed</option>\r\n";
 224                 }
 225
 226         }
 227
 228         $o .= "</select>\r\n";
 229
 230         call_hooks($a->module . '_post_' . $selname, $o);
 231
 232         return $o;
 233 }
 234
 235
 236 function fixacl(&$item) {
 237         $item = intval(str_replace(array('<','>'),array('',''),$item));
 238 }
 239
 240 function prune_deadguys($arr) {
 241
 242         if(! $arr)
 243                 return $arr;
 244         $str = dbesc(implode(',',$arr));
 245         $r = q("select id from contact where id in ( " . $str . ") and blocked = 0 and pending = 0 and archive = 0 ");
 246         if($r) {
 247                 $ret = array();
 248                 foreach($r as $rr)
 249                         $ret[] = intval($rr['id']);
 250                 return $ret;
 251         }
 252         return array();
 253 }
 254
 255
 256 function get_acl_permissions($user = null) {
 257         $allow_cid = $allow_gid = $deny_cid = $deny_gid = false;
 258
 259         if(is_array($user)) {
 260                 $allow_cid = ((strlen($user['allow_cid']))
 261                         ? explode('><', $user['allow_cid']) : array() );
 262                 $allow_gid = ((strlen($user['allow_gid']))
 263                         ? explode('><', $user['allow_gid']) : array() );
 264                 $deny_cid  = ((strlen($user['deny_cid']))
 265                         ? explode('><', $user['deny_cid']) : array() );
 266                 $deny_gid  = ((strlen($user['deny_gid']))
 267                         ? explode('><', $user['deny_gid']) : array() );
 268                 array_walk($allow_cid,'fixacl');
 269                 array_walk($allow_gid,'fixacl');
 270                 array_walk($deny_cid,'fixacl');
 271                 array_walk($deny_gid,'fixacl');
 272         }
 273
 274         $allow_cid = prune_deadguys($allow_cid);
 275
 276         return array(
 277                 'allow_cid' => $allow_cid,
 278                 'allow_gid' => $allow_gid,
 279                 'deny_cid' => $deny_cid,
 280                 'deny_gid' => $deny_gid,
 281         );
 282 }
 283
 284
 285 function populate_acl($user = null,$celeb = false) {
 286
 287         $perms = get_acl_permissions($user);
 288
 289         // We shouldn't need to prune deadguys from the block list. Either way they can't get the message.
 290         // Also no point enumerating groups and checking them, that will take place on delivery.
 291
 292 //      $deny_cid = prune_deadguys($deny_cid);
 293
 294
 295         /*$o = '';
 296         $o .= '<div id="acl-wrapper">';
 297         $o .= '<div id="acl-permit-outer-wrapper">';
 298         $o .= '<div id="acl-permit-text">' . t('Visible To:') . '</div><div id="jot-public">' . t('everybody') . '</div>';
 299         $o .= '<div id="acl-permit-text-end"></div>';
 300         $o .= '<div id="acl-permit-wrapper">';
 301         $o .= '<div id="group_allow_wrapper">';
 302         $o .= '<label id="acl-allow-group-label" for="group_allow" >' . t('Groups') . '</label>';
 303         $o .= group_select('group_allow','group_allow',$allow_gid);
 304         $o .= '</div>';
 305         $o .= '<div id="contact_allow_wrapper">';
 306         $o .= '<label id="acl-allow-contact-label" for="contact_allow" >' . t('Contacts') . '</label>';
 307         $o .= contact_select('contact_allow','contact_allow',$allow_cid,4,false,$celeb,true);
 308         $o .= '</div>';
 309         $o .= '</div>' . "\r\n";
 310         $o .= '<div id="acl-allow-end"></div>' . "\r\n";
 311         $o .= '</div>';
 312         $o .= '<div id="acl-deny-outer-wrapper">';
 313         $o .= '<div id="acl-deny-text">' . t('Except For:') . '</div>';
 314         $o .= '<div id="acl-deny-text-end"></div>';
 315         $o .= '<div id="acl-deny-wrapper">';
 316         $o .= '<div id="group_deny_wrapper" >';
 317         $o .= '<label id="acl-deny-group-label" for="group_deny" >' . t('Groups') . '</label>';
 318         $o .= group_select('group_deny','group_deny', $deny_gid);
 319         $o .= '</div>';
 320         $o .= '<div id="contact_deny_wrapper" >';
 321         $o .= '<label id="acl-deny-contact-label" for="contact_deny" >' . t('Contacts') . '</label>';
 322         $o .= contact_select('contact_deny','contact_deny', $deny_cid,4,false, $celeb,true);
 323         $o .= '</div>';
 324         $o .= '</div>' . "\r\n";
 325         $o .= '<div id="acl-deny-end"></div>' . "\r\n";
 326         $o .= '</div>';
 327         $o .= '</div>' . "\r\n";
 328         $o .= '<div id="acl-wrapper-end"></div>' . "\r\n";*/
 329
 330         $tpl = get_markup_template("acl_selector.tpl");
 331         $o = replace_macros($tpl, array(
 332                 '$showall'=> t("Visible to everybody"),
 333                 '$show'          => t("show"),
 334                 '$hide'          => t("don't show"),
 335                 '$allowcid' => json_encode($perms['allow_cid']),
 336                 '$allowgid' => json_encode($perms['allow_gid']),
 337                 '$denycid' => json_encode($perms['deny_cid']),
 338                 '$denygid' => json_encode($perms['deny_gid']),
 339                 '$features' => array(
 340                         "aclautomention"=>(feature_enabled($user['uid'],"aclautomention")?"true":"false")
 341                 ),
 342         ));
 343
 344
 345         return $o;
 346
 347 }
 348
 349 function construct_acl_data(&$a, $user) {
 350
 351         // Get group and contact information for html ACL selector
 352         $acl_data = acl_lookup($a, 'html');
 353
 354         $user_defaults = get_acl_permissions($user);
 355
 356         if($acl_data['groups']) {
 357                 foreach($acl_data['groups'] as $key=>$group) {
 358                         // Add a "selected" flag to groups that are posted to by default
 359                         if($user_defaults['allow_gid'] &&
 360                            in_array($group['id'], $user_defaults['allow_gid']) && !in_array($group['id'], $user_defaults['deny_gid']) )
 361                                 $acl_data['groups'][$key]['selected'] = 1;
 362                         else
 363                                 $acl_data['groups'][$key]['selected'] = 0;
 364                 }
 365         }
 366         if($acl_data['contacts']) {
 367                 foreach($acl_data['contacts'] as $key=>$contact) {
 368                         // Add a "selected" flag to groups that are posted to by default
 369                         if($user_defaults['allow_cid'] &&
 370                            in_array($contact['id'], $user_defaults['allow_cid']) && !in_array($contact['id'], $user_defaults['deny_cid']) )
 371                                 $acl_data['contacts'][$key]['selected'] = 1;
 372                         else
 373                                 $acl_data['contacts'][$key]['selected'] = 0;
 374                 }
 375         }
 376
 377         return $acl_data;
 378
 379 }
 380
 381 function acl_lookup(&$a, $out_type = 'json') {
 382
 383         if(!local_user())
 384                 return "";
 385
 386
 387         $start = (x($_REQUEST,'start')?$_REQUEST['start']:0);
 388         $count = (x($_REQUEST,'count')?$_REQUEST['count']:100);
 389         $search = (x($_REQUEST,'search')?$_REQUEST['search']:"");
 390         $type = (x($_REQUEST,'type')?$_REQUEST['type']:"");
 391         $conv_id = (x($_REQUEST,'conversation')?$_REQUEST['conversation']:null);
 392
 393         // For use with jquery.autocomplete for private mail completion
 394
 395         if(x($_REQUEST,'query') && strlen($_REQUEST['query'])) {
 396                 if(! $type)
 397                         $type = 'm';
 398                 $search = $_REQUEST['query'];
 399         }
 400
 401
 402         if ($search!=""){
 403                 $sql_extra = "AND `name` LIKE '%%".dbesc($search)."%%'";
 404                 $sql_extra2 = "AND (`attag` LIKE '%%".dbesc($search)."%%' OR `name` LIKE '%%".dbesc($search)."%%' OR `nick` LIKE '%%".dbesc($search)."%%')";
 405         } else {
 406                 $sql_extra = $sql_extra2 = "";
 407         }
 408
 409         // count groups and contacts
 410         if ($type=='' || $type=='g'){
 411                 $r = q("SELECT COUNT(*) AS g FROM `group` WHERE `deleted` = 0 AND `uid` = %d $sql_extra",
 412                         intval(local_user())
 413                 );
 414                 $group_count = (int)$r[0]['g'];
 415         } else {
 416                 $group_count = 0;
 417         }
 418
 419         if ($type=='' || $type=='c'){
 420                 $r = q("SELECT COUNT(*) AS c FROM `contact`
 421                                 WHERE `uid` = %d AND `self` = 0
 422                                 AND `blocked` = 0 AND `pending` = 0 AND `archive` = 0
 423                                 AND `notify` != '' $sql_extra2" ,
 424                         intval(local_user())
 425                 );
 426                 $contact_count = (int)$r[0]['c'];
 427         }
 428         elseif ($type == 'm') {
 429
 430                 // autocomplete for Private Messages
 431
 432                 $r = q("SELECT COUNT(*) AS c FROM `contact`
 433                                 WHERE `uid` = %d AND `self` = 0
 434                                 AND `blocked` = 0 AND `pending` = 0 AND `archive` = 0
 435                                 AND `network` IN ('%s','%s','%s') $sql_extra2" ,
 436                         intval(local_user()),
 437                         dbesc(NETWORK_DFRN),
 438                         dbesc(NETWORK_ZOT),
 439                         dbesc(NETWORK_DIASPORA)
 440                 );
 441                 $contact_count = (int)$r[0]['c'];
 442
 443         }
 444         elseif ($type == 'a') {
 445
 446                 // autocomplete for Contacts
 447
 448                 $r = q("SELECT COUNT(*) AS c FROM `contact`
 449                                 WHERE `uid` = %d AND `self` = 0
 450                                 AND `pending` = 0 $sql_extra2" ,
 451                         intval(local_user())
 452                 );
 453                 $contact_count = (int)$r[0]['c'];
 454
 455         } else {
 456                 $contact_count = 0;
 457         }
 458
 459
 460         $tot = $group_count+$contact_count;
 461
 462         $groups = array();
 463         $contacts = array();
 464
 465         if ($type=='' || $type=='g'){
 466
 467                 $r = q("SELECT `group`.`id`, `group`.`name`, GROUP_CONCAT(DISTINCT `group_member`.`contact-id` SEPARATOR ',') as uids
 468                                 FROM `group`,`group_member`
 469                                 WHERE `group`.`deleted` = 0 AND `group`.`uid` = %d
 470                                         AND `group_member`.`gid`=`group`.`id`
 471                                         $sql_extra
 472                                 GROUP BY `group`.`id`
 473                                 ORDER BY `group`.`name`
 474                                 LIMIT %d,%d",
 475                         intval(local_user()),
 476                         intval($start),
 477                         intval($count)
 478                 );
 479
 480                 foreach($r as $g){
 481 //              logger('acl: group: ' . $g['name'] . ' members: ' . $g['uids']);
 482                         $groups[] = array(
 483                                 "type"  => "g",
 484                                 "photo" => "images/twopeople.png",
 485                                 "name"  => $g['name'],
 486                                 "id"    => intval($g['id']),
 487                                 "uids"  => array_map("intval", explode(",",$g['uids'])),
 488                                 "link"  => '',
 489                                 "forum" => '0'
 490                         );
 491                 }
 492         }
 493
 494         if ($type=='' || $type=='c'){
 495
 496                 $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url`, `attag`, forum FROM `contact`
 497                         WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 AND `archive` = 0 AND `notify` != ''
 498                         $sql_extra2
 499                         ORDER BY `name` ASC ",
 500                         intval(local_user())
 501                 );
 502         }
 503         elseif($type == 'm') {
 504                 $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url`, `attag` FROM `contact`
 505                         WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 AND `archive` = 0
 506                         AND `network` IN ('%s','%s','%s')
 507                         $sql_extra2
 508                         ORDER BY `name` ASC ",
 509                         intval(local_user()),
 510                         dbesc(NETWORK_DFRN),
 511                         dbesc(NETWORK_ZOT),
 512                         dbesc(NETWORK_DIASPORA)
 513                 );
 514         }
 515         elseif($type == 'a') {
 516                 $r = q("SELECT `id`, `name`, `nick`, `micro`, `network`, `url`, `attag` FROM `contact`
 517                         WHERE `uid` = %d AND `pending` = 0
 518                         $sql_extra2
 519                         ORDER BY `name` ASC ",
 520                         intval(local_user())
 521                 );
 522         }
 523         else
 524                 $r = array();
 525
 526
 527         if($type == 'm' || $type == 'a') {
 528                 $x = array();
 529                 $x['query'] = $search;
 530                 $x['photos'] = array();
 531                 $x['links'] = array();
 532                 $x['suggestions'] = array();
 533                 $x['data'] = array();
 534                 if(count($r)) {
 535                         foreach($r as $g) {
 536                                 $x['photos'][] = $g['micro'];
 537                                 $x['links'][] = $g['url'];
 538                                 $x['suggestions'][] = $g['name'];
 539                                 $x['data'][] = intval($g['id']);
 540                         }
 541                 }
 542                 echo json_encode($x);
 543                 killme();
 544         }
 545
 546         if(count($r)) {
 547                 foreach($r as $g){
 548                         $contacts[] = array(
 549                                 "type"  => "c",
 550                                 "photo" => $g['micro'],
 551                                 "name"  => $g['name'],
 552                                 "id"    => intval($g['id']),
 553                                 "network" => $g['network'],
 554                                 "link" => $g['url'],
 555                                 "nick" => ($g['attag']) ? $g['attag'] : $g['nick'],
 556                                 "forum" => $g['forum']
 557                         );
 558                 }
 559         }
 560
 561         $items = array_merge($groups, $contacts);
 562
 563         if ($conv_id) {
 564                 /* if $conv_id is set, get unknow contacts in thread */
 565                 /* but first get know contacts url to filter them out */
 566                 function _contact_link($i){ return dbesc($i['link']); }
 567                 $known_contacts = array_map(_contact_link, $contacts);
 568                 $unknow_contacts=array();
 569                 $r = q("select
 570                                         `author-avatar`,`author-name`,`author-link`
 571                                 from item where parent=%d
 572                                 and (
 573                                         `author-name` LIKE '%%%s%%' OR
 574                                         `author-link` LIKE '%%%s%%'
 575                                 ) and
 576                                 `author-link` NOT IN ('%s')
 577                                 GROUP BY `author-link`
 578                                 ORDER BY `author-name` ASC
 579                                 ",
 580                                 intval($conv_id),
 581                                 dbesc($search),
 582                                 dbesc($search),
 583                                 implode("','", $known_contacts)
 584                 );
 585                 if (is_array($r) && count($r)){
 586                         foreach($r as $row) {
 587                                 // nickname..
 588                                 $up = parse_url($row['author-link']);
 589                                 $nick = explode("/",$up['path']);
 590                                 $nick = $nick[count($nick)-1];
 591                                 $nick .= "@".$up['host'];
 592                                 // /nickname
 593                                 $unknow_contacts[] = array(
 594                                         "type"  => "c",
 595                                         "photo" => $row['author-avatar'],
 596                                         "name"  => $row['author-name'],
 597                                         "id"    => '',
 598                                         "network" => "unknown",
 599                                         "link" => $row['author-link'],
 600                                         "nick" => $nick,
 601                                         "forum" => false
 602                                 );
 603                         }
 604                 }
 605
 606                 $items = array_merge($items, $unknow_contacts);
 607                 $tot += count($unknow_contacts);
 608         }
 609
 610         if($out_type === 'html') {
 611                 $o = array(
 612                         'tot'           => $tot,
 613                         'start' => $start,
 614                         'count' => $count,
 615                         'groups'        => $groups,
 616                         'contacts'      => $contacts,
 617                 );
 618                 return $o;
 619         }
 620
 621         $o = array(
 622                 'tot'   => $tot,
 623                 'start' => $start,
 624                 'count' => $count,
 625                 'items' => $items,
 626         );
 627
 628         echo json_encode($o);
 629
 630         killme();
 631 }
 632