Skip to content

Instantly share code, notes, and snippets.

<html>
<head>
<title>ao vivo </title>
<!--JS JW6-->
<script type="text/javascript" src="http://a123.g.akamai.net/f/123/214238/1d/214258g.download.akamai.com/214238/_player/jwplayer6/6_9/jwplayer.js" ></script>
<script type="text/javascript">jwplayer.key = "ZfKOArQz+u1vxoCkwM9cihPjTUoVodJwgUCFZRpZLis=";</script>
</head>
<body>
<div id="dPlayer">
<div class="dTitulo_video"></div>
User.joins(:pokes).
select("users.*, (
SELECT COUNT(p.*) FROM pokes p
WHERE p.user_id = users.id
AND p.campaign_id = #{self.id}
) as pokes_count").
where(["pokes.campaign_id = ?", self.id]).uniq
SELECT DISTINCT users.*, (SELECT COUNT(p.*) FROM pokes p WHERE p.user_id = users.id AND p.campaign_id = 3) as pokes_count FROM "users" INNER JOIN "pokes" ON "pokes"."user_id" = "users"."id" WHERE (pokes.campaign_id = 3) ORDER BY RANDOM() LIMIT 8
@nicolasiensen
nicolasiensen / member_export.rb
Created August 6, 2012 14:09
Export Meu Rio members from Mr. Dash
require "csv"
members = Group.find(1).users
CSV.open("/Users/nicolas/Desktop/members.csv", "wb") do |csv|
csv << ["Nome", "Email"]
members.each do |member|
csv << [member.name, member.email]
end
end
@nicolasiensen
nicolasiensen / .vimrc
Created July 11, 2012 01:10
My vimrc
set rtp+=~/.vim/bundle/vundle/
call vundle#rc()
Bundle 'gmarik/vundle'
Bundle 'wincent/Command-T.git'
Bundle 'bbommarito/vim-slim.git'
Bundle 'digitaltoad/vim-jade.git'
Bundle 'pangloss/vim-javascript.git'
Bundle 'vim-ruby/vim-ruby.git'
Bundle 'https://github.com/tpope/vim-fugitive.git'
@nicolasiensen
nicolasiensen / 01_envvars.rb
Created June 22, 2012 18:46
Mr. Dash Env Vars
ENV["DASH_TOKEN"] = "ebc309c2090073bbfdfd18494353f0771f33aa0da269f1f06e421d7e30b5aa19"
ENV["MAILEE_API_URL"] = "https://api.d3b39ea48efdc.meurio.mailee.me"
Início: 13 de Outubro de 2011
Deadline: 13 de Abril de 2013
Dias restantes: 375
Dias totais: 548
Membros: 17461
Restantes: 82539
Ideal: 183
Média real: 100
Ontem: 40
@nicolasiensen
nicolasiensen / gist:1987534
Created March 6, 2012 17:06
Mailing das LAN's
<html><head><script type="text/javascript">var NREUMQ=NREUMQ||[];NREUMQ.push(["mark","firstbyte",new Date().getTime()]);</script>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<!-- Facebook sharing information tags -->
<meta property="og:title" content="Meu Rio">
<title>Meu Rio</title>
<style type="text/css">
/* Client-specific Styles */
#outlook a{padding:0;} /* Force Outlook to provide a "view in browser" button. */
# require "~/Desktop/wordpress_parser.rb"
# parser = WordpressParser.new("/Users/nicolasiensen/Desktop/quintal.wordpress.2015-03-03.xml")
# posts = parser.posts
# posts.each_with_index {|post, i| puts i; parser.create_post post }
require 'nokogiri'
class WordpressParser
def initialize file_path = "quintal.wordpress.2015-03-03.xml"
@xml = Nokogiri::XML(File.open(file_path))
class OrganizationCreator
# TODO: add avatar, email_signature_html, bio and facebook_page_uid
def self.create_all
create_meu_recife
create_minha_blumenau
create_minha_campinas
create_minha_curitiba
create_minha_garopaba
create_minha_ouro_preto