wwwroot/inc/smarty/node_methodz/function.get_nodes_by_parent.php

   1 <?php
   2
   3 function smarty_function_get_nodes_by_parent($params,&$smarty) {
   4         global $node;
   5
   6         $parent=$params['parent'];
   7         $permissions=permissions::checkPerms($parent);
   8         if (!$permissions['r']) {
   9                 $error=$error_messages['READ_PERMISSION_ERROR'];
  10                 return false;
  11         }
  12         $parent_vectot=$parent['node_vector'];
  13
  14         if ($params['listing_amount']=='all') $listing_amount=DEF_MAX_LISTING_AMMOUNT;
  15         else $listing_amount=$params['listing_amount'];
  16         if (empty($params['offset'])) $offset=0;
  17         else $offset=$params['offset'];
  18
  19         if (isset($params['orderby'])) {
  20                 $orderby=db_escape_string($params['orderby']);
  21         }
  22
  23         global $db,$node;
  24         $node_id=$node['node_id'];
  25         $user_id=$_SESSION['user_id'];
  26         if (isset($params['time'])) {
  27                 $sql_time=" nodes.node_created > '".db_escape_string($params['time'])."' and ";
  28         }
  29         $q="select parent.node_name as parent_name,users.*,nodes.*,node_access.node_user_subchild_count from nodes left join nodes as parent on parent.node_id=nodes.node_parent left join node_access on node_access.node_id=nodes.node_id and node_access.user_id='$user_id' left  join users on users.user_id=nodes.node_creator where ";
  30         $q.=" $sql_time nodes.node_parent='$parent' and nodes.node_system_access!='private'";
  31
  32
  33                 if (isset($_POST['template_event']) && $_POST['template_event']=='filter_by') {
  34                 if (isset($_POST['search_type']) && $_POST['search_type']=='content')
  35                                  $sql_type.=" and node_content like '%".db_escape_string($_POST['node_content'])."%' ";
  36                 else {
  37                         $q2="select user_id from users where login='".db_escape_string($_POST['node_content'])."'";
  38                         $userset=$db->query($q2);
  39                         $userset->next();
  40                         $id=$userset->getString('user_id');
  41                         $sql_type=" and nodes.node_creator='$id'";
  42                 }
  43                         $q.=$sql_type;
  44         }
  45
  46         if ($orderby) $q.=" order by $orderby ";
  47         else $q.=" order by nodes.node_id desc ";
  48         $q.= " LIMIT $offset,$listing_amount ";
  49         $set=$db->query($q);
  50         while ($set->next()) $pole[]=$set->getRecord();
  51         $smarty->assign('get_nodes_by_parent',$pole);
  52
  53 }
  54 ?>
  55
  56
  57
  58