Timothy Wood codearachnid

## gravity-forms-select-optgroupify.php
<?php
/**
 * Filter for GravityForms to group select field choices by a special "optgroup" choice.
 *
 * Simply add a new choice with a value of 'optgroup' to the dropdown to start a group of options.
 * All following choices will be grouped under it using its label for the group.
 * Any number of groups can be created, as each optgroup choice will start a new group.
 * Supports field placeholder & ungrouped options, but must be before the first group.
 *
 * This snippet can be added to your theme's functions.php, or a custom plugin.

## deny-giant-image-uploads.php
<?php
/**
 * Plugin Name: Deny Giant Image Uploads
 * Description: Prevents Uploads of images greater than 3.2MP
 * Author: TJNowell
 * Author URI: http://tomjn.com
 * Plugin URI: http://tomjn.com/164/clients-who-upload-huge-camera-photos-decompression-bombs/
 * Version: 1.1
 */

## README.md

      
              1 file
            
          
              36 forks
            
          
              1 comment
            
          
              120 stars
            
          
                magnetikonline
                / README.md
            
            
              Last active
              April 28, 2023 16:06
            
              
                WordPress assorted database clean up SQL queries.
              
          
    WordPress database clean up queries


Orphan rows

wp_posts -> wp_posts (parent/child)
wp_postmeta -> wp_posts
wp_term_taxonomy -> wp_terms
wp_term_relationships -> wp_term_taxonomy
wp_usermeta -> wp_users
wp_posts -> wp_users


Other


## array-insert-after.php
<?php

/**
 * Insert a value or key/value pair after a specific key in an array.  If key doesn't exist, value is appended
 * to the end of the array.
 *
 * @param array $array
 * @param string $key
 * @param array $new
 *

## gist:2204864
Hi
I hope this helps you all get started with phonegap and sqlite in your
application

Dean-O

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>

## MySQL_zipcodes_within_radius.sql
/* Given table 'zipcodes' with columns:
   zipcode, latitude, longitude.
   Find zipcodes within radius from given zipcode.
   EXAMPLE:
   Coordinates for zip 91326 and radius 25 mi:
*/
SET @location_lat = 34.2766,
    @location_lon = -118.544;

SELECT zipcode, ( 3959 * acos( cos( radians(@location_lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(@location_lon) ) + sin( radians(@location_lat) ) * sin( radians( latitude ) ) ) ) AS distance

## gw-gravity-forms-unrequire-required-fields-usage.php
<?php

# Basic Usage
#   requires that the user be logged in as an administrator and that a 'gwunrequire' parameter be added to the query string
#   http://youurl.com/your-form-page/?gwunrequire=1
new GWUnrequire();

# Enable for All Users (Including Visitors)
#   still requires the 'gwunrequire' parameter be added to the query string
new GWUnrequire( array(

## cls.js
/**
 * cache script and css to localStorage (same domain only)
 *
 * $CLS.style("a.css");
 *
 * $CLS.script("jquery-1.5.2.min.js").wait()
 *     .script("a.js")
 *     .script("b.js")
 *     .script("c.js")
 *     .wait(function() {

## ko.utils.signatures.js
// knockout 2.2.1

ko.utils.arrayFilter                            = function (array, predicate) { /* .. */ }

ko.utils.arrayFirst                             = function (array, predicate, predicateOwner) { /* .. */ }

ko.utils.arrayForEach                           = function (array, action) { /* .. */ }

ko.utils.arrayGetDistinctValues                 = function (array) { /* .. */ }

## gist:6182904
<?php
/**
 * WooCommerce Extra Feature
 * --------------------------
 *
 * Add custom fee to cart automatically
 *
 */
function woo_add_cart_fee() {
	<?php
	/**
	* Filter for GravityForms to group select field choices by a special "optgroup" choice.
	*
	* Simply add a new choice with a value of 'optgroup' to the dropdown to start a group of options.
	* All following choices will be grouped under it using its label for the group.
	* Any number of groups can be created, as each optgroup choice will start a new group.
	* Supports field placeholder & ungrouped options, but must be before the first group.
	*
	* This snippet can be added to your theme's functions.php, or a custom plugin.
	<?php
	/**
	* Plugin Name: Deny Giant Image Uploads
	* Description: Prevents Uploads of images greater than 3.2MP
	* Author: TJNowell
	* Author URI: http://tomjn.com
	* Plugin URI: http://tomjn.com/164/clients-who-upload-huge-camera-photos-decompression-bombs/
	* Version: 1.1
	*/
	Hi
	I hope this helps you all get started with phonegap and sqlite in your
	application

	Dean-O

	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
	"http://www.w3.org/TR/html4/strict.dtd">
	<html>
	<head>
	/* Given table 'zipcodes' with columns:
	zipcode, latitude, longitude.
	Find zipcodes within radius from given zipcode.
	EXAMPLE:
	Coordinates for zip 91326 and radius 25 mi:
	*/
	SET @location_lat = 34.2766,
	@location_lon = -118.544;

	SELECT zipcode, ( 3959 * acos( cos( radians(@location_lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(@location_lon) ) + sin( radians(@location_lat) ) * sin( radians( latitude ) ) ) ) AS distance
	<?php

	# Basic Usage
	# requires that the user be logged in as an administrator and that a 'gwunrequire' parameter be added to the query string
	# http://youurl.com/your-form-page/?gwunrequire=1
	new GWUnrequire();

	# Enable for All Users (Including Visitors)
	# still requires the 'gwunrequire' parameter be added to the query string
	new GWUnrequire( array(
	/**
	* cache script and css to localStorage (same domain only)
	*
	* $CLS.style("a.css");
	*
	* $CLS.script("jquery-1.5.2.min.js").wait()
	* .script("a.js")
	* .script("b.js")
	* .script("c.js")
	* .wait(function() {
	// knockout 2.2.1

	ko.utils.arrayFilter = function (array, predicate) { /* .. */ }

	ko.utils.arrayFirst = function (array, predicate, predicateOwner) { /* .. */ }

	ko.utils.arrayForEach = function (array, action) { /* .. */ }

	ko.utils.arrayGetDistinctValues = function (array) { /* .. */ }
	<?php
	/**
	* WooCommerce Extra Feature
	* --------------------------
	*
	* Add custom fee to cart automatically
	*
	*/
	function woo_add_cart_fee() {