function cimy_update_ExtraFields_new_me()
{
global $wpdb, $wpdb_data_table, $user_ID, $max_length_value, $fields_name_prefix, $cimy_uef_file_types, $user_level, $cimy_uef_domain;
include_once ABSPATH . '/wp-admin/includes/user.php';
// if updating meta-data from registration post then exit
if (isset($_POST['cimy_post'])) {
return;
}
if (isset($_POST['user_id'])) {
$get_user_id = $_POST['user_id'];
if (!current_user_can('edit_user', $get_user_id)) {
return;
}
} else {
return;
}
//echo "asd";
if (!function_exists('get_cimyFields')) {
return;
}
$get_user_id = intval($get_user_id);
$profileuser = get_user_to_edit($get_user_id);
$user_login = $profileuser->user_login;
$user_displayname = $profileuser->display_name;
$extra_fields = get_cimyFields(false, true);
$query = "UPDATE " . $wpdb_data_table . " SET VALUE=CASE FIELD_ID";
$i = 0;
$field_ids = "";
$mail_changes = "";
foreach ($extra_fields as $thisField) {
$field_id = $thisField["ID"];
$name = $thisField["NAME"];
$type = $thisField["TYPE"];
$label = $thisField["LABEL"];
$rules = $thisField["RULES"];
$unique_id = $fields_name_prefix . $field_id;
$input_name = $fields_name_prefix . esc_attr($name);
$field_id_data = $input_name . "_" . $field_id . "_data";
$advanced_options = cimy_uef_parse_advanced_options($rules["advanced_options"]);
cimy_insert_ExtraFields_if_not_exist($get_user_id, $field_id);
// if the current user LOGGED IN has not enough permissions to see the field, skip it
// apply only for EXTRA FIELDS
if ($rules['show_level'] == 'view_cimy_extra_fields') {
if (!current_user_can($rules['show_level'])) {
continue;
}
} else {
if ($user_level < $rules['show_level']) {
continue;
}
}
// if show_level == anonymous then do NOT ovverride other show_xyz rules
if ($rules['show_level'] == -1) {
// if flag to show the field in the profile is NOT activated, skip it
if (!$rules['show_in_profile']) {
continue;
}
}
$prev_value = $wpdb->escape(stripslashes($_POST[$input_name . "_" . $field_id . "_prev_value"]));
if (cimy_uef_is_field_disabled($type, $rules['edit'], $prev_value)) {
continue;
}
if (isset($_POST[$input_name]) && !in_array($type, $cimy_uef_file_types)) {
if ($type == "dropdown-multi") {
$field_value = stripslashes(implode(",", $_POST[$input_name]));
} else {
$field_value = stripslashes($_POST[$input_name]);
}
if ($type == "picture-url") {
$field_value = str_replace('../', '', $field_value);
}
if (isset($rules['max_length'])) {
$field_value = substr($field_value, 0, $rules['max_length']);
} else {
$field_value = substr($field_value, 0, $max_length_value);
}
$field_value = $wpdb->escape($field_value);
if ($i > 0) {
$field_ids .= ", ";
} else {
$i = 1;
}
$field_ids .= $field_id;
$query .= " WHEN " . $field_id . " THEN ";
switch ($type) {
case 'dropdown':
case 'dropdown-multi':
$ret = cimy_dropDownOptions($label, $field_value);
$label = $ret['label'];
case 'picture-url':
case 'textarea':
case 'textarea-rich':
case 'password':
case 'text':
$value = "'" . $field_value . "'";
$prev_value = "'" . $prev_value . "'";
break;
case 'checkbox':
$value = $field_value == '1' ? "'YES'" : "'NO'";
$prev_value = $prev_value == "YES" ? "'YES'" : "'NO'";
break;
case 'radio':
$value = $field_value == $field_id ? "'selected'" : "''";
$prev_value = "'" . $prev_value . "'";
break;
}
$query .= $value;
} else {
$rules = $thisField['RULES'];
if (in_array($type, $cimy_uef_file_types)) {
if ($type == "avatar") {
// since avatars are drawn max to 512px then we can save bandwith resizing, do it!
$rules['equal_to'] = 512;
}
if (isset($_POST[$input_name . '_del'])) {
$delete_file = true;
} else {
$delete_file = false;
}
if (isset($_POST[$input_name . "_" . $field_id . "_prev_value"])) {
$old_file = stripslashes($_POST[$input_name . "_" . $field_id . "_prev_value"]);
} else {
$old_file = false;
}
$field_value = cimy_manage_upload($input_name, $user_login, $rules, $old_file, $delete_file, $type, !empty($advanced_options["filename"]) ? $advanced_options["filename"] : "");
if (!empty($field_value) || $delete_file) {
if ($i > 0) {
$field_ids .= ", ";
} else {
$i = 1;
}
$field_ids .= $field_id;
$value = "'" . $field_value . "'";
$prev_value = "'" . $prev_value . "'";
$query .= " WHEN " . $field_id . " THEN ";
$query .= $value;
} else {
$prev_value = $value;
$file_on_server = cimy_uef_get_dir_or_filename($user_login, $old_file, false);
if ($type == "picture" || $type == "avatar") {
cimy_uef_crop_image($file_on_server, $field_id_data);
}
}
}
if ($type == 'checkbox') {
// if can be editable then write NO
// there is no way to understand if was YES or NO previously
// without adding other hidden inputs so write always
if ($i > 0) {
$field_ids .= ", ";
} else {
$i = 1;
}
$field_ids .= $field_id;
$field_value = "NO";
$value = "'" . $field_value . "'";
$prev_value = $prev_value == "YES" ? "'YES'" : "'NO'";
$query .= " WHEN " . $field_id . " THEN ";
$query .= $value;
}
if ($type == 'dropdown-multi') {
// if can be editable then write ''
// there is no way to understand if was YES or NO previously
// without adding other hidden inputs so write always
if ($i > 0) {
$field_ids .= ", ";
} else {
$i = 1;
}
$field_ids .= $field_id;
$field_value = '';
$value = "'" . $field_value . "'";
$prev_value = "'" . $prev_value . "'";
$ret = cimy_dropDownOptions($label, $field_value);
$label = $ret['label'];
$query .= " WHEN " . $field_id . " THEN ";
$query .= $value;
}
}
if ($rules["email_admin"] && $value != $prev_value && $type != "registration-date") {
$mail_changes .= sprintf(__("%s previous value: %s new value: %s", $cimy_uef_domain), $label, stripslashes($prev_value), stripslashes($value));
$mail_changes .= "\r\n";
}
}
if ($i > 0) {
$query .= " ELSE FIELD_ID END WHERE FIELD_ID IN(" . $field_ids . ") AND USER_ID = " . $get_user_id;
// $query WILL BE: UPDATE <table> SET VALUE=CASE FIELD_ID WHEN <field_id1> THEN <value1> [WHEN ... THEN ...] ELSE FIELD_ID END WHERE FIELD_ID IN(<field_id1>, [<field_id2>...]) AND USER_ID=<user_id>
$wpdb->query($query);
}
// mail only if set and if there is something to mail
if (!empty($mail_changes)) {
$admin_email = get_option('admin_email');
$mail_subject = sprintf(__("%s (%s) has changed one or more fields", $cimy_uef_domain), $user_displayname, $user_login);
wp_mail($admin_email, $mail_subject, $mail_changes);
}
}
function cimy_registration_check($user_login, $user_email, $errors)
{
global $wpdb, $rule_canbeempty, $rule_email, $rule_maxlen, $fields_name_prefix, $wp_fields_name_prefix, $rule_equalto_case_sensitive, $apply_equalto_rule, $cimy_uef_domain, $cimy_uef_file_types, $rule_equalto_regex, $user_level, $cimy_uef_file_images_types, $wp_hidden_fields, $rule_maxlen_is_str;
if (cimy_is_at_least_wordpress35()) {
cimy_switch_to_blog();
}
$options = cimy_get_options();
if (!in_array("username", $options["wp_hidden_fields"])) {
// ok username is empty, we are replacing it with the email, don't bother
if (isset($errors->errors['empty_username'])) {
unset($errors->errors['empty_username']);
}
// remove username exists error only if email exists error is there covering for us
if (isset($errors->errors['username_exists']) && isset($errors->errors['email_exists'])) {
unset($errors->errors['username_exists']);
}
}
// code for confirmation email check
if (!is_multisite() && $options["confirm_email"]) {
$errors = cimy_check_user_on_signups($errors, $user_login, $user_email);
}
// avoid to save stuff if user is being added from: /wp-admin/user-new.php and shit WP 3.1 changed the value just to create new bugs :@
if (!empty($_POST["action"]) && ($_POST["action"] == "adduser" || $_POST["action"] == "createuser")) {
return $errors;
}
$my_user_level = $user_level;
// -1 == anonymous
if (!is_user_logged_in()) {
$my_user_level = -1;
}
$extra_fields = get_cimyFields(false, true);
$wp_fields = get_cimyFields(true);
$from_profile = false;
if (!empty($_POST["from"]) && $_POST["from"] == "profile") {
$from_profile = true;
}
$i = 1;
// do first for the WP fields then for EXTRA fields
while ($i <= 2) {
if ($i == 1) {
$fields = $wp_fields;
$prefix = $wp_fields_name_prefix;
} else {
$fields = $extra_fields;
$prefix = $fields_name_prefix;
}
foreach ($fields as $thisField) {
$field_id = $thisField['ID'];
$name = $thisField['NAME'];
$rules = $thisField['RULES'];
$type = $thisField['TYPE'];
$label = esc_html($thisField['LABEL']);
$description = $thisField['DESCRIPTION'];
$unique_id = $prefix . $field_id;
// Usernames cannot be changed after the registration
if ($i == 1 && $name == "USERNAME" && $from_profile) {
continue;
}
// use WP input name for the username (always) or when updating the profile
if ($i == 1 && ($name == "USERNAME" || $from_profile)) {
$input_name = $wp_hidden_fields[strtolower($name)]['post_name'];
} else {
$input_name = $prefix . esc_attr($name);
}
$field_id_data = $input_name . "_" . $field_id . "_data";
// if the current user LOGGED IN has not enough permissions to see the field, skip it
if ($rules['show_level'] == 'view_cimy_extra_fields') {
if (!current_user_can($rules['show_level'])) {
continue;
}
} else {
if ($my_user_level < $rules['show_level']) {
continue;
}
}
// if show_level == anonymous then do NOT ovverride other show_xyz rules
if ($rules['show_level'] == -1) {
// if we are updating the profile check correct rule
if ($from_profile) {
// if flag to show the field in the profile is NOT activated, skip it
if (!$rules['show_in_profile']) {
continue;
}
} else {
// we are registering new user
// if flag to show the field in the registration is NOT activated, skip it
if (!$rules['show_in_reg']) {
continue;
}
}
}
// uploading a file is not supported when confirmation email is enabled (on MS is turned on by default yes)
if ((is_multisite() || $options["confirm_email"]) && in_array($type, $cimy_uef_file_types)) {
continue;
}
if ($from_profile) {
if ($i == 1) {
// Do not bother with the rules if encountered an empty password field on profile update
if ($type == "password") {
continue;
}
} else {
$old_value = $_POST[$input_name . "_" . $field_id . "_prev_value"];
// Hey, no need to check for rules if anyway I can't edit due to low permissions, neeeext!
if (cimy_uef_is_field_disabled($type, $rules['edit'], $old_value)) {
continue;
}
}
}
if (isset($_POST[$input_name])) {
if ($type == "dropdown-multi" && is_array($_POST[$input_name])) {
$value = stripslashes(implode(",", $_POST[$input_name]));
} else {
$value = stripslashes($_POST[$input_name]);
}
} else {
$value = "";
}
if ($type == "dropdown") {
$ret = cimy_dropDownOptions($label, $value);
$label = esc_html($ret['label']);
$html = $ret['html'];
}
// upload of a file, avatar or picture
if (in_array($type, $cimy_uef_file_types)) {
// confirmation page
if (!empty($_POST["register_confirmation"]) && $_POST["register_confirmation"] == 2) {
$file_size = $_POST[$field_id_data . "_size"];
$file_type1 = $_POST[$field_id_data . "_type"];
// this can be faked!
$old_file = "";
$del_old_file = "";
} else {
if (!empty($_FILES[$input_name])) {
// filesize in Byte transformed in KiloByte
$file_size = $_FILES[$input_name]['size'] / 1024;
$file_type1 = $_FILES[$input_name]['type'];
// this can be faked!
$value = $_FILES[$input_name]['name'];
$old_file = $from_profile && !empty($_POST[$input_name . "_" . $field_id . "_prev_value"]) ? $_POST[$input_name . "_" . $field_id . "_prev_value"] : '';
$del_old_file = $from_profile && !empty($_POST[$input_name . "_del"]) ? $_POST[$input_name . "_del"] : '';
} else {
$file_size = 0;
$file_type1 = "";
$value = "";
$old_file = $from_profile && !empty($_POST[$input_name . "_" . $field_id . "_prev_value"]) ? $_POST[$input_name . "_" . $field_id . "_prev_value"] : '';
$del_old_file = $from_profile && !empty($_POST[$input_name . "_del"]) ? $_POST[$input_name . "_del"] : '';
}
}
}
switch ($type) {
case 'checkbox':
$value == 1 ? $value = "YES" : ($value = "NO");
break;
case 'radio':
intval($value) == intval($field_id) ? $value = "YES" : ($value = "NO");
break;
}
// if the flag can be empty is NOT set OR the field is not empty then other check can be useful, otherwise skip all
if (!$rules['can_be_empty'] || !empty($value)) {
if ($i == 1 && $input_name == $prefix . "PASSWORD2") {
if ($value != $_POST[$prefix . "PASSWORD"]) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('does not match.', $cimy_uef_domain));
}
}
if ($rules['email'] && in_array($type, $rule_email)) {
if (!is_email($value)) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('hasn’t a correct email syntax.', $cimy_uef_domain));
}
}
if (!$rules['can_be_empty'] && in_array($type, $rule_canbeempty) && empty($value)) {
$empty_error = true;
// IF 1. it's a file type
// AND 2. there is an old one uploaded
// AND 3. this old one is not gonna be deleted
// THEN do not throw the empty error.
if (in_array($type, $cimy_uef_file_types) && !empty($old_file) && empty($del_old_file)) {
$empty_error = false;
}
if ($empty_error) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('couldn’t be empty.', $cimy_uef_domain));
}
}
if (isset($rules['equal_to']) && in_array($type, $apply_equalto_rule)) {
$equalTo = $rules['equal_to'];
// if the type is not allowed to be case sensitive
// OR if case sensitive is not checked
// AND
// if the type is not allowed to be a regex
// OR if regex rule is not set
// THEN switch to uppercase
if ((!in_array($type, $rule_equalto_case_sensitive) || !$rules['equal_to_case_sensitive']) && (!in_array($type, $rule_equalto_regex) || !$rules['equal_to_regex'])) {
$value = strtoupper($value);
$equalTo = strtoupper($equalTo);
}
if ($rules['equal_to_regex']) {
$equalTo = $rules['equal_to_case_sensitive'] ? $equalTo . 'u' : $equalTo . 'iu';
if (!preg_match($equalTo, $value)) {
$equalmsg = " " . __("isn’t correct", $cimy_uef_domain);
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . $equalmsg . '.');
}
} else {
if ($value != $equalTo) {
if ($type == "radio" || $type == "checkbox") {
$equalTo == "YES" ? $equalTo = __("YES", $cimy_uef_domain) : __("NO", $cimy_uef_domain);
}
if ($type == "password") {
$equalmsg = " " . __("isn’t correct", $cimy_uef_domain);
} else {
$equalmsg = ' ' . __("should be", $cimy_uef_domain) . ' ' . esc_html($equalTo);
}
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . $equalmsg . '.');
}
}
}
// CHECK IF IT IS A REAL PICTURE
if (in_array($type, $cimy_uef_file_images_types)) {
$allowed_mime_types = get_allowed_mime_types();
$validate = wp_check_filetype($value, $allowed_mime_types);
$file_type2 = "";
if (!empty($validate['type'])) {
$file_type2 = $validate['type'];
}
if ((stristr($file_type1, "image/") === false || stristr($file_type2, "image/") === false) && !empty($value)) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('should be an image.', $cimy_uef_domain));
}
} else {
if (in_array($type, $cimy_uef_file_types)) {
$allowed_mime_types = get_allowed_mime_types();
$validate = wp_check_filetype($value, $allowed_mime_types);
$file_type2 = "";
if (!empty($validate['type'])) {
$file_type2 = $validate['type'];
}
if (empty($file_type2) && !empty($value)) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('does not accept this file type.', $cimy_uef_domain));
}
}
}
// MIN LEN
if (isset($rules['min_length'])) {
$minlen = intval($rules['min_length']);
if (in_array($type, $cimy_uef_file_types)) {
if ($file_size < $minlen) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('couldn’t have size less than', $cimy_uef_domain) . ' ' . $minlen . ' KB.');
}
} else {
if (!in_array($type, $rule_maxlen_is_str)) {
if (cimy_strlen($value) < $minlen) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('couldn’t have length less than', $cimy_uef_domain) . ' ' . $minlen . '.');
}
}
}
}
// EXACT LEN
if (isset($rules['exact_length'])) {
$exactlen = intval($rules['exact_length']);
if (in_array($type, $cimy_uef_file_types)) {
if ($file_size != $exactlen) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('couldn’t have size different than', $cimy_uef_domain) . ' ' . $exactlen . ' KB.');
}
} else {
if (!in_array($type, $rule_maxlen_is_str)) {
if (cimy_strlen($value) != $exactlen) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('couldn’t have length different than', $cimy_uef_domain) . ' ' . $exactlen . '.');
}
}
}
}
// MAX LEN
if (isset($rules['max_length'])) {
$maxlen = intval($rules['max_length']);
if (in_array($type, $cimy_uef_file_types)) {
if ($file_size > $maxlen) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('couldn’t have size more than', $cimy_uef_domain) . ' ' . $maxlen . ' KB.');
}
} else {
if (!in_array($type, $rule_maxlen_is_str)) {
if (cimy_strlen($value) > $maxlen) {
$errors->add($unique_id, '<strong>' . __("ERROR", $cimy_uef_domain) . '</strong>: ' . $label . ' ' . __('couldn’t have length more than', $cimy_uef_domain) . ' ' . $maxlen . '.');
}
}
}
}
}
}
$i++;
}
if ($options['confirm_form']) {
// this is executed to test registration for errors, to avoid a real registration we put a fake error
if (empty($errors->errors) && isset($_POST["register_confirmation"]) && $_POST["register_confirmation"] == 1) {
$errors->add('register_confirmation', 'true');
}
}
cimy_switch_current_blog();
return $errors;
}
