Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 3310 Rev 3311
Line 113... Line 113...
113
	    $this->bdd->requeter($requete);
113
	    $this->bdd->requeter($requete);
114
	}
114
	}
Line 115... Line 115...
115
	
115
	
116
	private function migrerImages() {
116
	private function migrerImages() {
117
	    $requete = "INSERT INTO ".$this->base.".photo
117
	    $requete = "INSERT INTO ".$this->base.".photo
118
	        (id, occurrence_id, user_id, user_pseudo, user_email, date_shot, original_name, mime_type
118
	        (id, occurrence_id, user_id, user_pseudo, user_email, date_shot, original_name, mime_type,
119
	        date_updated, date_created, date_linked_to_occurrence, content_url, url)
119
	        date_updated, date_created, date_linked_to_occurrence, content_url, url)
120
	        SELECT id_image, ce_observation, ce_utilisateur, prenom_utilisateur, 
120
	        SELECT id_image, ce_observation, ce_utilisateur, prenom_utilisateur, 
121
	        courriel_utilisateur, date_prise_de_vue, nom_original,'' , date_modification, 
121
	        courriel_utilisateur, date_prise_de_vue, nom_original,'' , date_modification, 
122
	        date_creation, date_liaison, '', concat('http://api.tela-botanica.org/img:000', '', `id_image`,
122
	        date_creation, date_liaison, '', concat('http://api.tela-botanica.org/img:000', '', `id_image`,