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();
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");
12 // include lastRSS library
13 include '../inc/lastRSS.php';
15 // create lastRSS object
18 // setup transparent cache
19 $rss->cache_dir
= './cache';
20 $rss->cache_time
= 3600; // one hour
22 while ($set->next()) {
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'));
30 readfile($set->getString('node_content'));
31 $data=ob_get_contents();
34 $rs=$rss->get($set->getString('node_content'));
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()) {
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()";
52 $id=$db->getLastInsertId();
53 $text=$item['description'];
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);
This page took 0.55165 seconds and 4 git commands to generate.