Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1199 Rev 1200
Line 77... Line 77...
77
		echo "-------------------------------------------------------------------\n";
77
		echo "-------------------------------------------------------------------\n";
78
		echo "  ETAPE 4. Génération des index des mots clés ... \n";
78
		echo "  ETAPE 4. Génération des index des mots clés ... \n";
79
		echo "-------------------------------------------------------------------\n";
79
		echo "-------------------------------------------------------------------\n";
80
		$this->genererIndexTexteMotsClesObs();
80
		$this->genererIndexTexteMotsClesObs();
81
		$this->genererIndexTexteMotsClesImages();
81
		$this->genererIndexTexteMotsClesImages();
-
 
82
		$this->mettreANullMotsClesTxtVide();
82
		echo "\n"."\n"."\n";
83
		echo "\n"."\n"."\n";
83
	}
84
	}
Line 84... Line 85...
84
 
85
 
85
	private function viderTables() {
86
	private function viderTables() {
Line 400... Line 401...
400
			"WHERE $chp_id_obs_ou_img = $id_image_ou_obs ".
401
			"WHERE $chp_id_obs_ou_img = $id_image_ou_obs ".
401
			"	AND ce_utilisateur = $id_utilisateur ";
402
			"	AND ce_utilisateur = $id_utilisateur ";
Line 402... Line 403...
402
 
403
 
403
		return $this->executer($requete);
404
		return $this->executer($requete);
-
 
405
	}
-
 
406
 
-
 
407
	private function mettreANullMotsClesTxtVide() {
-
 
408
		$bdd = self::$bdd_cel_migration;
-
 
409
		$tables = array('cel_obs', 'cel_images');
-
 
410
 
-
 
411
		foreach ($tables as $table) {
-
 
412
			$requete = 	"UPDATE $bdd.$table ".
-
 
413
				'SET mots_cles_texte = NULL '.
-
 
414
				"WHERE mots_cles_texte = '' ";
-
 
415
			$this->executer($requete);
-
 
416
		}
404
	}
417
	}
405
}
418
}