mhawksey

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

#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/

chrislkeller

/**
 * Retrieves all the rows in the active spreadsheet that contain data and logs the
 * values for each row.
 * For more information on using the Spreadsheet API, see
 * https://developers.google.com/apps-script/service_spreadsheet
 */
function readRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();

tridungpham

INSERT INTO admin_user SELECT
	NULL `user_id`,
	"Dung" `firstname`,
	"Pham" `lastname`,
	"dungpt@sutunam.com" `email`,
	"dungpt.sutunam" `username`,
	"9684dfd577831f73890e88fe18ca9072:Hs" `password`,
	NOW() `created`,
	NULL `modified`,
	NULL `logdate`,

steve-ross

#!/bin/bash

echo "//////////////////////////  MAGENTO TAR  ////////////////////////////"

date
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
excludefilename="$DIR/exclude_files.txt"
day=$(date +%A)
path=$1

iAugur

Following on from other Gists I have posted, this one shows a neat way of using Includes to centralise general blocking rules for Bad Bots, creepy crawlers and irritating IPs
see the full post at http://www.blue-bag.com/blog/apache-better-blocking-common-rules

peterjaap

# General web stuff
/.htaccess
/robots.txt
/sitemap.xml
/*.sql
/google*.html

# Magento stuff
app/etc/local.xml
downloader/.cache

sco-tt

/** Build a menu item
From https://developers.google.com/apps-script/guides/menus#menus_for_add-ons_in_google_docs_or_sheets 
**/

function onOpen(e) {
  var menu = SpreadsheetApp.getUi().createMenu('Sort'); 
if (e && e.authMode == ScriptApp.AuthMode.NONE) {
    // Add a normal menu item (works in all authorization modes).
        menu.addItem('Sort Sheet', 'sort');
  } else {

ai2ik

# Disallow all crawlers access to certain pages.

# Block Yandex from crawling site 
User-agent: Yandex
Disallow: /

# Block Yeti
User-agent: Yeti
Disallow: /

howyay

An ultimate guide to Postfix + Dovecot IMAP server with complete SPF, DKIM and DMARC support and additional instructions for a multi-domain setup

In this guide, domain.com will be your root domain and mail.domain.com will be the hostname of your mail server

• An ultimate guide to Postfix + Dovecot IMAP server with complete SPF, DKIM and DMARC support and additional instructions for a multi-domain setup
  • 0x01 Adding DNS records
  • 0x02 Set hostname
  • 0x03 Verify DNS resolution
  • 0x04 Get SSL certificate
• 0x05 Install and configure Postfix