Subversion Repositories eFlore/Applications.cel

Rev

Rev 769 | Rev 816 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 769 Rev 780
Line 77... Line 77...
77 
 
 77 
 
Line 78... Line 78...
78 
     	$valeur = $pairs['mots_cles'];
 78 
     	$valeur = $pairs['mots_cles'];
Line 79... Line 79...
79
79
80 
		$valeur = $this->nettoyerMotsCles($valeur);
 80 
		$valeur = $this->nettoyerMotsCles($valeur);
81 
 
 81 
 
Line -... Line 82...
- 
 
 82 
     	$requete_maj_liaison_mots_cles = "UPDATE cel_inventory SET ".
82 
     	$requete_maj_liaison_mots_cles = "UPDATE cel_inventory SET " ;
 83 
								"mots_cles = REPLACE(CONCAT(IFNULL(mots_cles,''),'".$valeur.";'),'null','') ".
Line 83... Line 84...
83 
		$requete_maj_liaison_mots_cles .= "mots_cles = CONCAT(IFNULL(mots_cles,''),'".$valeur.";') ";
 84 
								"WHERE ordre IN (".$uid[1].") AND identifiant = ".$this->proteger($uid[0]);
Line 84... Line 85...
84 
		$requete_maj_liaison_mots_cles .= "WHERE ordre IN (".$uid[1].") AND identifiant = ".$this->proteger($uid[0]);
 85 
 
Line 122... Line 123...
122 
 
 123 
 
Line 123... Line 124...
123 
     	$requete_suppression_mots_cles = "UPDATE cel_inventory SET " ;
 124 
     	$requete_suppression_mots_cles = "UPDATE cel_inventory SET " ;
124 
 
 125 
 
125 
		$requete_suppression_mots_cles .= "mots_cles = REPLACE(REPLACE(mots_cles,'".$chaine."',''),';;',';') ";
 - 
 
126 
		$requete_suppression_mots_cles .= "WHERE ordre IN (".$uid[1].") AND identifiant = '".$DB->escapeSimple($uid[0])."'";
 126 
		$requete_suppression_mots_cles .= "mots_cles = REPLACE(REPLACE(mots_cles,'".$chaine."',''),';;',';') ";
Line 127... Line 127...
127 
 
 127 
		$requete_suppression_mots_cles .= "WHERE ordre IN (".$uid[1].") AND identifiant = '".$DB->escapeSimple($uid[0])."'";
128 
		$resultat_suppression_mots_cles = $this->executerRequeteSimple($requete_suppression_mots_cles);
 128 
		$resultat_suppression_mots_cles = $this->executerRequeteSimple($requete_suppression_mots_cles);
129 
 
 129 
 
Line 208... Line 208...
208 
	}
 208 
	}
Line 209... Line 209...
209
209
Line 210... Line 210...
210 
	private function nettoyerMotsCles($chaine) {
 210 
	private function nettoyerMotsCles($chaine) {
211
- 
 
212 
		$valeur = str_replace('null','',$chaine);
 211
Line 213... Line 212...
213 
     	$valeur = trim($valeur, "null");
 212 
		$valeur = str_replace('null','',$chaine);
214 
       	$valeur = trim($valeur, ";;");
 213 
       	$valeur = trim($valeur, ";;");