WebSVN – eFlore/Applications.del – Path Comparison – / – /trunk/services Rev 1158 and /trunk/services Rev 1159

Ignore whitespace Rev 1158 → Rev 1159

/trunk/services/modules/0.1/motscles/ListeMotsCles.php
107,6 → 107,7
* */
private function chargerClauseWhere() {
$where = array();
$where[] = ' actif = 1 ';
$tableauMasque = $this->masque->getMasque();
if (!empty($tableauMasque)) {
foreach($tableauMasque as $idMasque => $valeurMasque) {
138,7 → 139,6
$requeteLiaisons = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS * '.
'FROM '.$this->gestionBdd->formaterTable('del_image_tag', 'dit');
$requeteLiaisons .= $this->chargerClauseWhere();
$requeteLiaisons .= $this->gestionBdd->getLimitSql();
return $this->bdd->recupererTous($requeteLiaisons);
}

 /trunk/services/modules/0.1/motscles/AjouterMotCle.php
 ,6 → 109,8
                                                         $this->bdd->proteger($mot_cle['auteur.id']).', '.
                                                         $this->bdd->proteger(trim($mot_cle_a_inserer)).', '.
                                                         $this->bdd->proteger($mot_cle_normalise).', '.
+                                                        'NOW(), '.
+                                                        '1, '.
                                                         'NOW() '.
                                         '), ';
                 }
 ,7 → 117,7
                 $valeurs_a_inserer = rtrim($valeurs_a_inserer,', ');
                 $requete = 'INSERT INTO del_image_tag '.
-                                        '(ce_image, ce_utilisateur, tag, tag_normalise, date) '.
+                                        '(ce_image, ce_utilisateur, tag, tag_normalise, date, actif, date_modification) '.
                                         'VALUES '.$valeurs_a_inserer;
                 $retour = $this->bdd->requeter($requete);