'.LF; echo ''.LF; echo ' '.LF.LF; //reads complete structure as array $struct = get_struct_data(); // fallback value when no article available $base = true; // now retrieve all articles $sql = "SELECT article_id, article_cid, DATE_FORMAT(article_tstamp, '%Y-%m-%d') AS article_tstamp, "; $sql .= "article_title, article_redirect, article_aliasid, article_alias "; $sql .= "FROM ".DB_PREPEND."phpwcms_article WHERE "; $sql .= "article_public=1 AND article_aktiv=1 AND article_deleted=0 AND article_nosearch!='1' AND "; $sql .= "article_nositemap=1 AND article_begin < NOW() AND article_end > NOW() "; $sql .= "ORDER BY article_tstamp DESC"; if($result = mysql_query($sql, $db)) { while($data = mysql_fetch_assoc($result)) { // first proof if this article is within an "public" structure section $_CAT = $struct[$data['article_cid']]; if($_CAT['acat_regonly'] || $_CAT['acat_nosearch']=='1' || !$_CAT['acat_nositemap']) { // no it is no public article - so jump to next entry continue; } // now add article URL to Google sitemap if(empty($phpwcms['rewrite_url']) || empty($data['article_alias'])) { $_link = PHPWCMS_URL.'index.php?'.setGetArticleAid( $data ); } else { $_link = PHPWCMS_URL.rawurlencode($data['article_alias']).'.phtml'; } echo ' '.LF; echo ' '.$_link.''.LF; echo ' '.$data["article_tstamp"].''.LF; echo ' '.LF; // yes we have a minimum of 1 article link $base = false; } } echo LF.' '.LF; if(is_array($_addURL) && count($_addURL)) { foreach($_addURL as $value) { $_link = empty($value['url']) ? '' : trim($value['url']); if(empty($_link)) { continue; } $_lastmod = empty($value['date']) ? '' : trim($value['date']); if(empty($value['date'])) { $_lastmod = date('Y-m-d'); } echo ' '.LF; echo ' '.$_link.''.LF; echo ' '.$_lastmod.''.LF; echo ' '.LF; } } else { echo ' '.LF.LF; } if($base) { // just return the main URL echo ' '.LF; echo ' '.PHPWCMS_URL.''.LF; echo ' '.date('Y-m-d').''.LF; echo ' '.LF; } echo ''; ?>