RyXéo » GLPI

";

//Les images / photos prises de cette installation ...

$query = "SELECT glpi_docs.FK_entities, glpi_docs.recursive,

  glpi_docs.name AS name,

  glpi_docs.filename AS filename,

  LEFT JOIN glpi_dropdown_rubdocs ON (glpi_docs.rubrique = glpi_dropdown_rubdocs.ID)

WHERE

  glpi_docs.mime LIKE '%image%' AND

  glpi_docs.deleted='0' AND ( glpi_docs.FK_entities IN (" . $_SESSION['glpiactive_entity'] . ") OR ( glpi_docs.recursive='1' AND glpi_docs.FK_entities IN (" . $_SESSION['glpiactive_entity'] . ")) ) ORDER BY glpi_docs.name";

$result = $DB->query($query) or die($DB->error());