Skip to content

Instantly share code, notes, and snippets.


David Alexander davidalexander

View GitHub Profile
davidalexander / gist:6937862
Created Oct 11, 2013
Magento - Report for count and revenue of promotions
View gist:6937862
sr.`name` as rule_name,
count(*) as total_orders,
SUM(sfo.`total_paid`) as revenue,
`sales_flat_order` sfo,
`salesrule` sr
davidalexander /
Last active Jan 29, 2020
rsync the media directory from live site to local site. Useful when you need imagery which is (correctly) ignored by version control.
rsync \
--verbose \
--progress \
--stats \
--compress \
--rsh=/usr/bin/ssh \
--recursive \
--times \
--perms \
--links \
davidalexander / index.php
Last active Oct 4, 2015
Magento developer subdomains
View index.php
* Set developer mode and display_errors based on subdomain
$staging_subdomains = array(
davidalexander / index.php
Created Mar 15, 2012
Thoughts on best way to test subdomain
View index.php
* how best to turn on errors for staging subdomains
* as this is in the index.php, performance is important,
* although technically the page will be cached
// 1. preg_match
if (preg_match('/^s1\.|^s2\.|^s3\.|^s4\.|^s5\.|^mac\.|^local\.|^mac-upgrade\./', $_SERVER['HTTP_HOST'])) {
davidalexander / .htaccess
Created Jul 16, 2011
Magento fix for IE9 issues
View .htaccess
### IE users need a little help (Magento+IE9=bad times) ###
<IfModule mod_setenvif.c>
<IfModule mod_headers.c>
BrowserMatch MSIE ie
Header set X-UA-Compatible "IE=EmulateIE8,chrome=1" env=ie
<IfModule mod_headers.c>
# Because X-UA-Compatible isn't sent to non-IE (to save header bytes),
# We need to inform proxies that content changes based on UA
davidalexander / gist:1086773
Created Jul 16, 2011
.htaccess Environments
View gist:1086773
RewriteEngine On
RewriteBase /
# Default to master
RewriteRule .* - [E=ENVIRONMENT:master]
davidalexander / gist:1086732
Created Jul 16, 2011
jQuery Dismiss Lightbox with ESC
View gist:1086732
// Bind a custom event to the lightbox that can be triggered when it needs to be dismissed:
$('.lightbox').bind('dismiss', function() {
// code to dismiss lightbox
// Then just trigger that event when escape it pressed:
$(document).bind('keyup', function(e) {
if(e.keyCode == 27) {
davidalexander / iframe.js
Created Jul 16, 2011
Add a class to the html tag if the page is being loaded in an iframe
View iframe.js
if (window.location !== window.parent.location) {
document.documentElement.className += ' iframe';
View gist:1086455

Magento Snippets

Download extension manually using pear/mage

Pear for 1.4, mage for 1.5. File downloaded into /downloader/.cache/community/

./pear download magento-community/Shipping_Agent
./mage download community Shipping_Agent

Clear cache/reindex

View index.html
<!doctype html>
<html lang="en" class="no-js">
<meta charset="utf-8">
<script src=""></script>
<script src="tabs.js"></script>
<div class="tab-container">