abubelinha’s gists

anonymous / SQLyogTunnel.php

Created May 23, 2010 00:50

	<?php

	/*
	SQLyog
	Copyright 2003-2006, Webyog
	http://www.webyog.com

	HTTP Tunneling Page

	This page exposes the MySQL API as a set of web-services which is consumed by SQLyog - the most popular GUI to MySQL.

mhawksey / gist:1170597

Created August 25, 2011 13:02

Google Apps Script to fill in a Document template with Spreadsheet data

	function onOpen() {
	var menuEntries = [ {name: "Create Diary Doc from Sheet", functionName: "createDocFromSheet"}];
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	ss.addMenu("Fitness Diaries", menuEntries);
	}

	function createDocFromSheet(){
	var templateid = "1O4afl8SZmMxMFpAiN16VZIddJDaFdeRBbFyBtJvepwM"; // get template file id
	var FOLDER_NAME = "Fitness Diaries"; // folder name of where to put completed diaries
	// get the data from an individual user

mhawksey / gist:1276293

Last active October 23, 2023 09:00

Google App Script to insert data to a google spreadsheet via POST or GET - updated version as per https://mashe.hawksey.info/2014/07/google-sheets-as-a-database-insert-with-apps-script-using-postget-methods-with-ajax-example/

	/*
	Copyright 2011 Martin Hawksey

	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

	Unless required by applicable law or agreed to in writing, software

mhawksey / gist:1442370

Last active February 25, 2024 12:01

Google Apps Script to read JSON and write to sheet

	function getJSON(aUrl,sheetname) {
	//var sheetname = "test";
	//var aUrl = "http://pipes.yahoo.com/pipes/pipe.run?_id=286bbb1d8d30f65b54173b3b752fa4d9&_render=json";
	var response = UrlFetchApp.fetch(aUrl); // get feed
	var dataAll = JSON.parse(response.getContentText()); //
	var data = dataAll.value.items;
	for (i in data){
	data[i].pubDate = new Date(data[i].pubDate);
	data[i].start = data[i].pubDate;
	}

ScottPhillips / .htaccess

Created February 2, 2012 04:30

Common .htaccess Redirects

	#301 Redirects for .htaccess

	#Redirect a single page:
	Redirect 301 /pagename.php http://www.domain.com/pagename.html

	#Redirect an entire site:
	Redirect 301 / http://www.domain.com/

	#Redirect an entire site to a sub folder
	Redirect 301 / http://www.domain.com/subfolder/

mourner / TileLayer.Common.js

Created February 11, 2012 23:11

Leaflet shortcuts for common tile providers

	// Lefalet shortcuts for common tile providers - is it worth adding such 1.5kb to Leaflet core?

	L.TileLayer.Common = L.TileLayer.extend({
	initialize: function (options) {
	L.TileLayer.prototype.initialize.call(this, this.url, options);
	}
	});

	(function () {

bmcbride / postgis_geojson.php

Created February 26, 2012 05:43

PHP PostGIS to GeoJSON

	<?php
	/**
	* PostGIS to GeoJSON
	* Query a PostGIS table or view and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
	*
	* @param string $geotable The PostGIS layer name REQUIRED
	* @param string $geomfield The PostGIS geometry field REQUIRED
	* @param string $srid The SRID of the returned GeoJSON OPTIONAL (If omitted, EPSG: 4326 will be used)
	* @param string $fields Fields to be returned OPTIONAL (If omitted, all fields will be returned) NOTE- Uppercase field names should be wrapped in double quotes
	* @param string $parameters SQL WHERE clause parameters OPTIONAL

rclark / TileLayer.Bing.js

Created March 11, 2012 16:50 — forked from pagameba/TileLayer.Bing.js

Leaflet Bing layer

	L.TileLayer.Bing = L.TileLayer.extend({

	supportedTypes: ['Road', 'Aerial', 'AerialWithLabels'],

	attributionTemplate: '<span style="display:inline-block">' +
	'<a target="_blank" href="http://www.bing.com/maps/">' +
	'<img src="{logo}" /></a><br><span>{copyrights}' +
	'<a style="white-space: nowrap" target="_blank" '+
	'href="http://www.microsoft.com/maps/product/terms.html">' +
	'Terms of Use</a></span></span>',

crofty / leaflet-google.js

Created March 25, 2012 15:07

Leaflet plugin that enables the use of Google Map tiles - http://matchingnotes.com/using-google-map-tiles-with-leaflet

	/*
	* L.TileLayer is used for standard xyz-numbered tile layers.
	*/
	L.Google = L.Class.extend({
	includes: L.Mixin.Events,

	options: {
	minZoom: 0,
	maxZoom: 18,
	tileSize: 256,

crofty / index.html

Last active October 22, 2021 08:24

A example of using Google Map tiles with the Leaflet mapping library - http://matchingnotes.com/using-google-map-tiles-with-leaflet

	<!DOCTYPE html>
	<html>
	<head>
	<title>Leaflet</title>
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.css" />
	<script src="http://cdn.leafletjs.com/leaflet-0.3.1/leaflet.js"></script>
	<script src="http://maps.google.com/maps/api/js?v=3.2&sensor=false"></script>
	<script src="http://matchingnotes.com/javascripts/leaflet-google.js"></script>
	</head>
	<body>

	<?php
	/**
	* PostGIS to GeoJSON
	* Query a PostGIS table or view and return the results in GeoJSON format, suitable for use in OpenLayers, Leaflet, etc.
	*
	* @param string $geotable The PostGIS layer name REQUIRED
	* @param string $geomfield The PostGIS geometry field REQUIRED
	* @param string $srid The SRID of the returned GeoJSON OPTIONAL (If omitted, EPSG: 4326 will be used)
	* @param string $fields Fields to be returned OPTIONAL (If omitted, all fields will be returned) NOTE- Uppercase field names should be wrapped in double quotes
	* @param string $parameters SQL WHERE clause parameters OPTIONAL