You are not admin !'; return; } $id_user = strip_tags(trim($_GET["id"])); if ($id_user == "") { echo '
"; var_dump($_POST); echo ""; if (strip_tags(trim($_POST["auth"]))) { $auth = "1"; $checked_auth = ' checked="checked"'; } else { $auth = "0"; } $first_name = strip_tags(trim($_POST["first_name"])); $last_name = strip_tags(trim($_POST["last_name"])); $email = strip_tags(trim($_POST["email"])); $phone = strip_tags(trim($_POST["phone"])); $country = strip_tags(trim($_POST["country"])); $city = strip_tags(trim($_POST["city"])); if (strip_tags(trim($_POST["move_country"]))) { $move_country = "1"; $checked_move_country = ' checked="checked"'; } else { $move_country = "0"; } $profession = strip_tags(trim($_POST["profession"])); $sub_profession = strip_tags(trim($_POST["sub_profession"])); $skill_level = strip_tags(trim($_POST["skill_level"])); $experience = strip_tags(trim($_POST["experience"])); $competences = strip_tags(trim($_POST["competences"])); $references = strip_tags(trim($_POST["references"])); $additional_information = strip_tags(trim($_POST["additional_information"])); $public_info = $_POST["public_info"]; if ($public_info === null) { $public_info = array(); } foreach ($public_info as $key => $value) { if ($public_info[$key]) { $public_info[$key] = "1"; $checked_public_info[$key] = ' checked="checked"'; } else { $public_info[$key] = "0"; } } $action = strip_tags(trim($_POST["action"])); if ($action != "false") { $sql = "SELECT `cvs`.* FROM `cvs` WHERE (`cvs`.`id_user` = '" . $id_user . "');"; $exist_cv = mysql_query($sql); if (mysql_affected_rows() == 1) { $sql = "UPDATE `edata`.`cvs` SET `auth` = '" . $auth . "', `last_update` = NOW(), `first_name` = '" . $first_name . "', `last_name` = '" . $last_name . "', `email` = '" . $email . "', `phone` = '" . $phone . "', `country` = '" . $country . "', `city` = '" . $city . "', `profession` = '" . $profession . "', `sub_profession` = '" . $sub_profession . "', `skill_level` = '" . $skill_level . "', `experience` = '" . $experience . "', `competences` = '" . $competences . "', `references` = '" . $references . "', `additional_information` = '" . $additional_information . "', `public_info_1` = '" . $public_info[1] . "', `public_info_2` = '" . $public_info[2] . "', `public_info_3` = '" . $public_info[3] . "', `public_info_4` = '" . $public_info[4] . "', `public_info_5` = '" . $public_info[5] . "', `public_info_6` = '" . $public_info[6] . "', `public_info_7` = '" . $public_info[7] . "', `public_info_8` = '" . $public_info[8] . "', `public_info_9` = '" . $public_info[9] . "', `public_info_10` = '" . $public_info[10] . "', `public_info_11` = '" . $public_info[11] . "', `public_info_12` = '" . $public_info[12] . "' WHERE (`cvs`.`id_user` = '" . $id_user . "') LIMIT 1;"; } else if (mysql_affected_rows() == 0) { $sql = "INSERT INTO `cvs` (`id_user`, `auth`, `last_update`, `first_name`, `last_name`, `email`, `phone`, `country`, `city`, `profession`, `sub_profession`, `skill_level`, `experience`, `competences`, `references`, `additional_information`, `public_info_1`, `public_info_2`, `public_info_3`, `public_info_4`, `public_info_5`, `public_info_6`, `public_info_7`, `public_info_8`, `public_info_9`, `public_info_10`, `public_info_11`, `public_info_12`) VALUES ('" . $id_user . "', '" . $auth . "', NOW(), '" . $first_name . "', '" . $last_name . "', '" . $email . "', '" . $phone . "', '" . $country . "', '" . $city . "', '" . $profession . "', '" . $sub_profession . "', '" . $skill_level . "', '" . $experience . "', '" . $competences . "', '" . $references . "', '" . $additional_information . "', '" . $public_info[1] . "', '" . $public_info[2] . "', '" . $public_info[3] . "', '" . $public_info[4] . "', '" . $public_info[5] . "', '" . $public_info[6] . "', '" . $public_info[7] . "', '" . $public_info[8] . "', '" . $public_info[9] . "', '" . $public_info[10] . "', '" . $public_info[11] . "', '" . $public_info[12] . "');"; } $result = mysql_query($sql) or die (mysql_error()); } } $sql = "SELECT `cvs`.* FROM `cvs` WHERE (`cvs`.`id_user` = '" . $id_user . "');"; $result = mysql_query($sql); $row = mysql_fetch_array($result); mysql_free_result($result); if (empty($row["last_update"])) { echo '