"); $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); //mehari_an $sql="UPDATE `rec_mehari_tmp` SET `mehari_an` = '".$_GET['mehari_an']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //mehari_type $sql="UPDATE `rec_mehari_tmp` SET `mehari_type` = '".$_GET['mehari_type']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //mehari_numero_serie $sql="UPDATE `rec_mehari_tmp` SET `mehari_numero_serie` = '".$_GET['mehari_numero_serie']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //mehari_enac $sql="UPDATE `rec_mehari_tmp` SET `mehari_enac` = '".$_GET['mehari_enac']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //mehari_immatriculation $sql="UPDATE `rec_mehari_tmp` SET `mehari_immatriculation` = '".$_GET['mehari_immatriculation']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //mehari_date_circulation $sql="UPDATE `rec_mehari_tmp` SET `mehari_date_circulation` = '".$_GET['mehari_date_circulation']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //echo($sql."
"); //modele_id $sql="UPDATE `rec_mehari_tmp` SET `modele_id` = '".$_GET['modele_id']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //mehari_couleur $sql="UPDATE `rec_mehari_tmp` SET `mehari_couleur` = '".$_GET['mehari_couleur']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //mehari_place $sql="UPDATE `rec_mehari_tmp` SET `mehari_place` = '".$_GET['mehari_place']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //recensement_note //echo($_GET['recensement_note']); $_GET['recensement_note']=str_replace("'","\'",$_GET['recensement_note']); //$_GET['recensement_note']=str_replace('"','',$_GET['recensement_note']); //echo($_GET['recensement_note']); $sql="UPDATE `rec_mehari_tmp` SET `recensement_note` = '".$_GET['recensement_note']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //post forum $sql="UPDATE `rec_mehari_tmp` SET `mehari_post_forum` = '".$_GET['mehari_post_forum']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //recensement_qui $sql="UPDATE `rec_mehari_tmp` SET `recensement_qui` = '".$_GET['recensement_qui']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //recensement_email $sql="UPDATE `rec_mehari_tmp` SET `recensement_email` = '".$_GET['recensement_email']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //mehari_pseudo_forum $sql="UPDATE `rec_mehari_tmp` SET `mehari_pseudo_forum` = '".$_GET['mehari_pseudo_forum']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //departement_id $sql="UPDATE `rec_mehari_tmp` SET `departement_id` = '".$_GET['departement_id']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //mehari_numero_serie_id $sql="UPDATE `rec_mehari_tmp` SET `mehari_numero_serie_id` = '".$_GET['mehari_numero_serie_id']."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //update //UPDATE `rec_mehari_tmp` SET `last_update` = '2020-10-03 14:27:51' WHERE `rec_mehari_tmp`.`id` = 2930; $sql="UPDATE `rec_mehari_tmp` SET `last_update` = '".date("Y-m-d")."' WHERE `rec_mehari_tmp`.`id` = ".$id; $result=$link->query($sql); //Pseudo OK if($_GET['mehari_pseudo_forum']) { $sql="UPDATE `rec_mehari_tmp` SET `mehari_pseudo_ok` = ".is_pseudo($_GET['mehari_pseudo_forum'])." WHERE `rec_mehari_tmp`.`id` = ".$id; } else { $sql="UPDATE `rec_mehari_tmp` SET `mehari_pseudo_ok` = ".'0'." WHERE `rec_mehari_tmp`.`id` = ".$id; } $result=$link->query($sql); $sql="UPDATE `rec_mehari_tmp` SET `mehari_doublon` = ".$_GET['mehari_doublon']." WHERE `rec_mehari_tmp`.`id` = ".$id;$link->query($sql); $sql="UPDATE `rec_mehari_tmp` SET `mehari_erreur` = ".$_GET['mehari_erreur']." WHERE `rec_mehari_tmp`.`id` = ".$id;$link->query($sql); fait_mail($id); //header('Location:http://www.mehariclubdefrance.com/rec/saisie/saisie.php'); function fait_mail($id) { $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql="SELECT * FROM `rec_mehari_tmp` WHERE `id` = ".$id; $result_tmp=$link->query($sql); while($resultat_tmp=$result_tmp->fetch_assoc()) { $ref=$resultat_tmp['id']; echo('id='.$ref."
"); $mail_to=$resultat_tmp['recensement_email'];echo('mail='.$mail_to."
"); $pseudo=$resultat_tmp['mehari_pseudo_forum'];echo('pseudo='.$pseudo."
"); $n_serie=back_mehari_an($resultat_tmp['mehari_an'])."-".$resultat_tmp['mehari_type'].'-'.$resultat_tmp['mehari_numero_serie'];echo('n_serie='.$n_serie."
"); $immat=$resultat_tmp['mehari_immatriculation'];echo('immat='.$immat."
"); $date_immat=fait_date($resultat_tmp['mehari_date_circulation']);echo('date_immat='.$date_immat."
"); $departement=back_departement($resultat_tmp['departement_id']);echo('departement='.$departement."
"); $couleur=back_couleur($resultat_tmp['mehari_couleur']);echo('couleur='.$couleur."
"); $n_place=back_place($resultat_tmp['mehari_place']);echo('n_place='.$n_place."
"); $modele=back_modele($resultat_tmp['modele_id']);echo('n_place='.$modele."
"); $enac=$resultat_tmp['mehari_enac'];echo('enac='.$enac."
"); $proprietaire=$resultat_tmp['recensement_qui'];echo('proprietaire='.$proprietaire."
"); $note=$resultat_tmp['recensement_note'];echo('note='.$note."
"); $query="SELECT * FROM `rec_numero_serie` WHERE `numero_serie_id` = ".$resultat_tmp['mehari_numero_serie_id']; $Texte=' Recensement Méhari Club De France '; $Texte.='

'; $Texte.='Bonjour '.$pseudo.'
' ; $Texte.='Le recensement de votre Méhari à bien été réceptionné sous la référence Ref='.$id.'
'; $Texte.=''; $Texte.='"; $Texte.='"; $Texte.='"; $Texte.='"; $Texte.='"; //$Texte.=""; $Texte.='"; $Texte.='"; $Texte.='"; $Texte.='"; $Texte.='"; $Texte.='"; $Texte.=''; $Texte.="
Informations transmises
Numéro série
'.$n_serie."		ENAC si 69
'.$enac."		Immatriculation
'.$immat."		Date Immatriculation
'.$date_immat."		Modèle
'.$modele."		Année Modèle
"."--"."		Couleur
'.$couleur."
Nb Places
'.$n_place."		 Nom Recenseur
'.$proprietaire."		 Mail Recenseur
'.$mail_to."		 Pseudo Recenseur
'.$pseudo."		Localisation Recenseur
'.$departement."
Commentaire**
'.$note.'
"; $Texte.="Merci de votre collaboration, en cas de problème concernant votre fiche l'équipe de recensement vous contacteras en MP"; $Texte.='

L\'équipe du recensement du MCDF

'; $Texte.=''; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=utf-8' . "\r\n"; $headers .= 'From: recensement@mehariclubdefrance.com' ."\r\n"; $headers .= "CC: webmaster@mehariclubdefrance.com". "\r\n"; mail($mail_to,"Recensement MCDF",$Texte, $headers); } } function get_last() { $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql="SELECT * FROM `rec_mehari_tmp` ORDER BY `rec_mehari_tmp`.`id` DESC LIMIT 1"; $result=$link->query($sql); $num_id=$result->fetch_assoc(); return($num_id['id']); } function fait_new() { $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql="SELECT * FROM `rec_mehari_tmp` ORDER BY `rec_mehari_tmp`.`mehari_id` DESC"; $result=$link->query($sql); $l_id=$result->fetch_assoc(); $mehari_id=$l_id['mehari_id']+1; $sql="INSERT INTO `rec_mehari_tmp` (`id`, `mehari_id`, `saisie`, `mehari_an`, `mehari_type`, `mehari_numero_serie`, `mehari_date_circulation`, `mehari_modele`, `departement_id`, `recensement_adherent`, `recensement_qui`, `recensement_email`, `mehari_enac`, `mehari_immatriculation`, `recensement_note`, `last_update`, `mehari_couleur`, `mehari_place`, `modele_id`, `mehari_pseudo_forum`, `mehari_pseudo_ok`, `recensement_actif`, `mehari_post_forum`, `mehari_numero_serie_id`) VALUES (NULL, '".$mehari_id."', CURRENT_DATE(), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CURRENT_DATE(), NULL, NULL, '0', NULL, '0', '1', NULL, '0');"; $result=$link->query($sql); } //**** /* function fait_Dept() { global $Nom_Dept,$Nb_Dept; $Nom_Dept="categories: ["; $Nb_Dept="data: ["; $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql = 'SELECT departement_id, COUNT(*) FROM `rec_mehari_tmp` GROUP BY `departement_id` ORDER BY `COUNT(*)` DESC'; $result=$link->query($sql); while($dept=$result->fetch_assoc()) { //en France ? if(france($dept['departement_id'])==1) { $nom=nom_dept($dept['departement_id']); $nom=str_replace("'","\'",$nom); $Nom_Dept=$Nom_Dept."'".$nom."',"; $Nb_Dept=$Nb_Dept.$dept['COUNT(*)'].","; } } $Nom_Dept=$Nom_Dept."],"; $Nb_Dept=$Nb_Dept."]"; $Nom_Dept=str_replace(",]","]",$Nom_Dept); $Nb_Dept=str_replace(",]","]",$Nb_Dept); } */ //**** /* function fait_Pays() { global $Nom_Pays,$Nb_Pays; $Nom_Pays="categories: ["; $Nb_Pays="data: ["; $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql = 'SELECT rec_pays.pays_nom, Count( rec_mehari_tmp.mehari_id ) AS CompteDemehari_id FROM rec_mehari_tmp INNER JOIN ( ( rec_regions INNER JOIN rec_pays ON rec_regions.pays_id = rec_pays.pays_id ) INNER JOIN rec_departements ON rec_regions.region_id = rec_departements.region_id ) ON rec_mehari_tmp.departement_id = rec_departements.departement_id GROUP BY rec_pays.pays_nom ORDER BY `CompteDemehari_id` DESC LIMIT 0, 30'; $result=$link->query($sql); while($pays=$result->fetch_assoc()) { $Nom_Pays=$Nom_Pays."'".$pays['pays_nom']."',"; $Nb_Pays=$Nb_Pays.$pays['CompteDemehari_id'].","; } $Nom_Pays=$Nom_Pays."],"; $Nb_Pays=$Nb_Pays."]"; $Nom_Pays=str_replace(",]","]",$Nom_Pays); $Nb_Pays=str_replace(",]","]",$Nb_Pays); } //***** */ /* function fait_Type() { global $Nom_Type,$Nb_Type; $Nom_Type="categories: ["; $Nb_Type="data: ["; $link = mysqli_connect("mehariclglobale.mysql.db", "mehariclglobale", "Pva131254", "mehariclglobale"); $sql = 'SELECT rec_modele.modele_desc, Count( rec_mehari_tmp.mehari_id ) AS CompteDemehari_id FROM rec_mehari_tmp INNER JOIN rec_modele ON rec_mehari_tmp.modele_id = rec_modele.modele_id GROUP BY rec_modele.modele_id, rec_modele.modele_desc ORDER BY `CompteDemehari_id` DESC'; $result=$link->query($sql); while($type=$result->fetch_assoc()) { $Nom_Type=$Nom_Type."'".$type['modele_desc']."',"; $Nb_Type=$Nb_Type.$type['CompteDemehari_id'].","; }; $Nom_Type=$Nom_Type."],"; $Nb_Type=$Nb_Type."]"; $Nom_Type=str_replace(",]","]",$Nom_Type); $Nb_Type=str_replace(",]","]",$Nb_Type); } /* function is_pseudo($pseudo) { $pseudo=strtolower($pseudo); $pseudo=utf8_decode($pseudo); $link = mysqli_connect("mehariclclobale.mysql.db", "mehariclclobale", "Pva131254", "mehariclclobale"); $sql="SELECT COUNT(*) FROM `phpbb_3users` WHERE `username_clean` LIKE '".$pseudo."'"; $result=$link->query($sql); $liste=$result->fetch_assoc(); return($liste['COUNT(*)']); } */ ?>