steverobbins

#!/bin/bash
# echo -n "black" | nc -4u -w0 localhost 1738

function anybarSet {
  #echo "anybarSet $1 $2"
  echo -n $1 | nc -4u -w0 localhost $2;
}

function checkStatusString() {
  #echo "checkStatusString $1 $2"

steverobbins

SELECT
    O.Created,
    O.OrderID,
    CASE WHEN O.TransactionID IS NULL THEN '' ELSE O.TransactionID END AS 'AuthnetTransID',
    CASE WHEN O.PaypalTransactionId IS NULL THEN '' ELSE O.PaypalTransactionId END AS 'PaypalTransID',
    O.OrderMotionOrderID,
    CONCAT(OA.SAFName, ' ', OA.SALName) AS 'CustomerName',
	OA.sEmail AS 'CustomerEmail',
	OD.PartNumber,
	OD.Quantity,

steverobbins

#!/bin/bash

PDIR=/Users/steverobbins

touch $PDIR/_ref.php_error.log

DIFF=`diff $PDIR/_ref.php_error.log $PDIR/php_error.log | grep -v "^[0-9c0-9]" | grep -v "^<" | sed -e 's/^.*Berlin\] //g' | sed -e 's/^.*UTC\] //g' | grep -v "^>" | grep -v "\-\-\-" `

if [ ! -z "$DIFF" ]; then
  say -r 300 -v Daniel "$DIFF" &

steverobbins

SET @OLDURL = 'http://blog.sizzix.com/';
SET @NEWURL = 'http://us.sizzix.stage.ellison.com/';
SET @SITEID = 2;

UPDATE szus_posts
SET post_content = REPLACE(
	REPLACE(
		post_content,
		@OLDURL,
		@NEWURL

steverobbins

diff -r magento-CE-1.9.2.0/app/code/core/Mage/Cms/Block/Block.php magento-CE-1.9.2.1/app/code/core/Mage/Cms/Block/Block.php
74a75,94
> 
>     /**
>      * Retrieve values of properties that unambiguously identify unique content
>      *
>      * @return array
>      */
>     public function getCacheKeyInfo()
>     {

steverobbins

select
    p.sku
    , coalesce(ap.title, p.long_name) title
    , ap.buybox_status
    , ap.ownbuybox
    , ap.reseller_count
    , ap.current_price + ap.current_shipping stb_total
    , ap.next_highest_price + ap.next_highest_shipping next_highest_total
    , ap.lowest_price + ap.lowest_shipping lowest_total
    , p.map

steverobbins

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

steverobbins

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

#
# 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

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'  
        )