Kyberia v2.3 - 1st revision from SVN (Without patches of kyberia.sk team)
[mirrors/Kyberia-bloodline.git] / cron / rssparse.php
CommitLineData
b42b2bf9
H
1#!/usr/local/bin/php
2<?php
3require('../config/config.inc');
4//connecting to database and creating universal $db object
5require(SYSTEM_ROOT.'/inc/log.inc');
6require(SYSTEM_ROOT.'/inc/database.inc');
7require(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
13include '../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
22while ($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
45node_name='".addslashes($item['title'])."',
46node_parent='".$set->getString('node_parent')."',
47node_thread_vector='".$set->getString('node_thread_vector').";".$set->getString('node_parent')."',
48node_system_access='".$set->getString('node_system_access')."',
49node_external_access='".$set->getString('node_external_access')."',external_link='".addslashes($item['link'])."',
50node_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?>
This page took 0.380837 seconds and 4 git commands to generate.