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

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

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

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

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

<?php ini_set('display_errors', 1) ?>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/8.5/styles/default.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/8.5/highlight.min.js"></script>
<script>hljs.initHighlightingOnLoad();</script>
<?php

// we need the autoloader
include 'app/Mage.php';

$classes = array(

steverobbins

set @lifecycle_attr_id               = 144;
set @isorderable_attr_id             = 151;
set @ispreorderable_attr_id          = 186;
set @lifecycle_attr_value_active     = 23;
set @lifecycle_attr_value_prerelease = 155;


select
    cpe.entity_id product_id,
    cpe.sku

steverobbins

#!/bin/bash

if [[ -e ../../app/etc/local.xml ]]
then

  if [[ ! -d ../../var/support ]]
  then
    mkdir ../../var/support ||
    if [[ $? != 0 ]]
    then

steverobbins

jQuery('.nestedlisting .give-gold').each(function (i, that) {
    setTimeout(function() {
        jQuery(that).click();
    }, i * 1000);
});
jQuery('button.btn.gold-button[type=button]:visible').each(function (i, that) {
    setTimeout(function() {
        jQuery(that).click();
    }, i * 1000);
});