scripts/undelete_node_tree.php

   1 <?
   2 //      ini_set("error_reporting", "E_ALL & ~E_NOTICE");
   3
   4         require('config/config.inc');
   5         require(SYSTEM_ROOT.'inc/database.inc');
   6
   7         $db=new CLASS_DATABASE();
   8
   9         $vector_size = VECTOR_CHARS;
  10
  11         $target = '1478222';
  12
  13         $query = "select node_thread_vector from tiamat where node_id = '$target'";
  14         $set = $db->query($query);
  15         $set->next();
  16         $parent_vector = $set->getString('node_thread_vector');
  17
  18         $query = "select * from nodes where node_parent = '$target'";
  19         $set = $db->query($query);
  20
  21         while($set->next())
  22         {
  23                 $level_one[$set->getString('node_id')] = $set->getString('node_name');
  24         }
  25
  26         print_r($level_one);
  27
  28         echo $parent_vector;
  29
  30         $test = str_split($parent_vector, $vector_size);
  31
  32         print_r($test);
  33
  34         echo "parent node_id :: $target <br /><br />";
  35
  36         $query = "insert into nodes
  37                         (node_id, node_name, node_parent, node_vector, node_type, node_external_access,
  38                         node_system_access, node_children_count, node_creator, node_created,
  39                         lastchild_created, k, node_views, node_descendant_count, lastdescendant_created, template_id)
  40                 select
  41                         tiamat.node_id, tiamat.node_name, tiamat.node_parent, tiamat.node_thread_vector, tiamat.node_type,
  42                         tiamat.node_external_access, tiamat.node_system_access, tiamat.node_children_count, tiamat.node_creator,
  43                         tiamat.node_created, tiamat.lastchild_created, tiamat.k, tiamat.node_views, tiamat.node_descendant_count,
  44                         tiamat.lastdescendant_created, tiamat.template_id from tiamat where tiamat.node_id = '$target' limit 1";
  45
  46 //      $db->query($query);
  47 //      echo $query."<br><br>";
  48
  49 //      echo "recovered!<br /><br />";
  50
  51         echo "starting update process at vector $parent_vector ...<br /><br />";
  52
  53         foreach($level_one as $target_id => $target_name)
  54         {
  55                 $q = "select * from nodes where node_vector like '%$target_id%'";
  56                 echo $q."<br>";
  57 /*              $raise = $db->query($q);
  58                 while($raise->next())
  59                 {
  60                         $q = "update nodes set node_vector = '".$parent_vector.$raise->getString('node_vector')."' where node_id = '".$raise->getString('node_id')."'";
  61                 //      $db->query($q);
  62                         echo $q."<br>";
  63                 }*/
  64         }
  65
  66         echo "update finished!";
  67
  68 ?>