scripts/category_restoration.php

   1 <?
   2
   3         require('config/config.inc');
   4         require(SYSTEM_ROOT.'inc/database.inc');
   5
   6         $db=new CLASS_DATABASE();
   7
   8         $query = "select node_id, node_name, node_vector from nodes where node_parent = '63530' or node_vector like '%63530%'";
   9         $set = $db->query($query);
  10
  11         $count = $set->getNumRows();
  12
  13         while($set->next())
  14         {
  15                 echo $set->getString('node_id')." :: ".$set->getString('node_name')." :: ".$set->getString('node_vector')." :: ";
  16                 $count = strlen($set->getString('node_vector'));
  17                 $node_vector = $set->getString('node_vector');
  18                 for($i = 1; $i <= $count; $i++)
  19                 {
  20                         $node_vector = "0".$node_vector;
  21                 }
  22                 if(strstr($set->getString('node_vector'), "00000101"))
  23                 {
  24                         echo $set->getString('node_vector');
  25                 }
  26                 else
  27                 {
  28                         echo $node_vector;
  29                 }
  30                 echo "<br>";
  31         }
  32
  33         //echo "<b>Fixing ownership problems for $count users...</b><br><br>";
  34
  35         //while($set->next())
  36         //{
  37         //      $victims[] =  $set->getString('node_id');
  38         //}
  39
  40         //foreach($victims as $target)
  41         //{
  42         //      $query = "update nodes set node_creator = '$target' where node_id = '$target'";
  43         //      $db->query($query);
  44         //      echo "User_id $target ownership problem fixed.<br>";
  45         //}
  46
  47         //echo "<br><br><b>Fix script finished!<br>U need to believe that nothing has fucked up ;o)!</b>";
  48
  49 ?>