| select | |
| p.ID as order_id, | |
| p.post_date, | |
| max( CASE WHEN pm.meta_key = '_billing_email' and p.ID = pm.post_id THEN pm.meta_value END ) as billing_email, | |
| max( CASE WHEN pm.meta_key = '_billing_first_name' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_first_name, | |
| max( CASE WHEN pm.meta_key = '_billing_last_name' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_last_name, | |
| max( CASE WHEN pm.meta_key = '_billing_address_1' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_address_1, | |
| max( CASE WHEN pm.meta_key = '_billing_address_2' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_address_2, | |
| max( CASE WHEN pm.meta_key = '_billing_city' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_city, | |
| max( CASE WHEN pm.meta_key = '_billing_state' and p.ID = pm.post_id THEN pm.meta_value END ) as _billing_state, |
| <?php | |
| /* | |
| Plugin Name: Custom Image Sizes for WooCommerce | |
| Plugin URI: https://themebynumbers.com/ | |
| Description: Let's you customize WooCommerce product image sizes from the Customizer | |
| Version: 0.1 | |
| Author: Mikey Arce | |
| Author URI: https://themebynumbers.com | |
| Text Domain: custom_image_sizes_for_wc | |
| Domain Path: /languages |
| if(version_compare(get_option( 'woocommerce_version' ),"3.5.2","<=") && version_compare(get_bloginfo( 'version' ),"5.0.2","=") ){ | |
| function fix_request_query_args_for_woocommerce( $query_args ) { | |
| if ( isset( $query_args['post_status'] ) && empty( $query_args['post_status'] ) ) { | |
| unset( $query_args['post_status'] ); | |
| } | |
| return $query_args; | |
| } | |
| add_filter( 'request', 'fix_request_query_args_for_woocommerce', 1, 1 ); | |
| } |
| function cs_super_admin_access(){ | |
| if ( ! defined( 'DOING_AJAX' ) && ! is_super_admin () ) { | |
| wp_redirect( home_url() ); | |
| die(); | |
| } | |
| } | |
| add_action( 'admin_init', 'cs_super_admin_access', 1 ); |
| /* https://www.mootpoint.org/blog/woocommerce-make-uk-county-field-required/ for an excellent description on why this filter. */ | |
| add_filter( 'woocommerce_get_country_locale', 'mp_change_locale_field_defaults'); | |
| function mp_change_locale_field_defaults($countries) { | |
| //swap 'RO' for your country ID. | |
| $countries['RO']['state']['required'] = true; | |
| //set custom field label | |
| $countries['RO']['state']['label'] = ''; |
| //output with add to cart button on product detail page | |
| add_action( 'woocommerce_after_add_to_cart_form', 'custom_notice_for_backorders_allowed' ); | |
| function custom_notice_for_backorders_allowed() | |
| { | |
| //instantinate product object | |
| global $product; | |
| //check if backorders are allowed | |
| if ( $product->backorders_allowed() ) |
| <?php //only copy if needed | |
| //filter documented at: https://docs.woocommerce.com/document/woocommerce-pdf-product-vouchers-developer-documentation/#wc_pdf_product_vouchers_voucher_filename | |
| add_filter('wc_pdf_product_vouchers_voucher_filename', 'cs_my_own_filename'); | |
| function cs_my_own_filename ($filename) { | |
| // This is how the variable is defined: $filename = 'voucher-' . sanitize_file_name( $this->get_voucher_number() ) . '.' . $type; | |
| // Note: $type may be defined as string. Default $type = 'pdf'; | |
| // Note: Do not use this filter to change the number. There are other filters for that. | |
| <?php | |
| // use of function has_term( 'slug', 'taxonomy_name', $post->ID ); | |
| // taxonomy_name for example: Visibility | |
| // slug for example: visible | |
| // $post->ID = current post | |
| $terms = has_term( 'intern', 'artikel_typ', $post->ID ); | |
| if($terms) | |
| { |
This document lists all the situations where WordPress sends an email, along with how to filter or disable each email.
This is accurate as of WordPress 4.8, and includes some upcoming changes in WordPress 4.9.
There are a few TODOs left. Please bear with me.
| #!/bin/bash | |
| # Usage: ./update-mysql56.sh | |
| # Backup of all databases... JUST IN CASE | |
| mysqldump --all-databases --single-transaction --events --user=root --password > ~/all_database_backup.sql | |
| # Remove MySQL 5.5 | |
| sudo apt-get remove mysql-server | |
| sudo apt-get autoremove |
