Subversion Repositories eFlore/Applications.cel

Rev

Rev 1720 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1720 Rev 1724
Line 27... Line 27...
27
	 * @param string $uid[1] identifiant numérique de l'utilisateur
27
	 * @param string $uid[1] identifiant numérique de l'utilisateur
28
	 */
28
	 */
29
	function getElement($uid){
29
	function getElement($uid){
Line 30... Line 30...
30
 
30
 
31
        $requete_obs_liee_images = 'SELECT * FROM cel_obs'.
31
        $requete_obs_liee_images = 'SELECT * FROM cel_obs'.
32
        		' WHERE ce_utilisateur = '.$this->proteger($uid[1]).
32
        		' WHERE ce_utilisateur = '.Cel::db()->proteger($uid[1]).
33
        		' AND id_observation IN (SELECT id_observation
33
        		' AND id_observation IN (SELECT id_observation
34
								FROM cel_obs_images
34
								FROM cel_obs_images
35
								WHERE id_utilisateur = '.$this->proteger($uid[1]).' )'.
35
								WHERE id_utilisateur = '.Cel::db()->proteger($uid[1]).' )'.
36
				' AND transmission =  0'.
36
				' AND transmission =  0'.
Line 37... Line 37...
37
				' ORDER BY date_modification DESC LIMIT 0,5';
37
				' ORDER BY date_modification DESC LIMIT 0,5';
Line 38... Line 38...
38
 
38
 
Line 39... Line 39...
39
        $html = '<div id="resume_cel">';
39
        $html = '<div id="resume_cel">';
Line 40... Line 40...
40
        
40
        
41
        $obs_liees_images = array();
41
        $obs_liees_images = array();
42
        
42
        
Line 53... Line 53...
53
            $requete_img_liees = 'SELECT * FROM cel_images WHERE id_image '.
53
            $requete_img_liees = 'SELECT * FROM cel_images WHERE id_image '.
54
						   'IN (SELECT id_image FROM cel_obs_images '.
54
						   'IN (SELECT id_image FROM cel_obs_images '.
55
						   'WHERE id_observation = "'.$obs['id_observation'].'") '.
55
						   'WHERE id_observation = "'.$obs['id_observation'].'") '.
56
						   'AND ce_utilisateur = "'.$obs['ce_utilisateur'].'"' ;
56
						   'AND ce_utilisateur = "'.$obs['ce_utilisateur'].'"' ;
Line 57... Line 57...
57
 
57
 
Line 58... Line 58...
58
			$resultat_requete_img_liees = $this->requeter($requete_img_liees);
58
			$resultat_requete_img_liees = Cel::db()->requeter($requete_img_liees);
Line 59... Line 59...
59
 
59