"Dynamenu" for osCommerce - Dynamic Fly-Out, Drop-Down, Tree Category Menu

[michael_s]

A little fix to get the Dynamenu to work with the Multi-Stores multiple shop system.

Line 246 in include/boxes/dm_categories.php:

$result = tep_db_query('select c.categories_id, cd.categories_name, c.parent_id from ' . TABLE_CATEGORIES . ' c, ' . TABLE_CATEGORIES_DESCRIPTION . ' cd where c.categories_id = cd.categories_id and cd.language_id="' . (int)$languages_id .'" '.$parent_query.'order by sort_order, cd.categories_name');

change to:

$result = tep_db_query('select c.categories_id, cd.categories_name, c.parent_id from ' . TABLE_CATEGORIES . ' c, ' . TABLE_CATEGORIES_DESCRIPTION . ' cd, ' . TABLE_CATEGORIES_TO_STORES . ' cc where c.categories_id = cd.categories_id and c.categories_id = cc.categories_id and cc.stores_id = "' . STORES_ID . '" and cd.language_id="' . (int)$languages_id .'" '.$parent_query.'order by sort_order, cd.categories_name');




More...