bdNewsHost, $config_news->bdNewsUser, $config_news->bdNewsPswd); $connect = mysql_selectdb($config_news->bdNewsName); if (!$connect) { die; } else { $cmd = "SELECT * FROM news_rss WHERE apublier = 1 AND DATENEWS <= NOW() ORDER BY DATENEWS DESC LIMIT 0, 50"; $result = mysql_query($cmd); $rows = mysql_num_rows($result); // En-t�te header("Content-Type: application/rss+xml"); $xml ='<'.'?xml version="1.0" encoding="UTF-8"?'.'>'; $xml .=''; $xml .=''; $xml .=''; $xml .='http://www.summilux.net'; $xml .='Nouvelles du monde Leica'; $xml .='gautier@summilux.net (Gautier)'; $xml .='fr'; $xml .='PHP'; $xml .='summilux.net'; $xml .='gautier@summilux.net (Gautier)'; // Boucle sur les nouvelles while ($nouvelle = mysql_fetch_array($result)) { // Identifiant pour dŽtail $id = $nouvelle['id']; // Auteur $auteur = $nouvelle['auteur']; if ($auteur == "jeand@summilux.net") { $auteur = "jeand@summilux.net (Jean D.)"; } if ($auteur == "gautier@summilux.net") { $auteur = "gautier@summilux.net (Gautier)"; } // Titre //$titre = str_replace("Õ", "‚", $nouvelle['titre']); //$titre = utf8_encode($titre]); $titre = utf8_encode($nouvelle['titre']); // BBCode actif $bbcode = $nouvelle['bbcode']; // Contenu de la nouvelle if ($bbcode == 1) { $message = stripslashes(trim(bb2html($nouvelle['message'], ''), '')); } else { $message = stripslashes(trim($nouvelle['message'])); } $message = str_replace("
", '
', $message); $message = str_replace("&", '&', $message); $message = str_replace("<", '<', $message); $message = str_replace(">", '>', $message); $message = str_replace("Õ", "‚", $message); $message = str_replace("alt=\"IdŽe\"", "alt=\"Idee\"", $message); $message = str_replace("src=\"/forums/images/smiles/", "src=\"http://www.summilux.net/forums/images/smiles/", $message); $message = utf8_encode($message);; // Date au format RFC822 $date = $nouvelle['datenews']; // Heure GMT //$cmd_date = "SELECT DATE_FORMAT(datenews,'%a, %d %b %Y %T GMT') AS daterfc FROM news_rss WHERE id=$id"; $aujourdhui = getdate(); $mois = $aujourdhui['mon']; if (($mois >= 3) && ($mois <= 10)) { // Horaire d'ŽtŽ $cmd_date = "SELECT DATE_FORMAT(datenews,'%a, %d %b %Y %T +0200') AS daterfc FROM news_rss WHERE id=$id"; } else { // Horaire d'hiver $cmd_date = "SELECT DATE_FORMAT(datenews,'%a, %d %b %Y %T +0100') AS daterfc FROM news_rss WHERE id=$id"; } if ($res_date = mysql_query($cmd_date)) { if($ligne = mysql_fetch_row($res_date)) { $date = $ligne[0]; } } $xml .=''; $xml .=''.$auteur.''; $xml .=''; $xml .='http://www.summilux.net/news/news.php?id='.$id.''; $xml .=''.$date.''; $xml .='http://www.summilux.net/news/news.php?id='.$id.''; $xml .='http://www.summilux.net/news/news.php?id='.$id.''; $xml .=''; $xml .=$message; $xml .=''; } mysql_close(); $xml .=''; echo $xml; } ?>