surplus Posted September 17, 2004 Share Posted September 17, 2004 Wondering if you knew this off the top of your head. I installed Add new products fields http://www.oscommerce.com/community/contri...arch,new+fields Everything seems to be working fine, but the actual field name does not show up on my site. My Site Below the price you will see a "14" In front of that I want it to say Issues: the new field added is products_issues any help is greatly appreciated. Quote Link to comment Share on other sites More sharing options...
241 Posted September 17, 2004 Share Posted September 17, 2004 go to the product_info.php locate the code for the new field product_issues and before it code the text Issues: or define the text in the languages file and then in product_info.php code in the text define or post your code for product_info.php and someone will do it all for you Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
surplus Posted September 17, 2004 Author Share Posted September 17, 2004 <?php /* $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); // ADDED BY CLEMENT for design define('HEADING_IMAGE_FILE', 'table_background_default.gif'); require(DIR_WS_INCLUDES . FILENAME_DESIGN); //** $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); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML <?php echo HTML_PARAMS; ?>> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=<?php echo CHARSET; ?>"> <TITLE><?php echo TITLE; ?></TITLE> <BASE HREF="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <LINK REL="stylesheet" TYPE="text/css" HREF="stylesheet.css"> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le ft=150') } //--></SCRIPT> <?php echo HEAD_TAGS; ?> <?php echo BODY_TAG; ?> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); if (COLUMN_LEFT_DISPLAY == 'true') { echo '<!-- left_navigation //-->'; require(DIR_WS_INCLUDES . 'column_left.php'); echo '<!-- left_navigation_eof //-->'; } ?> <!-- body_text //--> <TD <?php echo CONTENT_PARAM_FIRST_TD; ?>> <?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?> <?php echo CONTENT_TOP_FIRST_TD; ?> <TABLE <?php echo CONTENT_PARAM_FIRST_TABLE; ?>> <?php if ($product_check['total'] < 1) { ?> <?php echo CONTENT_TOP_FIRST_TABLE; ?> <TR> <TD><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></TD> </TR> <TR> <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD> </TR> <TR> <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="1" CELLPADDING="2" CLASS="infoBox_button"> <TR CLASS="infoBoxContents_button"> <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="0" CELLPADDING="2"> <TR> <TD WIDTH="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></TD> <TD ALIGN="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></TD> <TD WIDTH="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></TD> </TR> </TABLE></TD> </TR> </TABLE></TD> </TR> <?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_issues, p.products_retail_price, 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 = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <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'] . ' <span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <TR> <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="0" CELLPADDING="0"> <TR> <TD CLASS="pageHeading" VALIGN="top"><?php echo $products_name; ?></TD> </TR> <TR> <TD ALIGN="right" VALIGN="top" style="font-family: Tahoma; font-size: 20px; color: #4F576A; font-weight: bold; padding-right: 10px;"><?php echo $products_price; ?></TD> </TR> </TABLE></TD> </TR> <TR> <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD> </TR> <TR> <TD CLASS="main"> <?php if (tep_not_null($product_info['products_image'])) { ?> <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2" ALIGN="right"> <TR> <TD ALIGN="center" CLASS="smallText"> <script language="javascript"><!-- document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></SCRIPT> <NOSCRIPT> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> </td> </tr> </table> <?php } include(DIR_WS_MODULES . 'ezier_new_fields.php'); // START: Extra Fields Contribution $products_extra_fields_query = tep_db_query("SELECT pef.*,ptf.* FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " pef, " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " ptf WHERE ptf.products_id=" . (int)$HTTP_GET_VARS['products_id'] . " AND pef.products_extra_fields_status = 1 ORDER BY products_extra_fields_order"); while ($products_extra_fields = tep_db_fetch_array($products_extra_fields_query)) { $extra_product_field[$products_extra_fields['products_extra_fields_id']] = $products_extra_fields['products_extra_fields_value']; } $extra_fields_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " WHERE products_extra_fields_status = 1 ORDER BY products_extra_fields_order"); while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if ($extra_product_field[$extra_fields['products_extra_fields_id']] != '') { ?> <b><?php echo $extra_fields['products_extra_fields_name']; ?>:</b> <?php echo $extra_product_field[$extra_fields['products_extra_fields_id']]; ?><br /> <? } } // END: Extra Fields Contribution ?> <P><?php echo stripslashes($product_info['products_issues']); ?></P> <P><?php echo stripslashes($product_info['products_description']); ?></P> <?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) { ?> <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="2"> <TR> <TD CLASS="main" COLSPAN="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></TD> </TR> <?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 (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; } ?> <TR> <TD CLASS="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></TD> <TD CLASS="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></TD> </TR> <?php } ?> </TABLE> <?php //sandalwood if (tep_not_null($product_info['products_issues'])) { echo TEXT_PRODUCTS_SIZE.' '.$product_info['products_issues']; } //end of sandalwood ?> <?php } ?> </TD> </TR> <TR> <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD> </TR> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); if ($reviews['count'] > 0) { ?> <TR> <TD CLASS="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></TD> </TR> <TR> <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD> </TR> <?php } if (tep_not_null($product_info['products_url'])) { ?> <TR> <TD CLASS="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></TD> </TR> <TR> <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD> </TR> <?php } if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <TR> <TD ALIGN="center" CLASS="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></TD> </TR> <?php } else { ?> <TR> <TD ALIGN="center" CLASS="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></TD> </TR> <?php } ?> <TR> <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD> </TR> <TR> <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="1" CELLPADDING="2" CLASS="infoBox_button"> <TR CLASS="infoBoxContents_button"> <TD><TABLE BORDER="0" WIDTH="100%" CELLSPACING="0" CELLPADDING="2"> <TR> <TD WIDTH="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></TD> <TD CLASS="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></TD> <TD CLASS="main" ALIGN="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></TD> <TD WIDTH="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></TD> </TR> </TABLE></TD> </TR> </TABLE></TD> </TR> <TR> <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></TD> </TR> <TR> <TD> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } } ?> </TD> </TR> <?php echo CONTENT_BOTTOM_FIRST_TABLE; ?> </TABLE></form> <?php echo CONTENT_BOTTOM_FIRST_TD; ?> </TD> <!-- body_text_eof //--> <?php if (COLUMN_RIGHT_DISPLAY == 'true') { echo '<!-- right_navigation //-->'; require(DIR_WS_INCLUDES . 'column_right.php'); echo '<!-- right_navigation_eof //-->'; } require(DIR_WS_INCLUDES . 'footer.php'); ?> <?php echo ENDING_TAGS; ?> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Quote Link to comment Share on other sites More sharing options...
241 Posted September 17, 2004 Share Posted September 17, 2004 (edited) this code here <?php //sandalwood if (tep_not_null($product_info['products_issues'])) { echo TEXT_PRODUCTS_SIZE.' '.$product_info['products_issues']; } //end of sandalwood ?> <?php ? } ?> and more so the TEXT_PRODUCTS_SIZE should give you the text. There should be a define in catalog/includes/languages/english/product_info.php define('TEXT_PRODUCTS_SIZE', 'Issues:'); Edited September 17, 2004 by 241 Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
surplus Posted September 17, 2004 Author Share Posted September 17, 2004 I do have the CODE define('TEXT_PRODUCTS_SIZE', 'Issues:'); in the catalog/includes/languages/english/product_info.php I did find one mistake on the other code it had _SIZE it should have been _ISSUES but that did not fix my issue Quote Link to comment Share on other sites More sharing options...
surplus Posted September 17, 2004 Author Share Posted September 17, 2004 Not sure if this is DB issue the new field in the DB: products_issues, varchar(30), null:yes not sure if this could cause any issue Quote Link to comment Share on other sites More sharing options...
surplus Posted September 18, 2004 Author Share Posted September 18, 2004 I am having another issue with this as well I went ahead and put issues in the field on the easy populate sheet. But now I am limited to the number of characters. I can only put in Issues:# I want to have a format like Issues: ## how do I expand the field so it will accept a space and 2 more digits. my site thanks for your help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.