Line 59... |
Line 59... |
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} = $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__;
|
66 |
$resultat = Cel::db()->requeter($requete);
|
66 |
$resultat = Cel::db()->requeter($requete);
|
67 |
return $resultat;
|
67 |
return $resultat;
|
68 |
}
|
68 |
}
|