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 ) { if ( current_user_can( 'edit_user', $affiliate_user->ID ) ) { $affiliate_user_edit = sprintf( __( 'Edit %s', 'affiliates' ) , 'ID" ) . '">' . $affiliate_user->user_login . '' ); } else { $affiliate_user_edit = $affiliate_user->user_login; } } } $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 ); $output = '
' . '
' . '

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

' . '
' . '
' . '
' . '' . '
    ' . '
  • ' . sprintf( esc_html__( 'Name : %s', 'affiliates' ), wp_filter_kses( $affiliate['name'] ) ) . '
    • ' . '
  • ' . sprintf( esc_html__( 'Email : %s', 'affiliates' ), wp_filter_kses( $affiliate['email'] ) ) . '
    • ' . '
  • ' . sprintf( esc_html__( 'Username : %s', 'affiliates' ), wp_filter_kses( $affiliate_user_edit ) ) . '
    • ' . '
  • ' . sprintf( esc_html__( 'From : %s', 'affiliates' ), wp_filter_kses( $affiliate['from_date'] ) ) . '
    • ' . '
  • ' . sprintf( esc_html__( 'Until : %s', 'affiliates' ), wp_filter_kses( $affiliate['from_date'] ) ) . '
    • ' . '
' . wp_nonce_field( 'affiliates-remove', AFFILIATES_ADMIN_AFFILIATES_NONCE, true, false ) . '' . '' . ' ' . '' . esc_html__( 'Cancel', 'affiliates' ) . '' . '
' . '
' . // .affiliate.remove '' . ''; // .manage-affiliates echo $output; affiliates_footer(); } // function affiliates_admin_affiliates_remove /** * Handle remove form submission. */ function affiliates_admin_affiliates_remove_submit() { global $wpdb; $result = false; if ( !current_user_can( AFFILIATES_ADMINISTER_AFFILIATES ) ) { wp_die( esc_html__( 'Access denied.', 'affiliates' ) ); } if ( !wp_verify_nonce( $_POST[AFFILIATES_ADMIN_AFFILIATES_NONCE], 'affiliates-remove' ) ) { wp_die( esc_html__( 'Access denied.', 'affiliates' ) ); } $affiliates_table = _affiliates_get_tablename( 'affiliates' ); $affiliate_id = isset( $_POST['affiliate-id-field'] ) ? $_POST['affiliate-id-field'] : null; if ( $affiliate_id ) { $valid_affiliate = false; // do not mark the pseudo-affiliate as deleted: type != ... $check = $wpdb->prepare( "SELECT affiliate_id FROM $affiliates_table WHERE affiliate_id = %d AND (type IS NULL OR type != '" . AFFILIATES_DIRECT_TYPE . "')", intval( $affiliate_id ) ); if ( $wpdb->query( $check ) ) { $valid_affiliate = true; } if ( $valid_affiliate ) { $result = false !== $wpdb->query( $query = $wpdb->prepare( "UPDATE $affiliates_table SET status = 'deleted' WHERE affiliate_id = %d", intval( $affiliate_id ) ) ); do_action( 'affiliates_deleted_affiliate', intval( $affiliate_id ) ); } } return $result; } // function affiliates_admin_affiliates_remove_submit /** * Shows form to confirm bulk-removal of affiliates. */ function affiliates_admin_affiliates_bulk_remove() { global $wpdb; if ( !current_user_can( AFFILIATES_ADMINISTER_AFFILIATES ) ) { wp_die( esc_html__( 'Access denied.', 'affiliates' ) ); } $affiliate_ids = isset( $_POST['affiliate_ids'] ) ? $_POST['affiliate_ids'] : null; $affiliates = array(); foreach ( $affiliate_ids as $affiliate_id ) { $affiliate = affiliates_get_affiliate( intval( $affiliate_id ) ); if ( $affiliate ) { $affiliates[] = $affiliate; } } if ( count( $affiliates ) === 0 ) { wp_die( esc_html__( 'There are no affiliates.', 'affiliates' ) ); } $affiliates_users_table = _affiliates_get_tablename( 'affiliates_users' ); $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 ); $output = '
' . '
' . '

' . esc_html__( 'Remove affiliates', 'affiliates' ) . '

' . '
' . '
'; $output .= '

'; $output .= esc_html__( 'Please confirm removal of the following affiliates. This action cannot be undone.', 'affiliates' ); $output .= '

'; $output .= '
'; foreach ( $affiliates as $affiliate ) { $output .= ''; $affiliate_user_edit = ''; $affiliate_user_id = $wpdb->get_var( $wpdb->prepare( "SELECT user_id FROM $affiliates_users_table WHERE affiliate_id = %d", intval( $affiliate['affiliate_id'] ) ) ); if ( $affiliate_user_id !== null ) { $affiliate_user = get_user_by( 'id', intval( $affiliate_user_id ) ); if ( $affiliate_user ) { $affiliate_user_edit = $affiliate_user->user_login; } } $output .= '
    ' . '
  • ' . sprintf( esc_html__( 'Name : %s', 'affiliates' ), wp_filter_kses( $affiliate['name'] ) ) . '
    • ' . '
  • ' . sprintf( esc_html__( 'Email : %s', 'affiliates' ), wp_filter_kses( $affiliate['email'] ) ) . '
    • ' . '
  • ' . sprintf( esc_html__( 'Username : %s', 'affiliates' ), wp_filter_kses( $affiliate_user_edit ) ) . '
    • ' . '
  • ' . sprintf( esc_html__( 'From : %s', 'affiliates' ), wp_filter_kses( $affiliate['from_date'] ) ) . '
    • ' . '
  • ' . sprintf( esc_html__( 'Until : %s', 'affiliates' ), wp_filter_kses( $affiliate['from_date'] ) ) . '
    • ' . '
'; $output .= '
'; } $output .= ''; $output .= ''; $output .= ''; $output .= wp_nonce_field( 'admin', AFFILIATES_ADMIN_AFFILIATES_ACTION_NONCE, true, false ) . '' . ' ' . '' . esc_html__( 'Cancel', 'affiliates' ) . '' . '
' . '
' . // .affiliate.remove '' . ''; // .manage-affiliates echo $output; affiliates_footer(); } // function affiliates_admin_affiliates_bulk_remove /** * Handle remove form submission. * * @return array of deleted affiliates' ids */ function affiliates_admin_affiliates_bulk_remove_submit() { global $wpdb; $result = false; if ( !current_user_can( AFFILIATES_ADMINISTER_AFFILIATES ) ) { wp_die( esc_html__( 'Access denied.', 'affiliates' ) ); } if ( !wp_verify_nonce( $_POST[AFFILIATES_ADMIN_AFFILIATES_ACTION_NONCE], 'admin' ) ) { wp_die( esc_html__( '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 ) { $valid_affiliate = false; // do not mark the pseudo-affiliate as deleted: type != ... $check = $wpdb->prepare( "SELECT affiliate_id FROM $affiliates_table WHERE affiliate_id = %d AND (type IS NULL OR type != '" . AFFILIATES_DIRECT_TYPE . "')", intval( $affiliate_id ) ); if ( $wpdb->query( $check ) ) { $valid_affiliate = true; } if ( $valid_affiliate ) { $result = false !== $wpdb->query( $query = $wpdb->prepare( "UPDATE $affiliates_table SET status = 'deleted' WHERE affiliate_id = %d", intval( $affiliate_id ) ) ); do_action( 'affiliates_deleted_affiliate', intval( $affiliate_id ) ); } } } return $result; } // function affiliates_admin_affiliates_bulk_remove_submit