Skip to content

Instantly share code, notes, and snippets.

View stephenfeather's full-sized avatar

Stephen Feather stephenfeather

View GitHub Profile
@stephenfeather
stephenfeather / cleanUpMaps.sh
Created June 28, 2023 19:52
Bash script to clean up sourceMappingURL references in web files.
#!/bin/bash
# Script: grep_and_remove.sh
# Author: Stephen Feather
# Co-author: OpenAI (ChatGPT)
# Copyright (c) 2023
# All rights reserved.
# License: CC-BY-SA (https://creativecommons.org/licenses/by-sa/4.0/)
@stephenfeather
stephenfeather / parseFFL.js
Created June 28, 2023 14:40
A javascript function to parse a Federal Firearms License (FFL) number
/**
* Parses the FFL number and extracts relevant information.
*
* @param {string} fflNumber - The FFL number to parse.
* @returns {object} - An object containing the parsed FFL information or an error object.
* If parsing is successful, the object will have the following properties:
* - ffl_number: The full FFL number.
* - region: The region of the FFL.
* - irs_district: The IRS district of the FFL.
* - fips_code: The FIPS code of the FFL.
@stephenfeather
stephenfeather / parseFFL.php
Created June 28, 2023 14:37
A PHP function to parse a Federal Firearms License (FFL) number
/**
* Parses the FFL number and extracts relevant information.
*
* @param string $fflNumber The FFL number to parse.
* @return array An array containing the parsed FFL information or an error object.
* If parsing is successful, the array will have the following keys:
* - ffl_number: The full FFL number.
* - region: The region of the FFL.
* - irs_district: The IRS district of the FFL.
* - fips_code: The FIPS code of the FFL.
@stephenfeather
stephenfeather / NimbusPlus.xml
Last active June 2, 2023 14:42
Controller mapping file for Steelseries Nimbus+ and Farming Simulator 2019 (MacOS/OSX) - On some older macs the productID and vendor ID show as 000 so an alternate file is available.
<deviceMapping backends="rawInput;directInput;macosXSdl">
<productKey productId="1422" vendorId="1038" />
<productName vendorId="1038">
<keyword text="nimbus+" />
</productName>
<category>gamepad</category> <!-- gamepad, wheel, joystick, farmWheel, farmSidePanel -->
<buttonMappings>
<buttonMapping physical="0" logical="0" label="A" />
<buttonMapping physical="1" logical="1" label="B" />
<buttonMapping physical="2" logical="2" label="X" />
@stephenfeather
stephenfeather / wp_url_import.sh
Created May 15, 2023 13:45
Bash script to serve an asset url w/ optional params to remote wordpress setup for importation via wp_cli - b7cd9ff84718d3ca7fca26ebb60e765d1a0a8d5642722db795522e99a6759a90
#!/bin/bash
#
# upload_and_run.sh
# Author: Stephen Feather
# Copyright (c) 2023 Stephen Feather
# License: CC BY-SA 4.0
if [ -z "$1" ]; then
echo "Error: URL argument is required."
@stephenfeather
stephenfeather / dangerous.txt
Last active May 13, 2023 00:59
Bash script to remove/replace a prefix from woocommerce products
UPDATE wp_postmeta
SET meta_value = REPLACE(meta_value, 'FA-', '')
WHERE meta_key = '_sku'
AND meta_value LIKE 'FA-%'
ORDER BY post_id DESC
LIMIT 10000;
@stephenfeather
stephenfeather / wordpress_sequence.php
Last active April 30, 2023 11:45
Wordpress function and action to list all hooks/action in sequence of excecution
# Courtesy of Prosti (https://wordpress.stackexchange.com/users/88606/prosti)
# Context (https://wordpress.stackexchange.com/a/250293/215668)
function _20161224_printer( $r ){
$line = microtime(true)*10000 . ' ' . $r . "\n";
$fp = fopen( ABSPATH . 'hooks.txt', 'a+');
fwrite($fp, $line);
fclose($fp);
@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')