Skip to content

Instantly share code, notes, and snippets.

View davidalexander's full-sized avatar

David Alexander davidalexander

View GitHub Profile
@davidalexander
davidalexander / gist:1086437
Created July 16, 2011 15:17
Shell command to find size of folder
# single folder
du -sh [FOLDERNAME]/
# subfolders
du --max-depth=1 [FOLDERNAME]/ | sort -n -r
@davidalexander
davidalexander / gist:1086732
Created July 16, 2011 20:26
jQuery Dismiss Lightbox with ESC
// 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
davidalexander / gist:1086773
Created July 16, 2011 20:47
.htaccess Environments
# http://thenerdary.net/articles/entry/htaccess-environments
RewriteEngine On
RewriteBase /
### SET UP ENVIORNMENTS ###
# Default to master
RewriteRule .* - [E=ENVIRONMENT:master]
@davidalexander
davidalexander / .htaccess
Created July 16, 2011 21:15
Magento fix for IE9 issues
### 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>
</IfModule>
<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
davidalexander / index.php
Created March 15, 2012 21:21
Thoughts on best way to test subdomain
<?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
davidalexander / index.php
Last active October 4, 2015 22:48
Magento developer subdomains
/**
* Set developer mode and display_errors based on subdomain
*/
$staging_subdomains = array(
's1',
's2',
's3',
's4',
's5',
'mac',
@davidalexander
davidalexander / gist:6937862
Created October 11, 2013 16:30
Magento - Report for count and revenue of promotions
SELECT
sr.`name` as rule_name,
count(*) as total_orders,
SUM(sfo.`total_paid`) as revenue,
sr.`rule_id`,
sfo.`applied_rule_ids`
FROM
`sales_flat_order` sfo,
`salesrule` sr
WHERE
xdebug.remote_autostart=true
xdebug.remote_enable=1
xdebug.collect_vars=on
xdebug.collect_params=4
xdebug.show_local_vars=on
xdebug.var_display_max_depth=5
xdebug.show_exception_trace=on
@davidalexander
davidalexander / gist:7772193
Created December 3, 2013 16:21
Magento: Efficiently get a single product attribute from product id
<?php
$attribute_value = Mage::getResourceSingleton('catalog/product')->getAttributeRawValue($productId, 'attribute_code', Mage::app()->getStore());
echo $attribute_value;
@davidalexander
davidalexander / magento_logrotate
Last active September 17, 2016 08:46
magento logrotate
# /etc/logrotate.d/magento
"/path/to/site/var/log/*.log"
"/path/to/another-site/var/log/*.log" {
compress
copytruncate
daily
missingok
notifempty
olddir archive