X-Git-Url: https://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Finc%2Fsmarty%2Fnode_methodz%2Ffunction.get_threaded_children.php;h=802d1ceae47e1651618497a057db302e2e7c5c72;hb=ccb9c667e7fdb56dfc2aa3c800328511a26dffb8;hp=7f18e893b816bec134dcc3df3961d3f0d231e0df;hpb=0eb768bf3a10faf5ad7848caf2c2472e297f2837;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 7f18e89..802d1ce 100644 --- a/wwwroot/inc/smarty/node_methodz/function.get_threaded_children.php +++ b/wwwroot/inc/smarty/node_methodz/function.get_threaded_children.php @@ -50,37 +50,31 @@ else $security = ""; } 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,'' as transport 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"; + $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,transport 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)"; + 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(); -if($child['synapse_creator']!='') { - $child['node_status']='linked'; - if($child['transport']!='') { - require_once(INCLUDE_DIR.'transports.inc'); - transport_load($child['transport']); - global $transports; - $child['node_content']=$child['node_id'].'@'.$child['transport'].':
'.$transports[$child['transport']]['get_node_content']($child['node_id']); + while ($result->next()) { + $child = $result->getRecord(); + transport_process_node($child); + if($child['synapse_creator']!='') $child['node_status']='linked'; + + $get_children_array[]=$child; } -} -$get_children_array[]=$child; - } - global $time_1, $time_2; - $time_2=$result->getString('node_created'); - $time_1=$get_children_array[0]['node_created']; + global $time_1, $time_2; + $time_2=$result->getString('node_created'); + $time_1=$get_children_array[0]['node_created']; - $smarty->assign('get_threaded_children',$get_children_array); + $smarty->assign('get_threaded_children',$get_children_array); - } +} ?>