| 46,7 → 46,7 |
|---|
| unset($criteres['tri']); |
| $direction = (isset($criteres['dir']) && $criteres['dir']) ? $criteres['dir'] : 'ASC'; |
| unset($criteres['dir']); |
| |
| $imgUrlTplBase = explode('%', $this->config['settings']['celImgUrlTpl'])[0]; |
| $debut = ($debut < 0) ? 0 : $debut; |
| $requete_recherche_images = 'SELECT ci.`id_image` as id_photo, co.guid, |
| `id_observation` as id_obs, `nom_sel`, `nom_sel_nn`, `zone_geo` as localisation, `latitude`, `longitude`, |
| 59,7 → 59,7 |
|---|
| `ce_utilisateur` as id_utilisateur, `courriel_utilisateur` as mail_utilisateur, `pseudo_utilisateur` as nom_utilisateur, |
| ci.`nom_original`, ci.`date_prise_de_vue` as date_photo, "Creative Commons BY-SA (2.0)" as licence, |
| concat(`nom_sel`, " par ", `pseudo_utilisateur`, " [CC BY-SA 2.0 FR], via Tela Botanica") as attribution, |
| concat("https://api.tela-botanica.org/img:", lpad(ci.id_image, 9, "0"), "O,") as url_photo, ci.`mots_cles_texte` as tags_photo '; |
| concat("'.$imgUrlTplBase.'", lpad(ci.id_image, 9, "0"), "O") as url_photo, ci.`mots_cles_texte` as tags_photo '; |
| |
| $requete_recherche_images .= $this->fabriquerRequeteJointureDblObs(); |
| $requete_recherche_images .= ($id_utilisateur != null) ? 'AND co.ce_utilisateur = '.Cel::db()->proteger($id_utilisateur) : ''; |