7ochem

Magento Snippets

Set all Images to first position as default

UPDATE catalog_product_entity_media_gallery AS mg,
    catalog_product_entity_media_gallery_value AS mgv,
    catalog_product_entity_varchar AS ev
SET ev.value = mg.value
WHERE  mg.value_id = mgv.value_id

7ochem

<?php
// Init framework
require 'app/Mage.php';
Mage::app();

// Factory methods to search for
$methods = array(
  'Mage::helper',
  'Mage::getModel',
  'Mage::getResourceModel',

7ochem

(MySQLDUMP_DATABASE=$(sed -n 's/^.*<dbname><!\[CDATA\[\(.*\)\]\]><\/dbname>.*/\1/p' app/etc/local.xml | head -n1) \
&& \
mysqldump -h$(sed -n 's/^.*<host><!\[CDATA\[\(.*\)\]\]><\/host>.*/\1/p' app/etc/local.xml | head -n1) \
 -u$(sed -n 's/^.*<username><!\[CDATA\[\(.*\)\]\]><\/username>.*/\1/p' app/etc/local.xml | head -n1) \
 -p$(sed -n 's/^.*<password><!\[CDATA\[\(.*\)\]\]><\/password>.*/\1/p' app/etc/local.xml | head -n1) \
 $MySQLDUMP_DATABASE \
 --ignore-table=${MySQLDUMP_DATABASE}.core_cache \
 --ignore-table=${MySQLDUMP_DATABASE}.core_cache_tag \
 --ignore-table=${MySQLDUMP_DATABASE}.log_url \
 --ignore-table=${MySQLDUMP_DATABASE}.log_url_info  \

7ochem

## here is the original ~/.bashrc

# Alias definitions.
# You may want to put all your additions into a separate file like
# ~/.bash_aliases, instead of adding them here directly.
# See /usr/share/doc/bash-doc/examples in the bash-doc package.

if [ -f ~/.bash_aliases ]; then
    . ~/.bash_aliases
fi

7ochem

" Vim RC
" Based upon Rud5G .vimrc
" @link https://gist.github.com/Rud5G
" @link https://gist.github.com/2316255
"
" Below some links that could help understand and edit this file
" @link http://vimdoc.sourceforge.net/htmldoc/options.html
" @link http://www.eng.hawaii.edu/Tutor/vi.html [BROKEN!]
" -> {@link http://www.linuxfocus.org/English/May2000/article153.shtml}
"