[Contribution] More_pics_6 v1.1 For osC 2.2 MS2

[♥kymation]

I did. The error is in the file name used in the instructions. The file itself is correct.

 

Regards

Jim

[Webbies]

Hi Jim,

 

I installed your code but get the following:

 

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 'WHERE prp.pop_products_id_slave = pa.products_id AND pa.product' at line 14

 

SELECT prp.pop_products_id_slave, pa.products_name, pb.products_model, pb.products_price, pb.products_quantity, pb.products_tax_class_id, pi.image_filename FROM products_related_products prp, products_description pa, products pb left join products_images pi on pb.products_id = pi.products_id and pi.category_page = '1', WHERE prp.pop_products_id_slave = pa.products_id AND pa.products_id = pb.products_id AND pa.language_id = '4' AND prp.pop_products_id_master = '60' AND products_status = '1' ORDER BY rand()

 

:unsure:

 

 

Try this (Not tested, so may contain typos):

<?php
/*
$Id: optional_related_products.php, ver 1.0 02/05/2007 Exp $

Part of Contribution: Optional Related Products Ver 4.0

Based on code from Optional Relate Products, ver 2.0 05/01/2005
Copyright © 2004-2005 Daniel Bahna (daniel.bahna@gmail.com)

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Released under the GNU General Public License
*/

$orderBy = 'ORDER BY ';
$orderBy .= (RELATED_PRODUCTS_RANDOMIZE) ? 'rand()' : 'pop_order_id, pop_id';
$orderBy .= (RELATED_PRODUCTS_MAX_DISP) ? ' limit ' . RELATED_PRODUCTS_MAX_DISP : '';
$attributes = "SELECT prp.pop_products_id_slave,
				  pa.products_name,
				  pb.products_model,
				  pb.products_price,
				  pb.products_quantity,
				  pb.products_tax_class_id,
				  pi.image_filename
		   FROM " . TABLE_PRODUCTS_RELATED_PRODUCTS . " prp, 
				" . TABLE_PRODUCTS_DESCRIPTION . " pa, 
				" . TABLE_PRODUCTS . " pb
			 left join " . TABLE_PRODUCTS_IMAGES . " pi 
			   on pb.products_id = pi.products_id 
				 and pi.category_page = '1',
		   WHERE prp.pop_products_id_slave = pa.products_id
			 AND pa.products_id = pb.products_id
			 AND pa.language_id = '" . (int) $languages_id . "'
			 AND prp.pop_products_id_master = '" . $HTTP_GET_VARS['products_id'] . "'
			 AND products_status = '1' " . $orderBy;
$attribute_query = tep_db_query($attributes);

if (mysql_num_rows($attribute_query) > 0) {
 $count = 0;
?>
<tr>
 <td><table class="productlisting" border="0" cellspacing="0" cellpadding="2" width="100%">
<tr>
  <td align="center" class="productListing-heading"> <?php echo TEXT_RELATED_PRODUCTS ?> </td>
</tr>
<tr>
  <td align="center" class="productListing-data"><table border="0" cellspacing="0" cellpadding="2" width="100%" align="center">
	<tr>
<?php

 while ($attributes_values = tep_db_fetch_array($attribute_query)) {
$products_name_slave = ($attributes_values['products_name']);
$products_model_slave = ($attributes_values['products_model']);
$products_qty_slave = ($attributes_values['products_quantity']);
$products_id_slave = ($attributes_values['pop_products_id_slave']);
if ($new_price = tep_get_products_special_price($products_id_slave)) {
  $products_price_slave = $currencies->display_price($new_price, tep_get_tax_rate($attributes_values['products_tax_class_id']));
} else {
  $products_price_slave = $currencies->display_price($attributes_values['products_price'], tep_get_tax_rate($attributes_values['products_tax_class_id']));
}
echo '<td class="productListing-data" align="center">' . "\n";
// show thumb image if Enabled
if (RELATED_PRODUCTS_SHOW_THUMBS == 'True') {
  echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . "\n" . tep_image(DIR_WS_IMAGES . $attributes_values['image_filename'], $attributes_values['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a><br>' . "\n";
}
$caption = '';
if (RELATED_PRODUCTS_SHOW_NAME == 'True') {
  $caption .= '<p>' . $products_name_slave;
  if (RELATED_PRODUCTS_SHOW_MODEL == 'True') {
	$caption .= sprintf(RELATED_PRODUCTS_MODEL_COMBO, $products_model_slave);
  }
  $caption .= '</p>' . "\n";
}
elseif (RELATED_PRODUCTS_SHOW_MODEL == 'True') {
  $caption .= '<p>' . $products_model_slave . '</p>' . "\n";
}
if (RELATED_PRODUCTS_SHOW_PRICE == 'True') {
  $caption .= '<p>' . sprintf(RELATED_PRODUCTS_PRICE_TEXT, $products_price_slave) . '</p>' . "\n";
}
if (RELATED_PRODUCTS_SHOW_QUANTITY == 'True') {
  $caption .= '<p>' . sprintf(RELATED_PRODUCTS_QUANTITY_TEXT, $products_qty_slave) . '</p>' . "\n";
}
echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . $caption . '</a>' . "\n";
if (RELATED_PRODUCTS_SHOW_BUY_NOW == 'True') {
  echo '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array (
	'action'
  )) . 'action=rp_buy_now&rp_products_id=' . $products_id_slave) . '">' . tep_image_button('button_rp_buy_now.gif', IMAGE_BUTTON_RP_BUY_NOW) . '</a>';
}
echo '</td>' . "\n";
$count++;
if ((RELATED_PRODUCTS_USE_ROWS == 'True') && ($count % RELATED_PRODUCTS_PER_ROW == 0)) {
  echo '</tr><tr>' . "\n";
}
 }
?>
	</tr>
  </table></td>
</tr>
 </table></td>
</tr>
<?php
}
?>

Regards

Jim

[♥kymation]

Typo. Remove the comma just before the WHERE in that SQL.

 

Regards

Jim

[Webbies]

Jim,

 

You're my hero!!

 

It's working now

 

Regards,

 

Angelique

 

Typo. Remove the comma just before the WHERE in that SQL.

 

Regards

Jim

[lightshine]

Just some query on more_pics v2.05, have anyone tried more_pics v2.05 together with easy populate v3.0?

[Gary Osterholt]

Hey,

 

Great contribution.

 

I'm having problems when I'm using the "Use CSS Format" all the thumbnails end up really messed up.

 

Any way I can fix this?

 

Gary

[mrkiki911]

oscommerce should come with multiple picture support standard. Thats ridiculous.

 

But anyways, I have installed this following all the directions, but now my site is all off. I lost the color scheme, and the boxes are all over.

 

www.mrcbus.com

 

Please help! Thanks

[♥kymation]

Hey,

 

Great contribution.

 

I'm having problems when I'm using the "Use CSS Format" all the thumbnails end up really messed up.

 

Any way I can fix this?

 

Gary

Are all of your images the same size, or at least the same aspect ratio?

 

Regards

Jim

[♥kymation]

oscommerce should come with multiple picture support standard. Thats ridiculous.

 

But anyways, I have installed this following all the directions, but now my site is all off. I lost the color scheme, and the boxes are all over.

 

www.mrcbus.com

 

Please help! Thanks

Is this a new installation? Previous mods? You overwrote a previously modified stylesheet? There are many possibilities; it's too hard to tell without more information.

 

Regards

Jim

[Gary Osterholt]

Are all of your images the same size, or at least the same aspect ratio?

 

Regards

Jim

 

 

Jim,

 

I've done with the same exact size photos, I've done with the same aspect ratio, and I've done it with way different aspect ratio.

 

Gary

[♥kymation]

If you have the same size or the same aspect ratio, then set either the width or the height for the small images in the More Pics admin. Setting both can cause distortion. Other than that, I can't think of anything that would cause this problem.

 

Regards

Jim

[mrkiki911]

Is this a new installation? Previous mods? You overwrote a previously modified stylesheet? There are many possibilities; it's too hard to tell without more information.

 

Regards

Jim

 

I overwrote a previously modified stylesheet. Is it possible to add this to a new template?

 

www.mrcbus.com (i deleted everything and installed a fresh version of the template)

[♥kymation]

You can't overwrite files that have already been modified. This never works. You need to patch your modified files to add the new code. See the Read_me.txt under Files.

 

Regards

Jim

[Gary Osterholt]

If you have the same size or the same aspect ratio, then set either the width or the height for the small images in the More Pics admin. Setting both can cause distortion. Other than that, I can't think of anything that would cause this problem.

 

Regards

Jim

 

Jim,

 

Thanks figured it out. When using the CSS Format, make sure the Image size in the "More Pics" is blank. And control it with the CSS file.

 

Gary

[volau]

Great contribution, and I appreciate all the work done on it.

 

Seems to be working pretty much OK, and am still learning how to use it; I scanned backwards through the posts prior to the last release 2.0.5 and don't see anyone with this problem with the current said version.

 

When I try to enter a sort order for images within a given product, no matter what value I enter, ALL images still show up with value 0 (zero) on the panel showing all images per product, and can't seem to specify any sort order of images.

 

Am I doing something wrong, or is this a bug ?

Edited February 18, 2009 by volau

[♥kymation]

You've done something wrong. Check your edits to admin/images.php. Which you shouldn't have edited in the first place. This doesn't make any sense.

 

Regards

Jim

[Rebekah]

Firstly, I really like this contribution. I do have a couple of issues of combining it with other mods though. Any mod/contribution that has thumbnails won't display. I need help understand what code I need to change with what in general.

 

The two mods that are giving me a hard time right now is x-sell and featured products.

 

Any advice from anyone is much appreciated.

[♥kymation]

Any Contribution that uses images needs to be modified to pull the image name from the new images table. You can use a similar file for comparison, such as catalog/includes/modules/also_purchased_products.php, catalog/reviews.php, catalog/specials.php, etc. If you run into problems, post the SQL that calls the information from the database for whatever you're trying to modify. Also. please share with the rest of us when you get something working.

 

Regards

Jim

[Rebekah]

Will Work on it and post any successes.

 

Thanks,

Rebekah

[Rebekah]

To be honest, the easiest fix was the replace the catagories.php file in the Admin section with one that wasn't altered according to the directions in this mod/contribution. It put the image file browse back in the product description, which in turn will put an image in the old image directory where other mods expect it to be. I checked it out and everything works fine for me now.

 

Thanks again for this mod.

 

Rebekah

Edited February 18, 2009 by Rebekah

[vallenssia]

Hi there Jim,

Great contribution, although I had some truble because my osc is heavily modified.

I solved almost any error but it seems I can't get thrugh few ones:

 

1. When I click to any osc picture the popup shows empty. The popup on the pictures I added after installation of the contribution works fine.

2. I can't delete the inserted additional image from the server or the Admin and when I click the primary image on the site the popup shows the one I "deleted" (under specials.php)

,

3. When I turn off the admin option "Show Original Image on Product Info page" the page is distorted.

,

4. If I set admin option "Use CSS Images Instead of Popup" to "true" the product image doubles.

 

Please advise where to look for the errors. I am semi-newbie and not a native speaker.http://www.oscommerce.com/forums/style_emoticons/default/blush.gif

http://www.oscommerce.com/forums/style_emotico...fault/blush.gif

 

Thanks in advance

Vallenssia

[♥kymation]

1. When I click to any osc picture the popup shows empty. The popup on the pictures I added after installation of the contribution works fine.

See the Readme.txt file under Setup.

2. I can't delete the inserted additional image from the server or the Admin and when I click the primary image on the site the popup shows the one I "deleted" (under specials.php)

Try adding a new image and checking the Products box for the new image, then delete the old one.

3. When I turn off the admin option "Show Original Image on Product Info page" the page is distorted.

4. If I set admin option "Use CSS Images Instead of Popup" to "true" the product image doubles.

You have errors in your catalog/product_info.php. It appears that you added code instead of replacing the code for the image. Check your edits carefully.

 

Regards

Jim

[vallenssia]

See the Readme.txt file under Setup.

 

Try adding a new image and checking the Products box for the new image, then delete the old one.

 

You have errors in your catalog/product_info.php. It appears that you added code instead of replacing the code for the image. Check your edits carefully.

 

Regards

Jim

 

Thanks for your input. I'll try to investigate products_info again. Meanwhile, three thumbnail images are streched over entire page and I would like them to fit exactly below the large picture. I tried to change table width in includes/modules/more_pics.php but nothing happens. Where can I change the size of the table?

 

Vallenssia

[♥kymation]

The code in the More Pics distribution doesn't do that. The errors in your code edits are the most likely source of the distortion of the table. You are probably missing the HTML to close one of the other tables on the page.

 

Regards

Jim

[vallenssia]

The code in the More Pics distribution doesn't do that. The errors in your code edits are the most likely source of the distortion of the table. You are probably missing the HTML to close one of the other tables on the page.

 

Regards

Jim

 

Maybe you have few minutes to take a look at the products_info.php?

 

 

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="3" cellpadding="3">

<tr>

<td height="0" width="<?php echo BOX_WIDTH; ?>" valign="top"></td>

<!-- body_text //-->

<td rowspan="2" 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>

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

// BOF: More Pics 6 Removed images

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, 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 . "'");

// EOF: More Pics 6

$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

// BOF: More Pics

if (MORE_PICS_TABLE_LOCATION == 'above' || MORE_PICS_TABLE_LOCATION == 'sides') {

include (DIR_WS_MODULES . FILENAME_MORE_PICS);

}

 

$product_images_query = tep_db_query ("select image_filename

from " . TABLE_PRODUCTS_IMAGES . "

where products_id = '" . (int) $_GET['products_id'] . "'

and product_page = '1'

");

$product_images = tep_db_fetch_array ($product_images_query);

$products_main_image = $product_images['image_filename'];

 

if (tep_not_null ($products_main_image) && MORE_PICS_SHOW_ORIG_ON_PRODUCT_INFO == 'true') {

?>

<table width="200" 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="border-right:13px solid #ffffff;border-left:0px solid #ffffff;">

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

 

 

<?php /* echo tep_draw_prod_top(); */?>

<?php

if (MORE_PICS_LINK_CSS_IMAGES == 'true') {

echo '<a href="' . tep_href_link (FILENAME_PRODUCT_INFO, tep_get_all_get_params() . '#morepics') . '">' . tep_image (DIR_WS_IMAGES . $products_main_image, $product_info['products_name'], (MORE_PICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_WIDTH), (MORE_PICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_HEIGHT), 'hspace="5" vspace="5"') . '<br><img border=0 src=images/zoom.gif></a>';

} else {

}

?>

 

<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 . $products_main_image, addslashes($product_info['products_name']), (MORE_PICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_WIDTH), (MORE_PICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_HEIGHT), ' style="margin:0px 0px 0px 0px;"') . '<br><img border=0 src=images/zoom.gif></a>'; ?>');

//--></script>

<noscript>

<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $products_main_image) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $products_main_image, $product_info['products_name'], (MORE_PICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_WIDTH), (MORE_PICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_HEIGHT), ' style="margin:0px 0px 0px 0px;"') . '<br><img border=0 src=images/zoom.gif></a>'; ?>

</noscript>

<?php

} // if (MORE_PICS_LINK_CSS_IMAGES ... else ...

// EOF: More Pics

?>

<?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['product_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">

<tr><td style="vertical-align:middle; height:28px;"><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">

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

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

<tr><td height="5"></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); ?></td>

</tr>

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

<?php

}

?>

</table>

<?php

}

// BOF: More Pics 6

if (MORE_PICS_TABLE_LOCATION == 'below') {

include (DIR_WS_MODULES . FILENAME_MORE_PICS);

}

// EOF: More Pics 6

?>

<?php include_once (DIR_WS_MODULES . FILENAME_MORE_PICS); ?>

<?php

$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where approved = 1 and 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"><?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();?>

 

<? include(DIR_WS_MODULES . 'product_reviews_info.php'); ?>

<? include(DIR_WS_MODULES . FILENAME_TAGCLOUD);?>

 

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

if (MORE_PICS_TABLE_LOCATION == 'bottom') {

}

?>

</table></form>

</td>

 

 

<!-- body_text_eof //-->

<td height="0" width="<?php echo BOX_WIDTH; ?>" valign="top"></td>

</tr>

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

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

</html>

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