'.$BL['be_article_urlalias'].' ('.$BL['be_ftptakeover_active'].')'.LF; // now retrieve all articles $sql = "SELECT *, DATE_FORMAT(article_tstamp, '%Y-%m-%d') AS article_timestamp "; $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_alias"; $result = _dbQuery($sql); ?>
ID | ' . (empty($data["article_alias"]) ? '-' : html_specialchars($data["article_alias"]) ) . " | " . LF; echo ''.$data["article_id"]." | " . LF; echo ''.$data["article_timestamp"]." | " . LF; echo ''; echo ''; echo ' | ' . LF . ' ' . LF; $x++; } ?>
---|