Martin Schultheiß mschultheiss83

mschultheiss83 / gist:6366100

Created August 28, 2013 13:31 — forked from ryaan-anthony/gist:6290973

	delimiter ;;
	drop procedure if exists build_catalog;;
	create procedure build_catalog(IN categories INT, IN products INT)
	begin
	SET @category_count = 1;
	SET @CATNAMEPREFIX = "Category ";
	SET @CATURLKEYPREFIX = "cat-";
	SET @CATURLPATHPREFIX = "catpath-";
	SET @ROOTCATEGORY = 2;
	SET @INCLUDEINMENU = 1;

mschultheiss83 / magento-code-snippets.md

Created September 2, 2013 11:43 — forked from arosenhagen/magento-code-snippets.md

Magento Code Snippets

./mage config-set preferred_state stable
./mage clear-cache
./mage sync
./mage download community Module_Name

mschultheiss83 / gitignore-file-for-magento-project

Last active December 22, 2015 03:39 — forked from nesh/gist:364586

	# original from http://activecodeline.com/git-ignore-gitignore-file-for-magento-project

	# tested with Magento 1.4.0.1
	# put it into magento install dir

	app/code/community/Phoenix/
	app/code/core/

	app/design/adminhtml/default/default/
	app/design/frontend/base/

mschultheiss83 / time.php

Created September 5, 2013 14:23

Calculate script execution time (PHP class)

	<?php
	/**
	* http://codeaid.net/php/calculate-script-execution-time-(php-class)
	* Created by tripuls.
	* User: m.schultheiss
	* Date: 05.09.13
	* Time: 16:20
	*/

	class Timer

mschultheiss83 / clFile.php

Last active December 29, 2015 10:19

Dateinamen bereinigen clean up filenames

	<?php
	/**
	* äöüß und co
	*/
	function cleanUpFilename($val){
	// whitespace durch Unterstrich ersetzen
	$new = preg_replace('=(\s+)=', '_', $val);
	// Liste aller Umlaute
	$map = array(
	'ä' => 'ae',

mschultheiss83 / .gitignore

Last active December 29, 2015 10:19

Magento gitignore

mschultheiss83 / regular-expressions.link.txt

Created December 3, 2013 15:01

regular-expressions

http://net.tutsplus.com/tutorials/other/8-regular-expressions-you-should-know/

mschultheiss83 / magento_sql_snippets.md

Created March 13, 2014 13:33 — forked from petemcw/magento_sql_snippets.md

TRUNCATE `log_customer`;
TRUNCATE `log_quote`;
TRUNCATE `log_summary`;
TRUNCATE `log_url`;
TRUNCATE `log_url_info`;

mschultheiss83 / local.xml

Created May 8, 2014 14:46 — forked from MikeWilkie/local.xml

	<?xml version="1.0"?>
	<!-- license -->
	<config>
	<global>
	<!-- global config -->
	</global>
	<frontend>
	<events>
	<!-- disble logs -->
	<controller_action_predispatch>

mschultheiss83 / gist:9a35b077da256d0d8606

Last active August 29, 2015 14:01

Magento - loadMedialGallery by Product Id and Store Id

	<?php

	$backend = Mage::getResourceModel('catalog/product_attribute_backend_media');

	$attributeId = Mage::getResourceModel('eav/entity_attribute')->getIdByCode('catalog_product', 'media_gallery');
	$container = new Varien_Object(array(
	'attribute' => new Varien_Object(array('id' => $attributeId))
	));
	$product = new Varien_Object(array(
	'id' => 519,