Subversion Repositories eFlore/Applications.cel

Rev

Rev 2099 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2099 Rev 2112
Line 43... Line 43...
43 
		return $arbre;
 43 
		return $arbre;
44 
	}
 44 
	}
Line 45... Line 45...
45 
 
 45 
 
46 
	public function obtenirIdsMotsClesParIdParent($id_utilisateur, $id_mot_cle) {
 46 
	public function obtenirIdsMotsClesParIdParent($id_utilisateur, $id_mot_cle) {
- 
 
 47 
		$idMotCleP = Cel::db()->proteger($id_mot_cle);
Line 47... Line 48...
47 
		$idMotCleP = Cel::db()->proteger($id_mot_cle);
 48 
		$idUtilisateurP = Cel::db()->proteger($id_utilisateur);
48 
 
 49 
 
49 
		$sousRequete = "SELECT chemin FROM {$this->table_mots_cles} WHERE id_mot_cle = $idMotCleP ";
 50 
		$sousRequete = "SELECT chemin FROM {$this->table_mots_cles} WHERE id_mot_cle = $idMotCleP ";
50 
		$requete = 'SELECT id_mot_cle '.
 51 
		$requete = 'SELECT id_mot_cle '.
- 
 
 52 
			"FROM {$this->table_mots_cles} ".
51 
			"FROM {$this->table_mots_cles} ".
 53 
			"WHERE chemin LIKE CONCAT(($sousRequete), '%') ".
Line 52... Line 54...
52 
			"WHERE chemin LIKE CONCAT(($sousRequete), '%') ".
 54 
			"AND id_utilisateur = ".$idUtilisateurP." ".
Line 53... Line 55...
53 
			' -- '.__FILE__.':'.__LINE__;
 55 
			' -- '.__FILE__.':'.__LINE__;