latompa

-- I had an existing products table, and needed to denormalize two fields for faster sorting.
-- The number of rates and total rating is currently in a ratings table, and needs to be copied to products

create table products (
 id integer, 
 name varchar(16), 
 ratings_count integer,
 total_rating integer
);

latompa

-- building on data from my scenario http://gist.github.com/44489
-- and bayesian rating http://www.thebroth.com/blog/118/bayesian-rating

assume we have a products table and we want to sort products based on their rating.
With bayesian rating, you get better weighting, so that a single 5 star vote won't show up as "top product"

select * from products;
mysql> select * from products;
+------+--------+---------------+--------------+---------+
| id   | name   | ratings_count | total_rating | weight  |

mikeschinkel

<?php
/*
    PostsByTaxonomy class that extends WP_Query and filters to includes all posts that have any term of a taxonomy.

    Author: Mike Schinkel (http://mikeschinkel.com)

    This example works, just drop into the root of your website and call directly.
    Use the class in your plugins or themes.

    See: 

johnmegahan

<?php

add_action( 'after_setup_theme', 'bootstrap_setup' );

if ( ! function_exists( 'bootstrap_setup' ) ):

	function bootstrap_setup(){

		add_action( 'init', 'register_menu' );
			

luetkemj

// This gist is now maintained on github at https://github.com/luetkemj/wp-query-ref

<?php
/**
* WordPress Query Comprehensive Reference
* Compiled by luetkemj - luetkemj.github.io
*
* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters
* Source: https://core.trac.wordpress.org/browser/tags/4.9.4/src/wp-includes/query.php
*/

setola

<?php

/**
 * Extended Walker class for use with the
 * Twitter Bootstrap toolkit Dropdown menus in Wordpress.
 * Edited to support n-levels submenu.
 * @author johnmegahan https://gist.github.com/1597994, Emanuele 'Tex' Tessore https://gist.github.com/3765640
 * @license CC BY 4.0 https://creativecommons.org/licenses/by/4.0/
 */
class BootstrapNavMenuWalker extends Walker_Nav_Menu {

justintadlock

<?php

# Register custom post types on the 'init' hook.
add_action( 'init', 'my_register_post_types' );

/**
 * Registers post types needed by the plugin.
 *
 * @since  1.0.0
 * @access public

ndarville

Grab ffmpeg from https://www.ffmpeg.org/download.html

It's a command line tool which means you will have to type things with your keyboard instead of clicking on buttons.

The most trivial operation would be converting gifs:

ffmpeg -i your_gif.gif -c:v libvpx -crf 12 -b:v 500K output.webm

• -crf values can go from 4 to 63. Lower values mean better quality.
• -b:v is the maximum allowed bitrate. Higher means better quality.

lesterchan

.color-pinterest {
	color: #cb2027;
}
.color-facebook {
	color: #3b5998;
}
.color-twitter {
	color: #00aced;
}
.color-vimeo {

lesterchan

<?php
/**
 * Delete revisions from WordPress
 */
define( 'WP_USE_THEMES', false );
if( ! empty( $_SERVER['WP_DIR'] ) ) {
	require( $_SERVER['WP_DIR'] . '/wp-blog-header.php' );
} elseif( is_file( 'wp-blog-header.php' ) ) {
	require( 'wp-blog-header.php' );
} else {