Skip to content

Instantly share code, notes, and snippets.

View steverobbins's full-sized avatar

Steve Robbins steverobbins

124 followers · 113 following
View GitHub Profile
@steverobbins
steverobbins / keybase.md
Created January 15, 2016 04:21

Keybase proof

I hereby claim:

  • I am steverobbins on github.
  • I am steverobbins (https://keybase.io/steverobbins) on keybase.
  • I have a public key whose fingerprint is F665 C5A4 EAC2 A9E1 FDF1 9766 34BF D94C 4F19 CE38

To claim this, I am signing this object:

@steverobbins
steverobbins / 00-magento-session-db-gc-non-locking-readme.md
Last active January 18, 2021 05:18
Clean Magento's core_session table in background

Script to "safely" clean up the core_session table without causing lock wait timeouts.

Not thoroughly vetted but met the client's needs.

Requires disabling Mage_Core_Model_Resource_Session:gc(), e.g.

--- a/app/code/core/Mage/Core/Model/Resource/Session.php
+++ b/app/code/core/Mage/Core/Model/Resource/Session.php
@@ -74,7 +74,7 @@ class Mage_Core_Model_Resource_Session implements Zend_Session_SaveHandler_Inter
@steverobbins
steverobbins / gist:7039531b4c9457fe826a
Created January 8, 2016 19:37
Verifying that +steverobbins is my blockchain ID. https://onename.com/steverobbins
@steverobbins
steverobbins / php-memcached-session-test.php
Last active January 8, 2016 18:15
<?php
ini_set('display_errors', 1);
session_save_path('tcp://127.0.0.1:11211?persistent=1&weight=2&timeout=10&retry_interval=10');
session_module_name('memcache');
session_start();
$sesTime = 'first time';
if (isset($_SESSION['memc_time'])) $sesTime = $_SESSION['memc_time'];
@steverobbins
steverobbins / save-ip-to-dropbox
Last active December 21, 2015 03:50
Cron script I leave running on my home computer in case my ISP decides to change my IP
#!/bin/bash
BIN_CURL=$(which curl)
FILE_IP=/Users/steve/Dropbox/ip-home
URL_DETECT=icanhazip.com
echo "Config values:
curl bin: $BIN_CURL
ip file: $FILE_IP
detection url: $URL_DETECT
@steverobbins
steverobbins / scp-blackfriday-search.sql
Last active November 18, 2015 23:01
select p.id, p.sku, p.upc, json_get(p.custom_data, 'pricing_guide') pricing_guide, p.long_name
from products p
inner join amazonproducts ap on ap.product_id = p.id
where
(
json_get(p.custom_data, 'life_cycle', 0) != 'Pre-Release'
or (
json_get(p.custom_data, 'life_cycle', 0) != 'Active'
and json_get(p.custom_data, 'product_group') != 'Machines'
)
@steverobbins
steverobbins / aws-s3-backup-filesystem.sh
Last active September 14, 2016 00:37
#!/bin/bash
BUCKET=ellisonmagentobackups
TMPDIR=/mnt/shared/tmp
BACKUPITEMS="app erp errors media shell var wp"
DATESTAMP=`date +"%Y%m%d.%H%M%S"`
date
echo "Shared backup started"
@steverobbins
steverobbins / magento2-pr-1797-httpd.conf
Created September 15, 2015 20:50
#
# This is the main Apache server configuration file. It contains the
# configuration directives that give the server its instructions.
# See <URL:http://httpd.apache.org/docs/2.2/> for detailed information.
# In particular, see
# <URL:http://httpd.apache.org/docs/2.2/mod/directives.html>
# for a discussion of each configuration directive.
#
#
# Do NOT simply read the instructions in here without understanding
@steverobbins
steverobbins / phion-balance-products.sql
Created September 14, 2015 19:06
SELECT TOP 1000 p.[Name]
,p.[Price_Base]
,p.[Price_Wholesale]
,p.[Price_List]
,p.[Price_Site]
,p.[Price_Promotional]
,p.[StockStatus]
,p.[PartNumber]
,p.[TagLine]
,p.[SmallDescription]
@steverobbins
steverobbins / ellison-dev-to-prod.sql
Last active September 1, 2015 18:04
update core_config_data set value = 'http://www.sizzix.com/' where path = 'web/unsecure/base_url' and scope = 'default' and scope_id = 0;
update core_config_data set value = 'https://www.sizzix.com/' where path = 'web/secure/base_url' and scope = 'default' and scope_id = 0;
update core_config_data set value = 'http://www.ellison.com/' where path = 'web/unsecure/base_url' and scope = 'websites' and scope_id = 4;
update core_config_data set value = 'https://www.ellison.com/' where path = 'web/secure/base_url' and scope = 'websites' and scope_id = 4;
update core_config_data set value = 'http://www.ellisoneducation.com/' where path = 'web/unsecure/base_url' and scope = 'websites' and scope_id = 5;
update core_config_data set value = 'https://www.ellisoneducation.com/' where path = 'web/secure/base_url' and scope = 'websites' and scope_id = 5;
update core_config_data set value = 'http://www.sizzix.co.uk/' where path = 'web/unsecure/base_url' and scop