ajeesh-george

Magento Code Snippets

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

Pear for 1.4, mage for 1.5. File downloaded into /downloader/.cache/community/

./pear download magento-community/Shipping_Agent
./mage download community Shipping_Agent

	SET @entityid = '3';

	SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'varchar' AS 'type'
	FROM catalog_category_entity e
	JOIN catalog_category_entity_varchar eav
	ON e.entity_id = eav.entity_id
	JOIN eav_attribute ea
	ON eav.attribute_id = ea.attribute_id
	WHERE e.entity_id = @entityid
	UNION