IMP magento extension links

magento feed
http://www.gomage.com/extensions/advertising-marketing/gomage-feed-pro.html/#
.......................................

Social links
http://www.magentocommerce.com/magento-connect/Meanbee/extension/4103/meanbee_ordershare
..........................................................

leftnavegation:-:

 http://www.magentocommerce.com/magento-connect/sidebar-navigation-menu-4554.html
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

category id perticular products
http://www.magentocommerce.com/answers/discussion/1771/getting-specific-category-id-from-product/p1
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

solve error for ship order in admin

  $shippingMethod = $this->getData('shipping_method');
replace this line at the line no 133 item.php
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

show latest post in magento
http://fishpig.co.uk/wordpress-integration/adding-recent-posts-to-the-homepage/

http://www.sonassi.com/knowledge-base/magento-kb/integrate-wordpress-feeds-in-magento/
------------------------------------------------------------------------------

Twotter extension as slider and more
http://www.packtpub.com/article/integrating-twitter-magento#more
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

wordpress blog
http://www.magentocommerce.com/magento-connect/wordpress-integration.html
++++++++++++++++++++++++
twitter
http://www.magentocommerce.com/magento-connect/catalog/product/view/id/11920/
+++++++++++++++++++++++++
display attribute

<?php
$product = Mage::getModel('catalog/product');

$attribute=$product->getResource()->getAttribute("color");


if($attribute->usesSource()){

  
    $options = $attribute->getSource()->getAllOptions(false);?>
<td>

<?php  foreach ($options as $_item):
 //print_r($_item);?>
 
  <li> <a href="#"><?php echo $_item['label'] ?></a> </li>
 <?php endforeach  ?>

 </td>
<?php }
?>
....................................
<?php
$product = Mage::getModel('catalog/product');

$attribute=$product->getResource()->getAttribute("color");


if($attribute->usesSource()){

  
    $options = $attribute->getSource()->getAllOptions(false);?>
<td>

<?php  foreach ($options as $_item):
 //print_r($_item);?>
 
  <li>  <a href="<?php echo Mage::registry('current_category')->getUrl();?>?color=<?php echo $_item['value'];?>"><?php echo $_item['label'] ?></a> </li>
 <?php endforeach  ?>

 </td>
<?php }
?>................................................................................
==================================================================

paging in new product
http://www.dnawebagency.com/displaying-new-products-in-magento-with-pagination
*************************************************************

inner zoop product extension
http://www.magentocommerce.com/magento-connect/moo-cloudzoom.html
*************
http://www.magentocommerce.com/magento-connect/cloud-zoom-4634.html
**************************************************************************

upgrade magento version
http://www.expertmagentodevelopers.com/blog/how-to-upgrade-from-magento-1-5-1-to-magento-1-6-0/
http://www.slideshare.net/expertmagentodevelopers/learn-how-to-upgrade-to-magento-16
+++++++++++++++++++++++++++++++++++++++++++++++++++++

category import using csv
http://blog.srmklive.com/2011/03/21/how-to-export-categoriessubcategories-from-x-cart-to-magento/
++++++++++++++++++++++++

Create multiple store
http://www.magentocommerce.com/magento-on-the-fly/multiple-sites2

++++++++++++++++++++++++++++++++++++++++++
search contant from cms extension in magento
http://www.magentocommerce.com/magento-connect/tangkoko-and-fidesio-cms-search.html
++++++++++++++++++++++++++++++++

IMP Extensions : http://www.magentocommerce.com/magento-connect/developer/Magazento

+++++++++++++++++++++++++++++++++++++++++++++++++

tutorials magento
http://www.scribd.com/doc/77640577/70/Layered-Navigation
++++++++++++++++++++++++++++++++++++++++
filter by price good extension
http://magento.virginsoft.net/index.php/filter
+++++++++++++++++++++++++++++++++++
yougasht
http://yoast.com/landing-pages-module-magento/
+++++++++++++++++++++++++++++++++++++++++++++++++
statick block
<?php echo $this->getLayout()->createBlock('cms/block')->setBlockId('featured')->toHtml() ?>
++++++++++++++++++++++++++++++++++++++++++++

imp extension
http://blog.gaiterjones.com/magento-create-a-customer-product-pop-up-message-based-on-location/
+++++++++++++++++++++++++++++++++++++

seo friendly url
http://www.bestdesigns.co.in/blog/remove-index-php-url-magento
+++++++++++++++++++++++++++++++++++++++++

Recently sold item
 http://www.magikthemes.com/question-answers/how-to-show-best-selling-products-on-home-page-in-magento/
+++++++++++++++++++++++++++++++++

Multiple shipping accordint to order amount
http://www.magentocommerce.com/magento-connect/pickup-at-event-multiple-flatrates.html
++++++++++++++++++++++++++++++++++++++++++++++++++++++


for sql query

http://fishpig.co.uk/magento-tutorials/direct-sql-queries-magento
++++++++++++++++++++++++++++++++++++++++++++++++++++++++


light box paid with multiple image
http://www.magentocommerce.com/magento-connect/brandammo/extension/6534/progallery_advanced_product_image_gallery
+++++++++++++++++++++++++++++++++++++++++++++++++++
Custom module
http://www.exploremagento.com/magento/simple-custom-module.php
++++++++++++++++++++++++++++++++++++++++++

very imp roted images 360 degree
http://www.jquery4u.com/plugins/jquery-360-degrees-image-display-plugins/
++++++++++++++++++++++++++++++++++++++++++++


Currency with flag

 http://www.magentocommerce.com/boards/viewthread/240341/#t341337


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
left nevigation
http://www.magentocommerce.com/magento-connect/Rico+Neitzel/extension/763/vertical-navigation-with-css-classes
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

BL( ballu.malav@gmail.com )
Multiple flate rate
http://www.magentocommerce.com/magento-connect/sherrie/extension/306/pickup-at-event--multiple-flatrates

++++++++++++++++++++++++++++++++++++++++++++

Best seller TopRating/Populer/Reviews/New/BestSeller
http://www.magentocommerce.com/magento-connect/Magazento/extension/6647/magazento_homesellers



{{block type="homepage/topsell" template="magazento/homepage/topsell.phtml"}}

{{block type="homepage/new" template="magazento/homepage/new.phtml"}}

{{block type="homepage/popular" template="magazento/homepage/popular.phtml"}}

{{block type="homepage/toprated" template="magazento/homepage/toprated.phtml"}}

{{block type="homepage/review" template="magazento/homepage/review.phtml"}}

Extensions
http://www.ecommercecircle.com/magento-extensions-ecommerce-store_3912793.html


I-Banner

http://www.magentocommerce.com/magento-connect/magestore/extension/1850/banner-slider
+++++++++++++++++++

http://www.magentocommerce.com/magento-connect/Theodore+Doan/extension/4330/my_ibanner
 +++++++++++++
extension for blog

http://www.magentocommerce.com/magento-connect/aheadworks/extension/1516/blog-extension-by-aheadworks


-------------------------------------------------------------


extension for joom image
Mpycho_Jquery_Lightboxes
http://192.168.1.11/sextoynew/



Create product type
http://www.zetaprints.com/magentohelp/web-to-print-product-type-compatibility/#config

2  http://www.magentocommerce.com/knowledge-base/entry/tutorial-creating-a-configurable-product/
3 Very importent extension
http://www.zetaprints.com/magentohelp/create-simple-web-to-print-products/


For shipping

http://addoa.com/blog/how-restrict-free-shipping-magento


http://www.magentodevelop.com/blog/category/magento-admin/magento-shipping

+++++++++++++++++++++++++++++++++++++++++++++++

Live chect extension

http://www.magentocommerce.com/magento-connect/isidore/extension/3246/zopim-live-chat
******************************************************************************
Shipping extension
http://www.webshopapps.com/
+++++++++++++++++++++++++++++++++++++++++++++++++++++

For onsale

http://www.magentocommerce.com/magento-connect/thirty4+interactive/extension/841/catalog-sale-items
++++++
http://www.h-o.nl/blog/display-special-priced-products-on-homepage-magento/

++++++++++++++++++++++++++++++++++++++++++++
FOR ON SALE

http://www.magentocommerce.com/boards/viewthread/16098/

http://jainsamaj.org/rpg_site/literature4.php?id=89
http://www.magentocommerce.com/boards/viewthread/16098/
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
display random product
http://blog.decryptweb.com/random-products-in-magento/
+++++++++++++++++++++++++++++++++++++
randon best seller
http://www.magikthemes.com/question-answers/how-to-display-random-products-on-home-page-in-magento-theme/
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++

onsale product extension

http://www.mage-world.com/advance-on-sale-products-magento-extension

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
http://www.magentocommerce.com/magento-connect/developer/clockworkgeek
Free extension
+++++++++++++++++++++++++++++

 pagging with new arrival products

http://www.magentocommerce.com/boards/viewthread/31159/
+++++++++++++++++++++++++++++++++++
For MP3 Player Extension
http://www.webdesignbooth.com/10-easy-to-implement-flash-based-mp3-players-for-your-website/

2   http://www.magentocommerce.com/magento-connect/desv.us/extension/5390/mp3_flash_player

3
http://www.instantshift.com/2010/02/10/21-free-music-players-for-your-website/
++++++++++++++++++++++++++++++++++++++++

Free Testmonial extension
http://www.magentocommerce.com/magento-connect/Turnkeye.com/extension/4876/testimonials_pro
++++++++++++++++++++++++++++++
Contacu Us form
http://www.mage-world.com/quick-contact-extension-for-magento
+++++++++++++++++++++++++++++++++++
Free module
http://www.magentocommerce.com/magento-connect/rebimol/extension/7232/webforms
+++++++++++++++++++++++++++++++++++
http://www.richardcastera.com/blog/magento-add-additional-fields-to-the-contact-form
+++++++++++++++++++++++++++++++++++++
Cloth Extension
For clolor
http://demo.temgra.com/index.php/color-views/color-views-magento-extension-magento-plug-in.html
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
http://www.magentocommerce.com/magento-connect/temgra/extension/893/color-swatches
++++++++++++++++++++++++++++++++++++
http://techdad.wordpress.com/2010/02/20/most-downloaded-magento-extensions/
+++++++++++++++++++++++++++++++++++++++++
for shorting color soze
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
for remove default link

 http://www.magentocommerce.com/knowledge-base/entry/turning-on-off-magentos-content-blocks/
+++++++++++++++++++++++++++++++
http://store.belvg.com/demo/iconoptions/configurable-product.html
==================================================================

Extension for blog
http://www.magentocommerce.com/magento-connect/aheadworks/extension/1516/blog-extension-by-aheadworks
===================================================================
How to upload product using CSV file

http://www.magentocommerce.com/magento-connect/capacitywebsolutions/extension/4421/import_products_categories__multiple_images_and_custom_options
++++++++++++++++++++++++++++++++++++++++++++++++++
Light box

http://www.magentocommerce.com/magento-connect/TemplatesMaster/extension/1487/magento-easy-lightbox
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
Magento dropdwon


http://web-experiment.info/webandpeople-custom-menu-extension.html
++++++++++++++++++++++++++++++++++++++++++++
Paid dropdown
http://www.manadev.com/demo/drop-down-list-for-layered-navigation/index.php/electronics.html?___store=checkboxes&___from_store=default
+++++++++++++++++++++++++++++
Use for shorting it's paid 19$
http://www.magentocommerce.com/magento-connect/Mana+Team/extension/7480/drop-down-list-for-layered-navigation
+++++++++++++++++++++++++++++++++++++++++++++++
For dropdown menu

http://www.magentocommerce.com/magento-connect/EMThemes.com/extension/5163/em_catalogmenuwidget


Paid only 1$
http://www.magentocommerce.com/magento-connect/WebAndPeople/extension/5765/wp_custom_menu
++++++++++++++++++++++++++++
++++++++++++++++++++++++
Shippimg skip method/Skip
 http://winvinod.blogspot.com/2011/06/skip-shipping-method-from-onepage.html

+++++++++++++++++++++++++++++++++++++++
skip onpage checkout
http://connect20.magentocommerce.com/community/Crius_SkipStep1
+++++++++++++++++++++++++++++

Very most all extensions
 http://techdad.wordpress.com/2010/02/20/most-downloaded-magento-extensions/
++++++++++++++++++++++++++++++++++++++++++++++
for Recurring profile

http://www.magentocommerce.com/knowledge-base/entry/working-with-recurring-profiles
+++++++++++++++++++++++++++++++++++++
Gift cart
http://ecommercesoftwaresolutionsonline.com/magento-services-pricing/magento-extensions/magento-free-gift-product-extension.html


http://www.magentocommerce.com/magento-connect/varyous/extension/3570/freegift
+++++++++++++++++++++++++++++++++++++
Free Price complain
http://www.magentocommerce.com/magento-connect/Magazento/extension/6646/magazento_priceproposal
+++++++++++++++++++++++++++++++++++++
Custom shipping method
http://inchoo.net/ecommerce/magento/custom-shipping-method-in-magento/der
+++++++++++++++++++++++++++++++++++++++++++
reques catalogue form


http://www.magentocommerce.com/boards/viewthread/72142/

call modules:{{block type=\"catalogrequest/catalog\" template=\"catalogrequest/catalogrequest.phtml\"}}

http://www.magentocommerce.com/magento-connect/ebizmarts/extension/1208/ebizmarts-mail-chimp-module
..............................
+++++++++++++++++++++++++++++++++++++++++++++++++++++
quick buy overview of products

http://www.magentocommerce.com/magento-connect/EMThemes.com/extension/6195/em_quickshop

++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Smart former gold
http://www.magentocommerce.com/magento-connect/IToris/extension/4213/professional_form_builder_smartformer_gold
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Quick Shop
http://www.magentocommerce.com/magento-connect/EMThemes.com/extension/6195/em_quickshop
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Quick overview in tab on detail page

http://www.magentocommerce.com/magento-connect/TemplatesMaster/extension/1725/magento-easytabs

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Left navigation bar vertical category

http://www.magentocommerce.com/magento-connect/Rico+Neitzel/extension/763/vertical-navigation-with-css-classes
++++++++++++++++++++++++++++++++++++++++++++++

Dynamic banner for home page

 http://www.magentocommerce.com/magento-connect/Interakting.com/extension/2255/interakting-slider
+++++++++++++++++++++++++++++++++++++++
top menu with Ajex

 http://www.magentocommerce.com/magento-connect/OlivertAr/extension/657/navigation-bar-administrator
+++++++++++++++++++++++++++++++++++++++++++++
Face Book like button per product:

 http://www.magentocommerce.com/extension/specs/3816/facebooklb#specs
call button:
 <?php echo $this->getLayout()->createBlock('core/template')->setTemplate('facebooklb/like.phtml')->toHtml(); ?>
++++++++++++++++++++++++++++++++++++++++++++++++++++
On mouse over show my cart product

 http://www.magentocommerce.com/magento-connect/Vitalityshop/extension/6424/cartview
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
Gift cart:

http://www.magentocommerce.com/magento-connect/Vitalityshop/extension/6424/cartview

 http://www.magentocommerce.com/magento-connect/amahi/extension/6559/s3ibusiness_giftpromo
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Drop Down menu in left side

 http://www.magentocommerce.com/magento-connect/officeecommerce/extension/7747/ecommerceoffice_megamenusidebar
++++++
+++++++++++++++++++++++
menu navigation bar:
http://www.magentocommerce.com/magento-connect/OlivertAr/extension/657/navigation-bar-administrator
++++++++++++++++++++++++++++++++++
Show category on home page with images

 http://hridaya.com.np/display-categories-with-images-on-homepage-in-magento/

++++++++++++++++++++++++++++++++++++++++++++++++++
Show category with image extansion

http://www.magentocommerce.com/magento-connect/TemplatesMaster/extension/1562/magento-easy-catalog-images
+++++++++++++++++++++++++++++++++++++

Joomla show hide modules

<?php if($this->countModules('communities')) : ?>
++++++++++++++++++++++++++++++++++++++++++++++++++++++
currency converter extension
http://www.magentocommerce.com/magento-connect/jextn_theme/extension/6926/jextn_currencyconverter
++++++++++++++++++++++++++++++++++++++++++++++++++++
 Currency converter with flag
http://www.magentocommerce.com/magento-connect/TemplatesMaster/extension/1481/magento-easyflags
++++++++++++++++++++++++++++++++++++++++++++++++++
Simple currency convert in magento

http://inchoo.net/ecommerce/magento/how-to-add-currency-selector-to-magentos-header/
+++++++++++++++++++++++++++++++++++++++++++++++++++
currency convert with flag

 http://www.magentocommerce.com/magento-connect/jextn_theme/extension/6926/jextn_currencyconverter
Key:http://connect20.magentocommerce.com/community/Jextn_Currencyconverter

++++++++++++++++++++++++++++++++++++++++++++++++++++++
Js for tabing
http://www.dynamicdrive.com/dynamicindex17/tabcontent2.htm
++++++++++++++++++++++++++++++++++++++++++++++++++++++++

dynamic cms page link in magento || show all cms pages links in top navigation

First open top.phtml file of your template. My path for this file is /public_html/app/design/frontend/default/hellostyle/template/catalog/navigation/top.phtml.
Now after this, Remove default menu code like this :
<?php $_menu = $this->renderCategoriesMenuHtml(0,'level-top') ?>
<?php if($_menu): ?>
<ul id="nav">
<?php echo $_menu ?>
</ul>
<?php endif ?>
And Add this code here :
<?php $collection = Mage::getModel('cms/page')->getCollection()->addStoreFilter(Mage::app()->getStore()->getId());?>
<?php  $collection->getSelect()
->where('is_active = 1'); ?>
<ul id="nav">
<?php foreach ($collection as $page): ?>
<?php $PageData = $page->getData(); ?>
<?php if($PageData['identifier']!='no-route' && $PageData['identifier']!='enable-cookies' && $PageData['identifier']!='home2') { ?>
<li>
<a href="/<?php echo $PageData['identifier']?>"><span><?php echo $PageData['title'] ?></span></a>
</li>
<?php } ?>
<?php endforeach; ?>
</ul>
now your all cms page links will be displayed in top navigation in default magento(CE)

magento mysql queries

In magento to Read or Write any query we need database connection.

1	$read = Mage::getSingleton('core/resource')->getConnection('core_read');

1	$write = Mage::getSingleton('core/resource')->getConnection('core_write');

These connections return special instances of the Mage_Core_Model_Resource class, that contains functions used to execute raw Mysql Queries.

Execute a Query

To execute any raw query in magento we can use any connection. For example to truncate a table.

1	$read->query("truncate table TABLE_NAME");

The query() function simply executes any raw query.

Select Query

1	$result = $read->fetchAll("select * from TABLE_NAME where Field = 'Value'");

This query will return a multidimensional Array with table as keys and table values as value. It is equivalent to mysql_fetch_array() function on the mysql. The fetchAll() function executes the query and returns all the rows of the table.

MysqlNumRows

To get the effected number of rows use the php count method to count the array.

1	count($result);

Insert Query

As before we used the $read object to execute the fetch query so the same $write object will be used to execute insert query.

1	$write->insert("TABLE_NAME", array("field" => "value", "field" => "value");

or

1	$write->query("insert into TABLE_NAME (field1, field2) values('value1', 'value2'");

Update Query

Update and Delete queries will also be executed in the same manner.

1 2 3 4 5

$data = array("field" => "value", "field" => "value");   $where = "id = 5";   $write->update("TABLE_NAME", $data, $where);

or

1	$write->query("update TABLE_NAME  set field = 'value'");

Delete Query

1 2 3

$where = "id = 5";   $write->delete("TABLE_NAME", $where);

1	$write->query("delete from TABLE_NAME where field = 'value'");

Executing the query in Zend way

http://framework.zend.com/manual/en/zend.db.html
Beside the raw query execution method we can use the Zend_Db to prepare the mysql statements. Zend_Db has methods to prepares the individual parts of the mysql query.
These methods can be executed using the $read object.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

//will create a select object   $select = $read->select();   // add table name using from clause   $select->from("TABLE_NAME");   // conditional clauses   $select->where(" .. condition .. ");   // set order   $select->order(" .. order criteria ..");

Get the right Table Name

Magento provides ability to add multiple store using a common database with table prefixs. So its better to let the magento find the accurate name of the table. To get the name of the table we can use the getTableName(); method.

1 2 3 4 5

$tableName = $read->getTableName("catalog/product");   // OR   $tableName = $this->getTable("catalog/product");

Example of full query

1 2 3 4 5 6 7

$result = $read->select()   ->from($tableName)   ->where("sku = ?", 5)    ->order("name", "asc");

List of DB Methods

http://framework.zend.com/manual/en/zend.db.table.html

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

// return all rows of the table in object form   $read->fetchAll(" .. query ..");   // return all rows of the table in associated array   $read->fetchAssoc(" .. query ..");   // return single row   $read->fetchRow(" .. query ..");   // insert query   $write->insert("TABLE_NAME", array("field"=>"value", "field"=>"value");   // to get the last auto increment id   $write->lastInsertId();   // update query   $write->update("TABLE_NAME", array("field" => "value", "field" => "value"), "where clause");   // delete query   $write->delete("TABLE_NAME", $where);   // num rows   count($result);

how to all record from table in magento

$allCollection=Mage::getModel("web/web")->getCollection();
 echo $allCollection;
 foreach($allCollection as $objRow)
 {

echo '<tr><td>'.$objRow->Title.'</td>';
echo '<td>'.$objRow->Content.'</td>';
echo '<td> <img src="'.$imgpathcustom.'/'.$objRow->Filename.'" height="70" width="70" /></td>';
//echo '<td>'.$objRow->Filename.'</td>';

echo '<td>'.$objRow->Status.'</td></tr>';


   // print_r($objRow);
}
?>

magento config file or key file

Mage::log Access the system logger
Mage::getModel Access a system model object
Mage::getStoreConfig Access the system configuration settings

how to connect magento database in magento

$resource   = Mage::getSingleton('core/resource');
$conn       = $resource->getConnection('externaldb_read');

how to develop custom module for backend and frontend

http://www.webspeaks.in/2011/03/update-magento-frontendbackend-modules.html

Re-indexing all indexing

How to solve indexing problem?

DROP TABLE IF EXISTS `index_process_event`;
DROP TABLE IF EXISTS `index_event`;
DROP TABLE IF EXISTS `index_process`;


CREATE TABLE `index_event` (
`event_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` VARCHAR(64) NOT NULL,
`entity` VARCHAR(64) NOT NULL,
`entity_pk` BIGINT(20) DEFAULT NULL,
`created_at` DATETIME NOT NULL,
`old_data` MEDIUMTEXT,
`new_data` MEDIUMTEXT,
PRIMARY KEY (`event_id`),
UNIQUE KEY `IDX_UNIQUE_EVENT` (`type`,`entity`,`entity_pk`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `index_process` (
`process_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`indexer_code` VARCHAR(32) NOT NULL,
`status` ENUM('pending','working','require_reindex') NOT NULL DEFAULT 'pending',
`started_at` DATETIME DEFAULT NULL,
`ended_at` DATETIME DEFAULT NULL,
`mode` ENUM('real_time','manual') NOT NULL DEFAULT 'real_time',
PRIMARY KEY (`process_id`),
UNIQUE KEY `IDX_CODE` (`indexer_code`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO `index_process`(`process_id`,`indexer_code`,`status`,`started_at`,`ended_at`,`mode`) VALUES (1,'catalog_product_attribute','pending','2010-02-13 00:00:00','2010-02-13 00:00:00','real_time'),(2,'catalog_product_price','pending','2010-02-13 00:00:00','2010-02-13 00:00:00','real_time'),(3,'catalog_url','pending','2010-02-13 19:12:15','2010-02-13 19:12:15','real_time'),(4,'catalog_product_flat','pending','2010-02-13 00:00:00','2010-02-13 00:00:00','real_time'),(5,'catalog_category_flat','pending','2010-02-13 00:00:00','2010-02-13 00:00:00','real_time'),(6,'catalog_category_product','pending','2010-02-13 00:00:00','2010-02-13 00:00:00','real_time'),(7,'catalogsearch_fulltext','pending','2010-02-13 00:00:00','2010-02-13 00:00:00','real_time'),(8,'cataloginventory_stock','pending','2010-02-13 00:00:00','2010-02-13 00:00:00','real_time');

CREATE TABLE `index_process_event` (
`process_id` INT(10) UNSIGNED NOT NULL,
`event_id` BIGINT(20) UNSIGNED NOT NULL,
`status` ENUM('new','working','done','error') NOT NULL DEFAULT 'new',
PRIMARY KEY (`process_id`,`event_id`),
KEY `FK_INDEX_EVNT_PROCESS` (`event_id`),
CONSTRAINT `FK_INDEX_EVNT_PROCESS` FOREIGN KEY (`event_id`) REFERENCES `index_event` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_INDEX_PROCESS_EVENT` FOREIGN KEY (`process_id`) REFERENCES `index_process` (`process_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8;

How to Re-indexing in magento

For category flot deta
...............................

ALTER TABLE catalog_category_entity ENGINE=INNODB;
ALTER TABLE core_store ENGINE=INNODB;
it will work sure
...................................

how to get magento path url and get directory in magento

Get URL paths of your magento folder structure – Absolute URL Path
Mage::getBaseUrl() => Gets base url path e.g. http://my.website.com/
Mage::getBaseUrl(‘media’) => Gets MEDIA folder path e.g. http://my.website.com/media/
Mage::getBaseUrl(‘js’) => Gets JS folder path e.g. http://my.website.com/js/
Mage::getBaseUrl(‘skin’) => Gets SKIN folder path e.g. http://my.website.com/skin/
Get DIRECTORY paths (physical location of your folders on the server) – Relative URL Path
Mage::getBaseDir() => Gives you your Magento installation folder / root folder e.g. /home/kalpesh/workspace/magento
Mage::getBaseDir(‘app’) => Gives you your Magento’s APP directory file location e.g. /home/kalpesh/workspace/magento/app
Mage::getBaseDir(‘design’) => Gives you your Magento’s DESIGN directory file location e.g. /home/kalpesh/workspace/magento/design
Mage::getBaseDir(‘media’) => Gives MEDIA directory file path
Mage::getBaseDir(‘code’) => Gives CODE directory file path
Mage::getBaseDir(‘lib’) => Gives LIB directory file path
Get Current URL – whole URL path
Mage::helper(‘core/url’)->getCurrentUrl()

........................................................................................................

it will also help you
...............
base Mage::getBaseDir()
Mage::getBaseDir(‘base’) /var/www/magento/
app Mage::getBaseDir(‘app’) /var/www/magento/app/
code Mage::getBaseDir(‘code’) /var/www/magento/app/code
design Mage::getBaseDir(‘design’) /var/www/magento/app/design/
etc Mage::getBaseDir(‘etc’) /var/www/magento/app/etc
lib Mage::getBaseDir(‘lib’) /var/www/magento/lib
locale Mage::getBaseDir(‘locale’) /var/www/magento/app/locale
media Mage::getBaseDir(‘media’) /var/www/magento/media/
skin Mage::getBaseDir(‘skin’) /var/www/magento/skin/
var Mage::getBaseDir(‘var’) /var/www/magento/var/
tmp Mage::getBaseDir(‘tmp’) /var/www/magento/var/tmp
cache Mage::getBaseDir(‘cache’) /var/www/magento/var/cache
log Mage::getBaseDir(‘log’) /var/www/magento/var/log
session Mage::getBaseDir(‘session’) /var/www/magento/var/session
upload Mage::getBaseDir(‘upload’) /var/www/magento/media/upload
export Mage::getBaseDir(‘export’) /var/www/magento/var/export