Željko Prša zeljkoprsa

zeljkoprsa / CRLF to LF

Created January 28, 2011 13:11

On *nix

$ git config core.autocrlf false

zeljkoprsa / Magento:: Call Static Block

Created January 27, 2011 11:57

<?php echo $this->getLayout()->createBlock('cms/block')->setBlockId('block-name')->toHtml() ?> 

zeljkoprsa / Magento db Before Import

Created January 26, 2011 07:57

Code to insert at the top and the bottom of the exported "Magento db" to get properly imported again. By Branko Ajzele http://ajzele.net/moving-magento-site-from-development-to-live-server

	Place these lines of SQL code on very top of the .sql file:

	SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
	SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
	SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
	SET NAMES utf8;
	SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
	SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
	SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
	SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0;