Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 3509 → Rev 3510

/trunk/scripts/modules/nettoyage/Nettoyage.php
790,7 → 790,7
$requete = "ALTER TABLE ".$this->bd_cel.".`cel_obs` ADD IF NOT EXISTS `input_source` VARCHAR(15)";
$this->bdd->requeter($requete);
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'plantnet' WHERE `mots_cles_texte` like '%plantnet%'";
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'PlantNet' WHERE `mots_cles_texte` like '%plantnet%'";
$this->bdd->requeter($requete);
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'autre' WHERE `mots_cles_texte` like '%MobileSauvages%'";
802,7 → 802,7
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%widget%' and (input_source = '' OR input_source IS NULL)";
$this->bdd->requeter($requete);
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'cel' WHERE input_source = '' OR input_source IS NULL";
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'CEL' WHERE input_source = '' OR input_source IS NULL";
$this->bdd->requeter($requete);
echo "Suppression motcle du chemin \n";