How to make Paypal Recurring system for any site.

Hello every one today i am going to tell you how to make paypal recurring method for any site you can easily iterated this method to any website.

How to run direct MySQL Queries in Magento

While developing custom solutions for Magento, developers should always think about performance. There are many areas that we can focus on: block caching and removing unnecessary blocks from layout, disabling unused modules, database-related optimisation. Let's talk about the database-related optimisation, about direct SQL queries in particular.

How to create an attribute field for customer account in Magento

Follow these steps to create attribute :
Step 1: Create this file and save on this location app\etc\modules\Excellence_Profile.xml

<?xml version="1.0"?>
<config>
    <modules>
        <Excellence_Profile>
            <active>true</active>
            <codePool>local</codePool>
        </Excellence_Profile>
    </modules>
</config>

How to Make Custom admin theme in Magento

Follow these steps :-
 

Step 1:- Save this file in app/etc/modules/Smart_Admintheme.xml

<?xml version="1.0"?>
<config>
    <modules>
        <Smart_Admintheme>
            <active>true</active>
            <codePool>local</codePool>
        </Smart_Admintheme>
    </modules>
</config>

How to enable tempalte and block path hints in Magento

Run this query in your database.

INSERT INTO core_config_data (scope, scope_id, path,value)

VALUES ('default', 0, 'dev/debug/template_hints', 1),
('default', 0, 'dev/debug/template_hints_blocks', 1);

To disable them again, run this query:
UPDATE core_config_data set value = 0 where scope = 'default' and scope_id = 0 and path ='dev/debug/template_hints'

To enable again run this query:
UPDATE core_config_data set value = 1 where scope = 'default' and scope_id = 0 and path ='dev/debug/template_hints'