dboutote’s gists

## get-posts.php
<ul>
    <?php
    global $post;
    $args = array( 'numberposts' => 5, 'post_type' => 'article' );
    $myposts = get_posts( $args );
    foreach( $myposts as $post ) :
        setup_postdata($post); ?>
        <li>
            <a href="<?php the_permalink(); ?>"><?php the_title(); ?></a><br />
            <?php the_excerpt();?>

## instagram-scraper.php
<?php

/**
 *  Instagram scraper
 *
 *  Quick and dirty Instragram scraper for displaying a Instagram feed.
 *
 *  Based on : https://gist.github.com/cosmocatalano/4544576
 *
 *  @param string $username  Instagram user account

## shortcode.js
jQuery(document).ready(function($) {

	tinymce.create( 'tinymce.plugins.dbdb_social_button', {

        /**
         *  Initializes the plugin, this will be executed after the plugin has been created.
         *  This call is done before the editor instance has finished its initialization so use the onInit event
         *  of the editor instance to intercept that event.
         *
         *  @param {tinymce.Editor} ed  Editor instance that the plugin is initialized in.

## filter_acatw_allowed_taxonomies.php
<?php
/**
 *  This will ADD a custom taxonomy to the allowed taxonomies used by the widget
 * */
function filter_acatw_allowed_taxonomies( $taxonomies ){

    $taxonomies['project_category']= 'Project Categories';

    return $taxonomies;
}

## hide-wp-status-links.php
<?php
	function _dbdb_wp_count_posts( $counts, $type, $perm ) {
		global $pagenow;

		if( 'edit.php' !== $pagenow ){
			return $counts;
		}

		if( current_user_can( 'manage_options' ) ){
			return $counts;

## random-post-tags.php
<?php
	$args = array(
		'taxonomy'   => 'post_tag',
		'hide_empty' => 0
	);
	$tags = get_terms( $args );
	$class_name = 'my-custom-class-name';

	if ( ! empty( $tags ) && ! is_wp_error( $tags ) ) {
		shuffle( $tags );

## bootstrap-link-pages.php
<?php
function bootstrap_link_pages( $args = '' ) {

	$defaults = array(
		'before'           => '<p>' . __( 'Pages:' ),
		'after'            => '</p>',
		'link_before'      => '',
		'link_after'       => '',
		'next_or_number'   => 'number',
		'nextpagelink'     => __( 'Next page' ),

## resize-div-on-keyup.js
(function ($) {

    'use strict';

	function change_avatar_div( e ){
		var field = $(e.currentTarget);
		var acw_avatar_div = field.closest('.acw-thumb-size-wrap').find('.acw-avatar');

		if( acw_avatar_div.length ) {
			var icon = $( '.acw-icon', acw_avatar_div);

## recent-grouped-comments.sql
SELECT c.*
FROM `dbdb`.`wp_comments` c
LEFT JOIN `dbdb`.`wp_comments` c2 ON c.comment_post_ID = c2.comment_post_ID AND c.comment_date_gmt < c2.comment_date_gmt
JOIN `dbdb`.`wp_posts` ON `dbdb`.`wp_posts`.ID = c.comment_post_ID
WHERE c2.comment_date_gmt is NULL
AND ( c.comment_approved = '1' )
AND c.comment_type NOT IN ('pingback', 'trackback')
AND  `dbdb`.`wp_posts`.post_status IN ('publish')
AND  `dbdb`.`wp_posts`.post_type IN ('post')
ORDER BY c.comment_date_gmt DESC

## group-recent-comment.sql
SELECT c.comment_ID
FROM wp_comments c
JOIN
( SELECT wp_comments.comment_post_ID, max(wp_comments.comment_date_gmt) maxDate
  FROM wp_comments
  GROUP BY wp_comments.comment_post_ID
) c2
ON c.comment_date_gmt = c2.maxDate AND c.comment_post_ID = c2.comment_post_ID
JOIN wp_posts
ON wp_posts.ID = c.comment_post_ID