Skip to content

Instantly share code, notes, and snippets.

Avatar

Sam Sargent samsargent

  • Vivo Group
  • Brisbane, Australia
View GitHub Profile
@samsargent
samsargent / wget-crawl.sh
Created Feb 13, 2019
wget crawl and download local mirror of site and all files
View wget-crawl.sh
wget --mirror --convert-links --adjust-extension --page-requisites --no-parent http://domain.com/
View 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;
@samsargent
samsargent / Image Optimise Commands
Created Mar 16, 2018
Image Optimise Commands - pngquant jpegoptim
View 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 \{} \;
@samsargent
samsargent / Rsync
Created Mar 16, 2018
Rsync remote to local
View Rsync
rsync -ravzv -e ssh user@externalserver.com:/home/user/test/* --include=".*" /home/user/test
View 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
=-+=-+=-+=-+=-+=-+=-+=-+=-+=
@samsargent
samsargent / Gravity Forms Delete Entires.php
Created Jul 11, 2017
Remove entries from Gravity Forms
View 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'] );
}
@samsargent
samsargent / .bash_profile
Last active Jun 15, 2017
SSH Shortcuts & Helpers
View .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 ' ' | \
View .bash_profile
_complete_ssh_hosts ()
{
COMPREPLY=()
cur="${COMP_WORDS[COMP_CWORD]}"
comp_ssh_hosts=`cat ~/.ssh/known_hosts | \
cut -f 1 -d ' ' | \
sed -e s/,.*//g | \
grep -v ^# | \
uniq | \
grep -v "\[" ;
@samsargent
samsargent / Tar GZ - Exclude directory
Created Jul 10, 2016
Tar GZ - Exclude directory - good for copying down a live WP install and ignoring uploads
View Tar GZ - Exclude directory
tar -czvf filename.tar.gz /full/path/to/directory --exclude "/full/path/to/directory/to/exclude/wp-content/uploads"
Use this on local /wp-content/uploads:
<IfModule mod_rewrite.c>
RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule (.*) http://domain.com/wp-content/uploads/$1
</IfModule>
@samsargent
samsargent / Reset Permissions 755 644
Created Jul 10, 2016
Reset Permissions Folders 755 Files 644
View Reset Permissions 755 644
find . -type d -exec chmod 0755 {} \; && find . -type f -exec chmod 0644 {} \;
You can’t perform that action at this time.