function xtc_get_categoriesstatus_for_product($product_id) { $categorie_query = "SELECT\n\t categories_id\n\t FROM " . TABLE_PRODUCTS_TO_CATEGORIES . "\n\t WHERE products_id='" . xtc_db_input((int) $product_id) . "'"; $categorie_query = xtDBquery($categorie_query); while ($categorie_data = xtc_db_fetch_array($categorie_query, true)) { if (xtc_check_categories_status($categorie_data['categories_id']) >= 1) { return 1; } else { return 0; } echo $categorie_data['categories_id']; } }
Released under the GNU General Public License ---------------------------------------------------------------------------------------*/ $default_smarty = new smarty(); $default_smarty->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $default_smarty->assign('session', session_id()); // define defaults $main_content = ''; $group_check = ''; $fsk_lock = ''; // include needed functions require_once DIR_FS_INC . 'xtc_customer_greeting.inc.php'; require_once DIR_FS_INC . 'xtc_get_path.inc.php'; require_once DIR_FS_INC . 'xtc_check_categories_status.inc.php'; // check categorie exist if (xtc_check_categories_status($current_category_id) >= 1) { $error = CATEGORIE_NOT_FOUND; include DIR_WS_MODULES . FILENAME_ERROR_HANDLER; return; } // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && xtc_not_null($cPath)) { $categories_products_query = "select p2c.products_id\n from " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c\n left join " . TABLE_PRODUCTS . " p\n on p2c.products_id = p.products_id\n where p2c.categories_id = " . (int) $current_category_id . "\n and p.products_status = 1"; $categories_products_result = xtDBquery($categories_products_query); if (xtc_db_num_rows($categories_products_result, true) > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = "select parent_id from " . TABLE_CATEGORIES . " where parent_id = " . (int) $current_category_id . " AND categories_status = 1"; $category_parent_result = xtDBquery($category_parent_query);