51,10 → 51,10 |
{ |
$requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_observation, date_liaison) '. |
'VALUES '. |
'('.$this->proteger($image).','.$this->proteger($observation).', NOW()) '. |
'('.Cel::db()->proteger($image).','.Cel::db()->proteger($observation).', NOW()) '. |
'ON DUPLICATE KEY UPDATE id_image = id_image' ; |
|
$resultat_creation_lien = $this->executer($requete_creation_lien); |
$resultat_creation_lien = Cel::db()->executer($requete_creation_lien); |
|
if ($resultat_creation_lien) { |
$retour = "OK"; |
96,18 → 96,18 |
'WHERE id_image IN ( '. |
'SELECT id_image '. |
'FROM cel_obs_images '. |
'WHERE id_observation = '.$this->proteger($value).' '. |
'WHERE id_observation = '.Cel::db()->proteger($value).' '. |
')'; |
} |
else |
{ |
$column = 'id_observation' ; |
$requete_selection_liaison = 'SELECT * from cel_obs WHERE id_observation IN (SELECT '.$column.' FROM cel_obs_images WHERE '.$field.' = '.$this->proteger($value).') ' ; |
$requete_selection_liaison = 'SELECT * from cel_obs WHERE id_observation IN (SELECT '.$column.' FROM cel_obs_images WHERE '.$field.' = '.Cel::db()->proteger($value).') ' ; |
} |
|
} |
|
$resultat_selection_liaison = $this->requeter($requete_selection_liaison); |
$resultat_selection_liaison = Cel::db()->requeter($requete_selection_liaison); |
|
$liaisons = array(); |
if (is_array($resultat_selection_liaison) && count($resultat_selection_liaison) > 0) { |
141,7 → 141,7 |
$this->controleUtilisateur($uid[0]); |
|
$id_img = $uid[1] ; |
$id_obs = $this->proteger($uid[2]) ; |
$id_obs = Cel::db()->proteger($uid[2]) ; |
|
$id = $uid[0] ; |
|
151,7 → 151,7 |
"AND id_observation IN (".$id_obs.") " ; |
} |
|
$resultat_suppression_lien = $this->executer($requete_suppression_lien); |
$resultat_suppression_lien = Cel::db()->executer($requete_suppression_lien); |
|
$retour = false; |
if ($resultat_suppression_lien) { |