Subversion Repositories eFlore/Applications.cel

Rev

Rev 2143 | Rev 2461 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2143 Rev 2446
Line 123... Line 123...
123 
					$images_doublons_id[] = Cel::db()->quote($img['id_image']);
 123 
					$images_doublons_id[] = Cel::db()->quote($img['id_image']);
124 
				}
 124 
				}
125 
			}
 125 
			}
Line 126... Line 126...
126 
 
 126 
 
127 
			if (count($images_doublons_id) > 0) {
 127 
			if (count($images_doublons_id) > 0) {
128 
				$requete = 	'SELECT cim.id_image, nom_original, md5, co.ordre as ordre_obs '.
 128 
				$requete = 	'SELECT cim.id_image, nom_original, md5, co.ordre AS ordre_obs '.
129 
							'FROM cel_images AS cim '.
 - 
 
130 
							'	LEFT JOIN cel_obs_images AS coi '.
 - 
 
131 
							'		ON (coi.id_image = cim.id_image) '.
 129 
							'FROM cel_images AS cim '.
132 
							'	LEFT JOIN cel_obs AS co '.
 130 
							'	LEFT JOIN cel_obs AS co '.
133 
							'		ON (coi.id_observation = co.id_observation) '.
 131 
							'		ON (cim.ce_observation = co.id_observation) '.
134 
							"WHERE cim.ce_utilisateur = '$utilisateur' ".
 132 
							"WHERE cim.ce_utilisateur = '$utilisateur' ".
Line 135... Line 133...
135 
							'	AND cim.id_image IN ('.implode(',', $images_doublons_id).')';
 133 
							'	AND cim.id_image IN ('.implode(',', $images_doublons_id).')';