Импорт RSS, XML в БД через MODx API
<?php
$RSSS = array();
$RSSS[] = 'http://www.site.ru/news/rss/';
$RSSS[] = 'http://www.site.ru/xml/';
foreach($RSSS AS $RSS) {
$rss = simplexml_load_file($RSS);
foreach($rss->channel->item as $item) {
echo $item->title;
$result = mysql_fetch_object($modx->db->query("SELECT count(*) as CNT FROM modx_rmod_news WHERE title = '".$item->title."'"));
if(!$result->CNT) {
$fields = array (
'title' => $item->title,
'news_body' => $item->description,
'news_date' => $item->pubDate,
'autor' => $item->author,
'full_link' => 1,
'publish' => 1,
'catid' => 1,
);
$modx->db->insert($fields, $modx->getFullTableName(rmod_news));
} else {
//$modx->db->query("UPDATE ".$modx->getFullTableName(rmod_news)." SET ".$fields." WHERE title = '".$item->title."'";
}
}
}
?>