Magento Articles and Tips for Developers

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);

$erpSettings = Mage::getStoreConfig('my/path/settings');

$storeId = 15;
$erpSettings = Mage::getStoreConfig('my/path/settings', $storeId);

echo Mage::helper("adminhtml")->getUrl("/vendorname_modulename/controllername/",array("param1" => $value1));

echo Mage::helper("adminhtml")->getUrl("/vendorname_modulename/controllername/");

$website_id = Mage::app()->getWebsite()->getId();

$store_id = Mage::app()->getStore()->getId();

$store_id = Mage::app()->getStore($storeCode)->getId();

$store_id = Mage::getModel("core/store")->load($storeCode, "code");

    public function getSingleRecord($userId)
    {
        return $this->getCollection()
            ->addFieldToFilter('user_id', $userId)
            ->getFirstItem();
    }

SELECT * FROM magento01.core_config_data WHERE path LIKE 'modulename%';

<?xml version="1.0"?>
<config>
    <default>
        <modulename>
            <parametergroup>
                <param>value</param>
            </parametergroup>
        </modulename>
    </default>
</config>

$tableDataCollection = Mage::getResourceModel('modulename/tablename_collection')->setPageSize(50);
 
$tableDataCollection->getSelect()
            ->join(array('alias' => Mage::getSingleton('core/resource')->getTableName('modulename/tablename')),
                'main_table.id=alias.id', '*')
            ->where('alias.condition = ?', true);