[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 .= “

“;
$req = mysqli_query( $connect, “SELECT created_on,first_name,last_name, gender, website,occupation,otheroccupation,enrolement,active,otheractivity,specialisation, specificcompetence,research,language,address,city,zip,country,phone,consulted,eu_projects,repres_ema,ema_journal,special_interest,address_p,city_p,zip_p,country_p,phone_p,policy,license,accreditation,articles,feedback,statistics,publish,userid,email,other_specialisation,other_specific_competences FROM SaveContactForm7_8 WHERE userid = ‘$userid'” ) or die( ‘Erreur SQL84zz !’ . mysqli_error() );

while ( $res = mysqli_fetch_array( $req ) ) {
$result = $res[userid];
}
$modtrad_page .= “

“;
$modtrad_page .= “

“;
$modtrad_page .= “

Modifications validated

“; $modtrad_page .= “

“;
$modtrad_page .= “

“;
$modtrad_page .= “

“;
$modtrad_page .= “

“;
$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 = “

“;
$modtrad_page .= ‘

‘;

$modtrad_page .=’

‘;
$modtrad_page .=’

‘;
$modtrad_page .=’

‘;
$modtrad_page .=’

‘;
$modtrad_page .=’

‘;

$modtrad_page .= “

‘;
$modtrad_page .=’

‘;
$modtrad_page .=’

‘;
$modtrad_page .= “

‘;

$modtrad_page .= “

‘;
$modtrad_page .= “

‘;

$modtrad_page .= “

‘;

$modtrad_page .=’

‘;
$modtrad_page .= “

‘;
$modtrad_page .=’

‘;
$modtrad_page .=’

‘;
$modtrad_page .= “

‘;
$modtrad_page .=’

‘;
$modtrad_page .=’

‘;
$modtrad_page .=’

‘;
$modtrad_page .= “

‘;
$modtrad_page .= “

Control or modify the datas
First name : ‘.$first_name.’
Last name : ‘.$last_name.’
Email : ‘.$email_doc.’
Gender : ‘; $modtrad_page .= “Man :‘.$birthday.’
Website : ‘.$website.’
Occupation : “; $req1 = mysqli_query($connect,”SELECT id,act_value FROM vince_activin ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res1 = mysqli_fetch_row($req1)) { $modtrad_page .= “‘.$otheroccupation.’
Nr. of enrollment on the professional register : ‘.$enrolement.’
Year of graduation:(yyyy) ‘.$graduate.’
Are you active in : “; $req2 = mysqli_query($connect,”SELECT id,act_value FROM vince_activin2 ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res2 = mysqli_fetch_row($req2)) { $modtrad_page .= “‘.$otheractivity.’
Specialisation / sub-specialisation : “; $req3 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_special ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res3 = mysqli_fetch_row($req3)) { $modtrad_page .= “‘.$other_specialisation.’
Specific competence : “; $req4 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_specific ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res4 = mysqli_fetch_row($req4)) { $modtrad_page .= “ ‘.$other_specific_competences.’
Specific treatment: “; $req4 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_treat ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res4 = mysqli_fetch_row($req4)) { $modtrad_page .= “ ‘.$other_specific_treatment.’
Research in which you are involved : ‘.$research.’
Area of special interest : ( not mentioned above ) : “; $req7 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_spec_int ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res7 = mysqli_fetch_row($req7)) { $modtrad_page .= ““; $req72 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_spec_int ORDER BY act_value ASC”) or die(‘Erreur SQL8712 !’); while ($res72 = mysqli_fetch_row($req72)) { $modtrad_page .= ““; $req73 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_spec_int ORDER BY act_value ASC”) or die(‘Erreur SQL8713 !’); while ($res73 = mysqli_fetch_row($req73)) { $modtrad_page .= “‘; $req5 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_lang ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res5 = mysqli_fetch_row($req5)) { $modtrad_page .= “‘; $req25 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_lang ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res25 = mysqli_fetch_row($req25)) { $modtrad_page .= “‘; $req35 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_lang ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res35 = mysqli_fetch_row($req35)) { $modtrad_page .= “‘; $req354 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_lang ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res354 = mysqli_fetch_row($req354)) { $modtrad_page .= “‘; $req355 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_lang ORDER BY act_value ASC”) or die(‘Erreur SQL8715 !’); while ($res355 = mysqli_fetch_row($req355)) { $modtrad_page .= “‘.$address.’
City : ‘.$city.’
Post code : ‘.$zip.’
Country : “; $req6 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_country ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res6 = mysqli_fetch_row($req6)) { $modtrad_page .= “‘.$phone.’
I agree to be consulted for the professional opinions : ‘; $modtrad_page .= “Yes :‘.$address_p.’
Town : ‘.$city_p.’
Post code : ‘.$zip_p.’
Country : “; $req8 = mysqli_query($connect,”SELECT id,act_value FROM vince_a_country_p ORDER BY act_value ASC”) or die(‘Erreur SQL871 !’); while ($res8 = mysqli_fetch_row($req8)) { $modtrad_page .= “‘.$phone_p.’
	“; $modtrad_page .= “

“;
echo $modtrad_page;
}
}
[/insert_php]