Commit | Line | Data |
---|---|---|
b42b2bf9 H |
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 | ?> |