exit; } $debug = 0; $tmp = tempnam(sys_get_temp_dir(), 'rsstool2sql_'); // DEBUG // echo $tmp."\n"; $p = $rsstool_path . ' ' . $rsstool_opts . ' --xml "' . $argv[1] . '" -o "' . $tmp . '"'; // DEBUG echo $p . "\n"; echo misc_exec($p, $debug); $xml = simplexml_load_file($tmp); unlink($tmp); // DEBUG // print_r ($xml); // exit; // output $p = rsstool_write_ansisql($xml, NULL); $f = 'rsstool2sql.sql'; //$p = rsstool_write_csv ($xml); //$f = 'rsstool2csv.txt'; $fh = fopen($f, 'w'); if ($fh) { fwrite($fh, $p); fclose($fh); echo $f . ' written' . "\n"; } else { echo 'ERROR: could not write ' . $f . "\n"; } exit; ?> ?>
function rsscache_write_ansisql($a, $rsscache_category, $table_suffix = NULL, $db_conn = NULL) { return rsstool_write_ansisql($a, $rsscache_category, $table_suffix, $db_conn); }
function rsscache_download_feeds_by_category($c) { global $rsscache_sql_db; $c = trim($c); $category = config_xml_by_category($c); // DEBUG // echo '<pre><tt>'; // print_r ($category); //exit; if ($category == NULL) { return; } if (!rsscache_item_has_feed($category)) { return; } $table_suffix = isset($category['rsscache:table_suffix']) ? $category['rsscache:table_suffix'] : NULL; for ($j = 0; rsscache_item_has_feed($category, $j); $j++) { $exec = isset($category['rsscache:feed_' . $j . '_exec']) ? $category['rsscache:feed_' . $j . '_exec'] : ''; $link = isset($category['rsscache:feed_' . $j . '_link']) ? '"' . $category['rsscache:feed_' . $j . '_link'] . '"' : ''; $p = ''; $p .= 'category: ' . $c . "\n" . 'exec: ' . $exec . "\n" . 'link: ' . $link . "\n" . 'table_suffix: ' . ($table_suffix ? $table_suffix : '(none)') . "\n"; echo $p; // get feed $p = $exec . ' ' . $link; // DEBUG // echo $p; // exit; exec($p, $a); $p = implode("\n", $a); // DEBUG // echo $p; // exit; $rss = simplexml_load_string($p, 'SimpleXMLElement', LIBXML_NOCDATA); // DEBUG print_r($rss); exit; $a = rss2array($rss); // DEBUG print_r($a); exit; // download thumbnails // $a = rsscache_download_thumbnails ($a); $sql_queries_s = rsstool_write_ansisql($a, $c, $table_suffix, $rsscache_sql_db->conn); rsscache_sql_queries($sql_queries_s); } }