| 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) { |