abecoffman

SELECT count(*) AS 'TotalCount', wp_terms.name
FROM wp_terms
	INNER JOIN wp_term_relationships
		ON wp_term_relationships.term_taxonomy_id = wp_terms.term_id
	INNER JOIN wp_term_taxonomy
		ON wp_term_taxonomy.term_id = wp_terms.term_id AND wp_term_taxonomy.taxonomy = 'post_tag'
GROUP BY wp_terms.name
ORDER BY TotalCount DESC

abecoffman

SSL upgrades on rubygems.org and RubyInstaller versions

UPDATE 2014-12-21: RubyGems 1.8.30, 2.0.15 and 2.2.3 have been released. It requires manual installation, please see instructions below.

---

Hello,

If you reached this page, means you've hit this SSL error when trying to

abecoffman

SELECT * FROM wp_posts
  LEFT JOIN wp_term_relationships ON(wp_posts.ID = wp_term_relationships.object_id)
  LEFT JOIN wp_term_taxonomy ON(wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
  LEFT JOIN wp_terms ON(wp_terms.term_id = wp_term_taxonomy.term_id)
  WHERE wp_terms.name = 'CATEGORY_NAME'
  AND wp_term_taxonomy.taxonomy = 'category'
  AND wp_posts.post_status = 'publish'
  AND wp_posts.post_type = 'post'

abecoffman

/*!
 * $.preload() function for jQuery – http://mths.be/preload
 * Preload images, CSS and JavaScript files without executing them
 * Script by Stoyan Stefanov – http://www.phpied.com/preload-cssjavascript-without-execution/
 * Slightly rewritten by Mathias Bynens – http://mathiasbynens.be/
 * Note that since this script relies on jQuery, the preloading process will not start until jQuery has finished loading.
 */

jQuery.preload = function(array) {
	var length = array.length,

abecoffman

function subArray() {
    this.push.apply(this, arguments);
};

subArray.prototype = [];

var sub = new subArray(1,2,3);

alert(sub.length);  // 3

abecoffman

<?php

if ( function_exists( 'add_theme_support' ) ) {
  add_theme_support( 'post-thumbnails' );
}

function the_facebook_graph_data() {
  // setup the default site attributes
  $graph;
  $graph["site_name"] = "YOUR_SITE_NAME";

abecoffman

window.fbAsyncInit = function() {
  FB.init({appId: 'YOUR_APP_ID', status: true,
           cookie: true, xfbml: true});
};

abecoffman

<?php

function facebook_namespaces($attr) {
  $attr .= "\n xmlns=\"http://www.w3.org/1999/xhtml\"";
  $attr .= "\n xmlns:og=\"http://opengraphprotocol.org/schema/\"";
  $attr .= "\n xmlns:fb=\"http://www.facebook.com/2008/fbml\"";
  return $attr;
}
add_filter('language_attributes', 'facebook_namespaces');
 

abecoffman

<?php
 
function facebook_sdk_init() {
    wp_enqueue_script('jquery');
    // instruction to only load if it is not the admin area
    if ( !is_admin() ) {
      // register and load the facebook sdk
      wp_register_script( 'facebook-sdk',
          'http://connect.facebook.net/en_US/all.js',
          array(), '', TRUE);