Subversion Repositories eFlore/Applications.cel

Rev

Rev 1199 | Go to most recent revision | 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 
}