// Import sql file
mysql -h HOST --port=3307 -p -u USER DATABASE < FILE
// example
mysql -h localhost --port=3307 -p -u root main < main_dump.sql
// Import archive
evgv
/ mage_redirect_to_parent_category_from_empty_category.md
Created
April 27, 2016 07:01
Magento. Observer method for redirect from empty category to parent.
/**
* Redirect from empty category to parent
* Observe event - core_block_abstract_to_html_before
*
* @param Varien_Event_Observer $observer
*/
public function redirectToParentCategory(Varien_Event_Observer $observer)
{
Varien_Profiler::start(__METHOD__);
evgv
/ mage_redirect_to_product_category_from_disabled_product.md
Last active
April 27, 2016 07:15
Magento. Observer method for redirect from disabled product to last product category.
/**
* Redirect from disabled product to product last category
* Obseve event - controller_action_predispatch_catalog_product_view
*
* @param Varien_Event_Observer $observer
*/
public function catalogProductViewPredispatch(Varien_Event_Observer $observer)
{
evgv
/ mage_set_custom_layout_by_customer_group.md
Created
May 20, 2016 12:08
Mage. Set custom layout by customer group.
protected $_customer_groups = array('NOT_LOGGED_IN', 'Genaral', 'Wholesale', 'Retail');
/**
* Get current customer group and update handle depend from current group
* Observe event "controller_action_layout_load_before"
*
* @param Varien_Event_Observer $observer
*/
public function setTemplate(Varien_Event_Observer $observer)
evgv
/ mage_sql_restore_admin_password.md
Created
June 9, 2016 13:39
Magento. SQL query for restore admin password.
UPDATE admin_user SET password = CONCAT (MD5 ('sGnewpass'), ': sG') WHERE username = 'AdminUsername';
/**
* All of these functions can be found in class Mage_Core_Model_Store
* File: app/code/core/Mage/Core/Model/Store.php
*/
//Get store data
Mage::app()->getStore();
evgv
/ mage.send_email.md
Last active
June 27, 2016 10:17
— forked from damiann/send_email
Magento. Send Magento template email with attachment.
// using model magento\app\code\core\Mage\Core\Model\Email\Template.php
public function send_error_email($error = NULL) {
$mailTemplate = Mage::getModel('core/email_template');
$mailTemplate->setSenderName('Insert Sender Name'); // use general Mage::getStoreConfig('trans_email/ident_general/name');
$mailTemplate->setSenderEmail('insert@sender.email'); // use general Mage::getStoreConfig('trans_email/ident_general/email')
$mailTemplate->setTemplateSubject('Insert Subject Title');
$mailTemplate->setTemplateText('Insert Body Text');
evgv
/ mage_get_active_payment_methods.md
Created
June 30, 2016 14:26
Magento. Get all active payment methods.
/**
* Retrieve all active payment methods
*/
public function getActivPaymentMethods()
{
$payments = Mage::getSingleton('payment/config')->getActiveMethods();
$methods = array(array('value'=>'', 'label'=>Mage::helper('adminhtml')->__('--Please Select--')));
Mage::getModel('sales/order')->loadByIncrementId('10000001'); //use a real increment order id here
Mage::getModel('sales/order')->load(24999); //use an entity id here
evgv
/ mage_redirect_to_in_observer.md
Created
July 4, 2016 12:26
Magento. Redirect to custom URL in observer. Close default route.
/**
* Redirect redirect from default customer/account/createPost action to noRoute action (404 page)
* Observer event "controller_action_predispatch_customer_account_createpost"
*/
public function redirectToNoRoute()
{
Mage::app()->getResponse()
->setRedirect(Mage::getUrl('cms/index/noRoute'), 301)OlderNewer