Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] More_pics_6 v1.1 For osC 2.2 MS2


surfalot

Recommended Posts

Yes, I cannot see any images. I check the queries and are correct. I don't know why can't see any pictures.

Because you are not supposed to be able to see images there. It's normal. This is the way it is supposed to work. Am I getting through here?

 

Regards

JIm

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

  • Replies 1.6k
  • Created
  • Last Reply

Top Posters In This Topic

Yes, I cannot see any images. I check the queries and are correct. I don't know why can't see any pictures.

 

I installed the more_pics_classic_1.4.3 and I have the same problem.

And I found out the problem lies in the admin/categories.php file.

I found out in my file, one line is missing.

 

Find

      // BOF: More Pics 6
  echo tep_draw_hidden_field('products_subimage1', stripslashes($products_subimage1_name));
  echo tep_draw_hidden_field('products_subimage2', stripslashes($products_subimage2_name));
  echo tep_draw_hidden_field('products_subimage3', stripslashes($products_subimage3_name));
  echo tep_draw_hidden_field('products_subimage4', stripslashes($products_subimage4_name));
  echo tep_draw_hidden_field('products_subimage5', stripslashes($products_subimage5_name));
  echo tep_draw_hidden_field('products_subimage6', stripslashes($products_subimage6_name));
// BOF: More Pics 6

 

and add

      echo tep_draw_hidden_field('products_image', stripslashes($products_image_name));

before it.

It works for me. I hope it works for you too.

Link to comment
Share on other sites

I installed the more_pics_classic_1.4.3 and I have the same problem.

And I found out the problem lies in the admin/categories.php file.

I found out in my file, one line is missing.

It works for me. I hope it works for you too.

 

I have not installed classic version but advanced version, are more different. I check the code and I continue to have the problem. I don't find any error, if there is anyone that have the same problem write here!

Link to comment
Share on other sites

I have not installed classic version but advanced version, are more different. I check the code and I continue to have the problem. I don't find any error, if there is anyone that have the same problem write here!

 

Hum, I think in that case, it is better to just install the classic one. At least it works!

 

discountcorner.ca

Link to comment
Share on other sites

Hello, I just installed more pics 6 2.07 combined

I can't figure out how to do a classic popup window when you click on the zoom button, located on the product info page. Basically I don't want all the product images rolled over on the same product info page. I want a pop-up window with all my product images shown there. Is that possible with this module? :huh:

 

Thank!

kenz

Edited by kenz
Link to comment
Share on other sites

Also I wanted to make a note too that that under my configuration settings in admin, I tried turning more pics off by setting it to false, but the contribution still shows up. Any thoughts on that? I'm using OSC 2.2 RC2A and its a clean install. This is the only conrtib i got running on it.

 

Thanks

kenz

Link to comment
Share on other sites

Hello, I just installed more pics 6 2.07 combined

I can't figure out how to do a classic popup window when you click on the zoom button, located on the product info page. Basically I don't want all the product images rolled over on the same product info page. I want a pop-up window with all my product images shown there. Is that possible with this module? :huh:

 

Thank!

kenz

 

My apologies on this question - don't waste your time trying to figure this out - there was an additional option right inside the admin panel to allow me to view a classic pop-up window.

Link to comment
Share on other sites

product description is not showing at all...

can anyone help me?

i have attached the code.

Regards

 

<?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 type="text/javascript" src="iepngfix_tilebg.js"></script>
<style type="text/css">
.ie6_png			 {behavior: url("iepngfix.htc") }
.ie6_png img		{behavior: url("iepngfix.htc") }
.ie6_png input		{behavior: url("iepngfix.htc") }
</style>
<!--[if IE]>
  <script type="text/javascript" src="ie_png.js"></script>
  <script type="text/javascript">
   ie_png.fix('.png');
  </script>
<![endif]-->
<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,l
e
ft=150')
}
//--></script>
</head>
<body>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0">
<tr>
<td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?>



<?php
 if ($product_check['total'] < 1) {
?>
<?php echo tep_draw_top();?>

<?php echo tep_draw_title_top();?>

			<?php echo TEXT_PRODUCT_NOT_FOUND; ?>

<?php echo tep_draw_title_bottom();?>

<?php echo tep_draw1_top();?>

<?php echo tep_draw_infoBox2_top();?>

		<table border="0" width="100%" cellspacing="0" cellpadding="2">
			<tr><td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td></tr>
		</table>

<?php echo tep_draw_infoBox2_bottom();?>

<?php echo tep_draw1_bottom();?>

<?php
 } else {
// BOF: More Pics 6  Added: , p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6
$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, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, 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_price2 = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
} else {
  $products_price2 = '<span class="productSpecialPrice">'.$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])).'</span>';
}

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>   <b class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</b>';
} else {
  $products_price = '<b class="productSpecialPrice">'.$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])).'</b>';
}

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'];
}
// BOF: More Pics 6

$mopics_image_width = (MOPICS_RESTRICT_IMAGE_SIZE=='true'?SMALL_IMAGE_WIDTH:'');
$mopics_image_height = (MOPICS_RESTRICT_IMAGE_SIZE=='true'?SMALL_IMAGE_HEIGHT:'');

if (MOPICS_SHOW_ALL_ON_PRODUCT_INFO=='true') {

  $mopics_output = '';
  $mo_row = 1;
  $mo_col = 1;

  $mopics_images = array();
  if (tep_not_null($product_info['products_image']) && MOPICS_GROUP_WITH_PARENT == 'true') { $mopics_images[] = $product_info['products_image']; }
  for ( $mo_item=1; $mo_item<7; $mo_item++ ) {
	if (tep_not_null($product_info['products_subimage'.$mo_item])) { $mopics_images[] = $product_info['products_subimage'.$mo_item]; }
  }
  $mopics_count = sizeof($mopics_images);

  if ($mopics_count > 0) { 

	$mopics_output .= '<table border="0" cellspacing="0" cellpadding="6" align="'.MOPICS_TABLE_ALIGNMENT.'">';

	for ( $mo_item=0; $mo_item<$mopics_count; $mo_item++ ) {

	  if ($mo_row<(MOPICS_NUMBER_OF_ROWS+1)) {
		if ($mo_col==1) {$mopics_output.='<tr>'."\n";}

		$mopics_output .= '			  <td align="center" class="smallText"><script language="javascript"><!--
			document.write(\'<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'].'&invis='.(MOPICS_GROUP_WITH_PARENT=='true'?$mo_item:($mo_item+1))).'\\\')">' . tep_image(DIR_WS_IMAGES . $mopics_images[$mo_item], addslashes($product_info['products_name']), (MOPICS_RESTRICT_PARENT=='false'&&$mo_item==0&&MOPICS_GROUP_WITH_PARENT=='true'?'':$mopics_image_width), (MOPICS_RESTRICT_PARENT=='false'&&$mo_item==0&&MOPICS_GROUP_WITH_PARENT=='true'?'':$mopics_image_height), 'hspace="5" vspace="5"') . '<br><img border=0 src=images/zoom.gif></a>\');
			//--></script><noscript>
			  <a href="' . tep_href_link(DIR_WS_IMAGES . $mopics_images[$mo_item]) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $mopics_images[$mo_item], $product_info['products_name'], $mopics_image_width, $mopics_image_height, 'hspace="5" vspace="5"') . '<br><img border=0 src=images/zoom.gif></a>
			  </noscript></td>'."\n";

		if ($mo_col==MOPICS_NUMBER_OF_COLS) { $mo_col=1; $mo_row++; $mopics_output.='</tr>'."\n"; } else { $mo_col++; }
	  }

	}

	if ($mo_col!=1){ while (($mo_col++)<(MOPICS_NUMBER_OF_COLS+1)) { $mopics_output.='<td> </td>'; } $mopics_output.='</tr>'."\n"; }

	$mopics_output .= '</table>'."\n"; 

  }

}

// EOF: More Pics 6

?>

<?php echo tep_draw_top();?>

<?php echo tep_draw_title_top();?>

			<div class="left_part"><?php echo $breadcrumb->trail(' » ')?> »  <?php echo $products_name; ?></div><div class="right_part"><?php echo $products_price2; ?></div>

<?php echo tep_draw_title_bottom();?>

<?php echo tep_draw1_top();?>

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

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

<?php
// BOF: More Pics 6	ADDED to if statement:  && MOPICS_GROUP_WITH_PARENT == 'false'
if (tep_not_null($product_info['products_image']) && MOPICS_GROUP_WITH_PARENT == 'false') {
?>
	  <table border="0" cellspacing="0" cellpadding="2" align="right">
		<tr>
		  <td align="center" class="smallText">
<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']), (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_WIDTH), (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_HEIGHT), 'hspace="5" vspace="5"') . '<br><img border=0 src=images/zoom.gif></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'], (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_WIDTH), (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_HEIGHT), 'hspace="5" vspace="5"') . '<br><img border=0 src=images/zoom.gif></a>'; ?>
<?php // EOF: More Pics 6 ?>');
//--></script>
<noscript><?php echo '<a class="enlarge" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' .  TEXT_CLICK_TO_ENLARGE . '</a>'; ?></noscript></div>	
<div class="main"><div class="desc2">
// BOF: More Pics 6
if (MOPICS_TABLE_LOCATION=='above' && !empty($mopics_output)) {
  echo '		  <table width="100%" border="0" cellspacing="0" cellpadding="0">
		<tr>
		  <td align="center" class="smallText">'.$mopics_output.'</td>
		</tr>
	  </table>
	   <br>'."\n";
} else if (MOPICS_TABLE_LOCATION=='sides' && !empty($mopics_output)) {
  echo $mopics_output;
}
// EOF: More Pics 6

<?php echo stripslashes($product_info['products_description']); ?></div><br>
			  <br><div><?php echo $products_price?></div></div><br>
<div style="clear:both;"></div>
<?php
}
?>


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

<div class="cart_line_x padd2_gg"><?php echo tep_draw_separator('spacer.gif', '1', '1'); ?></div>

	<?php echo tep_draw2_top(); ?>

<?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="4" cellpadding="2">
		<tr>
		  <td class="main" colspan="2"><strong class="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>
<?php
  }
?>
	  </table>
<?php 
}
// BOF: More Pics 6
if (MOPICS_TABLE_LOCATION=='below' && !empty($mopics_output)) {
  echo ' <br>
	  <table width="100%" border="0" cellspacing="0" cellpadding="0">
		<tr>
		  <td align="center" class="smallText">'.$mopics_output.'</td>
		</tr>
	  </table>'."\n";
}
// EOF: More Pics 6
?>


<?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="4" border="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>
</table>
<?php
}

if (tep_not_null($product_info['products_url'])) {
?>
<table cellpadding="0" cellspacing="4" border="0">
  <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>
</table>

<?php echo tep_pixel_trans();?>

<?php
}

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

<?php echo tep_pixel_trans();?>

<table cellpadding="0" cellspacing="4" border="0">	
  <tr>
	<td class="main"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>
  </tr>
</table>
<?php
} else {
?>

<?php echo tep_pixel_trans();?>

  <table cellpadding="0" cellspacing="4" border="0">   
  <tr>
	<td class="main"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>
  </tr>
</table>
<?php
}
?>

<?php echo tep_draw2_bottom(); ?>

<?php echo tep_pixel_trans();?> 

<div class="cart_line_x padd2_gg"><?php echo tep_draw_separator('spacer.gif', '1', '1'); ?></div>

<?php echo tep_draw2_top(); ?>

<?php echo tep_pixel_trans();?>
<?php echo tep_pixel_trans();?>

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

		<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
			<td class="main button_marg"><?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 button_marg" align="right"><?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>

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

	<?php echo tep_draw2_bottom(); ?>


<?php echo tep_draw1_bottom();?>

<?php
if ((USE_CACHE == 'true') && empty($SID)) {
  echo tep_cache_also_purchased(3600);
} else {
 include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
 }
?>

<?php echo tep_draw_bottom();?>	

</form></td>
<!-- body_text_eof //-->
<td class="<?php echo BOX_WIDTH_TD_RIGHT; ?>"><table border="0" class="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="0">
<!-- 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'); ?>

Link to comment
Share on other sites

Hi men, I' trying to upgrade form More Pics classic to Advanced but my problem comes when i try to adapt product_info.php

 

i'm totally lost, here is my code in classic:

<?php
/*
 $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

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

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);

 $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 type="text/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>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="0" cellpadding="0">
 <tr>
  <td style="height:100%;">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</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) {
?>
<?
/*  
<?php echo TEXT_PRODUCT_NOT_FOUND;?>
*/
?>

	<tr><td>

<? tep_draw_heading_top(); ?>

		<table border="0" cellspacing="0" cellpadding="0">
			<tr><td class="cont_header_txt"><? echo(tep_image(DIR_WS_IMAGES.'1_z3.gif'))?> <?php echo TEXT_PRODUCT_NOT_FOUND;?></td></tr>
		</table>	

<? tep_draw_heading_top_1(); ?>
<?  echo $tep_draw_heading_top_prod_type1?>				


		<table cellpadding="0" cellspacing="0" border="0" width="100%">
			<tr><td height="27"></td></tr>
		</table>

 		<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>
			  <tr><td height="5"></td></tr>
		</table> 
<?php echo tep_draw_separator('spacer.gif', '1', '15'); ?><br>
<?  echo $tep_draw_heading_bottom_prod_type1?>				

<? tep_draw_heading_bottom_1(); ?>

<? tep_draw_heading_bottom(); ?>

<?php
 } else {
// BOF: More Pics 6  Added: , p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6
$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, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, 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 = '<span class="price_txt">' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span> <span class="price_txt_strice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
} else {
  $products_price = '<span class="price_txt">'.$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']).'</span>');
}




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'];
}
// BOF: More Pics 6

$mopics_image_width = (MOPICS_RESTRICT_IMAGE_SIZE=='true'?SMALL_IMAGE_WIDTH:'');
$mopics_image_height = (MOPICS_RESTRICT_IMAGE_SIZE=='true'?SMALL_IMAGE_HEIGHT:'');

if (MOPICS_SHOW_ALL_ON_PRODUCT_INFO=='true') {

  $mopics_output = '';
  $mo_row = 1;
  $mo_col = 1;

  $mopics_images = array();
  if (tep_not_null($product_info['products_image']) && MOPICS_GROUP_WITH_PARENT == 'true') { $mopics_images[] = $product_info['products_image']; }
  for ( $mo_item=1; $mo_item<7; $mo_item++ ) {
	if (tep_not_null($product_info['products_subimage'.$mo_item])) { $mopics_images[] = $product_info['products_subimage'.$mo_item]; }
  }
  $mopics_count = sizeof($mopics_images);

  if (tep_not_null($product_info['products_image'])) { $mopics_output .= '<table border="0" cellspacing="0" cellpadding="6" align="'.MOPICS_TABLE_ALIGNMENT.'">'."\n"; }

  for ( $mo_item=0; $mo_item<$mopics_count; $mo_item++ ) {

	if ($mo_row<(MOPICS_NUMBER_OF_ROWS+1)) {
	  if ($mo_col==1) {$mopics_output.='<tr>';}

	  $mopics_output .= '			  <td align="center" class="smallText"><script language="javascript"><!--
			document.write(\'<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'].'&invis='.(MOPICS_GROUP_WITH_PARENT=='true'?$mo_item:($mo_item+1))).'\\\')">' . tep_image(DIR_WS_IMAGES . $mopics_images[$mo_item], addslashes($product_info['products_name']), (MOPICS_RESTRICT_PARENT=='false'&&$mo_item==0&&MOPICS_GROUP_WITH_PARENT=='true'?'':$mopics_image_width), (MOPICS_RESTRICT_PARENT=='false'&&$mo_item==0&&MOPICS_GROUP_WITH_PARENT=='true'?'':$mopics_image_height), 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>\');
			//--></script><noscript>
			  <a href="' . tep_href_link(DIR_WS_IMAGES . $mopics_images[$mo_item]) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $mopics_images[$mo_item], $product_info['products_name'], $mopics_image_width, $mopics_image_height, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>
			  </noscript></td>'."\n";

	  if ($mo_col==MOPICS_NUMBER_OF_COLS) { $mo_col=1; $mo_row++; $mopics_output.='</tr>'."\n"; } else { $mo_col++; }
	}

  }

  if ($mo_col!=1){ while (($mo_col++)<(MOPICS_NUMBER_OF_COLS+1)) { $mopics_output.='<td> </td>'."\n"; } }

  if (tep_not_null($product_info['products_image'])) { $mopics_output .= '</table>'."\n"; }

}

// EOF: More Pics 6
?>
  <tr>
	<td>

<? tep_draw_heading_top(); ?>

				<?/*  going title */?>
				<?php tep_draw_titletop();?>
				<?php echo $breadcrumb->trail(' » ')?>
				<?php tep_draw_titlebottom();?>


<? tep_draw_heading_top_3(); ?>	
<?  tep_draw_heading_top_2(); ?>		

<? /*
<?php echo $products_name; ?>

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

<?php
  // BOF: More Pics 6	ADDED to if statement:  && MOPICS_GROUP_WITH_PARENT == 'false'
if (tep_not_null($product_info['products_image']) && MOPICS_GROUP_WITH_PARENT == 'false') {
// EOF: More Pics 6
?>





						  <table cellspacing="0" cellpadding="0" border="0" style="background:url(images/rtc1.gif) no-repeat right top; height:35px;">
						   <tr>
							<td style="background:url(images/rbc1.gif) no-repeat right bottom; padding:0 0 0 21px; vertical-align:middle;" class="title2_txt"> <?php echo $products_name; ?><br>
							</td>
						   </tr>
						  </table>
						 </td>
						</tr>
					   </table>
					   <table cellspacing="0" cellpadding="0" border="0" style="margin-top:16px;">
						<tr>
						 <td width="260" style="text-align:center;">
								  <script type="text/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, 'hspace="0" vspace="0"') . '</a>'; ?>');
//--></script>
<noscript>
<?php // BOF: More Pics 6 ?>
<?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'], (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_WIDTH), (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_HEIGHT), 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>
<?php // EOF: More Pics 6 ?>
<noscript>
<br>		

<script type="text/javascript"><!--
document.write('<?php echo '<br style="line-height:10px;">
<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 '<br style="line-height:10px;"><div><a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . TEXT_CLICK_TO_ENLARGE . '</a>

</div>'; ?>
</noscript><br>
<script type="text/javascript"><!--
document.write('<?php echo '<br style="line-height:10px;"><div class="link7"><a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . TEXT_CLICK_TO_ENLARGE . '</a>
</div>'; ?>');
//--></script>
						 </td>
						 <td>
						  <table cellspacing="0" cellpadding="0" border="0">
						   <tr>
							<td height="98" class="link7">
									 <?php

// BOF: More Pics 6
if (MOPICS_TABLE_LOCATION=='below') {
  echo ' 
	  <table width="100%" border="0" cellspacing="0" cellpadding="0">
		<tr>
		  <td align="center" class="smallText">'.$mopics_output.'</td>
		</tr>
	  </table>'."\n";
}
// EOF: More Pics 6
?><br>
							</td>
						   </tr>
						  </table>


									<table cellspacing="0" cellpadding="0" border="0">
										<tr>
<td style="width:100%; background:url(images/side.gif) repeat-x top;">
							 <table cellspacing="0" cellpadding="0" border="0" style="background:url(images/side.gif) repeat-x bottom;">
							  <tr>
							   <td style="background:url(images/side.gif) repeat-y left;">
								<table cellspacing="0" cellpadding="0" border="0" style="background:url(images/side.gif) repeat-y right;">
								 <tr>
								  <td style="background:url(images/ltc2.gif) no-repeat left top;">
								   <table cellspacing="0" cellpadding="0" border="0" style="background:url(images/lbc2.gif) no-repeat left bottom;">
									<tr>
									 <td style="background:url(images/rtc2.gif) no-repeat right top;">
									  <table cellspacing="0" cellpadding="0" border="0" style="background:url(images/rbc2.gif) no-repeat right bottom;height:59px;">
									   <tr>
										<td width="120" class="price_txt" style=" text-align:center; vertical-align:middle;"><?=$products_price?><br>
										</td>
										<td style="width:auto;">
									<?php echo tep_draw_separator('spacer.gif', '1', '14'); ?><br>
					   <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart1.gif', IMAGE_BUTTON_IN_CART); ?><br>
									   <?php echo tep_draw_separator('spacer.gif', '1', '4'); ?><br>
					  <?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>'; ?><br>
										</td>
									   </tr>
									  </table>
									 </td>
									</tr>
								   </table>
								  </td>
								 </tr>
								</table>
							   </td>
							  </tr>
							 </table>
							</td>													
										</tr>
									</table>
						 </td>
						</tr>
					   </table>
					   <table cellspacing="0" cellpadding="0" border="0" style="margin-top:23px;">
						<tr>
						 <td style="padding-left:11px; padding-right:15px;" class="txt5">




<?php
}
?>

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


<?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 class="p2" 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 style="width:47px;"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>
												<td><?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
}
?>

<?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 style=" line-height:15px;">
									<?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?>
									</td></tr>

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



<?php
}

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


								<table cellpadding="0" cellspacing="0" class="product box_width_cont">
									<tr><td style=" line-height:15px;">

									<?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 style=" line-height:15px;" class="txt10"><?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 style=" line-height:15px;" class="txt10"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td></tr>
									<tr><td height="17"></td></tr>
								</table>

<?php
}
// BOF: More Pics 6
if (MOPICS_TABLE_LOCATION=='above') {
  echo '		  <table width="100%" border="0" cellspacing="0" cellpadding="0">
		<tr>
		  <td align="center" class="smallText">'.$mopics_output.'</td>
		</tr>
	  </table>
	   <br>'."\n";
} else if (MOPICS_TABLE_LOCATION=='sides') {
  echo $mopics_output;
}
// EOF: More Pics 6
?>

					   <div style="line-height:16px;">
								<?php echo stripslashes($product_info['products_description']); ?><br>
								</div>
								<br style="line-height:20px;">


<?  tep_draw_heading_bottom_2(); ?>		
<? tep_draw_heading_bottom_3(); ?>

<?php tep_draw_heading_bottom();?>	



<?php
if ((USE_CACHE == 'true') && empty($SID)) {
  echo tep_cache_also_purchased(3600);
} else {
?>


<?php	  

  //include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
?>


<?php	  
}
?>


<?	

 }
?>

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



<!-- body_text_eof //-->
<td valign="top">
<!-- 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'); ?>

 

 

If anyone could help me please

Link to comment
Share on other sites

hello, i have more pics installed and its working great! I would like to add text to the photos, perhaps a caption? I do some php and javascript coding, but do you have any recommendations on where i can start to get that implemented. basically i want each image to have its own unique caption next to it. something short like 20 characters long or something.

If this has already been done and you know of that, that would be awesome!

 

 

thanks!

-k

Edited by kenz
Link to comment
Share on other sites

In that case, I would start with adding a caption field to the products_images table. Make it Varchar(32) or so. Then modify all of the database calls that retrieve images (on pages where you want the captions) to include your new database field. Last, add PHP code to the page to display your caption where you want it. Shouldn't take all that much work.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

In that case, I would start with adding a caption field to the products_images table. Make it Varchar(32) or so. Then modify all of the database calls that retrieve images (on pages where you want the captions) to include your new database field. Last, add PHP code to the page to display your caption where you want it. Shouldn't take all that much work.

 

Regards

Jim

 

sounds simple - thanks!

Link to comment
Share on other sites

2.2 MS2 is no longer supported. There are major security flaws in that version. You should upgrade to 2.2RC2a. There's a Contribution for the upgrade. Then you can use More Pics 2.0.7 Combined, either the Classic or Advanced version.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

  • 2 weeks later...

Hello and thanks for a great contribution!

 

I used pektsektye's autoinstaller 2.7 and everything works great except for when i try to update any product stock in the admin section. Then i get this:

 

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 'distinct pn.customers_id, c.customers_firstname, c.customers_lastname, c.custome' at line 1

select p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, distinct pn.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address from customers c, products_notifications pn where c.customers_id = pn.customers_id and pn.products_id in ( '32')

[TEP STOP]

 

I've been searching the forum and this thread but found no answers, I'm a complete sql noob, what should i do?

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