1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
| $site ="Monuments Touraine";
$titre_flux = "Animations du site Monuments-Touraine.fr";
$adresse ="http://www.monuments-touraine.fr/";
$description = "Animations du site Monuments-Touraine.fr";
$langue = "fr";
$copyright = "Mond.net";
$managingeditor = "";
$date =date('F, d D Y H:i:s');
$categorie = "Recouvrement";
$flux = '<?xml version="1.0" encoding="iso-8859-1"?><rss version="2.0">';
$flux.='
<channel>
<title>'.$titre_flux.'</title>
<link>'.$adresse.'</link>
<description>'.$description.'</description>
<language>'.$langue.'</language>
<copyright>'.$copyright.'</copyright>
<managingEditor>'.$managingeditor.'</managingEditor>
<pubDate>'.$date.'</pubDate>
<category>'.$categorie.'</category>
<generator>Mond.net</generator>
<docs>http://blogs.law.harvard.edu/tech/rss</docs>
';
$req="SELECT * FROM ANIMATION,ARBO_SITES WHERE ANIMATION.RSS=1 AND ARBO_SITES.ID_NOEUD=ANIMATION.ID_NOEUD AND ARBO_SITES.ID_NOEUD_PERE=99 ORDER BY ANIMATION.DATE_DEBUT DESC,ANIMATION.DATE_FIN DESC";
$res=executeMySqlQuery($req);
$last = '';
while($row=mysql_fetch_array($res))
{
$last[]=$row;
}
if(is_array($last))
{
foreach($last as $elem)
{
$req="SELECT B.ID_ARTICLE FROM LNK_ARTICLE_NOEUD as A,ARTICLE as B WHERE A.ID_NOEUD='".$elem["ID_NOEUD"]."' AND A.ID_ARTICLE=B.ID_ARTICLE AND B.LIBELLE='PROGRAMMATION'";
$res=executeMySqlQuery($req);
$temp=mysql_fetch_array($res);
$annee=substr($elem['DATE_DEBUT'],0,4);
$mois=substr($elem['DATE_DEBUT'],5,2);
$jour=substr($elem['DATE_DEBUT'],-2);
$date = date('F, d D Y H:i:s', mktime(0,0,0,$mois,$jour,$annee));
$flux.='
<item>
<title>'.$elem['LIBELLE'].'</title>
<link>'.$adresse.'</link>
<description>'.clean($elem["INFO"]).'</description>
<guid>'.$adresse.'</guid>
<pubDate>'.$date.' GMT</pubDate>
<source url="'.$adresse.'rss.php">'.$site.'</source>
</item>';
}
}
$flux.=' </channel>
</rss>';
echo $flux; |
Partager