DBInitialise(); $sql_object -> DBConnexion(); /////////////////// function SQL_getRSSformatedNews() { $requete = "SELECT news_id, news_title, CONCAT(LEFT(CONCAT(news_header, ' ', news_body),247), '...') AS news_description, theme_name, ". "DATE_FORMAT(news_published_date, '%Y-%m-%d\\T%H:%i:%s+00:00') AS news_published_date_display, ". "DATE_FORMAT(news_date_crea, '%d-%m-%Y') AS news_date_crea_display, user_login ". "FROM " . T_NEWS . " ". "LEFT OUTER JOIN " . T_THEME. " ON news_theme=theme_id ". "LEFT OUTER JOIN " . T_USER. " ON news_posted_by=user_id ". " WHERE news_statut='P' ". "ORDER BY news_published_date DESC LIMIT 0 , 15;"; return $requete; } $data=$sql_object -> DBSelect(SQL_getRSSformatedNews()); $li_items=''; $content=''; if($data!=0) { for($i=0; $i$GLOBALS['links']['actualite']['linkvalue'], 'id'=>$news_id); $li_items.=''.END_LINE; $content.=''.END_LINE; $content.=''.END_LINE; $content.=''.LINEA_ROOT_URL.HrefMaker($link_news).''.END_LINE; $content.=''.$news_date.''.END_LINE; $content.=''.$news_theme.''.END_LINE; $content.=''.utf8_encode(SITE_CITY_NAME).''.END_LINE; $content.=''.$news_posted_by.''.END_LINE; $content.=''.END_LINE; $content.=$news_description; $content.=''.END_LINE; $content.=''.END_LINE; } } /** * HEADER RSS ****************************************************************/ header('Content-Type: text/xml'); echo ''.END_LINE; echo ''.END_LINE; echo ''.END_LINE; echo ''.END_LINE; echo ''.utf8_encode(LINEA_ROOT_URL).''.END_LINE; echo ''.utf8_encode('Actualités - '.SITE_CITY_NAME).''.END_LINE; echo ''.strtolower(LANGUAGE).''.END_LINE; echo ''.utf8_encode(SITE_CITY_NAME).''.END_LINE; echo ''.utf8_encode(SITE_LINEA_NAME.' (mailto:'.MAIL_LINEA.')').''.END_LINE; echo 'Copyrights '.date("Y").''.END_LINE; echo ''.date('Y-m-d\\TH:i:s+00:00').''.END_LINE; echo ''.END_LINE; echo ''.END_LINE; echo 'daily'.END_LINE; echo '2'.END_LINE; echo '2000-01-01'.END_LINE; echo ''.END_LINE; # LISTES ITEMS echo ''.END_LINE; echo ''.END_LINE; echo $li_items.END_LINE; echo ''.END_LINE; echo ''.END_LINE; echo ''.END_LINE; echo $content; /** * FOOTER RSS **********************************************************/ echo ''.END_LINE; ?>