Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1391 Rev 1765
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