| 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 | ?> |