X-Git-Url: https://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Finc%2Fsmarty%2Fnode_methodz%2Ffunction.get_threaded_children.php;h=e2f88675626eaea2f7f2b0201c6d42ef2a590b25;hb=9823a4d3a94132e008b8a65eadf695827d1994ee;hp=b1bb7521e047ca0188ec87ff8d524d9899d496be;hpb=b584ae7bcbbe0ada3e9c6f135db5ea9f7c4905bf;p=mirrors%2FKyberia-bloodline.git diff --git a/wwwroot/inc/smarty/node_methodz/function.get_threaded_children.php b/wwwroot/inc/smarty/node_methodz/function.get_threaded_children.php index b1bb752..e2f8867 100644 --- a/wwwroot/inc/smarty/node_methodz/function.get_threaded_children.php +++ b/wwwroot/inc/smarty/node_methodz/function.get_threaded_children.php @@ -1,80 +1,39 @@ 100) - $limit = 100; - - if (!empty($params['search'])) { - if ($params['search_type']=='content') $sql_type.=" and node_content like '%".addslashes($params['search'])."%' "; - else { - $q2="select user_id from users where login='".$params['search']."'"; - $userset=$db->query($q2); - $userset->next(); - $id=$userset->getString('user_id'); - $sql_type=" and nodes.node_creator='$id'"; - } - - } - if (!empty($_POST['synapse_time'])) $sql_synapse.=" and node_created >'".$_POST['synapse_time']."'"; - if (empty($params['orderby']) OR $params['orderby']=='desc') { - //$orderby="node_vector desc"; - $orderby="concat(node_vector,'z') desc,depth"; - } - else { - $orderby="node_vector asc"; - } - -if ($params['time']) { -$time=addslashes($params['time']); -$sql_time="node_created > '$time' and"; -} -if ($node['node_system_access']=='public') $security=" and node_system_access!='private'"; -else $security = ""; - - // by br & maniac - - if ($node['node_vector']=='') { - $node['node_vector']='blabla'; // XXX - // system("echo \"node: $node[node_id]\" >> /tmp/blabla.log") ; +function smarty_function_get_threaded_children($params,&$smarty) { + global $error, $node; + + $offset=isset($params['offset']) ? $params['offset'] : ""; + $limit=isset($params['listing_amount']) ? $params['listing_amount'] : DEF_LISTING_AMMOUNT; + $limit=($limit > DEF_MAX_LISTING_AMMOUNT) ? DEF_MAX_LISTING_AMMOUNT : $limit; + $synapse_time= isset($_POST['synapse_time'])? $_POST['synapse_time'] : ""; + $orderby=isset($params['orderby']) ? $params['orderby'] : "desc"; + $time=isset($params['time']) ? $params['time'] : ""; + $link=(isset($params['link']) && $params['link']=='yes') ? "yes" : ""; + $node_id=$node['node_id']; + $node_vector=$node['node_vector']; + + + // XXX WTF + if ($node['node_system_access']=='public') { $security="yes"; } + else { $security = ""; } + + if (!empty($params['search'])) { + if ($params['search_type']=='content') { + $search='content'; + $search_param=$params['search']; + } else { + $id=nodes::getUserByLogin($params['search']); + $search='user'; + $search_param=$id; } - - if ($params['link']=='yes') $q.="("; - $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"; - - if ($params['link']=='yes') { - $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, - 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)"; - } - - if ($params['link']=='yes') $q.=" order by $orderby LIMIT $limit"; - - $result=$db->query($q); - - while ($result->next()) { - $child = $result->getRecord(); - transport_process_node($child); - if($child['synapse_creator']!='') $child['node_status']='linked'; - - $get_children_array[]=$child; + } else { + $search=""; + $search_param=""; } - global $time_1, $time_2; - $time_2=$result->getString('node_created'); - $time_1=$get_children_array[0]['node_created']; + $get_children_array)=nodes::getThreadedChildren($node_id,$node_vector,$offset,$limit,$orderby,$time,$synapse_time,$security,$link,$search,$search_param); $smarty->assign('get_threaded_children',$get_children_array); - } ?> -