Darren Felton dfelton

Scripts for synching a development Magento database database with it's live counterpart.

Adds a Region Selector to custom Magento entity types that have standard address attributes.

Numerous SQL snippets to reference for pulling data straight from Magento's database.

All SQL snippets assume there is no database table name prefix configured. In the event that your database does have a table nameprefix, you should be able to simply update the original table names found in the "FROM" and "LEFT JOIN" declarations. All table names are aliased therefore a full revision of the SQL snippets would not be necessary.

	UPDATE
	`catalog_product_entity_int`
	SET
	`value` = '1'
	WHERE
	`attribute_id` = (
	SELECT
	`attribute_id`
	FROM
	`eav_attribute`

	<?php
	// app/code/local/FirstScribe/ModuleName/Model/Observer/Adminhtml.php
	/**
	* Observer class. Public method names correspond directly to the event which
	* they observe.
	*
	* @category FirstScribe
	* @package FirstScribe_ModuleName
	* @author ${author}
	* @version ${date}

	<?php
	/**
	* Finds simple products which belong to a configurable, and have no base image.
	* Then assigns the base image from the configurable to that simple product.
	*
	* @category FirstScribe
	* @package FirstScribe_Shell
	* @author Darren Felton
	*/

	<?php
	/**
	* Finds simple products which belong to a grouped product, and have no base image.
	* Then assigns the base image from the grouped product to that simple product.
	*
	* @category FirstScribe
	* @package FirstScribe_Shell
	* @author Darren Felton
	*/

	<?php

	// Example Usage for cms/page objects.
	// cms_page_prepare_save event observer logic:
	//
	// $model = $observer->getEvent()->getPage();
	// $this->processFile($model, 'image_1', 'cms/page', array('jpg', 'jpeg', 'png', 'bmp', 'gif'));


	/**

	Instructions on how to add an Instagram Feed to a Magento Site.

	Includes:
	Block Class w/ base template for rendering the feed
	System -> Configuration options for connecting to the client's Instagram account
	Default CSS Styles