scripts/poll2node.php

   1 <?php
   2 require('../config/config.inc');
   3
   4 //connecting to database and creating universal $db object
   5 require(SYSTEM_ROOT.'/inc/log.inc');
   6 require(SYSTEM_ROOT.'/inc/database.inc');
   7 require(SYSTEM_ROOT.'/inc/nodes.inc');
   8 $db=new CLASS_DATABASE();
   9 $db_old=new CLASS_DATABASE("kyberia","root","db.h-k.sk","127.0.0.1");
  10
  11 $q="select * from nodes where node_type='3'";
  12 $forumset=$db->query($q);
  13 while ($forumset->next()) {
  14         $forums[$forumset->getString('old_id')]=array("thread"=>$forumset->getString('node_thread_vector'),"id"=>$forumset->getString('node_id'),"owner"=>$forumset->getString('node_creator'));
  15 }
  16
  17 $q="select * from polls where forum_id>0 order by id_poll";
  18 $set=$db_old->query($q);
  19
  20 while ($set->next()) {
  21 if (is_array($forums[$set->getString('forum_id')])){
  22 $q="insert into nodes set
  23 node_name='".addslashes($set->getString('question'))."',old_id='".$set->getString('id_poll')."',node_parent='".
  24 $forums[$set->getString('forum_id')]['id']."'
  25 ,node_creator='".$forums[$set->getString('forum_id')]['owner']."'
  26 ,node_thread_vector='".$forums[$set->getString('forum_id')]['thread'].";".$forums[$set->getString('forum_id')]['id']."'
  27 , node_views='".$set->getString('responses')."',node_type='11'";
  28 $db->query($q);
  29
  30 $q="select * from poll_options where id_poll=".$set->getString('id_poll');
  31 $pollset=$db_old->query($q);
  32 unset($pollset_array);
  33 while ($pollset->next()) {
  34         $pollset_array[]=array("text"=>$pollset->getString('text'),"number"=>$pollset->getString('number'));
  35 }
  36 $options=AddSlashes(serialize($pollset_array));
  37 $db->query("insert into node_content set node_id=LAST_INSERT_ID(),node_content='$options'");
  38 echo "<br><br>";
  39 }
  40 }
  41 ?>