kurtschlatzer

Bootstrap 4 menus in WordPress with filters

No walker needed!

This snippet allows you to create Bootstrap 4 menus without the use of a Walker. Instead, we're using filters to leverage WordPress core functionality as much as possible. Basically, all you need to do is this and you're done:

<nav class="navbar navbar-expand-lg fixed-top">
  <div class="container">
    <a class="navbar-brand" href="<?php echo home_url(); ?>">

kurtschlatzer

<?php

add_filter( 'get_user_metadata', 'mtkdocs_filter_user_metadata', 10, 4 );
function mtkdocs_filter_user_metadata( $value, $object_id, $meta_key, $single ) {
    // Check if it's one of the keys we want to filter
    if ( in_array( $meta_key, array( '_money_spent', '_order_count' ) ) ) {
        // Return 0 so WC doesn't try calculate it
        return 0;
    }
    // Default

kurtschlatzer

<?php
/**
 * WordPress menu cache.
 *
 * @package BJ\Menu
 * @author bjornjohansen
 * @version 0.1.0
 * @license https://www.gnu.org/licenses/old-licenses/gpl-2.0.html  GNU General Public License version 2 (GPLv2)
 */

kurtschlatzer

# GET number of orders 
select count(*)from wp_posts where post_type = 'shop_order';

# DELETE ORDERS
delete from wp_postmeta where post_id in (
select ID from wp_posts where post_type = 'shop_order');
delete from wp_posts where post_type = 'shop_order';

# DELETE order refunds

kurtschlatzer

## Delete duplicate WooCommerce products

## (Retains the lowest ID)
## Pro tip: Change to SELECT to test
DELETE bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MIN(id) as min_id
from wp_posts
where post_type = 'product'

kurtschlatzer

# First Attempt, seemed to have worked
SELECT DISTINCT(p.ID), p.post_title, p.post_content FROM `wp_posts` p
LEFT JOIN wp_posts im ON p.ID = im.post_parent AND im.post_type = "attachment" 
WHERE p.post_status ='publish' 
AND p.post_type = "product" 
AND im.ID IS NULL
AND p.post_content NOT REGEXP 'src=".*"' 

# This works well with woocommerce products.
# Fast

kurtschlatzer

/**
 * USE AT YOUR OWN RISK!
 *
 * In no way do I guarantee the accuracy of these queries to do exactly what you want on your own server.
 * I have written them down for my own personal record, and you are free to use at your own discretion,
 * and provide corrections.
 */

/** 
 * 1. Delete order and coupon meta data.

kurtschlatzer

// PHP snippet included in wp-config.php (or settings.php).
// Including from that location in a separate file is OK as well.

<?php
// Remove any leading "www." from the host name.
$redirect_host = str_replace('www.', '', $_SERVER['HTTP_HOST']);
$redirect_path = strtolower(rtrim($_SERVER['REQUEST_URI']));
if (strlen($redirect_path) > 2) {
  $redirect_path = rtrim($redirect_path, '/');
}

kurtschlatzer

<input type="submit" class="button" name="clear-cart" value="<?php _e('Empty Cart', 'woocommerce'); ?>" />

kurtschlatzer

$subdomains = ['atlanta', 'berkeley', 'columbus'];

foreach ($subdomains as $subdomain) {

if (isset($_ENV['PANTHEON_ENVIRONMENT']) &&
($_SERVER['HTTP_HOST'] == $subdomain . '.yoursite.com') &&
// Check if Drupal or WordPress is running via command line
(php_sapi_name() != "cli")) {
$newurl = 'http://www.yoursite.com/' . $subdomain . '/'. $_SERVER['REQUEST_URI'];
header('HTTP/1.0 301 Moved Permanently');