Leonan LeonanCarvalho

Working, Learning, Colaborating

LeonanCarvalho / gist:95727de91e1e0e73de39

Last active August 29, 2015 14:18 — forked from bryhal/gist:4129042

	DROP TABLE IF EXISTS time_dimension;
	CREATE TABLE time_dimension (
	id INTEGER PRIMARY KEY, -- year10000+month100+day
	db_date DATE NOT NULL,
	year INTEGER NOT NULL,
	month INTEGER NOT NULL, -- 1 to 12
	day INTEGER NOT NULL, -- 1 to 31
	quarter INTEGER NOT NULL, -- 1 to 4
	week INTEGER NOT NULL, -- 1 to 52/53
	day_name VARCHAR(9) NOT NULL, -- 'Monday', 'Tuesday'...

LeonanCarvalho / animationFrame

Last active August 29, 2015 14:20

Ativar request animationFrame para todos os navegadores.

	(function() {
	var lastTime = 0;
	var vendors = ['ms', 'moz', 'webkit', 'o'];
	for(var x = 0; x < vendors.length && !window.requestAnimationFrame; ++x) {
	window.requestAnimationFrame = window[vendors[x]+'RequestAnimationFrame'];
	window.cancelAnimationFrame = window[vendors[x]+'CancelAnimationFrame']
	\|\| window[vendors[x]+'CancelRequestAnimationFrame'];
	}
	if (!window.requestAnimationFrame)
	window.requestAnimationFrame = function(callback, element) {

LeonanCarvalho / safe_display_images.php

Last active October 11, 2019 08:05

My way to safely display external pictures

	/* =========================================================
	* My way to safely display external pictures
	* =========================================================
	* Copyright 2015 Leonan Carvalho @leonancarvalho
	*
	* Licensed under the Apache License, Version 2.0 (the "License");
	* you may not use this file except in compliance with the License.
	* You may obtain a copy of the License at
	*
	* http://www.apache.org/licenses/LICENSE-2.0

LeonanCarvalho / getClientHostname.php

Last active August 29, 2015 14:27

Get client using ip address, works fine in intranet and DNS and reverse proxyes

	$proxy = (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : false;
	$hostname = "";
	if (!!$proxy) {
	$ipaddress = $_SERVER['HTTP_X_FORWARDED_FOR'];
	$hostname .= "Proxy: ";
	} else {
	$ipaddress = $_SERVER['REMOTE_ADDR']; //
	}
	if ($ipaddress == $hostname) {
	$hostname .= "Unknown";

LeonanCarvalho / mysql_linux_backup.php

Last active December 11, 2015 13:07

PHP Script That provide a easy way to safe backup your databases

	<?php
	/* =========================================================
	* Script to Generate MySQL dumps With PHP
	* =========================================================
	* Copyright 2015 Leonan Carvalho @leonancarvalho
	*
	* Licensed under the Apache License, Version 2.0 (the "License");
	* you may not use this file except in compliance with the License.
	* You may obtain a copy of the License at
	*

LeonanCarvalho / cassandra_fetchAll.php

Created August 31, 2016 12:49

	<?php


	/**
	* Description of ResultSet:
	* This class handler a paginated Cassandra\FutureRows
	*
	* @author Leonan Carvalho
	*/
	class ResultSet {

LeonanCarvalho / L2jBrasilRequest.java

Last active September 2, 2016 12:59


	import java.io.BufferedReader;
	import java.io.DataOutputStream;
	import java.io.InputStreamReader;
	import java.net.HttpURLConnection;
	import java.net.URL;

	import javax.servlet.http.HttpServletRequest;

	//...

LeonanCarvalho / pip.log

Created February 7, 2017 20:16

This file has been truncated, but you can view the full file.

	Downloading/unpacking argparse==1.4.0 (from -r default/src/ckan/requirements.txt (line 7))

	Getting page https://pypi.python.org/simple/argparse/
	URLs to search for versions for argparse==1.4.0 (from -r default/src/ckan/requirements.txt (line 7)):
	* https://pypi.python.org/simple/argparse/1.4.0
	* https://pypi.python.org/simple/argparse/
	Getting page https://pypi.python.org/simple/argparse/1.4.0
	Could not fetch URL https://pypi.python.org/simple/argparse/1.4.0: HTTP Error 404: Not Found
	Will skip URL https://pypi.python.org/simple/argparse/1.4.0 when looking for download links for argparse==1.4.0 (from -r default/src/ckan/requirements.txt (line 7))
	Analyzing links from page https://pypi.python.org/simple/argparse/

LeonanCarvalho / ckan_lighttpd_vhost.conf

Last active February 8, 2017 20:24

Solr 5.5.3 CKAN core schemas

LeonanCarvalho / GenericEntity.json

Created February 16, 2017 00:05