| 48,9 → 48,9 |
|---|
| { |
| foreach($ids_observations_liste as $observation) |
| { |
| $requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_utilisateur, id_observation, date_liaison) '. |
| $requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_observation, date_liaison) '. |
| 'VALUES '. |
| '('.$this->proteger($image).','.$this->proteger($utilisateur).','.$this->proteger($observation).', NOW()) '. |
| '('.$this->proteger($image).','.$this->proteger($observation).', NOW()) '. |
| 'ON DUPLICATE KEY UPDATE id_image = id_image' ; |
| |
| $resultat_creation_lien = $this->executer($requete_creation_lien); |
| 96,13 → 96,12 |
|---|
| 'SELECT id_image '. |
| 'FROM cel_obs_images '. |
| 'WHERE id_observation = '.$this->proteger($value).' '. |
| 'AND id_utilisateur = '.$this->proteger($uid[0]).' '. |
| ')'; |
| } |
| 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).') AND ce_utilisateur = '.$this->proteger($uid[0]).' ' ; |
| $requete_selection_liaison = 'SELECT * from cel_obs WHERE id_observation IN (SELECT '.$column.' FROM cel_obs_images WHERE '.$field.' = '.$this->proteger($value).') ' ; |
| } |
| |
| } |
| 143,7 → 142,7 |
|---|
| if (isset($id)) { |
| $requete_suppression_lien = "DELETE FROM cel_obs_images ". |
| "WHERE id_image IN (".$id_img.") ". |
| "AND id_observation IN (".$id_obs.") AND id_utilisateur = '".$id."'" ; |
| "AND id_observation IN (".$id_obs.") " ; |
| } |
| |
| $resultat_suppression_lien = $this->executer($requete_suppression_lien); |