.tpl.php as a default (sub 'fallback' with your current template to see if there is a template specife change). // catalog\templates\fallback\contents\.tpl.php as a default (sub 'fallback' with your current template to see if there is a template specife change). // (Sub 'fallback' with your current template to see if there is a template specific file.) require('includes/application_top.php'); // LINE ADDED: MOD - Added for Dynamic MoPics v3.000 require(DIR_WS_FUNCTIONS . 'dynamic_mopics.php'); require(bts_select('language', FILENAME_PRODUCT_INFO)); // $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); // $product_check = tep_db_fetch_array($product_check_query); // BOF Separate Pricing Per Customer, Hide products and categories from groups $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_status > '0' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0"); $product_check = tep_db_fetch_array($product_check_query); // EOF Separate Pricing Per Customer, Hide products and categories from groups // BOF: Extra Product Fields $epf = array(); if ($product_check['total'] > 0) { $epf_query = tep_db_query("select * from " . TABLE_EPF . " e join " . TABLE_EPF_LABELS . " l where e.epf_status and (e.epf_id = l.epf_id) and (l.languages_id = " . (int)$languages_id . ") and l.epf_active_for_language order by epf_order"); while ($e = tep_db_fetch_array($epf_query)) { // retrieve all active extra fields $field = 'extra_value'; if ($e['epf_uses_value_list']) { if ($e['epf_multi_select']) { $field .= '_ms'; } else { $field .= '_id'; } } $field .= $e['epf_id']; $epf[] = array('id' => $e['epf_id'], 'label' => $e['epf_label'], 'uses_list' => $e['epf_uses_value_list'], 'multi_select' => $e['epf_multi_select'], 'columns' => $e['epf_num_columns'], 'display_type' => $e['epf_value_display_type'], 'show_chain' => $e['epf_show_parent_chain'], 'search' => $e['epf_advanced_search'], 'keyword' => $e['epf_use_as_meta_keyword'], 'field' => $field); } $query = "select p.products_date_added, p.products_last_modified, pd.products_name"; foreach ($epf as $e) { if ($e['keyword']) $query .= ", pd." . $e['field']; } $query .= " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status > '0' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"; $pname = tep_db_fetch_array(tep_db_query($query)); $datemod = substr((tep_not_null($pname['products_last_modified']) ? $pname['products_last_modified'] : $pname['products_date_added']), 0, 10); } else { $pname = TEXT_PRODUCT_NOT_FOUND; $datemod = date('Y-m-d'); } // EOF: Extra Product Fields $content = CONTENT_PRODUCT_INFO; $javascript = $content . '.js.php'; include (bts_select('main')); // BTSv1.5 require(DIR_WS_INCLUDES . 'application_bottom.php');