dbTableExist('TABLE_NEWS_ARTICLES')) {
echo '' . TEXT_HEAD_NEWS_ARTICLES . '
';
$last_date = $db->Execute("SELECT MAX(GREATEST(n.news_date_added, IFNULL(n.news_last_modified, 0), n.news_date_published)) AS last_date
FROM " . TABLE_NEWS_ARTICLES . " n
WHERE n.news_status = '1'
AND n.news_date_published <= NOW()");
$table_status = $db->Execute("SHOW TABLE STATUS LIKE '" . TABLE_NEWS_ARTICLES . "'");
$last_date = max($table_status->fields['Update_time'], $last_date->fields['last_date']);
if ($sitemapXML->SitemapOpen('newsarticles', $last_date)) {
$news = $db->Execute("SELECT n.article_id, GREATEST(n.news_date_added, IFNULL(n.news_last_modified, '0001-01-01 00:00:00'), n.news_date_published) AS last_date, nt.language_id AS language_id
FROM " . TABLE_NEWS_ARTICLES . " n
LEFT JOIN " . TABLE_NEWS_ARTICLES_TEXT . " nt ON (n.article_id = nt.article_id)
WHERE n.news_status = '1'
AND n.news_date_published <= NOW()
AND nt.news_article_text != ''" .
(SITEMAPXML_NEWS_ORDERBY != '' ? "ORDER BY " . SITEMAPXML_NEWS_ORDERBY : ''));
$sitemapXML->SitemapSetMaxItems($news->RecordCount());
while (!$news->EOF) {
$sitemapXML->writeItem(FILENAME_NEWS_ARTICLE, 'article_id=' . $news->fields['article_id'], $news->fields['language_id'], $news->fields['last_date'], SITEMAPXML_NEWS_CHANGEFREQ);
$news->MoveNext();
}
$sitemapXML->SitemapClose();
}
if (false) {
echo '' . TEXT_HEAD_NEWS . '
';
if ($sitemapXML->SitemapOpen('news', $last_date)) {
$news = $db->Execute("SELECT news_date_published
FROM " . TABLE_NEWS_ARTICLES . "
WHERE news_status = '1'
AND news_date_published <= NOW()
GROUP BY news_date_published DESC");
$sitemapXML->SitemapSetMaxItems($news->RecordCount());
$link_ym_array = array();
while (!$news->EOF) {
$date_ymd = substr($news->fields['news_date_published'], 0, 10);
$date_ym = substr($news->fields['news_date_published'], 0, 7);
if (!isset($link_ym_array[$date_ym])) {
$sitemapXML->writeItem(FILENAME_NEWS_INDEX, 'date=' . $date_ym, 0, $date_ym, SITEMAPXML_NEWS_CHANGEFREQ);
$link_ym_array[$date_ym] = true;
}
$sitemapXML->writeItem(FILENAME_NEWS_INDEX, 'date=' . $date_ymd, 0, $date_ymd, SITEMAPXML_NEWS_CHANGEFREQ);
$news->MoveNext();
}
$sitemapXML->SitemapClose();
}
}
}
unset($news);
// EOF