| 1 | <?php |
| 2 | |
| 3 | function smarty_function_get_threaded_children($params,&$smarty) { |
| 4 | global $db, $error, $node; |
| 5 | |
| 6 | if (!strlen($node['node_vector'])) { |
| 7 | ob_start(); |
| 8 | phpinfo(INFO_VARIABLES); |
| 9 | print_r($_SESSION); |
| 10 | $s = ob_get_contents(); |
| 11 | ob_end_clean(); |
| 12 | } |
| 13 | $offset=$params['offset']; |
| 14 | $limit=$params['listing_amount']; |
| 15 | if ($limit > 100) |
| 16 | $limit = 100; |
| 17 | |
| 18 | if (!empty($params['search'])) { |
| 19 | if ($params['search_type']=='content') $sql_type.=" and node_content like '%".addslashes($params['search'])."%' "; |
| 20 | else { |
| 21 | $q2="select user_id from users where login='".$params['search']."'"; |
| 22 | $userset=$db->query($q2); |
| 23 | $userset->next(); |
| 24 | $id=$userset->getString('user_id'); |
| 25 | $sql_type=" and nodes.node_creator='$id'"; |
| 26 | } |
| 27 | |
| 28 | } |
| 29 | if (!empty($_POST['synapse_time'])) $sql_synapse.=" and node_created >'".$_POST['synapse_time']."'"; |
| 30 | if (empty($params['orderby']) OR $params['orderby']=='desc') { |
| 31 | //$orderby="node_vector desc"; |
| 32 | $orderby="concat(node_vector,'z') desc,depth"; |
| 33 | } |
| 34 | else { |
| 35 | $orderby="node_vector asc"; |
| 36 | } |
| 37 | |
| 38 | if ($params['time']) { |
| 39 | $time=addslashes($params['time']); |
| 40 | $sql_time="node_created > '$time' and"; |
| 41 | } |
| 42 | if ($node['node_system_access']=='public') $security=" and node_system_access!='private'"; |
| 43 | else $security = ""; |
| 44 | |
| 45 | // by br & maniac |
| 46 | |
| 47 | if ($node['node_vector']=='') { |
| 48 | $node['node_vector']='blabla'; |
| 49 | // system("echo \"node: $node[node_id]\" >> /tmp/blabla.log") ; |
| 50 | } |
| 51 | |
| 52 | if ($params['link']=='yes') $q.="("; |
| 53 | $q.="select nodes.node_id,node_name,node_external_access,external_link,node_parent,node_system_access,node_children_count,node_creator,node_created,lastchild_created,k,node_views,node_descendant_count,lastdescendant_created,template_id,node_updated,length(node_vector) as depth,users.login,node_vector, node_content,'' as synapse_creator from nodes left join users on users.user_id=nodes.node_creator where $sql_time node_vector like '".$node['node_vector']."%' $sql_type and node_id != '".$node['node_id']."' $security order by $orderby LIMIT $offset,$limit"; |
| 54 | |
| 55 | if ($params['link']=='yes') { |
| 56 | $q.=" ) UNION (select nodes.node_id,node_name,node_external_access,external_link,node_parent,node_system_access,node_children_count,node_creator,node_created,lastchild_created,k,node_views,node_descendant_count,lastdescendant_created,template_id,node_updated,length(dst_vector) as depth, |
| 57 | users.login,dst_vector as node_vector,node_content,synapse_creator from neurons left join nodes on neurons.src=nodes.node_id left join users on users.user_id=nodes.node_creator where $sql_time dst_vector like '".$node['node_vector']."%' $sql_synapse $sql_type and node_id != '".$node['node_id']."' order by $orderby LIMIT $offset,$limit)"; |
| 58 | } |
| 59 | |
| 60 | if ($params['link']=='yes') $q.=" order by $orderby LIMIT $limit"; |
| 61 | |
| 62 | $result=$db->query($q); |
| 63 | |
| 64 | while ($result->next()) { |
| 65 | $child = $result->getRecord(); |
| 66 | if($child['external_link']=='transport') { |
| 67 | $child['node_status']='linked'; |
| 68 | $transport = preg_split('/[:@]/',trim($child['node_content'])); |
| 69 | require_once(INCLUDE_DIR.'transports.inc'); |
| 70 | transport_load($transport[0]); |
| 71 | global $transports; |
| 72 | $child['node_name']=$transport[0].':'.$transport[1].'@defaulthost'; |
| 73 | $child['node_content']=$transport[0].':'.$transport[1].'@defaulthost:<br />'.$transports[$transport[0]]['get_node_content']($transport[1]); |
| 74 | } |
| 75 | |
| 76 | if($child['synapse_creator']!='') { |
| 77 | $child['node_status']='linked'; |
| 78 | /* if($child['transport']!='') { |
| 79 | require_once(INCLUDE_DIR.'transports.inc'); |
| 80 | transport_load($child['transport']); |
| 81 | global $transports; |
| 82 | $child['node_content']=$child['transport'].':'.$child['node_id'].'@default:\n<br />'.$transports[$child['transport']]['get_node_content']($child['node_id']); |
| 83 | $child['node_name']=$child['transport'].':'.$child['node_id']; |
| 84 | } */ |
| 85 | } |
| 86 | |
| 87 | $get_children_array[]=$child; |
| 88 | } |
| 89 | global $time_1, $time_2; |
| 90 | $time_2=$result->getString('node_created'); |
| 91 | $time_1=$get_children_array[0]['node_created']; |
| 92 | |
| 93 | $smarty->assign('get_threaded_children',$get_children_array); |
| 94 | |
| 95 | } |
| 96 | ?> |
| 97 | |