Jump to content
alenkij

Imprint Text Options

Recommended Posts

so maybe someone can help me here so I don't kill myself trying to find this. If the product_info.php appears to work okay with the template with this contribution BUT the product info area is like half as wide as it should be, where is that setting. The template is staying in place fine, but just that area of the page where the description is is 50% narrower than it should be. Where does that get fixed to widen that to double what it is now?

Well it's not right. The original one with the template has breadcrumbs and everything else, but if I have to handle it this way, that may be alright. Here is the code for the EXISTING template (not the one in denuz contribution);

 

<?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 © 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,res

izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le

ft=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="0" cellpadding="0">

 

<tr>

 

<td class="col_left">

 

<!-- left_navigation //-->

 

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

 

<!-- left_navigation_eof //-->

 

</td>

 

<!-- body_text //-->

 

<td width="100%" class="col_center"><?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>

 

<? tep_draw_heading_top(); ?>

 

 

 

<?php echo tep_draw_title_top();?>

 

 

 

<?php echo TEXT_PRODUCT_NOT_FOUND;?>

 

 

 

<?php echo tep_draw_title_bottom();?>

 

 

 

<? tep_draw_heading_top_1(); ?>

 

 

 

 

 

 

 

<!--

 

<table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

 

<tr class="infoBoxContents">

 

<td>

 

-->

 

<br style="line-height:1px;"><br style="line-height:12px;">

 

 

 

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

 

-->

 

 

 

 

 

<? tep_draw_heading_bottom_1(); ?>

 

 

 

<? tep_draw_heading_bottom(); ?>

 

 

 

<?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>

 

 

 

<? tep_draw_heading_top(); ?>

 

 

 

<?php echo tep_draw_title_top();?>

 

 

 

<?php echo $breadcrumb->trail(' » ')?>

 

 

 

<?php echo tep_draw_title_bottom();?>

 

 

 

 

 

<? tep_draw_heading_top_1(); ?>

 

<? tep_draw_heading_top_2(); ?>

 

 

 

 

 

<?php

 

if (tep_not_null($product_info['products_image'])) {

 

?>

 

<table cellspacing="0" cellpadding="0" border="0" class="product">

 

<tr><td>

 

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

 

<tr><td height="100%">

 

<table cellpadding="0" cellspacing="0" border="0" align="left" class="prod_info" style=" margin-right:15px;">

 

<tr><td class="pic" align="center"> <br style="line-height:1px;"><br style="line-height:9px;">

 

 

 

<?php echo tep_draw_prod_top();?>

 

 

 

<script language="javascript"><!--

 

document.write('<?php echo '<a href="java script: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, ' style="margin:0px 0px 0px 0px;"') . ''; ?>');

 

//--></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, ' style="margin:0px 0px 0px 0px;"') . ''; ?>

 

</noscript>

 

 

 

<?php echo tep_draw_prod_bottom();?>

 

 

 

</td></tr>

 

<tr><td align="center">

 

<script language="javascript"><!--

 

document.write('<?php echo '<div><a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . TEXT_CLICK_TO_ENLARGE . '</a></div>'; ?>');

 

//--></script>

 

<noscript>

 

<?php echo '<div><a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank"><br style="line-height:7px">' . TEXT_CLICK_TO_ENLARGE . '</a></div>'; ?>

 

</noscript>

 

</td></tr>

 

</table>

 

<table cellpadding="0" cellspacing="0" border="0" style="width:170px;">

 

<tr><td style="vertical-align:middle; height:38px;"><em><?php echo $products_name; ?></em></td></tr>

 

</table>

 

 

 

<div class="padd3"><?php echo stripslashes($product_info['products_description']); ?>

 

<br><br style="line-height:11px"><span class="productSpecialPrice"><?=$products_price?></span></div>

 

 

 

</td></tr>

 

 

 

</table>

 

</td>

 

</tr>

 

</table>

 

<?php

 

}

 

?>

 

<? tep_draw_heading_bottom_2(); ?>

 

<table cellspacing="0" cellpadding="0" border="0" align="center" style="margin:15px 0px 15px 0px; height:1px;">

 

<tr><td class="bg_gg_1"><?php echo tep_draw_separator('spacer.gif', '1', '1');?></td></tr>

 

</table>

 

<? tep_draw_heading_top_2();?>

 

 

 

<?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 cellpadding="0" cellspacing="0" class="box_width_cont product">

 

<tr><td height="25" colspan="2"><strong><?php echo TEXT_PRODUCT_OPTIONS; ?></strong></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); ?><br>

 

 

<!-- denuz products text attributes -->

 

 

<?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)) {

?>

<br>

<?php echo $text_attributes['products_text_attributes_name'] . ': ' . 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'] : ''); ?>

<?php

}

?>

 

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

 

</td>

 

</tr>

 

<tr><td height="10" colspan="2"></td></tr>

 

<?php

 

}

 

?>

 

 

</table>

 

<?php

 

}

 

?>

 

 

 

<?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) {

 

?>

 

<table cellpadding="0" cellspacing="0" class="product box_width_cont">

 

<tr><td class="line_h"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td></tr>

 

<tr><td height="17"></td></tr>

 

</table>

 

<?php

 

}

 

 

 

if (tep_not_null($product_info['products_url'])) {

 

?>

 

<table cellpadding="0" cellspacing="0" class="product box_width_cont">

 

<tr><td class="line_h"><?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 height="17"></td></tr>

 

</table>

 

<?php

 

}

 

 

 

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

 

?>

 

<table cellpadding="0" cellspacing="0" class="product box_width_cont">

 

<tr><td class="line_h"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td></tr>

 

<tr><td height="17"></td></tr>

 

</table>

 

<?php

 

} else {

 

?>

 

<table cellpadding="0" cellspacing="0" class="product box_width_cont">

 

<tr><td class="line_h"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td></tr>

 

<tr><td height="17"></td></tr>

 

</table>

 

<?php

 

}

 

?>

 

<!--

 

<table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

 

<tr class="infoBoxContents"><td>

 

-->

 

<table border="0" width="100%" cellspacing="0" cellpadding="0" class="product box_width_cont">

 

<tr>

 

<td class="main bg_input"><?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>'; ?><?php echo tep_draw_separator('spacer.gif', '15', '1'); ?><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart1.gif', IMAGE_BUTTON_IN_CART); ?></td>

 

</tr>

 

</table><br style="line-height:1px;"><br style="line-height:10px;">

 

<!--

 

</td></tr>

 

</table>

 

-->

 

<? tep_draw_heading_bottom_2();?>

 

 

 

<? tep_draw_heading_bottom_1(); ?>

 

 

 

<?php tep_draw_heading_bottom();?>

 

 

 

<?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 class="col_right">

 

<!-- right_navigation //-->

 

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

 

<!-- right_navigation_eof //-->

 

</td>

 

</tr>

 

</table>

 

<!-- body_eof //-->

 

 

 

<!-- footer //-->

 

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

 

<!-- footer_eof //--></body>

 

</html>

 

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Share this post


Link to post
Share on other sites

Hi All,

i tried to install this before ,

but had a lot of problems with it .

 

Now I have been install this Contribution V1.3.5 (tnx jack for solve the problems)

now this contribute works great . (so far as i tested)

 

But......

 

I have also installed the contribution U HTML EMAILS

 

And here starts my little problem ,

 

if i order something and i fill in the extra text , no problem and i can also see it if i log in in my admin and check the order

 

but in the email what i and my customer get ,, i can't find anything back from this extra text ..

 

Does anyone has the experience what i need to change or what to do ?

 

to see the extra added text in the emails

 

Many thanks

 

mandy

Share this post


Link to post
Share on other sites

There are changed files in the contribution. Use those to find the problem.

 

Jack

Share this post


Link to post
Share on other sites

Hi Nick,

I had the same , problem was a little typo from me in catalog-admin-orders.php

 

i use Examdiff to compare the files ,,

 

the contribution works good here , except i have still the problem that the added text isnt in the E-mail pfffffffff

 

anyway hope someone can help me with this ,,

would really apreciate it

 

mandy

Share this post


Link to post
Share on other sites

Hey Guys, Hopefully someone can point me in the right direction..

 

I'm using Jack's Contrib 1.3.5

 

I'm not getting any errors, however I don't see the options to customize the text on the product info page..

 

I have double checked all my mods.. I even tried replacing my product_info.php

 

I know the admin side is working because i can create a new custom field, and it get's written to the database..

 

I ran

$query="select * from products_text_attributes where products_text_attributes_id = 3";

$result = mysql_query($query);

 

$array=mysql_fetch_assoc($result);

print_r($array);

 

and got my:

Array ( [products_text_attributes_id] => 3 [products_text_attributes_name] => First Name )

 

another thing I noticed, is in the admin side, after I put a check mark box beside the text option I want, save, update, and exit, I notice that when I go back in to that item, that the text field items are not showing up as being checked.. they are all defaulted to being unchecked but by new text field item I created is listed at least.

 

The only other contrib that might be getting in the way is the Prod Info (QTPro) (keeps track of stock and allows for product options.

 

my server: PHP Version 5.2.6, MySQL 5.0.67

 

I'm not running STS..

 

Ideas?

Share this post


Link to post
Share on other sites
Hey Guys, Hopefully someone can point me in the right direction..

 

I'm using Jack's Contrib 1.3.5

 

I'm not getting any errors, however I don't see the options to customize the text on the product info page..

 

I have double checked all my mods.. I even tried replacing my product_info.php

 

I know the admin side is working because i can create a new custom field, and it get's written to the database..

 

I ran

$query="select * from products_text_attributes where products_text_attributes_id = 3";

$result = mysql_query($query);

 

$array=mysql_fetch_assoc($result);

print_r($array);

 

and got my:

Array ( [products_text_attributes_id] => 3 [products_text_attributes_name] => First Name )

 

another thing I noticed, is in the admin side, after I put a check mark box beside the text option I want, save, update, and exit, I notice that when I go back in to that item, that the text field items are not showing up as being checked.. they are all defaulted to being unchecked but by new text field item I created is listed at least.

 

The only other contrib that might be getting in the way is the Prod Info (QTPro) (keeps track of stock and allows for product options.

 

my server: PHP Version 5.2.6, MySQL 5.0.67

 

I'm not running STS..

 

Ideas?

 

Never mind.. I fixed the error..

 

I placed one of the denuz file mod's too early in my admin\categories.php

 

I basically searched for "$languages = tep_get_languages();" and placed the denuz text right above it.. little did I know.. that that string repeats its self.

 

 

Thanks for reading :)

Share this post


Link to post
Share on other sites

Hello All,

 

New problem,

 

I can now see the customize text option..

I fill it out, hit add to cart.. and in the "What's in my cart" section.. I see the item, but I don't see the imprint text..

 

The text is written to the DB..and I have replaced my custom shopping_cart.php with the Jack 1.3.5 contrib and still no go..

 

am I supposed to see the text when I view my cart? or only when I click the item to edit it?

 

I also don't see the imprint text in my invoice or packing slip which are both replaced files.. so I expect something is broken.. I'm just not sure where.. as I have replaced pretty well all files on my site with the contrib one..

Share this post


Link to post
Share on other sites
Hello All,

 

New problem,

 

I can now see the customize text option..

I fill it out, hit add to cart.. and in the "What's in my cart" section.. I see the item, but I don't see the imprint text..

 

The text is written to the DB..and I have replaced my custom shopping_cart.php with the Jack 1.3.5 contrib and still no go..

 

am I supposed to see the text when I view my cart? or only when I click the item to edit it?

 

I also don't see the imprint text in my invoice or packing slip which are both replaced files.. so I expect something is broken.. I'm just not sure where.. as I have replaced pretty well all files on my site with the contrib one..

If the attributes are set up correctly and showing on the product page, then when you add that product to the cart, the attribute should show too. If not, then there is most likely a mistake in either the includes/application_top.php or shopping_cart.php files, or maybe both.

 

Jack

Share this post


Link to post
Share on other sites

Hi ,

does anyone a solution ?

 

I have also installed the contribution U HTML EMAILS

 

,

 

if i order something and i fill in the extra text that is needed, no problem ,

everything works great

 

but in the email what i and my customer get ,,

i can't find anything back from this extra text ..

 

But if i log in as admin and check the order everything is there , also if i log in as custumor and check the order history i see the extra added text,

 

 

 

Does anyone has the experience what i need to change and what to do ?

 

to become the extra added text also in the emails

 

Many thanks

 

mandy

Edited by mandynl

Share this post


Link to post
Share on other sites

I have this working, however, I can't seem to control the order. On the product page it's

line 1

line 2

line 3

line 4

 

but on the What's In My Cart? and Order Confirmation the order is totally different. Even on one or two product pages it's different. Is there a way to control the order of the options?

 

Coming from the database base I would have thought that they would always be in the same order.

Share this post


Link to post
Share on other sites
I have this working, however, I can't seem to control the order. On the product page it's

line 1

line 2

line 3

line 4

 

but on the What's In My Cart? and Order Confirmation the order is totally different. Even on one or two product pages it's different. Is there a way to control the order of the options?

 

Coming from the database base I would have thought that they would always be in the same order.

There's not sorting code built in although I think adding them in the correct order may work. Or you can change this line in products_info.php. I haven't tried it but I think it will work.

  $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() . "'");

to this

  $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() . "' order by cbta.products_text_attributes_text ");

 

Jack

Share this post


Link to post
Share on other sites

Thanks for the try. Did not work. It's really maddening.

 

Look at: https://www.brettcardsonline.com/Cards/prod...;products_id=45 that is the way they should be.

 

But then we have https://www.brettcardsonline.com/Cards/prod...;products_id=63

 

All items were loaded at the same time. Some show one while others show the other. I don't know what is causing this.

Share this post


Link to post
Share on other sites

I have a small issue, nothing too major, please help if you can...

 

I've installed everything according to instructions.

 

Here is what's working properly...

 

1. Text Input boxes are showing on product_info.php

2. Input text data is showing on shopping cart summary page after adding item to cart

3. The last place I see input text data is on checkout confirmation page before submitting order

 

Here is the issue...

 

After hitting submit order on checkout confirmation page it goes to checkout confirmation page as normal.

 

However, my text input data never makes it to my admin panel orders.php page

 

I do see the other basic product attribute options show up, but the "text input" fields I entered on product info never made it. The confirmation email doesn't show "text input fields either.

 

Any idea whats happening? Here are some screenshots for your reference

 

product_info.php - Showing input fields - this is ok

product_info.jpg

 

Shopping Cart Page - this is ok

cart.jpg

 

Checkout Confirmation Page - this is ok - last place I see input data

confirm.jpg

 

Order Page - this is the issue, data is not showing up under other attribute

missing.jpg

Share this post


Link to post
Share on other sites
After hitting submit order on checkout confirmation page it goes to checkout confirmation page as normal.

 

However, my text input data never makes it to my admin panel orders.php page

 

I do see the other basic product attribute options show up, but the "text input" fields I entered on product info never made it. The confirmation email doesn't show "text input fields either.

 

Any idea whats happening? Here are some screenshots for your reference

It is probably an installation error. Be sure you made the changes to all of the pages.

 

Jack

Share this post


Link to post
Share on other sites

G Day everyone

 

Firstly great contribution. Love it

 

I am having exactly the same problem as anoited

 

Any ideas?

 

Ray

Share this post


Link to post
Share on other sites

If you did a manual install of v1.3.5 and text input fields are not showing in your confirmation email this is how to fix it. Open checkout_process.php

 

1. FIND FOLLOWING (around line 220)

--------------------------------

//------insert customer choosen option eof ----
   $total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']);
   $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty'];
   $total_cost += $total_products_price;

   $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] .') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n\n";
 }

2. AND REPLACE BY FOLLOWING
  ------------------------

// denuz_arun text attr

     $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id");
  $denux_arunQry = "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 . " and pta.products_text_attributes_id = ota.products_text_attributes_id";
  //echo ;
     $attr_q = tep_db_query($denux_arunQry); $denux_arun_ ='';
     while ($attr = tep_db_fetch_array($attr_q)) {
       $denux_arun_ .=  $attr['products_text_attributes_name'] . ': ' . stripslashes($attr['products_text_attributes_text'])."\n";
     }

// eof denuz_arun text attr

//------insert customer choosen option eof ----
   $total_weight += ($order->products[$i]['qty'] * $order->products[$i]['weight']);
   $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty'];
   $total_cost += $total_products_price;

   $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] .') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n". $denux_arun_ . "\n";
 }

The last line of code has been modified (. $denux_arun_ . "\n") but it is outside of the denuz tag. If you are copy/pasting code blocks obviously it will get missed. :(

 

I am still having the issue of text input fields showing on the customer side but not in admin. The best part is, it's only for some items, others work fine. Also, if the text input does not show in admin it does not show in the confirmation email as well. When it works, it works for both. Anyone seen this or have a solution?

Share this post


Link to post
Share on other sites

The last line of code has been modified (. $denux_arun_ . "\n") but it is outside of the denuz tag. If you are copy/pasting code blocks obviously it will get missed. :(

 

I am still having the issue of text input fields showing on the customer side but not in admin. The best part is, it's only for some items, others work fine. Also, if the text input does not show in admin it does not show in the confirmation email as well. When it works, it works for both. Anyone seen this or have a solution?

Thanks, I would have gone nuts looking for that piece of code.

Do the items that show have other attributes attached?

 

When I add 2 different items with text options to the cart and go look at a third, it shows the options for both the items in the cart on a different product. Can this be fixed?

Share this post


Link to post
Share on other sites

This is what I did to fix the text input fields showing on the customer side but not in admin issue.

 

Open admin/invoice.php and find the following:

// denuz text attr

//      $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id");
     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'");

Replace with:



//      $pid = @mysql_result(tep_db_query("select products_id from products_description where products_name='" . tep_db_input($order->products[$i]['name']) . "'"), 0, "products_id");
     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");

Open admin/packingslip.php and find the following:

// denuz text attr

     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'");

Replace with:

// denuz text attr

     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");

 

Also (this may be a known issue but I was unaware) once you create a text attribute for a product don't use that same attribute for another product. This was causing problems for me as well.

 

Big Bear - sorry, I haven't seen that issue.

Share this post


Link to post
Share on other sites

I forgot to mention, after I got the text input fields to work in admin I had to make one more change so they would show up in the confirmation email as well.

 

Open checkout_process.php and find the following:

// denuz_arun text attr

     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_model LIKE '" . tep_db_input($order->products[$i]['model']) . "'");

 

Replace with:

// denuz_arun text attr

     $pid_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_name = '" . tep_db_input($order->products[$i]['name']) . "'");

Share this post


Link to post
Share on other sites

Hi

 

I have just installed the imprint text options and all seems ok except the admin page under catalog.

 

When I click it I get a message saying:

 

"1146 - Table '####################.TABLE_TEXT_ATTRIBUTES' doesn't exist

 

select count(*) as total from TABLE_TEXT_ATTRIBUTES

 

[TEP STOP]"

 

########### is the database name

 

I have doubled checked the table is there and all other parts seem to function correctly as in on the product pages etc.

 

Can anyone help please?

 

Thanks

 

Dan

Share this post


Link to post
Share on other sites

Capital letters in an error mean you made a mistake in the installation. Search through the instructions and/or files for TABLE_TEXT_ATTRIBUTES and compare what is there to what was actually done.

Share this post


Link to post
Share on other sites

Thank you dangerman for your two last posts no #227 and #228 - I followed your advice/solutions and now this contribution works perfectly in my store!

 

Thanks :)

Share this post


Link to post
Share on other sites

Good morning, please excuse me for the writing because I do not speak English.

I use a translator to write you.

My problem, I installed the contribution without problem.

The frame to put the text is well in the chip article, on the contrary when I come back from the text, it is not displayed in the shopping cart.

On the contrary, if there is an article already in the shopping cart, the text and good in the shopping cart.

I do not succeed in understanding why, if there is 1 only article in the shopping cart the text is not displayed, if there is 2 the second article shows the text well.

I did again the installation, but nothing changes, I do not find why the first article in the shopping cart does not take the text.

Thank you in advance for your assistant.

Share this post


Link to post
Share on other sites

Good morning, please excuse me for the writing because I do not speak English.

I use a translator to write you.

My problem, I installed the contribution without problem.

The frame to put the text is well in the chip article, on the contrary when I come back from the text, it is not displayed in the shopping cart.

On the contrary, if there is an article already in the shopping cart, the text and good in the shopping cart.

I do not succeed in understanding why, if there is 1 only article in the shopping cart the text is not displayed, if there is 2 the second article shows the text well.

I did again the installation, but nothing changes, I do not find why the first article in the shopping cart does not take the text.

Thank you in advance for your assistant.

 

here are pictures

Imageimp1.jpg

 

Imageimp3.jpg

 

I also have problem when I turn articles on one I have the text of both articles

Imageimp2.jpg

 

 

 

bye thierry

Edited by thierryc

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

×