get_var( $wpdb->prepare( "SELECT user_id FROM $affiliates_users_table WHERE affiliate_id = %d", intval( $affiliate_id ) ) ); if ( $affiliate_user_id !== null ) { $affiliate_user = get_user_by( 'id', intval( $affiliate_user_id ) ); if ( $affiliate_user ) { // user edit link if ( current_user_can( 'edit_user', $affiliate_user->ID ) ) { $affiliate_user_edit = sprintf( __( 'Edit %s', 'affiliates' ) , 'ID" ) . '">' . $affiliate_user->user_login . '' ); } // user meta fields require_once AFFILIATES_CORE_LIB . '/class-affiliates-settings.php'; require_once AFFILIATES_CORE_LIB . '/class-affiliates-settings-registration.php'; $registration_fields = Affiliates_Settings_Registration::get_fields(); // remove fields not stored as user meta foreach ( Affiliates_Registration::get_skip_meta_fields() as $key ) { unset( $registration_fields[$key] ); } // render user meta foreach ( $registration_fields as $name => $field ) { if ( $field['enabled'] ) { $affiliate_user_fields .= '

'; $affiliate_user_fields .= ''; $affiliate_user_fields .= esc_html( stripslashes( $field['label'] ) ); // @todo i18n $affiliate_user_fields .= ' '; $type = isset( $field['type'] ) ? $field['type'] : 'text'; $value = get_user_meta( $affiliate_user->ID, $name , true ); $affiliate_user_fields .= sprintf( '', esc_attr( stripslashes( $value ) ) ); $affiliate_user_fields .= ''; $affiliate_user_fields .= '

'; } } } } $current_url = ( is_ssl() ? 'https://' : 'http://' ) . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $current_url = remove_query_arg( 'action', $current_url ); $current_url = remove_query_arg( 'affiliate_id', $current_url ); $name = isset( $_POST['name-field'] ) ? $_POST['name-field'] : $affiliate['name']; $email = isset( $_POST['email-field'] ) ? $_POST['email-field'] : $affiliate['email']; $user_login = isset( $_POST['user-field'] ) ? $_POST['user-field'] : ( $affiliate_user != null ? $affiliate_user->user_login : '' ); $from_date = isset( $_POST['from-date-field'] ) ? $_POST['from-date-field'] : $affiliate['from_date']; $thru_date = isset( $_POST['thru-date-field'] ) ? $_POST['thru-date-field'] : $affiliate['thru_date']; $status = isset( $_POST['status'] ) ? $_POST['status'] : $affiliate['status']; $notice = ''; if ( isset( $_POST['errors'] ) && is_array( $_POST['errors'] ) ) { $notice_msg = array(); foreach ( $_POST['errors'] as $error ) { switch ( $error ) { case AFFILIATES_ADMIN_AFFILIATES_ERROR_NAME_EMPTY : $notice_msg[] = __( 'Name can not be empty.', 'affiliates' ); break; case AFFILIATES_ADMIN_AFFILIATES_ERROR_USERNAME : $notice_msg[] = __( 'The username does not exist.', 'affiliates' ); break; default: $notice_msg[] = __( 'Something went wrong.', 'affiliates' ); break; } } $notice .= '

'; $notice .= implode( '
', $notice_msg ); $notice .= '

'; } $output = '

' . '

' . '

' . esc_html__( 'Edit an affiliate', 'affiliates' ) . '

' . '

' . $notice . '

' . '

' . '' . '

' . '' . '' . esc_html__( 'Name', 'affiliates' ) . '' . ' ' . '' . '' . '

' . '

' . '' . '' . esc_html__( 'Email', 'affiliates' ) . '' . ' ' . '' . '' . ' ' . '' . __( "If a valid Username is specified and no email is given, the user's email address will be used automatically.", 'affiliates' ) . '' . '

' . '

' . '' . '' . esc_html__( 'Username', 'affiliates' ) . '' . ' ' . '' . '' . ' ' . $affiliate_user_edit . '

' . $affiliate_user_fields . '

' . '' . '' . esc_html__( 'From', 'affiliates' ) . '' . ' ' . '' . '' . '

' . '

' . '' . '' . esc_html__( 'Until', 'affiliates' ) . '' . ' ' . '' . '' . '

'; $output .= '

' . '' . '' . esc_html__( 'Status', 'affiliates' ) . '' . ' ' . '' . '' . '

'; $output .= '

' . wp_nonce_field( 'affiliates-edit', AFFILIATES_ADMIN_AFFILIATES_NONCE, true, false ) . '' . '' . ' ' . '' . __( 'Cancel', 'affiliates' ) . '' . '

' . '

' . // .affiliate.edit '

' . '

'; // .manage-affiliates echo $output; affiliates_footer(); } // function affiliates_admin_affiliates_edit /** * Handle edit form submission. * * @return int error_value: * AFFILIATES_ADMIN_AFFILIATES_NO_ERROR -- No errors * AFFILIATES_ADMIN_AFFILIATES_ERROR_NAME_EMPTY * AFFILIATES_ADMIN_AFFILIATES_ERROR_USERNAME */ function affiliates_admin_affiliates_edit_submit() { global $wpdb, $affiliates_version; $result = array(); if ( !current_user_can( AFFILIATES_ADMINISTER_AFFILIATES ) ) { wp_die( esc_html__( 'Access denied.', 'affiliates' ) ); } if ( !wp_verify_nonce( $_POST[AFFILIATES_ADMIN_AFFILIATES_NONCE], 'affiliates-edit' ) ) { wp_die( esc_html__( 'Access denied.', 'affiliates' ) ); } $affiliates_table = _affiliates_get_tablename( 'affiliates' ); $affiliates_users_table = _affiliates_get_tablename( 'affiliates_users' ); $affiliate_id = isset( $_POST['affiliate-id-field'] ) ? $_POST['affiliate-id-field'] : null; $is_direct = false; $affiliate = null; if ( $affiliate = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $affiliates_table WHERE affiliate_id = %d", intval( $affiliate_id ) ) ) ) { $is_direct = isset( $affiliate->type ) && ( $affiliate->type == AFFILIATES_DIRECT_TYPE ); } if ( empty( $affiliate ) ) { wp_die( esc_html__( 'No such affiliate.', 'affiliates' ) ); } // field validation $name = isset( $_POST['name-field'] ) ? trim( $_POST['name-field'] ) : null; if ( empty( $name ) ) { $result['errors'][] = AFFILIATES_ADMIN_AFFILIATES_ERROR_NAME_EMPTY; } $login_valid = true; if ( !empty( $_POST['user-field'] ) ) { $login = trim( $_POST['user-field'] ); if ( !empty( $login ) ) { if ( !get_user_by( 'login', $login ) ) { $login_valid = false; $result['errors'][] = AFFILIATES_ADMIN_AFFILIATES_ERROR_USERNAME; } } } if ( !empty( $name ) && $login_valid ) { // Note the trickery (*) that has to be used because wpdb::prepare() is not // able to handle null values. // @see http://core.trac.wordpress.org/ticket/11622 // @see http://core.trac.wordpress.org/ticket/12819 $data = array( 'name' => $name ); $formats = array( '%s' ); $email = trim( $_POST['email-field'] ); if ( is_email( $email ) ) { $data['email'] = $email; $formats[] = '%s'; } else { $data['email'] = null; // (*) $formats[] = 'NULL'; // (*) } $from_date = $_POST['from-date-field']; if ( empty( $from_date ) ) { $from_date = date( 'Y-m-d', time() ); } else { $from_date = date( 'Y-m-d', strtotime( $from_date ) ); } $data['from_date'] = $from_date; $formats[] = '%s'; $thru_date = $_POST['thru-date-field']; if ( !empty( $thru_date ) && strtotime( $thru_date ) < strtotime( $from_date ) ) { // thru_date is before from_date => set to null $thru_date = null; } if ( !empty( $thru_date ) ) { $thru_date = date( 'Y-m-d', strtotime( $thru_date ) ); $data['thru_date'] = $thru_date; $formats[] = '%s'; } else { $data['thru_date'] = null; // (*) $formats[] = 'NULL'; // (*) } $status = $_POST['status']; $old_status = $affiliate->status; if ( empty( $status ) ) { $status = get_option( 'aff_status', 'active' ); } $data['status'] = $status; $formats[] = '%s'; $sets = array(); $values = array(); $j = 0; foreach ( $data as $key => $value ) { $sets[] = $key . ' = ' . $formats[$j]; if ( $value ) { // (*) $values[] = $value; } $j++; } if ( !empty( $sets ) ) { $sets = implode( ', ', $sets ); $values[] = intval( $affiliate_id ); $query = $wpdb->prepare( "UPDATE $affiliates_table SET $sets WHERE affiliate_id = %d", $values ); $wpdb->query( $query ); } // user association // delete old association if necessary $current_associated_user = $wpdb->get_row( $wpdb->prepare(" SELECT affiliate_id, user_id, user_login FROM $affiliates_users_table LEFT JOIN $wpdb->users ON $affiliates_users_table.user_id = $wpdb->users.ID WHERE affiliate_id = %d", intval( $affiliate_id ) ) ); $new_associated_user_login = trim( $_POST['user-field'] ); if ( ( empty( $new_associated_user_login ) && !empty( $current_associated_user ) ) || ( !empty( $current_associated_user ) && ( strcmp( $current_associated_user->user_login, $new_associated_user_login ) !== 0 ) ) ) { $wpdb->query( $wpdb->prepare( "DELETE FROM $affiliates_users_table WHERE affiliate_id = %d", intval( $affiliate_id ) ) ); } // new association if ( !empty( $affiliate_id ) && !empty( $new_associated_user_login ) && ( empty( $current_associated_user ) || ( !empty( $current_associated_user ) && ( strcmp( $current_associated_user->user_login, $new_associated_user_login ) !== 0 ) ) ) ) { $new_associated_user = get_user_by( 'login', $new_associated_user_login ); if ( !empty( $new_associated_user ) ) { if ( $wpdb->query( $wpdb->prepare( "INSERT INTO $affiliates_users_table SET affiliate_id = %d, user_id = %d", intval( $affiliate_id ), intval( $new_associated_user->ID ) ) ) ) { if ( empty( $email ) && !empty( $new_associated_user->user_email ) ) { $wpdb->query( $wpdb->prepare( "UPDATE $affiliates_table SET email = %s WHERE affiliate_id = %d", $new_associated_user->user_email, $affiliate_id ) ); } } } } // hook do_action( 'affiliates_updated_affiliate', intval( $affiliate_id ) ); if ( !empty( $status ) ) { do_action( 'affiliates_updated_affiliate_status', intval( $affiliate_id ), $old_status, $status ); } } return $result; } // function affiliates_admin_affiliates_edit_submit /** * Handle change bulk status to active * * @return array of updated affiliates' ids */ function affiliates_admin_affiliates_bulk_status_active_submit() { global $wpdb; $result = false; if ( !current_user_can( AFFILIATES_ADMINISTER_AFFILIATES ) ) { wp_die( __( 'Access denied.', 'affiliates' ) ); } if ( !wp_verify_nonce( $_POST[AFFILIATES_ADMIN_AFFILIATES_ACTION_NONCE], 'admin' ) ) { wp_die( __( 'Access denied.', 'affiliates' ) ); } $affiliates_table = _affiliates_get_tablename( 'affiliates' ); $affiliate_ids = isset( $_POST['affiliate_ids'] ) ? $_POST['affiliate_ids'] : null; if ( $affiliate_ids ) { foreach ( $affiliate_ids as $affiliate_id ) { // do not mark the pseudo-affiliate as deleted: type != ... $check = $wpdb->prepare( "SELECT affiliate_id FROM $affiliates_table WHERE affiliate_id = %d AND status != 'active' AND (type IS NULL OR type != %s)", intval( $affiliate_id ), AFFILIATES_DIRECT_TYPE ); if ( $wpdb->query( $check ) ) { if ( $affiliate = affiliates_get_affiliate( $affiliate_id ) ) { $old_status = $affiliate['status']; $result = false !== $wpdb->query( $wpdb->prepare( "UPDATE $affiliates_table SET status = 'active' WHERE affiliate_id = %d", intval( $affiliate_id ) ) ); if ( $result ) { do_action( 'affiliates_updated_affiliate', intval( $affiliate_id ) ); do_action( 'affiliates_updated_affiliate_status', intval( $affiliate_id ), $old_status, 'active' ); } unset( $affiliate ); } } unset( $check ); } } return $result; } // function affiliates_admin_affiliates_bulk_status_active_submit /** * Handle change bulk status to pending * * @return array of updated affiliates' ids */ function affiliates_admin_affiliates_bulk_status_pending_submit() { global $wpdb; $result = false; if ( !current_user_can( AFFILIATES_ADMINISTER_AFFILIATES ) ) { wp_die( __( 'Access denied.', 'affiliates' ) ); } if ( !wp_verify_nonce( $_POST[AFFILIATES_ADMIN_AFFILIATES_ACTION_NONCE], 'admin' ) ) { wp_die( __( 'Access denied.', 'affiliates' ) ); } $affiliates_table = _affiliates_get_tablename( 'affiliates' ); $affiliate_ids = isset( $_POST['affiliate_ids'] ) ? $_POST['affiliate_ids'] : null; if ( $affiliate_ids ) { foreach ( $affiliate_ids as $affiliate_id ) { // do not mark the pseudo-affiliate as deleted: type != ... $check = $wpdb->prepare( "SELECT affiliate_id FROM $affiliates_table WHERE affiliate_id = %d AND status != 'pending' AND (type IS NULL OR type != %s)", intval( $affiliate_id ), AFFILIATES_DIRECT_TYPE ); if ( $wpdb->query( $check ) ) { if ( $affiliate = affiliates_get_affiliate( $affiliate_id ) ) { $old_status = $affiliate['status']; $result = false !== $wpdb->query( $wpdb->prepare( "UPDATE $affiliates_table SET status = 'pending' WHERE affiliate_id = %d", intval( $affiliate_id ) ) ); if ( $result ) { do_action( 'affiliates_updated_affiliate', intval( $affiliate_id ) ); do_action( 'affiliates_updated_affiliate_status', intval( $affiliate_id ), $old_status, 'pending' ); } unset( $affiliate ); } } unset( $check ); } } return $result; } // function affiliates_admin_affiliates_bulk_status_pending_submit