cron/rssparse.php

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