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 21... Line 21...
21
class Resume extends Cel {
21
class Resume extends Cel {
Line 22... Line 22...
22
 
22
 
Line 23... Line 23...
23
	function getElement($uid){
23
	function getElement($uid){
24
 
24
 
25
        $requete_dernieres_obs = 'SELECT * FROM cel_obs'.
25
        $requete_dernieres_obs = 'SELECT * FROM cel_obs'.
26
        		' WHERE ce_utilisateur = '.$this->proteger($uid[1]).
26
        		' WHERE ce_utilisateur = '.Cel::db()->proteger($uid[1]).
Line 27... Line 27...
27
				' AND transmission =  0'.
27
				' AND transmission =  0'.
Line 28... Line 28...
28
				' ORDER BY date_modification DESC LIMIT 0,5';
28
				' ORDER BY date_modification DESC LIMIT 0,5';
29
 
29
 
Line 30... Line 30...
30
        $resultat_dernieres_obs = $this->requeter($requete_dernieres_obs);
30
        $resultat_dernieres_obs = Cel::db()->requeter($requete_dernieres_obs);
Line 52... Line 52...
52
 
52
 
53
			$image ='';
53
			$image ='';
Line 54... Line 54...
54
			$cible_lien = '';
54
			$cible_lien = '';
55
		    		
55
		    		
Line 56... Line 56...
56
			$req_liaison = 'SELECT * FROM cel_images WHERE id_image IN (SELECT id_image FROM cel_obs_images WHERE id_observation = "'.$obs['id_observation'].'") AND ce_utilisateur = "'.$obs['ce_utilisateur'].'"' ;
56
			$req_liaison = 'SELECT * FROM cel_images WHERE id_image IN (SELECT id_image FROM cel_obs_images WHERE id_observation = "'.$obs['id_observation'].'") AND ce_utilisateur = "'.$obs['ce_utilisateur'].'"' ;
Line 57... Line 57...
57
           	$res_liaison = $this->requeter($req_liaison);
57
           	$res_liaison = Cel::db()->requeter($req_liaison);
58
 
58