Jump to content
Sign in to follow this  
surplus

Add New Products fields

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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


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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Share this post


Link to post
Share on other sites
<?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'); ?>

Share this post


Link to post
Share on other sites

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 by 241

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×