Sam Sargent samsargent

## wget-crawl.sh
wget --mirror --convert-links --adjust-extension --page-requisites --no-parent http://domain.com/

## clear-drupal-cache.php
<?php
include_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
drupal_flush_all_caches();
?>

## database_size.sql
SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
where table_schema='REPLACE_WITH_DATABASE_NAME'
GROUP BY table_schema;

## Server Log File helpers
=-+=-+=-+=-+=-+=-+=-+=-+=-+=
List all IP's hitting any domain
=-+=-+=-+=-+=-+=-+=-+=-+=-+=

less /home/*/access-logs/* | awk '{print $1}' | sort | uniq -c | sort -n


=-+=-+=-+=-+=-+=-+=-+=-+=-+=
List all IP's hitting POSTING to any domain
=-+=-+=-+=-+=-+=-+=-+=-+=-+=

## Image Optimise Commands

JPEGS
find uploads/ -type f -iname '*.jpg' -exec jpegoptim --strip-all {} +

PNG
find uploads/ -iname "*.png" -exec pngquant --force --quality=40-100 --skip-if-larger --strip --verbose \{} --output \{} \;

## Rsync
rsync -ravzv -e ssh user@externalserver.com:/home/user/test/* --include=".*" /home/user/test

## Gravity Forms Delete Entires.php
add_action( 'gform_after_submission', 'site_gform_after_submission', 10, 2 );
function site_gform_after_submission ( $entry, $form ) {
  GFAPI::delete_entry( $entry['id'] );
}

## Parsely.js Mobile Number Validation
<input type="text" class="text" name="mobilePhone" id="mobilePhone" value="" parsley-regex-message="Please enter a valid Australian mobile phone number." parsley-regexp="^\(?(?:\+?61|0)4\)?(?:[ -]?[0-9]){2}\)?(?:[ -]?[0-9]){5}[0-9]$"/>

## .bash_profile
# add this to your .bash_profile

export PATH=$PATH:$HOME/bin

_complete_ssh_hosts ()
{
        COMPREPLY=()
        cur="${COMP_WORDS[COMP_CWORD]}"
        comp_ssh_hosts=`cat ~/.ssh/known_hosts | \
                        cut -f 1 -d ' ' | \

## GA EVent Tracking on PDF's.js
$('a[href$=".pdf"]').click(function(){
  ga('send', {
    hitType: 'event',
    eventCategory: 'Download',
    eventAction: 'PDF',
    eventLabel: this.href
  });
});