alexx855

-- ALL SUBSCRIBERS WITH AN ORDER COMPLETED
SELECT 
    u.ID, um.meta_value AS user_role, COALESCE(COUNT(p.ID), 0) AS completed_orders
FROM wp_users AS u JOIN wp_usermeta AS um ON u.ID = um.user_id 
	LEFT JOIN wp_postmeta AS pm ON pm.meta_value = um.user_id  
    LEFT JOIN wp_posts AS p ON p.ID = pm.post_id 
WHERE um.meta_key = 'wp_capabilities'
    AND um.meta_value LIKE '%subscriber%' 
    AND um.meta_value NOT LIKE '%administrator%'
    AND pm.meta_key = '_customer_user'

alexx855

install deps

sudo apt-get install jpegoptim
sudo apt-get install optipng

change ./ for your images folder

find ./ -type f -iname *.png -print0 | xargs -0 optipng -nc -nb -o7
find ./ -type f -iname *.jpeg -exec jpegoptim --max=70 --all-progressive -p {} \;

alexx855

function onFormSubmit( e ) {
	const values = e.namedValues;

	//e.values is an array of form values
	const fecha = e.values[ 0 ];
	const email = e.values[ 1 ];

	//file is the template file, and you get it by ID
	const file = DriveApp.getFileById(
		'FILE_ID'

alexx855

<?php

// Add the custom columns to the book post type:
add_filter( 'manage_book_posts_columns', 'set_custom_edit_book_columns' );
function set_custom_edit_book_columns($columns) {
    unset( $columns['author'] );
    $columns['book_author'] = __( 'Author', 'your_text_domain' );
    $columns['publisher'] = __( 'Publisher', 'your_text_domain' );

    return $columns;

alexx855

<?php 

add_action( 'wp_enqueue_scripts', function() {
  // Register the script
  wp_register_script('ajax-script', get_template_directory_uri() . '/js/my-ajax-script.js', ['jquery']);
  // Localize the script with new data
  wp_localize_script('ajax-script', 'my_ajax_object', ['ajax_url' => admin_url( 'admin-ajax.php' )]);
  // Enqueued script with localized data.
  wp_enqueue_script('ajax-script');
});

alexx855

<?php 

function switch_page_template() {
    global $post;
    // Checks if current post type is a page, rather than a post
  if (is_page())
  { 
    // Checks if page is parent, if yes, return
    if ($post->post_parent == 0)

alexx855

<?php 

add_action( '{taxonomy}_add_form_fields', 'add_feature_group_field', 10, 2 );
function add_feature_group_field($taxonomy) {
    global $meta_name;
    ?>

    <div class="form-field">
      <label for="meta_name">Meta Name</label>
      <input name="meta_name" id="meta_name" type="text" value="<?php echo $meta_name; ?>" size="40" aria-required="true">

alexx855

<?php 

add_filter( 'wp_nav_menu_items', 'your_custom_menu_item', 10, 2 );
function your_custom_menu_item ( $items, $args ) {
    if (is_single() && $args->theme_location == 'primary') {
        $items .= '<li>Show whatever</li>';
    }
    return $items;
}