[ms-note type=”info”][/ms-note]
[insert_php]
global $current_user;
global $userid;
global $test;
global $test2;
global $code1;
global $code2;
global $code3;
global $code4;
global $result;
global $modtrad_page ;
global $location;
$location =”http://emanet.org/members-datas/”;
$code1 =”code1″;
$code2=”code2″;
$code3=”code3″;
$code4=”code4″;
$test2 = “vide”;
get_currentuserinfo();
global $connect ;
global $modtrad_page;
global $comid;
global $connect;
get_header();
global $current_user;
global $userid;
get_currentuserinfo();
$userid = $current_user->ID;
$connect = mysqli_connect( ’emanetorg.mysql.db’, ’emanetorg’, ‘Xt6PsTNdS2′, ’emanetorg’ ) or die ( “Connexion au serveur sql impossible” );
$req222 = mysqli_query( $connect, “SELECT userid FROM SaveContactForm7_8 WHERE userid = ‘$userid'” ) or die( ‘Erreur SQL84777 !’ . mysqli_error() );
while ( $res222 = mysqli_fetch_array( $req222 ) ) {
$result = $res222[userid];
}
if ($result != $userid){
$display2 = ‘Please fill up your full acreditation‘ ;
echo $display2 ;
} else {
if (isset($_POST[“status”]) and ($_POST[“status”] == ‘1’)) {
$modfirst_name = $_POST[first_name];
$modlast_name = $_POST[last_name];
$modgender = $_POST[gender];
$modoccupation = $_POST[occupation];
$modwebsite = $_POST[website];
$modotheroccupation = $_POST[otheroccupation];
$modenrolement = $_POST[enrolement];
$modactive = $_POST[active];
$modotheractivity = $_POST[otheractivity];
$modspecialisation = $_POST[specialisation];
$modother_specialisation = $_POST[other_specialisation];
$modspecificcompetence = $_POST[specificcompetence];
$modother_specific_competences = $_POST[other_specific_competences];
$modspecifictreatment = $_POST[specifictreatment];
$modother_specific_treatment = $_POST[other_specific_treatment];
$modresearch = $_POST[research];
$modspecial_interest = $_POST[special_interest];
$modspecial_interest2 = $_POST[special_interest2];
$modspecial_interest3 = $_POST[special_interest3];
$modlanguage = $_POST[language];
$modlanguage2 = $_POST[language2];
$modlanguage3 = $_POST[language3];
$modlanguage4 = $_POST[language4];
$modlanguage5 = $_POST[language5];
$modaddress = $_POST[address];
$modcity = $_POST[city];
$modzip = $_POST[zip];
$modcountry = $_POST[country];
$modphone = $_POST[phone];
$modconsulted = $_POST[consulted];
$modeu_projects = $_POST[eu_projects];
$modrepres_ema = $_POST[repres_ema];
$modema_journal = $_POST[ema_journal];
$modaddress_p = $_POST[address_p];
$modcity_p = $_POST[city_p];
$modzip_p = $_POST[zip_p];
$modcountry_p = $_POST[country_p];
$modphone_p = $_POST[phone_p];
$modemail = $_POST[az_email];
$modid = $_POST[modid];
$modbirthday = $_POST[birthday];
$modgraduate = $_POST[graduate];
$sql = “UPDATE `SaveContactForm7_8` set first_name = ‘$modfirst_name’, last_name = ‘$modlast_name’, gender = ‘$modgender’, occupation = ‘$modoccupation’
, website = ‘$modwebsite’, otheroccupation = ‘$modotheroccupation’, enrolement = ‘$modenrolement’, active = ‘$modactive’, otheractivity= ‘$modotheractivity’
, specialisation = ‘$modspecialisation’, other_specialisation = ‘$modother_specialisation’, specificcompetence = ‘$modspecificcompetence’, other_specific_competences = ‘$modother_specific_competences’, specifictreatment = ‘$modspecifictreatment’, other_specific_treatment = ‘$modother_specific_treatment’, research= ‘$modresearch’
, special_interest = ‘$modspecial_interest’, special_interest2 = ‘$modspecial_interest2’, special_interest3 = ‘$modspecial_interest3’, language = ‘$modlanguage’, language2 = ‘$modlanguage2’, language3 = ‘$modlanguage3’, language4 = ‘$modlanguage4’, language5 = ‘$modlanguage5’, address = ‘$modaddress’, city = ‘$modcity’, zip= ‘$modzip’ , country = ‘$modcountry’, phone = ‘$modphone’, consulted = ‘$modconsulted’, eu_projects = ‘$modeu_projects’, repres_ema= ‘$modrepres_ema’ , ema_journal = ‘$modema_journal’, address_p = ‘$modaddress_p’, city_p = ‘$modcity_p’, zip_p = ‘$modzip_p’, country_p= ‘$modcountry_p’
, phone_p = ‘$modphone_p’, email = ‘$modemail’ , birthday = ‘$modbirthday’, graduate= ‘$modgraduate’ WHERE userid = ‘$modid’ “;
mysqli_query($connect,$sql) or die(‘Erreur SQL8114 !’ . mysqli_error());
$sql2 = “UPDATE `vince_users` set user_email = ‘$modemail’ WHERE ID = ‘$modid’ “;
mysqli_query($connect,$sql2) or die(‘Erreur SQL81145 !’ . mysqli_error());
$modtrad_page = “
“;
$modtrad_page .= “
“;
echo $modtrad_page;
} else {
$userid = $current_user->ID;
$email_doc = $current_user->user_email;
$req = mysqli_query( $connect, “SELECT created_on,first_name,last_name, gender, website,occupation,otheroccupation,enrolement,active,otheractivity,specialisation, specificcompetence,specifictreatment,research,language,language2,language3,language4,language5,address,city,zip,country,phone,consulted,eu_projects,repres_ema,ema_journal,special_interest,special_interest2, special_interest3, userid, email,other_specialisation,other_specific_competences,other_specific_treatment,graduate, address_p, city_p,zip_p,country_p, phone_p, policy, birthday, publish FROM SaveContactForm7_8 WHERE userid = ‘$userid'” ) or die( ‘Erreur SQL84zz !’ . mysqli_error() );
while ($res = mysqli_fetch_array($req)) {
$first_name = $res[first_name];
$last_name = $res[last_name];
$gender = $res[gender];
$occupation = $res[occupation];
$website = $res[website];
$otheroccupation = $res[otheroccupation];
$enrolement = $res[enrolement];
$active = $res[active];
$otheractivity = $res[otheractivity];
$specialisation = $res[specialisation];
$other_specialisation = $res[other_specialisation];
$specificcompetence = $res[specificcompetence];
$other_specific_competences = $res[other_specific_competences];
$specifictreatment = $res[specifictreatment];
$other_specific_treatment = $res[other_specific_treatment];
$research = $res[research];
$special_interest = $res[special_interest];
$special_interest2 = $res[special_interest2];
$special_interest3 = $res[special_interest3];
$language = $res[language];
$language2 = $res[language2];
$language3 = $res[language3];
$language4 = $res[language4];
$language5 = $res[language5];
$address = $res[address];
$city = $res[city];
$zip = $res[zip];
$country = $res[country];
$phone = $res[phone];
$consulted = $res[consulted];
$eu_projects = $res[eu_projects];
$repres_ema = $res[repres_ema];
$ema_journal = $res[ema_journal];
$address_p = $res[address_p];
$city_p = $res[city_p];
$zip_p = $res[zip_p];
$country_p = $res[country_p];
$phone_p = $res[phone_p];
$birthday = $res[birthday];
$graduate= $res[graduate];
}
$modtrad_page = “
“;
echo $modtrad_page;
}
}
[/insert_php]