Alexander Turiak Zifius

Technical Architect @adobe, craft beer aficionado, check-in driven

Zifius / ElasticSearch.sh

Last active August 29, 2015 14:18 — forked from ricardo-rossi/ElasticSearch.sh

	### USAGE
	###
	### ./ElasticSearch.sh 1.5.0 will install Elasticsearch 1.5.0
	### ./ElasticSearch.sh 1.4.4 will install Elasticsearch 1.4.4
	### ./ElasticSearch.sh will fail because no version was specified (exit code 1)
	###
	### CLI options Contributed by @janpieper
	### Check http://www.elasticsearch.org/download/ for latest version of ElasticSearch

	### ElasticSearch version

Zifius / get-gallery-images.sql

Last active March 24, 2016 00:16 — forked from tegansnyder/get-images-for-sku.sql

Query to get all gallery images with position and disabled flag

	SELECT DISTINCT b.value, a.sku, c.position, c.disabled
	FROM `catalog_product_entity` AS a
	LEFT JOIN `catalog_product_entity_media_gallery` AS b ON a.entity_id = b.entity_id
	INNER JOIN `catalog_product_entity_media_gallery_value` AS c ON c.value_id = b.value_id
	ORDER BY a.sku, c.position

Zifius / defaults.conf

Created July 9, 2011 13:04 — forked from shadowhand/defaults.conf

	location / {
	index index.php index.html index.htm;
	try_files $uri index.php$uri;
	}

	error_page 500 502 503 504 /50x.html;
	location = /50x.html {
	root /opt/local/share/nginx/html;
	}