EricSeastrand’s gists

EricSeastrand / gist:b21b2e045756f719a31b951256234dec

Last active December 11, 2023 23:48

Making a Debian router

Set WAN DHCP client Set LAN static IP and subnet

cat /etc/network/interfaces

source /etc/network/interfaces.d/*

# The loopback network interface
auto lo

EricSeastrand / pushFileToStorage.ts

Last active January 2, 2023 18:52 — forked from mrgarymartin/pushFileToStorage.ts

Angular Fire Upload tasks


	pushFileToStorage(fileUpload: FileUpload) { // Pass in a callback as argument
	const filePath = `${this.basePath}/${fileUpload.file.name}`;
	const storageRef = ref(this.storage, filePath);
	const uploadTask = uploadBytesResumable(storageRef, fileUpload.file);

	uploadTask.on('state_changed',
	(snapshot) => {
	// Observe state change events such as progress, pause, and resume
	// Get task progress, including the number of bytes uploaded and the total number of bytes to be uploaded

EricSeastrand / load-html-inside-iframe.liquid

Created March 16, 2022 15:03

EricSeastrand / computer-control.user.js

Last active November 7, 2022 18:04

Browser side of my alexa skill

	// ==UserScript==
	// @name Computer Control Alexa Skill
	// @namespace http://ericseastrand.com/
	// @version 0.6
	// @description Connects to a websocket server to listen for instructions like pausing media, searching youtube, etc..
	// @author Eric Seastrand
	// @match https://www.youtube.com/*
	// @grant none
	//@downloadURL https://gist.githubusercontent.com/willcodeforfood/c2320e6673e9137a581b66314807da46/raw/computer-control.user.js
	// ==/UserScript==

EricSeastrand / tsm_to_csv.py

Last active September 1, 2021 23:59

Converts the TradeSkillMaster data that the addon downloads into a CSV file you can upload into a Google Sheet.

	import re # Regex ... sadly...
	import os

	# Update your WoW path here..
	tsm_file = "E:/World of Warcraft/_retail_/Interface/AddOns/TradeSkillMaster_AppHelper/AppData.lua"

	desktop_path = os.path.expandvars('%USERPROFILE%/Desktop/')

	csv_destination = desktop_path + '/tsm_data.csv'

EricSeastrand / magento-disable-extensions-by-glob.sh

Created April 8, 2019 13:33

Sed command to automagically disable a bunch of Magento 1 modules

sed -i'' -e's/active>true/active>false/' app/etc/modules/Mirasvit_*.xml

EricSeastrand / shopify-twine-embed.liquid

Last active March 13, 2019 19:35

This Shopify "section" will allow you to add a Twine social feed to any sectioned page by entering the app ID.

	{% assign urlParam_app = section.settings.appName \| url_encode %}
	{% assign urlParam_showNav = section.settings.includeNavBar \| url_encode %}

	{% case section.settings.loadingBehavior %}
	{% when 'automatic' %}
	{% assign urlParam_showLoadMore = 'no' %}
	{% assign urlParam_autoload = 'yes' %}
	{% when 'none' %}
	{% assign urlParam_showLoadMore = 'no' %}
	{% assign urlParam_autoload = 'no' %}

EricSeastrand / magento1_find_category_scope_overrides.sql

Last active March 1, 2019 15:54

Finds all the overridden values in storeview scopes for Magento 1 categories

	-- Find overridden values

	SELECT a.attribute_code, overrides.* FROM (
	SELECT 'datetime', entity_id, store_id, attribute_id, `value` FROM catalog_category_entity_datetime WHERE store_id!=0 UNION ALL
	SELECT 'decimal', entity_id, store_id, attribute_id, `value` FROM catalog_category_entity_decimal WHERE store_id!=0 UNION ALL
	SELECT 'int', entity_id, store_id, attribute_id, `value` FROM catalog_category_entity_int WHERE store_id!=0 UNION ALL
	SELECT 'text', entity_id, store_id, attribute_id, `value` FROM catalog_category_entity_text WHERE store_id!=0 UNION ALL
	SELECT 'varchar', entity_id, store_id, attribute_id, `value` FROM catalog_category_entity_varchar WHERE store_id!=0
	) AS overrides
	LEFT JOIN eav_attribute a ON overrides.attribute_id=a.attribute_id

EricSeastrand / disable_old_cartrules.sql

Created August 31, 2018 18:20

Magento 1: SQL query to disable old shopping cart price rules

UPDATE salesrule SET is_active=0 WHERE to_date<NOW() AND is_active=1;

EricSeastrand / pma_install.sh

Last active March 31, 2020 20:15

Install PHPMyAdmin on an AWS Elastic Beanstalk EC2 instance

	## To install, log into the server, download this file, and run as webapp user like:
	# sudo -u webapp bash pma_install.sh

	ALLOWED_IP='' # Put your public IP here... See whatismyip.com
	PMA_VERSION=4.9.5
	PMA_FILE="phpMyAdmin-$PMA_VERSION-english"
	INSTALL_IN_DIR='pma'

	cd /var/www/html

Eric Seastrand EricSeastrand