function _createArticleSitemap() { global $osC_Database; $num_of_entries = 0; $num_of_article_file = 0; $Qarticles = $osC_Database->query('select articles_id , if( articles_last_modified is null || articles_last_modified in (\'0000-00-00 00:00:00\'), articles_date_added, articles_last_modified ) as last_modified from :table_articles order by articles_order asc, articles_id asc'); $Qarticles->bindTable(':table_articles', TABLE_ARTICLES); $Qarticles->execute(); $handle = $this->_createSitemapFile('Articles'); $this->_writeFile($handle, $this->_createXmlHeader()); while ($Qarticles->next()) { $location = $this->_base_url . $this->_hrefLink(FILENAME_INFO, 'articles&articles_id=' . $Qarticles->valueInt('articles_id')); $last_mod = date("Y-m-d", osC_DateTime::getTimestamp($Qarticles->value('last_modified'))); $change_freq = $article_change_frequency; $this->_writeSitemapFile($handle, $this->_createUrlElement($location, $last_mod, $this->_articles_change_freq, $this->_articles_priority), $num_of_entries, $num_of_article_file, 'Article'); } $Qarticles->freeResult(); $this->_closeSitemapFile($handle); return true; }