Added rudimentary transport support to get_threaded_children

[mirrors/Kyberia-bloodline.git] / wwwroot / inc / nodes.inc

diff --git a/wwwroot/inc/nodes.inc b/wwwroot/inc/nodes.inc
index 2f63e55265648747b7ef17714ac58858916eabac..175f9fd8299123b16b211dda694148351e9e46b2 100644 (file)
--- a/wwwroot/inc/nodes.inc
+++ b/wwwroot/inc/nodes.inc
@@ -13,9 +13,9 @@
      }
    }
 
-class nodes {
-
+require_once(INCLUDE_DIR.'base36.inc');
 
+class nodes {
 
 function addNode($params) {
         global $db,$node,$error,$error_messages;
@@ -61,10 +61,13 @@ function addNode($params) {
         $template_id=$params['template_id'];
         if (!is_numeric($template_id)) $template_id=DEFAULT_TEMPLATE_ID;
 
+        if(!isset($params['node_system_access'])) $params['node_system_access'] = $node['node_system_access'];
+        if(!isset($params['node_external_access'])) $params['node_external_access'] = $node['node_external_access'];
+
         $q="insert into nodes set
 node_name='".$params['node_name']."',
-node_external_access='".$node['node_external_access']."',
-node_system_access='".$node['node_system_access']."',
+node_external_access='".$params['node_external_access']."',
+node_system_access='".$params['node_system_access']."',
 node_creator='".$params['node_creator']."',
 template_id='".$template_id."',
 external_link='".$external_link."',
@@ -148,7 +151,7 @@ function processContent($node_content) {
                 }
 
                 $node_content = eregi_Replace("((( )|(\n)|(^))+)(http://|ftp://|https://)([[:alnum:]][^,[:space:]]*)","\\2<a target='_blank' href=\"\\6\\7\">\\6\\7</a>",$node_content);
-               $node_content = mysql_real_escape_string($node_content);
+               //$node_content = mysql_real_escape_string($node_content); once is enough
         }
 
         return $node_content;
@@ -194,7 +197,7 @@ where $table_name.node_id='$node_handle'";
                         return false;
                 }
                 else {
-                        $node=$result->getRecord();
+                        $node=addBase36id($result->getRecord());
                         $node['node_vector']=trim($node['node_vector'],"z");
                         $ancestors=str_split($node['node_vector'],VECTOR_CHARS);
                         foreach ($ancestors as $ancestor) {
@@ -233,7 +236,7 @@ where $table_name.node_id='$node_handle'";
                 $result=$db->query($q);
 
                 while ($result->next()){
-                        $record[]=$result->getRecord();
+                        $record[]=addBase36id($result->getRecord());
                 }
                 return $record;
 
@@ -252,7 +255,7 @@ node_parent='$node_handle' order by node_created $orderby LIMIT $offset,$limit";
                 $result=$db->query($q);
 
                 while ($result->next()) {
-                        $array[]=$result->getRecord();
+                        $array[]=addBase36id($result->getRecord());
                 }
 
                 return $array;
@@ -269,7 +272,7 @@ node_parent='$node_handle' order by node_created $orderby LIMIT $offset,$limit";
                 $result=$db->query($q);
 
                 while ($result->next()) {
-                        $children_array[]=$result->getRecord();
+                        $children_array[]=addBase36id($result->getRecord());
                 }
 
                 return $children_array;
@@ -290,6 +293,26 @@ node_parent='$node_handle' order by node_created $orderby LIMIT $offset,$limit";
                 return $access_data;
 
         }
+
+
+// Simple internal function to set node parrent
+
+function setParent($params) {
+        global $db,$node,$error,$error_messages;
+        $parent_id=$params['node_parent'];
+        $node_id=$params['node_id'];
+
+        if (!is_numeric($parent_id)) {
+                return false;
+        }
+       $q="select node_vector from nodes where node_id='$parent_id'";
+       $parent_vector=$db->query($q);
+
+       $new_vector=$parent_vector.str_pad($node_id,VECTOR_CHARS,"0",STR_PAD_LEFT);     
+       $q="update nodes set node_parent='$parent_id',node_vector='".$new_vector."
+               ' where node_id='$node_id'";
+       $db->query($q);
+}
 }
 
 ?>