| /trunk/services/modules/0.1/syndication/squelettes/rss1.tpl.xml |
|---|
| 14,7 → 14,7 |
| <channel rdf:about="<?=$guid?>"> |
| <title><?=$titre?></title> |
| <link><?=$lien_del?></link> |
| <link><?=$lien_service?></link> |
| <description><?=$description?></description> |
| <dc:publisher><?=$editeur?></dc:publisher> |
| <dc:date><?=$date_maj_W3C?></dc:date> |
| /trunk/services/modules/0.1/syndication/squelettes/rss2.tpl.xml |
|---|
| 2,7 → 2,7 |
| <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"> |
| <channel> |
| <title><?=$titre?></title> |
| <link><?=$lien_del?></link> |
| <link><?=$lien_service?></link> |
| <atom:link href="<?=$lien_service?>" rel="self" type="application/rss+xml" /> |
| <description><?=$description?></description> |
| /trunk/services/modules/0.1/syndication/squelettes/atom.tpl.xml |
|---|
| 2,7 → 2,7 |
| <feed xmlns="http://www.w3.org/2005/Atom"> |
| <title><?=$titre?></title> |
| <link href="<?=$lien_del?>" rel="alternate" type="text/html" hreflang="fr" /> |
| <link href="<?=$lien_service?>" rel="alternate" type="text/html" hreflang="fr" /> |
| <link href="<?=$lien_service?>" rel="self" type="application/atom+xml"/> |
| <updated><?=$date_maj_ATOM?></updated> |
| <author> |
| /trunk/services/modules/0.1/syndication/SyndicationTagsParProtocole.php |
|---|
| 107,7 → 107,7 |
| * */ |
| private function getDerniersVotesImage() { |
| $requete = 'SELECT id_tag, tag, date, nom, prenom, nom_sel, id_image '. |
| $requete = 'SELECT DISTINCT id_tag, tag, date, nom, prenom, nom_sel, id_image '. |
| 'FROM del_image_tag '. |
| 'LEFT JOIN del_utilisateur ON ce_utilisateur = id_utilisateur '. |
| 'INNER JOIN del_obs_image doi ON ce_image = id_image '. |
| /trunk/services/modules/0.1/syndication/SyndicationVotesParProtocole.php |
|---|
| 107,12 → 107,12 |
| * */ |
| private function getDerniersVotesImage() { |
| $requete = 'SELECT id_vote, prenom, nom, nom_sel, intitule, ce_image, valeur, do.id_observation as del_obs, divo.date as date_vote '. |
| $requete = 'SELECT DISTINCT id_vote, prenom, nom, nom_sel, intitule, ce_image, valeur, dob.id_observation as del_obs, divo.date as date_vote '. |
| ' FROM `del_image_vote` divo '. |
| ' INNER JOIN del_obs_image doi ON divo.ce_image = doi.id_image '. |
| ' INNER JOIN del_observation dob ON dob.id_observation = doi.id_observation '. |
| ' INNER JOIN del_image_protocole ON ce_protocole = id_protocole '. |
| ' INNER JOIN del_obs_image doi ON ce_image = id_image '. |
| ' INNER JOIN del_observation do ON do.id_observation = doi.id_observation '. |
| ' INNER JOIN del_utilisateur ON do.ce_utilisateur = id_utilisateur '. |
| ' INNER JOIN del_utilisateur ON dob.ce_utilisateur = id_utilisateur '. |
| $this->chargerClauseWhere()." ". |
| ' ORDER BY divo.date DESC '. |
| ' LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite(); |