Line 55... |
Line 55... |
55 |
*
|
55 |
*
|
56 |
* @param int $id_element_lie
|
56 |
* @param int $id_element_lie
|
57 |
* @return array tableau associatif des champs de la table etendu
|
57 |
* @return array tableau associatif des champs de la table etendu
|
58 |
*/
|
58 |
*/
|
59 |
public function consulter($id_element_lie, $langue = "fr") {
|
59 |
public function consulter($id_element_lie, $langue = "fr") {
|
60 |
$requete = "SELECT $this->liste_champs} ".
|
60 |
$requete = "SELECT {$this->liste_champs} ".
|
61 |
"FROM {$this->table_champs_etendus} ce ".
|
61 |
"FROM {$this->table_champs_etendus} ce ".
|
62 |
"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ".
|
62 |
"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ".
|
63 |
"WHERE cet.language_iso_code = '".$langue."' AND ";
|
63 |
"WHERE cet.language_iso_code = '".$langue."' AND ";
|
64 |
($id_element_lie != "") ? $requete .= " {$this->champ_id} = ".Cel::db()->proteger($id_element_lie) : "";
|
64 |
($id_element_lie != "") ? $requete .= " {$this->champ_id} = ".Cel::db()->proteger($id_element_lie) : "";
|
65 |
$requete .= ' -- '.__FILE__.':'.__LINE__;
|
65 |
$requete .= ' -- '.__FILE__.':'.__LINE__;
|