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);
}
}
