| 1 | #!/usr/local/bin/php |
| 2 | <?php |
| 3 | require('../config/config.inc'); |
| 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 | |
| 10 | $set=$db->query("select nodes.*,node_content.*,nodes.node_id as node_id from nodes left join node_content on nodes.node_id=node_content.node_id where node_type='28' and nodes.node_id>100"); |
| 11 | |
| 12 | // include lastRSS library |
| 13 | include '../inc/lastRSS.php'; |
| 14 | |
| 15 | // create lastRSS object |
| 16 | $rss = new lastRSS; |
| 17 | |
| 18 | // setup transparent cache |
| 19 | $rss->cache_dir = './cache'; |
| 20 | $rss->cache_time = 3600; // one hour |
| 21 | |
| 22 | while ($set->next()) { |
| 23 | // load some RSS file |
| 24 | if (!preg_match("/http:(.*)/",$set->getString('node_content'))) { |
| 25 | $rs = $rss->get("http://kyberia.sk/scripts/google2rss.php?num=25&q=".$set->getString('node_content')); |
| 26 | } |
| 27 | else { |
| 28 | /* |
| 29 | ob_start(); |
| 30 | readfile($set->getString('node_content')); |
| 31 | $data=ob_get_contents(); |
| 32 | ob_end_clean(); |
| 33 | */ |
| 34 | $rs=$rss->get($set->getString('node_content')); |
| 35 | |
| 36 | } |
| 37 | |
| 38 | |
| 39 | foreach ($rs['items'] as $item) { |
| 40 | $q="select node_id from nodes where node_name='".addslashes($item['title'])."'"; |
| 41 | $itemset=$db->query($q); |
| 42 | if (!$itemset->getNumRows()) { |
| 43 | /* |
| 44 | $q="insert into nodes set |
| 45 | node_name='".addslashes($item['title'])."', |
| 46 | node_parent='".$set->getString('node_parent')."', |
| 47 | node_thread_vector='".$set->getString('node_thread_vector').";".$set->getString('node_parent')."', |
| 48 | node_system_access='".$set->getString('node_system_access')."', |
| 49 | node_external_access='".$set->getString('node_external_access')."',external_link='".addslashes($item['link'])."', |
| 50 | node_type=13,node_creator='".$set->getString('node_id')."',node_created=NOW()"; |
| 51 | $db->query($q); |
| 52 | $id=$db->getLastInsertId(); |
| 53 | $text=$item['description']; |
| 54 | */ |
| 55 | //$text.="<br><br><iframe width='666' height='230' src='".$item['link']."'>"; |
| 56 | $text=AddSlashes($item['description']); |
| 57 | $params['node_content']=$text; |
| 58 | $params['node_name']=addslashes($item['title']); |
| 59 | $params['node_parent']=$set->getString('node_parent'); |
| 60 | $params['node_creator']=$set->getString('node_id'); |
| 61 | nodes:addNode($params); |
| 62 | |
| 63 | } |
| 64 | } |
| 65 | } |
| 66 | |
| 67 | |
| 68 | |
| 69 | |
| 70 | ?> |