dannguyen

SELECT 
  `wp_terms`.`slug` AS wordpress_category,
  COUNT(1) AS post_count,
  SUM(`google_stats`.`Visits`) AS total_visits,
  SUM(`google_stats`.`New Visits`) AS total_new_visits,
  ROUND((SUM(`google_stats`.`Visits`) / COUNT(1)), 1) AS visits_per_post


  FROM `wp_posts`
  INNER JOIN `wp_term_relationships`

dannguyen

# First
# http://unix.stackexchange.com/questions/46948/how-to-make-duplicates-with-different-names-from-a-single-file

mkdir copies
newnames=("a" "b" "c" "d" "e")
orgfile=my_original_doc.pdf
for x in "${newnames[@]}"; do
  cp $orgfile "copies/$x.pdf" 
done

dannguyen

course_id,userid_DI,registered,viewed,explored,certified,final_cc_cname_DI,LoE_DI,YoB,gender,grade,start_time_DI,last_event_DI,nevents,ndays_act,nplay_video,nchapters,nforum_posts,roles,incomplete_flag
HarvardX/CB22x/2013_Spring,MHxPC130442623,1,0,0,0,United States,NA,NA,NA,0,2012-12-19,2013-11-17,,9,,,0,,1
HarvardX/CS50x/2012,MHxPC130442623,1,1,0,0,United States,NA,NA,NA,0,2012-10-15,,,9,,1.0,0,,1
HarvardX/CB22x/2013_Spring,MHxPC130275857,1,0,0,0,United States,NA,NA,NA,0,2013-02-08,2013-11-17,,16,,,0,,1
HarvardX/CS50x/2012,MHxPC130275857,1,0,0,0,United States,NA,NA,NA,0,2012-09-17,,,16,,,0,,1
HarvardX/ER22x/2013_Spring,MHxPC130275857,1,0,0,0,United States,NA,NA,NA,0,2012-12-19,,,16,,,0,,1
HarvardX/PH207x/2012_Fall,MHxPC130275857,1,1,1,0,United States,NA,NA,NA,0,2012-09-17,2013-05-23,502,16,50,12.0,0,,
HarvardX/PH278x/2013_Spring,MHxPC130275857,1,0,0,0,United States,NA,NA,NA,0,2013-02-08,,,16,,,0,,1
HarvardX/CB22x/2013_Spring,MHxPC130539455,1,1,0,0,France,NA,NA,NA,0,2013-01-01,2013-05-14,42,6,,3.0,0,,
Harvard

dannguyen

Middleman - Makes developing websites simple

Middleman is a static site generator using all the shortcuts and tools in modern web development. Check out middlemanapp.com for detailed tutorials, including a getting started guide. You can also follow @middlemanapp for updates.

Why Middleman?

The last few years have seen an explosion in the amount and variety of tools developers can use to build web applications. Ruby on Rails selects a handful of these tools:

• Sass for DRY stylesheets
• CoffeeScript for safer and less verbose javascript

dannguyen

var element1 = document.createElement("script");element1.src = "http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js";element1.type="text/javascript";document.getElementsByTagName("head")[0].appendChild(element1);

var str = "<table><tbody>";

$(".field-items h3").each(function(){
  var h3 = $(this);
  var p = h3.next();

  var rows = p.html().split("<br>").reverse();

dannguyen

# A mirror of: http://cfenollosa.com/misc/tricks.txt
-----------------


I have marked with a * those which I think are absolutely essential
Items for each section are sorted by oldest to newest. Come back soon for more!

BASH
* In bash, 'ctrl-r' searches your command history as you type
- Input from the commandline as if it were a file by replacing 

dannguyen

# A quickie script to timeshift all XMP files of a certain camera model
# by an arbitrary number of seconds

require 'nokogiri'
require 'chronic'
require 'fileutils'
files = Dir.glob('./xmps/*.xmp')
orgdir = "./new-xmps"
seconds_to_shift = 98
model_name_to_change = 'NEX-7'

dannguyen

#!/usr/bin/env ruby
# nyt-list-scrape.rb
# Dan Nguyen @dancow
# Created: 2014-07-26
# Updated: 2014-07-29
#
# Scrape the titles/urls of articles recommended to the user by the NYT,
# and also, the most popular ones at the moment
#
# Requirements: Ruby 1.9.x and the Mechanize gem and a NYT digital subscriber account

dannguyen

Sharknado Protection

This series of commands will unfollow anyone you currently follow who has recently mentioned "sharknado".

Pre-installation

• Install the Rubygem t:

gem install t

dannguyen

# ca_public_salaries.rb
# A quickie script to batch download all the raw salary data
# from publicpay.ca.gov
#
# by Dan Nguyen
#
# How to use:
# install these gems: nokogiri, rubyzip
#
# then pop open irb and run: