Skip to content

Instantly share code, notes, and snippets.


Patrick PegWeb

View GitHub Profile
mikaelz / delete-all-woocommerce-products.php
Last active Nov 20, 2021
Remove all WooCommerce products from database via SQL
View delete-all-woocommerce-products.php
require dirname(__FILE__).'/wp-blog-header.php';
$wpdb->query("DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%')");
$wpdb->query("DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%'");
$wpdb->query("DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy)");
$wpdb->query("DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
$wpdb->query("DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
$wpdb->query("DELETE FROM wp_posts WHERE post_type IN ('product','product_variation')");
stevewithington / recaptcha.cfc
Created Dec 4, 2014
Google ReCAPTCHA v2 for ColdFusion / Railo / CFML. See for example usage.
View recaptcha.cfc
* This is a CFML library that handles calling reCAPTCHA.
* - Documentation and latest version
* - Get a reCAPTCHA API Key
* - Discussion group
* @copyright Copyright (c) 2014, Stephen J. Withington, Jr.
woogist / functions.php
Last active May 14, 2021
Redirect to a custom page after login based on the user role
View functions.php
* Redirect users to custom URL based on their role after login
* @param string $redirect
* @param object $user
* @return string
function wc_custom_user_redirect( $redirect, $user ) {
// Get the first of all the roles assigned to the user
BFTrick / woocommerce-email-new-address.php
Last active Nov 3, 2021
Email the site admin when a customer changes their address
View woocommerce-email-new-address.php
* Plugin Name: WooCommerce Email Customer Address
* Plugin URI:
* Description: Email the site admin when a customer changes their address
* Author: Patrick Rauland
* Author URI:
* Version: 1.0.1
* This program is free software: you can redistribute it and/or modify
jsteenkamp / upload.cfc
Created Jul 30, 2011
ColdFusion code for Plupload file uploading including chunked transfers
View upload.cfc
<cffunction name="upload" access="remote" returntype="struct" returnformat="json" output="false">
var uploadDir = expandPath('.') & '/uploads/'; // should be a temp directory that you clear periodically to flush orphaned files
var uploadFile = uploadDir & arguments.NAME;
var response = {'result' = arguments.NAME, 'id' = 0};
var result = {};
// if chunked append chunk number to filename for reassembly
if (structKeyExists(arguments, 'CHUNKS')){