So no more support for this ?
Latest News: (loading..)
0
109 replies to this topic
#102
Posted 03 September 2010 - 01:29 PM
first of all i must say this is a super addon so thnx for this and the time you spend on it
ok now here is my problem and i believe i am doing something wrong
so maybe some one can point out to me how to fix this problem
i am using a template so i know its harder to add the contributions
this is the php file i have
and i need this code to be implemented
as you can see the section to find is not the same as the section i have in my file
and i am no php expert so i have done some things but with no succes
i hope someone can help me with this
ok now here is my problem and i believe i am doing something wrong
so maybe some one can point out to me how to fix this problem
i am using a template so i know its harder to add the contributions
this is the php file i have
<?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>
<?php require(DIR_WS_INCLUDES . 'header_includes.php'); ?>
<script language="javascript"><!--
function popupWindow(url) {
window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150')
}
//--></script>
</head>
<body>
<!-- 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 include(DIR_WS_BOXES . 'panel_top.php');?><?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 {
$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_price2 = '<span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span><br><s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s>';
} 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'];
}
?>
<?php echo tep_draw_top();?>
<?php echo tep_draw_title_top();?>
<?php echo $breadcrumb->trail(' » ')?> » <?php echo $products_name; ?>
<?php echo tep_draw_title_bottom();?>
<?php echo tep_draw4_top();?>
<?php echo tep_draw2_top(); ?>
<?php /* echo tep_pixel_trans(); */?>
<?php
if (tep_not_null($product_info['products_image'])) {
?>
<div class="main prod_info" style="width:<?php echo (SMALL_IMAGE_WIDTH +23);?>px;">
<?php echo tep_draw_prod_pic_top();?><script language="javascript"><!--
document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, '') . '</a>'; ?>');
//--></script><noscript>
<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, '') . '</a>'; ?></noscript><?php echo tep_draw_prod_pic_bottom();?>
<script language="javascript"><!--
document.write('<?php echo '<a class="enlarge" href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');
//--></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>
<?php
}
?>
<div class="main"><div class="desc2"><?php echo stripslashes($product_info['products_description']); ?></div><br>
<br><div><?php echo $products_price?></div></div><br>
<div style="clear:both;"></div>
<?php echo tep_draw2_bottom();?>
<div class="cart_line_x padd2_gg"><?php echo tep_draw_separator('spacer.gif', '1', '2'); ?></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><?php echo tep_draw_separator('spacer.gif', '1', '9'); ?></td><td></td></tr>
<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
}
?>
<?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', '2'); ?></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_draw4_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>
<?php require(DIR_WS_INCLUDES . 'footer_includes.php'); ?>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
and i need this code to be implemented
Find (124):
<table border="0" cellspacing="0" cellpadding="2" align="right">
<tr>
<td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');
//--></script>
<noscript>
<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>
</noscript>
</td>
</tr>
</table>
Replace With:
<!-- Simple multi image addon -->
<div id="fancy">
<table border="0" cellspacing="0" cellpadding="2" align="right">
<tr>
<td align="center" class="smallText">
<?php if (strlen($product_info['products_name']) > $max_title_length) { $title = wordwrap(htmlspecialchars($product_info['products_name']), $max_title_length, '<br>');
} else { $title = htmlspecialchars($product_info['products_name']); }
$m_source = ''; $thumb = (class_exists('oscthumb') && CFG_MASTER_SWITCH == 'On'); if ($thumb) { preg_match('/"([^"]+)"/',htmlentities ( tep_image(DIR_WS_IMAGES . $product_info['products_image'],'','','','','',5), ENT_NOQUOTES), $image); $m_source=str_replace('&','&',$image[1]); }
echo '<a rel="prettyPhoto[gallery1]" title="'.$title.'" href="' . ($m_source ? $m_source : DIR_WS_IMAGES . $product_info['products_image']) . '" alt="' . $product_info['products_name'] . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"', false, 5) . '</a><br />';
if(!$vertical_format) { echo ''; $row = 1; reset($products_image_array); foreach($products_image_array as $value) {
if ($thumb) {
$source = ''; preg_match('/"([^"]+)"/',htmlentities ( tep_image(DIR_WS_IMAGES . $value,'','','','','',5), ENT_NOQUOTES), $image); $source=str_replace('&','&',$image[1]);
}
echo '<a rel="prettyPhoto[gallery1]" title="'.$title.'" href="' . ($source ? $source : DIR_WS_IMAGES . $value) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $value, $product_info['products_name'], TINY_IMAGE_WIDTH, TINY_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a>';
++$row; if ($row > $image_group) { echo '<br />'; $row = 1; } } }
echo '</td>';
if($vertical_format) { echo '<td>'; $row = 1; reset($products_image_array); foreach($products_image_array as $value) {
if ($thumb) {
$source = ''; preg_match('/"([^"]+)"/',htmlentities ( tep_image(DIR_WS_IMAGES . $value,'','','','','',5), ENT_NOQUOTES), $image); $source=str_replace('&','&',$image[1]);
}
echo '<a rel="prettyPhoto[gallery1]" title="'.$title.'" href="' . ($source ? $source : DIR_WS_IMAGES . $value) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $value, $product_info['products_name'], TINY_IMAGE_WIDTH, TINY_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br />' . '</a>';
++$row; if ($row > $image_group) { echo '</td><td>'; $row = 1; } } echo '</td>'; } ?>
</tr><?php echo '<tr><td class="smallText">' . TEXT_CLICK_TO_ENLARGE . '</td></tr>'; ?>
</table>
</div>
<!-- EOF Simple multi image addon -->
Save the altered product_info.php
as you can see the section to find is not the same as the section i have in my file
and i am no php expert so i have done some things but with no succes
i hope someone can help me with this
#103
Posted 02 October 2010 - 02:22 AM
just wanted to say Thanks for a great contribution. Everything seems to be ok so far.
I had the same error as someone in Nov 2009
Warning: mysql_num_rows() expects parameter 1 to be resource, null given in C:\wamp\www\catalog\includes\functions\database.php on line 103
after checking the edits - this was due to my mistake when replacing the very first edit on product_info page. Just wanted to post in case someone else will have the same message, it will make for a quicker fix.
Again, thank you!!
I had the same error as someone in Nov 2009
Warning: mysql_num_rows() expects parameter 1 to be resource, null given in C:\wamp\www\catalog\includes\functions\database.php on line 103
after checking the edits - this was due to my mistake when replacing the very first edit on product_info page. Just wanted to post in case someone else will have the same message, it will make for a quicker fix.
Again, thank you!!
#104
Posted 05 January 2011 - 10:56 AM
Hi Spooks,
Thank you for your great contribution, I've installed it properly and everything works great.
I was just wondering if I could integrate your contribution with Pikachoose (another jquery plugin, lightweight version of Galleria).
So, here is what I want to achieve:
- on product_info, i want to display a gallery that consists of one (1) main photo with 3 additional pictures listed horizontally under it.
- when i click one of the additional pictures, the main photo will change and display the new picture (so no prettyPhoto pop up action needed at this point) ---> this is what i need to solve
- prettyPhoto should be in action only when i click the main photo, displaying a much larger image in prettyPhoto style.
I know that I need to add in the API hook for the 3rd point , but thats really not a big issue here.
My big question is related to the 2nd point, how to have those additional pictures assigned to Pikachoose and not to prettyPhoto. Because at this moment, every additional image i upload in the Admin section is linked to prettyPhoto.
Maybe you can help me by pointing out which code is responsible for that and I will alter it accordingly. I know how to add/change code but still cannot determine which code is for what
And if someone else out there knows how, could you pls spare a minute and tell me where/what I need to examine? Thanks for your support
Thank you for your great contribution, I've installed it properly and everything works great.
I was just wondering if I could integrate your contribution with Pikachoose (another jquery plugin, lightweight version of Galleria).
So, here is what I want to achieve:
- on product_info, i want to display a gallery that consists of one (1) main photo with 3 additional pictures listed horizontally under it.
- when i click one of the additional pictures, the main photo will change and display the new picture (so no prettyPhoto pop up action needed at this point) ---> this is what i need to solve
- prettyPhoto should be in action only when i click the main photo, displaying a much larger image in prettyPhoto style.
I know that I need to add in the API hook for the 3rd point , but thats really not a big issue here.
My big question is related to the 2nd point, how to have those additional pictures assigned to Pikachoose and not to prettyPhoto. Because at this moment, every additional image i upload in the Admin section is linked to prettyPhoto.
Maybe you can help me by pointing out which code is responsible for that and I will alter it accordingly. I know how to add/change code but still cannot determine which code is for what
And if someone else out there knows how, could you pls spare a minute and tell me where/what I need to examine? Thanks for your support
#105
Posted 09 January 2011 - 10:34 PM
Hi,
I've tried to install this addon but once I've finished it, it does not give any errors, but once I click on a product it says no product found. Also in my admin the catalog does not show at all, just a blank page. Do you have any idea what could be wrong?
Thanks,
I've tried to install this addon but once I've finished it, it does not give any errors, but once I click on a product it says no product found. Also in my admin the catalog does not show at all, just a blank page. Do you have any idea what could be wrong?
Thanks,
#107
Posted 17 July 2011 - 11:33 AM
i cut and past this:
when i run this i get the following error like teh thirt post:
greetz Edwin
ALTER TABLE `products` ADD `products_image_array` blob;
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Tiny Image Width', 'TINY_IMAGE_WIDTH', '30', 'Image width for additional image thumbnail', 4, 20, NULL, now(), '', '');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Tiny Image Height', 'TINY_IMAGE_HEIGHT', '30', 'Image height for additional image thumbnail', 4, 21, NULL, now(), '', '');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Additional images per row/column', 'TINY_IMAGE_GROUP_SIZE', '3', 'Number of additional images to show per row/column in the product display', 4, 22, NULL, now(), '', '');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Additional Image Format', 'ADDITIONAL_IMAGE_FORMAT', 'horizontal', 'Show additional image in a vertical or horizontal format', 4, 23, NULL, now(), '', 'tep_cfg_select_option(array(\'horizontal\', \'vertical\'),');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Dim background on popup', 'DIM_BACKGROUND', 'false', 'Dim the background when popup images are shown. (enabled, this option can make the zoom action less smooth).', 4, 24, NULL, now(), '', 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Background luminosity', 'BKG_LUMA', '2', 'How much to dim background, if enabled. 1 = min, 9 = max.', 4, 25, NULL, now(), '', 'tep_cfg_select_option(array(\'1\', \'2\',\'3\',\'4\',\'5\',\'6\',\'7\',\'8\',\'9\'),');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Popup images dragable', 'DRAG_POPUP', 'false', 'Enable dragging of popup images.', 4, 26, NULL, now(), '', 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Popup \'swing\' effect', 'SWING_POPUP', 'true', 'Add a \'swing\' effect to the opening popup zoom.', 4, 27, NULL, now(), '', 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Show popup navigation', 'SHOW_NAV', 'false', 'Always show popup navigation icons, or hide till mouse over.', 4, 28, NULL, now(), '', 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`)
VALUES ('Popup navigation position', 'POS_NAV', 'middle', 'Position the popup navigation icons at the top, middle or bottom of images.', 4, 29, NULL, now(), '', 'tep_cfg_select_option(array(\'top\', \'middle\',\'bottom\'),');
when i run this i get the following error like teh thirt post:
SQL-query: ALTER TABLE `products` ADD `products_image_array` BLOB; MySQL retourneerde: #1060 - Duplicate column name 'products_image_array'what i am doing wrong?
greetz Edwin
#108
Posted 14 October 2011 - 06:15 PM
Olá, sou novo aqui sou do Brazil bom eu instalei esta contribuição Simple Multiple Images (Unlimited) with PrettyPhoto Popups V0.9
Ao entrar em admin Categorias / Produtos apareceu este erro
Warning: reset() [function.reset]: Passed variable is not an array or object in /home/sofil/public_html/loja/admin/categories.php on line 872
Warning: Variable passed to each() is not an array or object in /home/sofil/public_html/loja/admin/categories.php on line 873
Este é os códigos
// Simple multi image addon
LINHA 872 É ESTE $i=1;reset($products_image_array);
LINHA 873 É ESTE while (list($key, $value) = each($products_image_array))
{
echo tep_draw_hidden_field('products_image_' . $i, stripslashes($value));
++$i; }
// EOF Simple multi image addon
Poderia mim ajudar?
Ao entrar em admin Categorias / Produtos apareceu este erro
Warning: reset() [function.reset]: Passed variable is not an array or object in /home/sofil/public_html/loja/admin/categories.php on line 872
Warning: Variable passed to each() is not an array or object in /home/sofil/public_html/loja/admin/categories.php on line 873
Este é os códigos
// Simple multi image addon
LINHA 872 É ESTE $i=1;reset($products_image_array);
LINHA 873 É ESTE while (list($key, $value) = each($products_image_array))
{
echo tep_draw_hidden_field('products_image_' . $i, stripslashes($value));
++$i; }
// EOF Simple multi image addon
Poderia mim ajudar?
Edited by Nisinho Brazil, 14 October 2011 - 06:16 PM.
#110
Posted 17 October 2011 - 01:27 AM
Hey..
Great plugin, I love it. I had a few issues myself:
1 With the install instructions.
2 I Have custom template [img]http://forums.oscommerce.com//public/style_emoticons/default/pinch.gif[/img]
For people getting the error:
Warning: mysql_num_rows() expects parameter 1 to be resource, null given in \catalog\includes\functions\database.php on line 103
This is the very FIRST edit to product_info.php which has gone wrong due to: The 5TH EDIT:
This replaces the text in the FIRST edit with "// Simple multi image addon section moved"
The above edit is actually around line 101 .. Check the line numbers first.
Once i fit it into my template, Fantasic plugin!
Great plugin, I love it. I had a few issues myself:
1 With the install instructions.
2 I Have custom template [img]http://forums.oscommerce.com//public/style_emoticons/default/pinch.gif[/img]
For people getting the error:
Warning: mysql_num_rows() expects parameter 1 to be resource, null given in \catalog\includes\functions\database.php on line 103
This is the very FIRST edit to product_info.php which has gone wrong due to: The 5TH EDIT:
Find: (92)
$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_image_array, 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);
Replace with:
// Simple multi image addon section moved
This replaces the text in the FIRST edit with "// Simple multi image addon section moved"
The above edit is actually around line 101 .. Check the line numbers first.
Once i fit it into my template, Fantasic plugin!
