Jump to content

ce7

Members
  • Content count

    494
  • Joined

  • Last visited

  • Days Won

    1

ce7 last won the day on June 5 2015

ce7 had the most liked content!

Profile Information

  • Real Name
    lyn

Recent Profile Visitors

13,574 profile views
  1. ce7

    Information Pages SEO addon

    @Jack_mcs Thank you very much for this addon. I installed it on BS (frozen) version. In admin infobox, i can see two page link: ================================================= Messages (information_manager.php?gID=2) Pages (information_manager.php?gID=1) ================================================= Both I have problem of using Browser Title / Meta Description / Meta Keywords. How can I enable to use those? ================================================= Messages (information_manager.php?gID=2) ================================================= And when I add Messages, on the front page, i can not see any link of the message, unless I on admin/message, i lick on VIEW and it will link me to the front end with URL: mysite.com/information.php?info_id=8 ---> how can i make the message show up in the front end homepage infobox? ID= 1 HEADING_TITLE ID= 2 TEXT_GREETING_PERSONAL ID= 3 TEXT_GREETING_PERSONAL_RELOGON ID= 4 TEXT_GREETING_GUEST ID= 5 TEXT_MAIN and at your instruction read_additional.txt __________________________________________________________________ ADD TEXT TO ANY PAGE: Find where you want to add the text on the page and add the following: <!-- // BOF: Information Pages SEO --> <?php echo GetInformationPageText(XX); ?> <!-- // EOF: Information Pages SEO --> Change the XX to the ID of the message in the Messages section in admin. __________________________________________________________________ does it means i have to modify all the modules/content/index file so that it can show up? without any modification (no instruction) it doesn't seems modify any index message. ================================================= Pages (information_manager.php?gID=1) ================================================= eg, insert two pages: Page A and Page B, if I set up both pages without Parent ID, it will show up both pages on front page without problem, if I setup Page B with Parent ID Page A, on the front Page, I only see Page A, and there is no where has Page B show up, how can I make it works? Many thanks! Lyn
  2. ce7

    Header Tags SEO

    @Jack_mcs Hi, Thank you for the addon. I had install Header Tags SEO on Frozen BS version. I also have a separately index.htm, when google search, it will link to the index.htm, and when customers click on shop1 or shop 2, it can have option to link to two different shops. (so total have 3 oscommerce system: all have Header Tags SEO installed main-oscommerce.com/admin/ & main-oscommerce.com/index.htm main-oscommerce.com/shop1/admin/ & main-oscommerce.com/shop1/index.php main-oscommerce.com/shop2/admin/ & main-oscommerce.com/shop2/index.php ) so my question is that on main-oscommerce.com I tried to add the missing page under page control, update "index.htm" but it seems ony read .php files, is it possible to add Tag / meta for this separated index.htm? Many thanks! Lyn
  3. ce7

    SEO Assistant

    @Jack_mcs @geoffreywalton Hi, thank you for this addon and update! I have installed this addon with osc BS (frozen) version, most of it works ok, few need to have your help! 1. Check Links Found 1 suspected bad link(s) out of a total of 10 Broken Link: http://www.w3.org/TR/html4/loose.dtd Is this suppose to show up? 2. Header Status Fatal error: Call-time pass-by-reference has been removed in admin/includes/modules/seo_header.php on line 30 not changing any seo_header.php code, how can fix this issue? Right now i have separate index page (index.html) and have a text link, if clicked, then it link to the catalog page, so far google ranking is very low for both page, is there any addon there can help me to modify the html tag from admin site, for this modified index.html and catalog/index.php? many thanks! Lyn
  4. ce7

    Australian Shipping Module

    I found this addon (for osc 2.2 version) Shipping Zone Rates with SQL, which show the price base on the Australian post code, which is good, but have few problems: P1: it doesn't show up the sort order properly P2: when go to the checkout_confirmation.php page, the price show up as $0.00, (should be $106.8), it did add up with sub-total, but there is no option for add 10% tax for this shipping modules tried to modified the modules/shipping/tollzipzones.php but not working.... if the problems fix, what I like to do next step is instead of customer place order, the order/shopping cart details will be sent by email to the shop owner, and the owner check the list and grant permission for the order, not sure any addon do this function? any suggestion? Many thanks! Lyn
  5. ce7

    Australian Shipping Module

    also i like to know if it is possible to have a shipping module that base on per kilo, is there a similar addon already there to adapt with? for example modify PER ITEM, instead of weight x per product, it is base on how far from dispatch location to destination, and the customer enter the estimate kilometer, eg: 150 km @ deleivery information (checkout_shipping.php) and the shipping price will be calculated as $0.1/per km x 150 km = $15 many thanks! Lyn
  6. Hi, @raiwa I have BS frozen with few addons, installed Australian Shipping Module and it is working great, thank you! two questions need your help. Q1 in the front page, it will show up the handling fee and insurance fee, how can I not showing these two fee on the text area but only total? current example: AusPOST Express Post Parcel (Insured) $33 Delivery to 2000 - 1 days Estimated Delivery Time* 1 boxes 0.8kg(s) (incl $5.00 handling $5.00 insurance) wish example: AusPOST Express Post Parcel (Insured) $33 Delivery to 2000 - 1 days Estimated Delivery Time* 1 boxes 0.8kg(s) ---------------------------->not showing the handling fee nor the insurance Q2. Zone Rates No shipping available to the selected country zone module, the default i guess is iso_code_1, how can i change it for Australia zone? I guess because it is setting for us, so it doesn't show up now, how can i make it be able to use for Australia? (notice your code has this: $order->delivery['country']['iso_code_2'] == 'AU') Many thanks! Lyn
  7. ce7

    order confirmation gst subtotal

    Thank you @raiwa I will give it a try! Lyn
  8. ce7

    order confirmation gst subtotal

    Hi @raiwa Sorry to tag you, thought you have addon display tax info, that you might know of this issues and can give me some advises or links. I like to have this setting on checkout_confirmation.php Sub-Total: NO GST, only product price Shipping Price: No GST, only shipping price product GST: Shipping GST: Total: = Sub-Total + Shipping Price + product GST + Shipping GST Many thanks! Lyn
  9. ce7

    order confirmation gst subtotal

    By the way, the total now is included GST for subtotal, what i want is Sub-Total: just product price no GST GST (not 10% GST & GST separated...) Per Item (): (shipping price) Total: Sub-Total + GST + Shipping price what should I change to achieve this? Many thanks! Lyn
  10. Hi, I have VAT incl/excl addon on my osC BS (Frozen), the index.php/ product_listing.php/specials.php/new_products.php/shopping cart have show up the tax incl/excl without any problem, however when go through checkout to Order Confirmation (checkout_confirmation.php) If have more then 2 products, the VAT/GST will be separated, I did not modify any code with checkout_confirmation.php if (sizeof($order->info['tax_groups']) > 1) echo ' <td valign="top" align="right">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n"; echo ' <td align="right" valign="top">' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . '</td>' . "\n" . ' </tr>' . "\n"; } Can any one please help and advise what part of file/codes maybe not right and causing this problem? Many thanks! Lyn
  11. @auzStar hi, thank you for this great addon. It is working great! i also install theme switcher and with few clicks, you can change the theme easily. right now i am setting dark background and that make the search result hard to read, which file should I check to change the color setting for search result text color, and is there a way it can auto change depending on UI setting? also i like to type a hint in the search blank area to let users know please at least type min 3 letters, which files should I change? many thanks! Lynn
  12. ce7

    configuration values

    Hi, I have BS Frozen version with few addons, the addon i am having issue is Random Unique Code ( Author copy from Handling Fee (http://addons.oscommerce.com/info/1190) ), they both have same configuration problem. The correct one (one the right) should show up the description : 9546 Allow Unique Code Do you want to allow Unique Code? However it doesn't shop up, as see on the left. Here are the code: tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('9546 Display Unique Code', 'MODULE_ORDER_TOTAL_UNIQUECODE_STATUS', 'true', 'Do you want to display the Unique Code?', '6', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', '9546 MODULE_ORDER_TOTAL_UNIQUECODE_SORT_ORDER', '4', 'Sort order of display.', '6', '2', now())"); // BOF Not show up properly tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('9546 Allow Unique Code', 'MODULE_ORDER_TOTAL_UNIQUECODE_HANDLING_FEE', 'true', 'Do you want to allow Unique Codes?', '6', '3', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, date_added) values ('9546 Unique Code For Orders Under', 'MODULE_ORDER_TOTAL_UNIQUECODE_ORDER_UNDER', '50', 'Add the Unique Code to orders under this amount.', '6', '4', 'currencies->format', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('9546 How many unique code digit?', 'MODULE_ORDER_TOTAL_UNIQUECODE_DIGIT', '2', 'How many unique digit you want to setup?', '6', '8', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, date_added) values ('9546 Unique Code', 'MODULE_ORDER_TOTAL_UNIQUECODE_FEE', '5', 'Low order fee.', '6', '5', 'currencies->format', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('9546 Attach Unique Code On Orders Made', 'MODULE_ORDER_TOTAL_UNIQUECODE_DESTINATION', 'both', 'Attach Unique Code for orders sent to the set destination.', '6', '6', 'tep_cfg_select_option(array(\'national\', \'international\', \'both\'), ', now())"); // EOF Not show up properly tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('9546 Tax Class', 'MODULE_ORDER_TOTAL_UNIQUECODE_TAX_CLASS', '0', 'Use the following tax class on the Unique Code.', '6', '7', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())"); [/php} Can someone please help and point out what is wrong here? Many thanks! Lyn
  13. ce7

    Product Extra Field

    Hey Eddy, @Moxamint Thank you very much! Found 2202, and 8528, not realize another one 7810, thank you very much, I will give it a try and yes i am interested in those files, thank you again for your generous help! Lyn
  14. ce7

    Product Extra Field

    @Clau123 @fotovideoat @mihelicjm Hi there, I have BS Frozen with few addons, and trying to install a new add on "product extra field", it seems working with admin, that i can create new product extra field, and add content to extra field in product page and saved, however having trouble to make the saved extra filed show up in the front end catalog product_info page. here is a product_info.php code for version 2.3 from the addon download: <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2014 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if (!isset($HTTP_GET_VARS['products_id'])) { tep_redirect(tep_href_link(FILENAME_DEFAULT)); } require(DIR_WS_LANGUAGES . $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)$HTTP_GET_VARS['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); require(DIR_WS_INCLUDES . 'template_top.php'); if ($product_check['total'] < 1) { ?> <div class="contentContainer"> <div class="contentText"> <?php echo TEXT_PRODUCT_NOT_FOUND; ?> </div> <div style="float: right;"> <?php echo tep_draw_button(IMAGE_BUTTON_CONTINUE, 'triangle-1-e', tep_href_link(FILENAME_DEFAULT)); ?> </div> </div> <?php } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<del>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</del> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br /><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <?php /* // START: Extra Fields Contribution v2.0b - mintpeel display fix $extra_fields_query = tep_db_query(" SELECT pef.products_extra_fields_order, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=". (int)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."') ORDER BY pef.products_extra_fields_order"); echo '<tr> <td> <table border="0" width="50%" cellspacing="0" cellpadding="2px">'; while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) // show only enabled extra field continue; echo'<tr><td class="main" align="left" valign="middle"><font size="1" color="#666666"><b>'.$extra_fields['name'].': </b>' . stripslashes($extra_fields['value']).'</font></td></tr>'; } echo' </table> </td> </tr>'; // END: Extra Fields Contribution - mintpeel display fix */ ?> <?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?> <div> <h1 style="float: right;"><?php echo $products_price; ?></h1> <h1><?php echo $products_name; ?></h1> </div> <div class="contentContainer"> <div class="contentText"> <?php if (tep_not_null($product_info['products_image'])) { $photoset_layout = '1'; $pi_query = tep_db_query("select image, htmlcontent from " . TABLE_PRODUCTS_IMAGES . " where products_id = '" . (int)$product_info['products_id'] . "' order by sort_order"); $pi_total = tep_db_num_rows($pi_query); if ($pi_total > 0) { $pi_sub = $pi_total-1; while ($pi_sub > 5) { $photoset_layout .= 5; $pi_sub = $pi_sub-5; } if ($pi_sub > 0) { $photoset_layout .= ($pi_total > 5) ? 5 : $pi_sub; } ?> <div id="piGal"> <?php $pi_counter = 0; $pi_html = array(); while ($pi = tep_db_fetch_array($pi_query)) { $pi_counter++; if (tep_not_null($pi['htmlcontent'])) { $pi_html[] = '<div id="piGalDiv_' . $pi_counter . '">' . $pi['htmlcontent'] . '</div>'; } echo tep_image(DIR_WS_IMAGES . $pi['image'], '', '', '', 'id="piGalImg_' . $pi_counter . '"'); } ?> </div> <?php if ( !empty($pi_html) ) { echo ' <div style="display: none;">' . implode('', $pi_html) . '</div>'; } } else { ?> <div id="piGal"> <?php echo tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name'])); ?> </div> <?php } } ?> <script type="text/javascript"> $(function() { $('#piGal').css({ 'visibility': 'hidden' }); $('#piGal').photosetGrid({ layout: '<?php echo $photoset_layout; ?>', width: '250px', highresLinks: true, rel: 'pigallery', onComplete: function() { $('#piGal').css({ 'visibility': 'visible'}); $('#piGal a').colorbox({ maxHeight: '90%', maxWidth: '90%', rel: 'pigallery' }); $('#piGal img').each(function() { var imgid = $(this).attr('id').substring(9); if ( $('#piGalDiv_' + imgid).length ) { $(this).parent().colorbox({ inline: true, href: "#piGalDiv_" + imgid }); } }); } }); }); </script> <?php echo stripslashes($product_info['products_description']); ?> <?php // START: Extra Fields Contribution v2.0b - mintpeel display fix $extra_fields_query = tep_db_query(" SELECT pef.products_extra_fields_order, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=". (int)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."') ORDER BY pef.products_extra_fields_order"); echo '<tr> <td> <table border="0" width="50%" cellspacing="0" cellpadding="2px">'; while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) // show only enabled extra field continue; echo'<tr><td class="main" align="left" valign="middle"><font size="1" color="#666666"><b>'.$extra_fields['name'].': </b>' . stripslashes($extra_fields['value']).'</font></td></tr>'; } echo' </table> </td> </tr>'; // END: Extra Fields Contribution - mintpeel display fix ?> <?php $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <p><?php echo TEXT_PRODUCT_OPTIONS; ?></p> <p> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (is_string($HTTP_GET_VARS['products_id']) && isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <strong><?php echo $products_options_name['products_options_name'] . ':'; ?></strong><br /><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?><br /> <?php } ?> </p> <?php } ?> <div style="clear: both;"></div> <?php if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <p style="text-align: center;"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></p> <?php } ?> </div> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and reviews_status = 1"); $reviews = tep_db_fetch_array($reviews_query); ?> <div class="buttonSet"> <span class="buttonAction"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_draw_button(IMAGE_BUTTON_IN_CART, 'cart', null, 'primary'); ?></span> <?php echo tep_draw_button(IMAGE_BUTTON_REVIEWS . (($reviews['count'] > 0) ? ' (' . $reviews['count'] . ')' : ''), 'comment', tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params())); ?> </div> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } ?> </div> </form> <?php } require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> the main modification is here: <?php echo stripslashes($product_info['products_description']); ?> <?php // START: Extra Fields Contribution v2.0b - mintpeel display fix $extra_fields_query = tep_db_query(" SELECT pef.products_extra_fields_order, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=". (int)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."') ORDER BY pef.products_extra_fields_order"); echo '<tr> <td> <table border="0" width="50%" cellspacing="0" cellpadding="2px">'; while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) // show only enabled extra field continue; echo'<tr><td class="main" align="left" valign="middle"><font size="1" color="#666666"><b>'.$extra_fields['name'].': </b>' . stripslashes($extra_fields['value']).'</font></td></tr>'; } echo' </table> </td> </tr>'; // END: Extra Fields Contribution - mintpeel display fix So I tried to put this code in BS version @ includes/modules/content/product_info/templates/tpl_cm_pi_description.php <?php echo $product_description . '<br/>'; //BOF 8528 Product Extra Fields $extra_fields_query = tep_db_query(" SELECT pef.products_extra_fields_order, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=". (int)$_GET['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."') ORDER BY pef.products_extra_fields_order"); while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) // show only enabled extra field continue; echo $extra_fields['name'].': </b>' . stripslashes($extra_fields['value']); } //EOF 8528 Product Extra Fields ?> and below attached image is the correct one that show up extra fields: EAN Code: ISBN Code: however my modification did not show up any fields, can some one please help? Many thanks! Lyn
  15. @Jack_mcs Hi, Thank you for the wonderful addon, I had installed it in BS frozen, and it is working great! I love the fact it can edit any page. I spend weeks to tried the version 2.2 and 2.3 before with no luck!!! Tried to install several times and could not see the pages, thought I made mistake or not working, but finally I read the "read me - additional" and find the important statement, ADD LINKS TO THE INFORMATION BOX: @ includes/modules/boxes/templates/information.php under the <ul>, add code: <?php echo tep_information_show_category(1,999, true); ?> however I still very confuse about the BOX ID and Parent ID. And I think the ID is for showing on the URL, it is not practical for admin to know which ID is to match if they are not the one put this addon.... is there a way, for example, have a drop down list, and will show both ID, and corresponding box or page name? Many thanks! Lyn
×