Archive for November 2018

Update website base url

Posted on November 30, 2018, 2:28 pm, by admin, under Magento 1.x, Tips.

UPDATE core_config_data SET VALUE=’http://www.website.com/’ WHERE path=’web/unsecure/base_url’; UPDATE core_config_data SET VALUE=’http://www.website.com/’ WHERE path=’web/secure/base_url’;

No Comments | Read the rest of this entry »

Cms Block Stores

Posted on November 29, 2018, 1:12 pm, by admin, under Magento 1.x, Tips.

$blockCollection = Mage::getResourceModel(’cms/block_collection’); foreach($blockCollection as $block) { Zend_Debug::dump($block->getResource()->lookupStoreIds($block->getBlockId())); }

No Comments | Read the rest of this entry »

Redirecting in observer

Posted on November 23, 2018, 5:53 pm, by admin, under Magento 1.x, Tips.

$controller = $observer->getEvent()->getControllerAction(); $controller->getResponse()->setRedirect($redirectUrl); $controller->setFlag(”, Mage_Core_Controller_Varien_Action::FLAG_NO_DISPATCH, true); $controller->setFlag(”, Mage_Core_Controller_Varien_Action::FLAG_NO_POST_DISPATCH, true);

No Comments | Read the rest of this entry »

Reset customer password in db

Posted on November 2, 2018, 1:17 pm, by admin, under Magento 1.x.

UPDATE customer_entity_varchar SET VALUE = md5(’new_password’) WHERE entity_id=(SELECT entity_id FROM customer_entity WHERE email=’email@hostname.com’) AND attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code = ‘password_hash’ AND entity_type_id = 1);

No Comments | Read the rest of this entry »