siffring

# ----------------------------------------------------------------------
# Password protect staging server
# Use one .htaccess file across multiple environments
# (e.g. local, dev, staging, production)
# but only password protect a specific environment.
# ----------------------------------------------------------------------

SetEnvIf Host staging.domain.com passreq
AuthType Basic
AuthName "Password Required"

marcedwards

/* ---------------------------------------------------------- */
/*                                                            */
/* A media query that captures:                               */
/*                                                            */
/* - Retina iOS devices                                       */
/* - Retina Macs running Safari                               */
/* - High DPI Windows PCs running IE 8 and above              */
/* - Low DPI Windows PCs running IE, zoomed in                */
/* - Low DPI Windows PCs and Macs running Firefox, zoomed in  */
/* - Android hdpi devices and above                           */

peterjaap

<?php

/*
 * This script deletes duplicate images and imagerows from the database of which the images are not present in the filesystem.
 * It also removes images that are exact copies of another image for the same product.
 * And lastly, it looks for images that are on the filesystem but not in the database (orphaned images).
 * 
 * This script can most likely be optimized but since it'll probably only be run a few times, I can't be bothered.
 *
 * Place scripts in a folder named 'scripts' (or similar) in the Magento root.

thorstenfriesen

$$('.checkout-agreements p.agree').each(function(item){
  var agreementsBlock = $(item);
	if(agreementsBlock != undefined) {
	    agreementsBlock.replace('<p class="agree">' + agreementsBlock.innerHTML + '</p>');
	}
});

erfanimani

### MAGENTO DIRECTORIES

# Ignore everything in media, except for the htaccess files
# Also include the Lazy Catalog Images (LCI) .htaccess if that's installed
# (https://github.com/AOEpeople/Aoe_LazyCatalogImages)
/media/*
!/media/.htaccess
!/media/customer/.htaccess
!/media/downloadable/.htaccess
!/media/catalog/product/LCI/.htaccess

reidblomquist

The following SQL queries should set an orders status to canceled:

UPDATE sales_flat_order SET state = 'canceled', status = 'canceled' WHERE increment_id IN (order#1,order#2,etc);

UPDATE sales_flat_order_grid SET status = 'canceled' WHERE increment_id IN (order#1,order#2,etc);

markshust

find app/code/local/ -type f -name "*.xml" -exec xmllint --noout {} \;

loopool

SET FOREIGN_KEY_CHECKS=0;

-- Delete all products
TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
TRUNCATE TABLE `catalog_product_entity_int`;

renttek

From 473846959772d8160b34b92ae3bcecddf24b972f Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Julian=20Nu=C3=9F?= <julian.nuss@outlook.com>
Date: Tue, 23 Sep 2014 21:07:29 +0200
Subject: [PATCH 1/1] [BUGIFX] Zend Framework 1 + PHP5.6

---
 lib/Zend/Locale/Format.php          | 22 +++++++++++-----------
 lib/Zend/Service/Audioscrobbler.php |  6 +++---
 lib/Zend/Service/Technorati.php     |  6 +++---
 lib/Zend/Validate/Hostname.php      |  4 ++--

avoelkl

How-to

Add --single-transaction and --quick to your mysqldump command.

--single-transaction

sets the isolation mode to REPEATABLE READ and starts a transaction before dumping data. useful for InnoDB tables, dumps the consistent state without blocking any applications.

--quick