Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Imprint Text Options


Guest

Recommended Posts

If you go back into admin now and view the product and the checkbox is checked for the option, then it is in the database correctly. In that case, the problem is most likely on the shop side. You can try using the included product_info.php file for a quick test. If it shows up, then the problem is in that file. If not, it is in the includes/application_top.php file.

 

Dear Thanks for your prompt Reply I checked all again But Problem is same there.

 

1. As you declare I add new product and checked the checkbox of Default ( Name ) text.

2. I checked coding in product_info.php It is Ok Codding is here

 

 

in catalog/product_info.php

**FIND:

<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

}

}

?>

 

**ADD AFTER:

<!-- denuz products text attributes -->

 

<tr>

<td><table border="0" cellspacing="0" cellpadding="2">

 

<?php

$text_attributes_query = tep_db_query("select pta.*, cbta.products_text_attributes_text from products_text_attributes as pta, products_text_attributes_enabled as ptae, customers_basket_text_attributes as cbta where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = " . tep_get_prid($HTTP_GET_VARS['products_id']) . " and cbta.products_text_attributes_id = pta.products_text_attributes_id and cbta.session_id = '" . tep_session_id() . "'");

if (tep_db_num_rows($text_attributes_query) == 0)

$text_attributes_query = tep_db_query("select pta.* from products_text_attributes as pta, products_text_attributes_enabled as ptae where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = " . tep_get_prid($HTTP_GET_VARS['products_id']));

 

while ($text_attributes = tep_db_fetch_array($text_attributes_query)) {

?>

<tr>

<td class=main><?php echo $text_attributes['products_text_attributes_name'] . ': </td><td>' . tep_draw_input_field('products_text_attributes_' . $text_attributes['products_text_attributes_id'], tep_not_null($text_attributes['products_text_attributes_text']) ? $text_attributes['products_text_attributes_text'] : ''); ?></td>

</tr>

<?php

}

?>

 

</table></td>

</tr>

 

<!-- eof denuz products text attributes -->

 

 

 

 

3. checked coding in includes/application_top.php It is Ok Codding is here,

 

 

 

in catalog/includes/application_top.php

**FIND:

case 'update_product' : for ($i=0, $n=sizeof($HTTP_POST_VARS['products_id']); $i<$n; $i++) {

if (in_array($HTTP_POST_VARS['products_id'][$i], (is_array($HTTP_POST_VARS['cart_delete']) ? $HTTP_POST_VARS['cart_delete'] : array()))) {

$cart->remove($HTTP_POST_VARS['products_id'][$i]);

 

**ADD AFTER:

// denuz text attr

tep_db_query("delete from customers_basket_text_attributes where products_id = " . tep_get_prid($HTTP_POST_VARS['products_id'][$i]) . " and session_id = '" . $osCsid . "'");

// eof denuz text attr

 

**FIND:

// customer adds a product from the products page

case 'add_product' : if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) {

$cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']);

 

**ADD AFTER:

// denuz text attr

tep_db_query("delete from customers_basket_text_attributes where products_id = " . $HTTP_POST_VARS['products_id'] . " and session_id = '" . $osCsid . "'");

$attr_query = tep_db_query("select * from products_text_attributes_enabled where products_id = " . $HTTP_POST_VARS['products_id']);

while ($attr = tep_db_fetch_array($attr_query)) {

tep_db_query("insert into customers_basket_text_attributes values ('$osCsid', " . $HTTP_POST_VARS['products_id'] . ", " . $attr['products_text_attributes_id'] . ", '" . addslashes($HTTP_POST_VARS['products_text_attributes_' . $attr['products_text_attributes_id']]) . "');");

}

// eof denuz text attr

 

 

 

Dear Problem Is still There

Link to comment
Share on other sites

  • Replies 337
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

Dear Problem Is still There

You can try replacing the product_info.php file as suggested but, other than that, I don't have any other suggestions.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Dear, Jack I done as you recommend but Problem is Still there plz can you give me your email I want to send some screen shorts

[email protected]

No, sorry, but free support is only available on these forums.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

No, sorry, but free support is only available on these forums.

Its Ok Then Solve my problem it is a big fault in this addon I read all forum many people are in this problem but no solution. I think no any body interested to clear this problem by free support.......... Its good for osCommerce Community :angry:

Link to comment
Share on other sites

I installed Imprint Text V 1.3.5 and it works fine except for one problem. The text option box only shows up when there are other options with the product. If there are no other standard product option with a drop down menu the text options do not show. I have checked and rechecked the code but can find no errors. Can someone point me in the right direction to fix this?

 

Thanks,

 

Dan

 

Hi, I had the same problem like Dan. I have found the mistake yesterday but today i don't really know where it was so i post the whole code of product_info.php. As i remember right it was some misplaced <table> tag at the second edit position.

 

<?php
/*
 $Id: product_info.php 1739 2007-12-20 00:52:16Z hpdl $

 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);

 $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,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150')
}
//--></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
<?php
 if ($product_check['total'] < 1) {
?>
     <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">
         <tr class="infoBoxContents">
           <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_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'] . '<br><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>
           <td class="pageHeading" align="right" valign="top"><?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
   }
?>
         <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
     }
   }
?>
<!-- denuz products text attributes -->

     <tr>
       <td><table border="0" cellspacing="0" cellpadding="2">

<?php
 $text_attributes_query = tep_db_query("select pta.*, cbta.products_text_attributes_text from products_text_attributes as pta, products_text_attributes_enabled as ptae, customers_basket_text_attributes as cbta where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = " . tep_get_prid($HTTP_GET_VARS['products_id']) . " and cbta.products_text_attributes_id = pta.products_text_attributes_id and cbta.session_id = '" . tep_session_id() . "'");
 if (tep_db_num_rows($text_attributes_query) == 0)
   $text_attributes_query = tep_db_query("select pta.* from products_text_attributes as pta, products_text_attributes_enabled as ptae where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = " . tep_get_prid($HTTP_GET_VARS['products_id']));

 while ($text_attributes = tep_db_fetch_array($text_attributes_query)) {
?>
   <tr>
     <td class=main><?php echo $text_attributes['products_text_attributes_name'] . ': </td><td>' . tep_draw_input_field('products_text_attributes_' . $text_attributes['products_text_attributes_id'], tep_not_null($text_attributes['products_text_attributes_text']) ? $text_attributes['products_text_attributes_text'] : ''); ?></td>
   </tr>
<?php
 }
?>

       </table></td>
     </tr>

<!-- eof denuz products text attributes -->

       </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">
         <tr class="infoBoxContents">
           <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>
   </table></form></td>
<!-- body_text_eof //-->
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Edited by Kalan
Link to comment
Share on other sites

osCommerce, php, et al newbie here! I was thrown into the deep end of OSCommerce last Friday and have been doing my best to get the hang of it all.

 

I've installed Imprint Txt and encountered an issue while modifying the OSC files. Where it says:

 

in catalog/product_info.php

**FIND:

<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

}

}

?>

 

This snippet is not found in the document.

 

I am running v2.2 RC2a and STSv4.6. Could there be a related reason?

 

I've been several nights in a row trying to figure out this whole OSCommerce/STS thing... so, I hopefully I am not overlooking something in Imprint Txt due to sheer exhaustion.

 

Thank you!

Link to comment
Share on other sites

I am running v2.2 RC2a and STSv4.6. Could there be a related reason?

You can turn STS off in admin and check to see if this contribution is working. If it is, then the probable is probably that you are using a template file for the product page. There aren't any instructions for integrating that, I don't think.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

You can turn STS off in admin and check to see if this contribution is working. If it is, then the probable is probably that you are using a template file for the product page. There aren't any instructions for integrating that, I don't think.

 

 

Whoa! I actually understood this! :D I think I just might be getting the hang of this bold new OS, et al world. Thanks Jack. I will certainly proceed down this path.

Link to comment
Share on other sites

  • 1 month later...

Hey Thanks for the great contribution! Installed and works flawlessly. Also installed and set up for custom product builder, worked fine. Had to edit checkout_process.php to add imprint text in the outgoing emails to customers.

Link to comment
Share on other sites

  • 2 weeks later...

Hey Thanks for the great contribution! Installed and works flawlessly. Also installed and set up for custom product builder, worked fine. Had to edit checkout_process.php to add imprint text in the outgoing emails to customers.

 

So my code to put the imprint text in the outgoing emails stopped working mysteriously. I am not sure why yet.. here is the code in checkout_process.php

 

$chris_Qry = "select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . 	$insert_id.
  						//$HTTP_GET_VARS['oID'] . 
						" and ota.products_id = " . $pid['products_id'] . " and pta.products_text_attributes_id = ota.products_text_attributes_id";
  //echo ;
     $attr_qq = tep_db_query($chris_Qry); 
     while ($attr = tep_db_fetch_array($attr_qq)) {
       $email_order .=  $attr['products_text_attributes_name'] . ': ' . $attr['products_text_attributes_text'] . "\n";

   }

 

it used to work but then stopped working, any idea why this would happen?

Link to comment
Share on other sites

So my code to put the imprint text in the outgoing emails stopped working mysteriously. I am not sure why yet.. here is the code in checkout_process.php

 

$chris_Qry = "select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = " . 	$insert_id.
  						//$HTTP_GET_VARS['oID'] . 
						" and ota.products_id = " . $pid['products_id'] . " and pta.products_text_attributes_id = ota.products_text_attributes_id";

   }

 

it used to work but then stopped working, any idea why this would happen?

That's not a very well formed statement. Is it part of the contribution? Try removng

//$HTTP_GET_VARS['oID'] .

It could be that your host upgraded something which allowed the code to work before but not now.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

  • 4 weeks later...

I am using the text imprint option but I am having a problem getting the data over to PayPal and Google Checkout. I am using oscmax and all attributes get transferred except the text option. I am sure I missed something but if anyone has any idea of what I missed, that would be great...

 

I appreciate any help you can provide...

 

Jason

Link to comment
Share on other sites

Adding more text field space. Right now I am only able to type in 19 characters, how do I make the text box longer so it can have lets say 40 characters?

You normally make such changes to the database directly but there isn't such a limit in this contribution so I don't have any suggestions for you.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

I am using the text imprint option but I am having a problem getting the data over to PayPal and Google Checkout. I am using oscmax and all attributes get transferred except the text option. I am sure I missed something but if anyone has any idea of what I missed, that would be great...

The options are treated as regualr attributes so they should get passed over as attributes would. But support of your shop is not allowed here, by forum rules, so I can't offer any suggestions.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

  • 5 weeks later...

I have installed the attribute, however the information is not passing through to the admin invoice, packing slip or paypal. The last place where I am able to see it is right before you confirm the order it will tell you all the attributes. Also, it will not place the attribute info tect box option on product page unless there are other types of options chosen for the same item. Did I miss a placement of some code or something?

Link to comment
Share on other sites

  • 1 month later...

Hi Jack and ecommers,

 

I have a unique situation with this contrib.

 

(On an existing Invoice with a items "products_model" over 12 characters) ps. the db is set for 20 chars

Product XYZ model_XYZ123456

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pta.products_text_attributes_id = ota.products_text_attributes_id' at line 1

 

select ota.*, pta.products_text_attributes_name from orders_text_attributes as ota, products_text_attributes as pta where ota.orders_id = 12370 and ota.products_id = and pta.products_text_attributes_id = ota.products_text_attributes_id

 

[TEP STOP]

 

All other functions work great, all invoices, packing lists load except on long(er) than 12 model numbered items.

 

Hope there's an answer, I like the contrib :)

Many Pre-Thanks, KJ

 

-------

UPDATE

-------

 

It's something in the admin/orders.php i believe?

I backed up the copy and went back to it and i don't get the error.

Edited by Top_Speed

define('PROJECTS', 'Something that goes on forever!');

Link to comment
Share on other sites

I have a unique situation with this contrib.

 

(On an existing Invoice with a items "products_model" over 12 characters) ps. the db is set for 20 chars

Product XYZ model_XYZ123456

 

All other functions work great, all invoices, packing lists load except on long(er) than 12 model numbered items.

Hi KJ. Hadn't seen you around for awhile - glad to see you're still here. :)

 

As for that problem, there's nothing in the code that limits the size and there isn't a field for it in the database changes. Are you sure you changed the model number size in the orders_products table? This is often missed when the model number size is changed.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Hi Jack, yep been a long time... still going strong, i try to keep the airwaves clear for those in need of yours and others excellent help & responses. Good to see your still here!!

 

Your spot on (as usual). The orders_products wasn't updated (been this way for years! lol). I guess this contrib changed how it reads from the db on orders model#. THe long sku's were chopped off and this is what caused the 1064's. I now can go back and edit the invoice to add on the longer sku and the old invoices are fine. The new invoices are already correct thanks to YOU!!

 

Great work, hope things r going well w/ you and you family!

TC,

 

-KJ

define('PROJECTS', 'Something that goes on forever!');

Link to comment
Share on other sites

  • 1 month later...
  • 1 month later...

Hey Jack

 

I have not asked you questions for awhile lol hehe...hope you are doing well.

 

Your posts are always very helpful, the inputting fields on product info page were not showing and I followed suggestion you gave to other ppl that use contribution's stock product_info.php to check if its the problem in this file or application_top.php.....then I found I mistakenly (heavy modded store, guide for product_info page is not precise against my store) put the additional code of this contribution within <table> that is for product attributes in product_info.php ;) Now I have moved it out of that table and everything is working fine.

 

Also you mentioned there is no database entry to limit number of characters in the field, and you would not be able to advice on it. The thing is, this contribution said all inputted texts are store in database, there must be a table to contain those info so can I find those database tables and insert different value into each table to limit the number of characters been entered? Or say DROP those info table and CREATE same tables again but with extra value that will limit how many characters can be inputted?

 

 

Thanks

Link to comment
Share on other sites

Also you mentioned there is no database entry to limit number of characters in the field, and you would not be able to advice on it. The thing is, this contribution said all inputted texts are store in database, there must be a table to contain those info so can I find those database tables and insert different value into each table to limit the number of characters been entered? Or say DROP those info table and CREATE same tables again but with extra value that will limit how many characters can be inputted?

I don't recall that conversation but I'm guessing I was talking about in the code. You can change the size of the fields in the database to limit the input but that would no stop someone from entering a longer string unless the code was changed too. The longer text entered would just be truncated so the customer would be confused since what they entered didn't match what is shown. So the correct way to do it would be to change the code to limit the input.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Hello,

The customer input attributes are not appearing in the shopping cart. Could there be something causing a problem with this section of code(shopping_cart.php)?

	  // denuz text attr
    $b = strpos($products[$i]['id'], '{');
    if ($b === false) {
      $pid = $products[$i]['id'];
    } else {
      $pid = substr($products[$i]['id'], 0, $B);
    }
    $attr_q = tep_db_query("select cbta.*, pta.products_text_attributes_name from customers_basket_text_attributes as cbta, products_text_attributes as pta where cbta.products_text_attributes_id = pta.products_text_attributes_id and cbta.products_id = " . $pid . " and cbta.session_id = '" . $osCsid . "'");
    while ($attr = tep_db_fetch_array($attr_q)) {
         $products_name .= '<br><small><i> - ' . $attr['products_text_attributes_name'] . ' ' . stripslashes($attr['products_text_attributes_text'])  . '</i></small>';       
    }
// eof denuz text attr

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...