'."\n";
$xml .="\t".''.$xml_data['titre'].''."\n";
$xml .="\t".''.$url_doc.''."\n";
$xml .="\t".''.$url_doc.''."\n";
if ($_GET['desc'] == 1){
$xml .="\t".''.xmlentities(strip_tags(truncate($xml_data['description'], 0, $_GET['nb_car'], $url_doc))).''."\n";}
if ($xml_data['pphoto'] !="" && $xml_data['pphoto'] != "0" && $_GET['photos'] == 1){
$xml .="\t".''.$url_img.''."\n";}
$xml .="\t".''.date('r', $xml_data['date_insertion']).''."\n";
$xml .=''."\n";
}
break;
case "articles":
$sql_xml = "SELECT * FROM articles";
/// Si la catÈgorie est précisée, on cherche uniquement les articles de cette catégorie
if (isset($_GET['cat'])){ $sql_xml.= " WHERE categorie='".$_GET['cat']."'";}
if (!isset($_GET['cat'])){ $sql_xml.= " WHERE afficher = 1";}
else { $sql_xml.= " AND afficher = 1";}
$sql_xml.= " ORDER BY date_redaction DESC";
$sql_xml .= " LIMIT 0,".$_GET['nb_items'];
$res_xml = mysql_query ($sql_xml, $db);
$title_flux = "Les Articles du Cap-Sizun";
$link_flux = "http://articles.cap-sizun.com";
$desc_flux = "Flux RSS des articles de Cap-Sizun.com";
$xml = "";
while ($xml_data = mysql_fetch_array($res_xml))
{
$url_doc = 'http://articles.cap-sizun.com/'.$xml_data['id_article'].'-'.mef_url($xml_data['titre']).'.html';
$xml .='- '."\n";
$xml .="\t".''.xmlentities($xml_data['titre']).''."\n";
$xml .="\t".''.$url_doc.''."\n";
$xml .="\t".''.$url_doc.''."\n";
if ($_GET['desc'] == 1) {
$xml .="\t".''.xmlentities(strip_tags(truncate($xml_data['texte'], 0, $_GET['nb_car'], $url_doc))).''."\n";}
$xml .="\t".''.date('r', $xml_data['date_redaction']).''."\n";
$xml .='
'."\n";
}
break;
case "agenda":
if ($_GET['selection'] == "bientot"){
$sql_xml = "SELECT titre, date, description, id_agenda, date_modif, photo FROM agenda";
$sql_xml .= " WHERE (DATEDIFF(date, NOW()) <= 7) AND (date >= NOW()) AND afficher = '1'";
if ($_GET['majeur'] == 1){$sql_xml .= " AND majeur = 1";}
$sql_xml .= " ORDER BY date DESC";
$sql_xml .= " LIMIT 0,".$_GET['nb_items'];
$res_xml = mysql_query ($sql_xml, $db);
$title_flux = 'Bientôt dans le Cap-Sizun';
$link_flux = 'http://agenda.cap-sizun.com';
$desc_flux = 'Evenements et manifestations se déroulant dans le Cap-Sizun';
$xml = "";
while ($xml_data = mysql_fetch_array($res_xml))
{
$url_doc = 'http://agenda.cap-sizun.com/'.$xml_data['id_agenda'].'-'.mef_url($xml_data['titre']).'.html';
$date_pub = date('r',mktime(0,0,0,mois_date_sql($xml_data['date']),jour_date_sql($xml_data['date']),annee_date_sql($xml_data['date'])) - 60*60*24*7);
$xml .='- '."\n";
$xml .="\t".''.jour_date_sql($xml_data['date']).'-'.mois_date_sql($xml_data['date']).'-'.annee_date_sql($xml_data['date']).' - '.$xml_data['titre'].''."\n";
if ($_GET['desc'] == 1){
$xml .="\t".''.strip_tags(truncate($xml_data['description'], 0, $_GET['nb_car'], $url_doc)).''."\n";}
$xml .="\t".''.$url_doc.''."\n";
$xml .="\t".''.$url_doc.''."\n";
if ($xml_data['photo'] != ""){
$xml .="\t".'http://agenda.cap-sizun.com/images/'.$xml_data['photo'].'-ssq.jpg'."\n";
} $xml .="\t".''.$date_pub.''."\n";
$xml .='
'."\n";
}
}
elseif ($_GET['semaine'] != "" || $_GET['weekend'] != "" ){
if ($_GET['semaine'] != ""){$title_flux = 'Le programme de la Semaine - Agenda du Cap-Sizun';}
if ($_GET['weekend'] != ""){$title_flux = 'Le programme du Weekend - Agenda du Cap-Sizun';}
$link_flux = 'http://agenda.cap-sizun.com';
$desc_flux = 'Evenements et manifestations se déroulant dans le Cap-Sizun';
$xml = "";
$numero_actuel = date('W');
if (date('N') == 7)
{
# $url_doc = 'http://agenda.cap-sizun.com/semaine-'.$numero.'-'.html';
# $date_pub = date('r',mktime(0,0,0,mois_date_sql($xml_data['date']),jour_date_sql($xml_data['date']),annee_date_sql($xml_data['date'])) - 60*60*24*7);
$xml .='- '."\n";
$xml .="\t".''.jour_date_sql($xml_data['date']).'-'.mois_date_sql($xml_data['date']).'-'.annee_date_sql($xml_data['date']).' - '.$xml_data['titre'].''."\n";
if ($_GET['desc'] == 1){
$xml .="\t".''.strip_tags(truncate($xml_data['description'], 0, $_GET['nb_car'], $url_doc)).''."\n";}
$xml .="\t".''.$url_doc.''."\n";
$xml .="\t".''.$url_doc.''."\n";
if ($xml_data['photo'] != ""){
$xml .="\t".'http://agenda.cap-sizun.com/images/'.$xml_data['photo'].'-ssq.jpg'."\n";
} $xml .="\t".''.$date_pub.''."\n";
$xml .='
'."\n";
}
}
else {
$sql_xml = "SELECT titre, date, description, id_agenda, date_modif, photo FROM agenda";
$sql_xml .= " WHERE date > NOW() AND afficher = '1' ORDER BY date";
$sql_xml .= " LIMIT 0,".$_GET['nb_items'];
$res_xml = mysql_query ($sql_xml, $db);
$title_flux = 'Les prochains Evènements dans le Cap-Sizun';
$link_flux = 'http://agenda.cap-sizun.com';
$desc_flux = 'Evenements et manifestations se déroulant dans le Cap-Sizun';
$xml = "";
while ($xml_data = mysql_fetch_array($res_xml))
{
$url_doc = 'http://agenda.cap-sizun.com/'.$xml_data['id_agenda'].'-'.mef_url($xml_data['titre']).'.html';
$xml .='- '."\n";
$xml .="\t".''.jour_date_sql($xml_data['date']).'-'.mois_date_sql($xml_data['date']).'-'.annee_date_sql($xml_data['date']).' - '.$xml_data['titre'].''."\n";
if ($_GET['desc'] == 1){
$xml .="\t".''.strip_tags(truncate($xml_data['description'], 0, $_GET['nb_car'], $url_doc)).''."\n";}
$xml .="\t".''.$url_doc.''."\n";
$xml .="\t".''.$url_doc.''."\n";
if ($xml_data['photo'] != ""){
$xml .="\t".'http://agenda.cap-sizun.com/images/'.$xml_data['photo'].'-ssq.jpg'."\n";
}
$xml .="\t".''.date('r', $xml_data['date_modif']).''."\n";
$xml .='
'."\n";
}
}
break;
case "photos":
$query = "SELECT id_photo, nom, titre, description, date_insertion FROM photos WHERE afficher = 1";
$query .= " ORDER BY date_insertion DESC";
if (isset($_GET['nb_items'])){$query .= " LIMIT 0,".$_GET['nb_items'];}
else {$query .= " LIMIT 0,10";}
$result = mysql_query ($query, $db);
$nb_msg = mysql_num_rows($result);
$title_flux = 'Les photos du Cap-Sizun';
$link_flux .='http://photos.cap-sizun.com';
$desc_flux .='Dernières photos ajoutées sur le site Cap-Sizun.com';
$xml = "";
while ($msg_data = mysql_fetch_array($result))
{
list($a,$m,$j)=explode("-",$msg_data['date']);
$xml .='- '."\n";
$xml .="\t".''.stripslashes($msg_data['titre']).''."\n";
if (isset($_GET['nb_car'])){
if (strlen($msg_data['description']) > $_GET['nb_car']) {$msg_data['description'] = substr($msg_data['description'], 0, $_GET['nb_car']).' [...]';}}
if ($_GET['desc']== 1){
$xml .="\t".''.mef_rss($msg_data['description']).''."\n";}
$xml .="\t".'http://photos.cap-sizun.com/'.$msg_data['id_photo'].'-'.mef_url($msg_data['titre']).'.html'."\n";
$xml .="\t".'http://photos.cap-sizun.com/'.$msg_data['id_photo'].'-'.mef_url($msg_data['titre']).'.html'."\n";
if ($_GET['photos']){
$xml .="\t".'http://photos.cap-sizun.com/fichiers/'.$msg_data['nom'].'-ssq.jpg'."\n";}
$xml .="\t".''.date('d/m/Y', $msg_data['date_insertion']).''."\n";
$xml .='
'."\n";
}
break;
case "cartes-postales":
$sql_xml = "SELECT id_carte, nom, titre, description, date_insertion, date_modif FROM cartes_postales WHERE afficher = 1";
///if (isset($_GET['cat'])){$sql_xml .= " AND (cat1='".$_GET['cat']."' OR cat2='".$_GET['cat']."')";}
$sql_xml .= " ORDER BY date_insertion DESC";
$sql_xml .= " LIMIT 0,".$_GET['nb_items'];
$res_xml = mysql_query ($sql_xml, $db);
$title_flux ='Les cartes postales du Cap-Sizun';
$link_flux ='http://cartes-postales.cap-sizun.com/';
$desc_flux ='Dernières cartes postales ajoutées sur le site Cap-Sizun.com';
$xml = "";
while ($xml_data = mysql_fetch_array($res_xml))
{
$url_doc = 'http://cartes-postales.cap-sizun.com/'.$xml_data['id_carte'].'-'.mef_url($xml_data['titre']).'.html';
$xml .='- '."\n";
$xml .="\t".''.xmlentities($xml_data['titre']).''."\n";
if ($_GET['desc'] != 0){
$xml .="\t".''.xmlentities(strip_tags(truncate($xml_data['description'], 0, $_GET['nb_car'], $url_doc))).''."\n";}
$xml .="\t".''.$url_doc.''."\n";
$xml .="\t".'http://cartes-postales.cap-sizun.com/'.$xml_data['id_carte'].'-'.mef_url($xml_data['titre']).'.html'."\n";
if ($_GET['photos'] != ""){
$xml .="\t".'http://cartes-postales.cap-sizun.com/'.$xml_data['nom'].'-ssq.jpg'."\n";}
$xml .="\t".''.date('r', $xml_data['date_modif']).''."\n";
$xml .='
'."\n";
}
break;
case "discussions":
$title_flux = 'Les dernières discussions du Forum du Cap-Sizun';
$link_flux = 'http://forum.cap-sizun.com';
$desc_flux = 'Dernières discussions lancées sur le Forum du Cap-sizun.com';
$xml = "";
// Fetch 15 topics
$result = mysql_query('SELECT t.id, t.poster, t.subject, t.posted, t.last_post, f.id AS fid, f.forum_name FROM flu_topics AS t INNER JOIN flu_forums AS f ON f.id=t.forum_id LEFT JOIN flu_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.moved_to IS NULL ORDER BY t.id DESC LIMIT '.$_GET['nb_items'], $db);
while ($cur_topic = mysql_fetch_array($result))
{
if ($pun_config['o_censoring'] == '1'){$cur_topic['subject'] = censor_words($cur_topic['subject']);}
$xml.= "\t".'- '."\r\n";
$xml.= "\t\t".''.$cur_topic['subject'].''."\r\n";
$xml.= "\t\t".'http://forum.cap-sizun.com/sujet-'.$cur_topic['id'].'-'.pun_url($cur_topic['subject']).'.html'."\r\n";
$xml.= "\t\t".''."\r\n";
$xml.= "\t\t".'http://forum.cap-sizun.com/sujet-'.$cur_topic['id'].'-'.pun_url($cur_topic['subject']).'.html';
$xml.= "\t".'
'."\r\n";
}
break;
case "reponses":
$title_flux = 'Les dernières participations au Forum du Cap-Sizun';
$link_flux = 'http://forum.cap-sizun.com';
$desc_flux = 'Dernières réponses aux discussions lancées sur le Forum du Cap-Sizun';
$xml = "";
// Fetch 15 topics
$result = mysql_query('SELECT t.id, t.poster, t.subject, t.posted, t.last_post, f.id AS fid, f.forum_name FROM flu_topics AS t INNER JOIN flu_forums AS f ON f.id=t.forum_id LEFT JOIN flu_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.moved_to IS NULL ORDER BY t.last_post DESC LIMIT '.$_GET['nb_items'], $db) or error('Impossible de retrouver la liste des discussions', __FILE__, __LINE__, $db->error());
while ($cur_topic = mysql_fetch_array($result))
{
if ($pun_config['o_censoring'] == '1'){$cur_topic['subject'] = censor_words($cur_topic['subject']);}
$xml.= "\t".'- '."\r\n";
$xml.= "\t\t".''.$cur_topic['subject'].''."\r\n";
$xml.= "\t\t".'http://forum.cap-sizun.com/sujet-'.$cur_topic['id'].'-'.pun_url($cur_topic['subject']).'.html'."\r\n";
$xml.= "\t\t".''."\r\n";
$xml.= "\t\t".'http://forum.cap-sizun.com/sujet-'.$cur_topic['id'].'-'.pun_url($cur_topic['subject']).'.html';
$xml.= "\t".'
'."\r\n";
}
break;
}
header("Content-Type: text/xml; charset=UTF-8");
print ''."\n";
print ''."\n";
print ''."\n";
print ''.$title_flux.''."\n";
print ''.$link_flux.''."\n";
print ''.$desc_flux.''."\n";
print 'fr'."\n";
print $xml;
print ''."\n";
print ''."\n";
?>