/trunk/services/modules/0.1/motscles/AjouterMotCle.php |
---|
109,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() '. |
'), '; |
} |
115,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); |
/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); |
} |