Skip to content

Instantly share code, notes, and snippets.

View stephenfeather's full-sized avatar

Stephen Feather stephenfeather

View GitHub Profile
@stephenfeather
stephenfeather / verify_attachment_url.sh
Created February 27, 2023 17:27
Bash script to deleted wordpress attachments that have a bad URL (WIP)
#!/usr/bin/bash
BASE_URL="https://myourdomain.com/files/"
# We need to be able to trap breakouts
trap exit_script INT
function exit_script() {
end=`date +%s.%N`
runtime=$( echo "$end - $start" | bc -l )
@stephenfeather
stephenfeather / wp-useful-sql-queries.txt
Last active December 23, 2022 16:02
Useful Raw SQL Queries for Wordpress
/*
This is a query to return a post.ID, post.post_title, and the SKU of
products that do not have an attached image. The vendor, as associated through
wp-all-import into an ACF field, can be adjusted as needed.
*/
USE featherarms;
SET @vendor = 'CSSI' COLLATE utf8mb4_unicode_ci;
SELECT fa_posts.ID, fa_posts.post_title, fa_postmeta1.meta_value as SKU
FROM fa_posts
LEFT OUTER JOIN fa_postmeta pm ON (fa_posts.ID=pm.post_id AND pm.meta_key = '_thumbnail_id')
@stephenfeather
stephenfeather / image-organize.sh
Last active December 10, 2023 21:14
Creates a subdirecty tree based upon a file name to work around the 999 object list issues on S3
#!/bin/bash
#
# Designed to organize files into
# sub folders to a depth of X based
# upon the first X letters of the file name
# Currently --depth does not work
@stephenfeather
stephenfeather / cleanup.zsh
Created April 21, 2019 00:49
Clean Up wasted space on osx
#!/usr/local/bin/zsh
echo "Updating Homebrew"
brew update
brew upgrade
brew cask upgrade
brew cleanup -s
brew doctor
brew missing
echo "Updating App Store Items"
mas outdated
04d13ee4564f01142758f002d6b3069e7bfccf6d6ed92b8352e4782c9ceedddac7a38ed4109da157c27888d4318552a3738a07ef9910ebc9e8c1bbdfc56aea4e4a
@stephenfeather
stephenfeather / Timings.js
Last active December 19, 2016 12:22
Quick and dirty timings libary, most definitely should not be used for engineering, medical, safety related usages.
/*
Requires Underscore
Basic Usage:
var Timing = require('Timing');
Timing.start('myLabel');
Timing.stop('myLabel');
Timing.getTime('myLabel');
@stephenfeather
stephenfeather / slackLogger.js
Last active October 27, 2016 20:59
Small library for Titanium to send info to a Slack webhook for 'remote logging' during development/testing
// Copyright 2016 Stephen Feather
//
// 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
@stephenfeather
stephenfeather / UIModule.m
Created July 1, 2016 13:19
textStyle hack
-(NSString*)TEXT_STYLE_TITLE1
{
if ([TiUtils isIOS9OrGreater]) {
return UIFontTextStyleTitle1;
} else {
return UIFontTextStyleBody;
}
}
-(NSString*)TEXT_STYLE_TITLE2
@stephenfeather
stephenfeather / gist:2ac42b8544c995f7b7ff
Created January 3, 2016 00:23
OSX command line for tool to test your android library for text relocations
/sdks/android-ndk-r10e/toolchains/arm-linux-androideabi-4.9/prebuilt/darwin-x86_64/bin/arm-linux-androideabi-readelf -a yourlib.so | grep TEXTREL