oniryx

#! /bin/bash

#
# WARNING: You will lose all git history of the submodule
#

$submodule_path=''
$backup_path=''

rm -rf $submodule_path/.git

oniryx

/* Init sortable_rank without scope */
select @rank:=0;
update TABLE_NAME set sortable_rank=(@rank:=(@rank+1));

/* Init sortable_rank with scope */
select @range:=0;
update TABLE_NAME set sortable_rank=IF(@range!=SCOPE_COLUMN, @rank:=1 && (@range:=SCOPE_COLUMN), @rank:=@rank+1) order by SCOPE_COLUMN, PK_COLUMN;

oniryx

/**
   * Export an array as downladable Excel CSV
   * @param array   $header
   * @param array   $data
   * @param string  $filename
   */
  function toCSV($header, $data, $filename) {
    $sep  = "\t";
    $eol  = "\n";
    $csv  =  count($header) ? '"'. implode('"'.$sep.'"', $header).'"'.$eol : '';

oniryx

<?php
// Resource: http://stackoverflow.com/questions/4329260/cross-platform-php-to-c-sharp-net-encryption-decryption-with-rijndael

$iv = "45287112549354892144548565456541";
$key = "anjueolkdiwpoida";

$clear = "2310296|340105";
$encrypted = "B/DrahtonRfOMOgkCTcZRcuOdlpc68uKrNp9oCBpchY=";

$block = mcrypt_get_block_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_CBC);

oniryx

#Script to extract to data from google cache This is a simple python script which retrieves content like your blog posts from googles cache, you can use this if your servers hard drive crashes or if a meteor hits your data center.

Remove the time.sleep code if you don't have more than 50 pages to retrieve.

Added check if file exists before downloading in case you need to rerun the script

##Original Source

• http://www.guyrutenberg.com/2008/10/02/retrieving-googles-cache-for-a-whole-website/