geomilli

As with everything here, example and explanation isn't clear enough to get the results we need... so here is my attempt at clarifying what is needed to be done to update the shipping arrays in usps.php. In the contribution for USPS Methods 6.1, you should have a PHP page installed that retrieves an updated array from the USPS server. Type into the address bar "your host... /catalog/admin/USPS_methods_utility.php" The page will display the array that ...catalog/includes/modules/shipping/usps.php needs to be updated with. Below is just a snippet of the results you should see, do not use it. Run the USPS_methods_utility.php yourself, because most likely this array is likely to change. Open usps.php and replace the code completely with the updated array from the request. Uninstall USPS from your admin panel and then reinstall it. Unfortunately, you will have to redo all of your settings... but it should be accurate and complete.

As with everything here, example and explanation isn't clear enough to get the results we need... so here is my attempt at clarifying what is needed to be done to update the shipping arrays in usps.php. In the contribution for USPS Methods 6.1, you should have a PHP page installed that retrieves an updated array from the USPS server. Type into the address bar "your host... /catalog/admin/USPS_methods_utility.php" The page will display the array that ...catalog/includes/modules/shipping/usps.php needs to be updated with. Below is just a snippet of the results you should see, do not use it. Run the USPS_methods_utility.php yourself, because most likely this array is likely to change. Open usps.php and replace the code completely with the updated array from the request. Uninstall USPS from your admin panel and then reinstall it. Unfortunately, you will have to redo all of your settings... but it should be accurate and complete.

OK, maybe Jetta can help here... I use Uniform Server to beta test my site before going live. I used http://addons.oscommerce.com/info/8403 to update the USPS functions and the above occurred in my last post. So, I figured I would go with a live swap out of the files and test it from there (what the heck!)... It works. Don't know why, other than that's a good thing. My provider actually has a older version of PHP running than my version in Uniform Server and MySQL is only a fraction of a version out from each other. I don't see that being the issue. Just thought I would post this little tip to help those that might be trying to resolve their install.

Here's the debate... Use http://addons.oscommerce.com/info/8327 or http://addons.oscommerce.com/info/8403? I personally tried 8403 to the letter and all I get a blank page for checkout_shipping... However, the weight of the product displays when I moved up into the other upgrades. Curious... The min/max/handing dialog goes wacky, perhaps a database issue? I check one of the shipping methods and return to check it, and all I get is a minimum "Parcel Post" and the 70lbs. max jumps to the handling. Any ideas?

In my post #5878, I have come up with a better explanation... If you link a product from one category to another, the product_id is identical. When you view products_new.php it will show the duplicated id's IE products from both categories because of this link. I don't want that. >_< This problem is also in featured_products.php, assuming an identical result. To prove that the code in my quote was not an issue, I started with a fresh install of osC and added SPPC and HP&C. The scenario is the same on product_new.php. I made a new category called "Our Favorites" and then linked the product Unreal Tournament to it. The product then appears in two places when product_new.php is displayed. Any ideas or fixes that I am not aware of? I have read through most of this forum and searched crazily, to no avail. However, I haven't stopped yet. :blink:

Anyone using "Category Box Enhancement", version 1.1? Well, if you are then use the code snippet below to make it work with Hide Categories & Products. Just replace the code from the instructions for catalog/includes/boxes/categories.php. Line 14 // BOF SPPC hide categories from groups for "Category Box Enhancement", version 1.1 global $tree, $categories_string, $cPath_array, $customer_group_id, $languages_id; // EOF SPPC hide categories from groups Line 74 // BOF SPPC hide categories from groups for "Category Box Enhancement", version 1.1 $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = " . (int)$parent_id . $catstatus . " and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by sort_order, cd.categories_name"); // EOF SPPC hide categories from groups FYI - This is for an install on RC2a.

OOPS! Simple mistake on my end... made a configuration error on the admin side. Best Sellers was set to 5 as a minimum by mistake. However, to get it to work I had to purge my beta orders and customers to reset the system. I suppose from messing around with different groups and orders from those various settings the database was a bit confused. Delete orders and customers either by client or admin software, then you should be good again. I still have a problem with products in two categories or two specials for two groups displaying in various areas. If you have or had a similar problem let me know!

Yes, it works with: Credit Class & Gift Voucher - http://www.oscommerce.com/community/contributions,282 or http://addons.oscommerce.com/info/8002 and if your interested... POINTS AND REWARDS MODULE V1.00 - http://www.oscommerce.com/community/contributions,3220

Best Sellers Missing - Gone - Disappeared (for search reasons, because I can't find anything close in the forums) Has anyone experienced the disappearance of the Best Sellers box after installing SPPC and HP&C? Specials still active with conflicting settings (should this work or just deal with it?) Anyone get it working with Specials as well? There is a little problem with mine if you disable the entire category for retail customers and have specials from that category in a retail group the products from that category still show. Is that normal? Also, if you link to two categories for one product the products_new.php displays two of that same product on the page. My code is modified to be in columns, integrated for Ezier New Fields, SPPC and HP&C, Wishlist and a database name "products_namebreak" that I have created for display formatting so it's funky. I can post the code if anyone is interested, but I know it's not products_new.php, because I replaced it with the unaltered version from the install with the same results. I assume the problem is from somewhere else maybe? The call is from another page handed off to this one? Any insight would be great and if you know the post with the answer, thanks ahead of time!

Ezier New Fields (ENF) and Separate Price Per Customer (SPPC) - product_listing_col.php Todd from post 263 had supplied some good information about installing ENF and SPPC together, however the problem I was experiencing with ENF after installing SPPC was exactly what was described by Todd. The symptoms are ENF works on the advanced_search_result.php but not on pages generated from the index.php. If that's the case then you missed something (like I did). I am a relative noob at PHP and if you are too, here is how the pages lead to each other. Once I realized that, it took me 2 minutes to fix the index.php and correct the display using product_listing_col.php. Product Listing - index.php hands off to product_listing_col.php Perform a Search - advanced_search_results.php hands off to product_listing_col.php advanced_search_result.php calls all the variables again and works if the index page does not. That is because you forgot to add the p.products_retail_price of ENF back into the index.php. Every line in the code below calls tmp_pp.products_price and needs p.products_retail_price added after it. EX: tmp_pp.products_price, p.products_retail_price, // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category // BOF Separate Pricing Per Customer if ($status_product_prices_table == true) { // ok in mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_retail_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd , " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else { // either retail or no need to get correct special prices -- changed for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_retail_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } // end else { // either retail... // EOF Separate Pricing Per Customer } else { // We show them all // BOF Separate Pricing Per Customer if ($status_product_prices_table == true) { // ok in mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_retail_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } else { // either retail or no need to get correct special prices -- changed for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_retail_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } // end else { // either retail... // EOF Separate Pricing Per Customer } } else { // show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory; // BOF Separate Pricing Per Customer if ($status_product_prices_table == true) { // ok for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_retail_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // either retail or no need to get correct special prices -- ok in mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_retail_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s using(products_id) where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } // end else { // either retail... // EOF Separate Pricing Per Customer } else { // We show them all // BOF Separate Pricing Per Customer --last query changed for mysql 5 compatibility if ($status_product_prices_table == true) { // original, no need to change for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_retail_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // either retail or no need to get correct special prices -- changed for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_retail_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } // end else { // either retail... // EOF Separate Pricing per Customer } } Hope that helps! I have clearly defined the issue above so future NOOBS can Google this sucker and know how simple the problem is. (w00t)

Are you using the right version of "customer_group_discounts.php"? I made the mistake of using the one in the folder "SPPC Using Quantity Discount Contribution." This resulted in the 1054 - Unknown column 'p.products_price1' in 'field list'. It made sense to me that I wanted to USE the Quantity Discount Contribution, so I went for the "SPPC Using Quantity Discount Contribution" version. However, if you started from scratch use "SPPC Without Quantity Discount Contribution." I just finished installing SPPC and then added this with no problem. Honestly, I don't know why there are two of them.

To add to this little nugget... The sub-categories are included in the catalog on the storefront by just inserting the root category id, but it will not show in the admin. If you want to have full control you have to include the id from the root categories to the sub-categories. A little flaw in the program, but survivable. Example: 63, 62, 61, 71, 104, 63, 62, 61, is the root of the catalog and 71, 104, are the sub-categories. All of these are now editible in the admin control. If I add more sub-categories to the catalog, I will need to add the number to the string for admin access. Hope that explains the issue better.

I've been looking at code to long and not looking for the obvious. Tony is right... and I will clarify for anyone as dumb as me. Once I had uploaded my catalog, put in multiple categories and started shuffling my sub-categories around, it then "didn't work." Well, it was. Tony just didn't say it was adjusted to work in the Admin Panel and I went and looked at the hard solution. IN THE ADMIN CONTROLS for Product Extra Fields, under the Category field where you put the category the extra field will be related to, enter in ALL. I would do this first (something to add to the contribution) to ensure it works through all of the site, then tweak it to the right parameters as I did. This is a clear case of OT (operator trouble) and not reading the signs here by Tony. Thanks, Dude!

Tony or Whomever may read this, I am wondering the same issue described above, anything not in the first category of the admin product listing will not show Product Extra Fields. I assume it's not reaching for the right category_id or something. I'm no expert and like everyone here we are getting better at it, but a clearer example would be nice. Tony explains to put a comma event if you write one category or write all, well "all" is in there as: OR category_id='all' The rest of the code responsible for the displaying of the fields is here: // BOF Extra Fields Contribution (chapter 1.4) // Sort language by ID for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $languages_array[$languages[$i]['id']]=$languages[$i]; } //relevant fields bof $extra_fields_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " pef WHERE category_id like '% " . $current_category_id . ",%' OR category_id=" . $current_category_id . " OR category_id='all' OR pef.category_id=(SELECT c.parent_id FROM " . TABLE_CATEGORIES . " as c WHERE c.categories_id = " . $current_category_id . ") ORDER BY products_extra_fields_order"); //relevant fields eof while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { // Display language icon or blank space if ($extra_fields['languages_id']==0) { $m=tep_draw_separator('pixel_trans.gif', '24', '15'); } else $m= tep_image(DIR_WS_CATALOG_LANGUAGES . $languages_array[$extra_fields['languages_id']]['directory'] . '/images/' . $languages_array[$extra_fields['languages_id']]['image'], $languages_array[$extra_fields['languages_id']]['name']); ?> <tr bgcolor="#F0F1F1"> <td class="main"><?php echo $extra_fields['products_extra_fields_name']; ?>:</td> <td class="main"><?php echo $m . ' ' . tep_draw_input_field("extra_field[".$extra_fields['products_extra_fields_id']."]", $pInfo->extra_field[$extra_fields['products_extra_fields_id']]); ?></td> </tr> <?php } // EOF Extra Fields Contribution Any ideas on where to pop this comma or something in? If I find it, I will let you know. Thanks!

Here's an addition to be Inserted into your SQL: 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 ('Fancybox Title Position', 'FBTITLE_POSITION', 'outside', 'The position of title. Can be set to Outside, Inside or Over.', 4, 32, NULL, now(), '', 'tep_cfg_select_option(array(\'outside\', \'inside\', \'over\'),'); And in the script settings replace: 'titlePosition' : 'outside', with 'titlePosition' : '<?php echo (FBTITLE_POSITION); ?>', That will now give you control on where the text will be displayed. :thumbsup:

Makeholer, You posted a while ago, but I had the same problem with this contribution and IE9. You can fix your problem instantly by taking out the meta tag, this I believe is what is blocking the image from view. Emulate IE7? A little late, so let's move forward! <!-- Simple multi image addon <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" /> EOF Simple multi image addon --> An IE 9 conditional fix: <!--[if IE]> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <![endif]--> <!--[if !IE]> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <!--<![endif]--> The "if" statement will use the strict rules for IE rather than loose, however that may not solve all your problems it could just create more. I was having a problem with spacing and the images for Simple Multi Image Add-on were not going from one to the other when multiples needed to be displayed. This hack works but there can be formatting issues all over the place and transitional changes from one browser to another bad enough. Keeping it "loose" on everything levels the playing field and sets a constant for all browsers. Remove all that and let's try it again or if you haven't done anything forget about it and do this: Update the Javascript itself. I went to http://fancybox.googlecode.com/files/jquery.fancybox-1.3.4.zip and got the latest js from them. I added the new items into my osCommerce folders (see code below) and had made some modifications to the script settings. <script type="text/javascript" src="<?php echo DIR_WS_IMAGES ?>/fancybox/jquery-1.4.3.min.js"></script> <script type="text/javascript" src="<?php echo DIR_WS_IMAGES ?>/fancybox/jquery.fancybox-1.3.4.pack.js"></script> <script type="text/javascript" src="<?php echo DIR_WS_IMAGES ?>/fancybox/jquery.fancybox-1.3.4.js"></script> <script type="text/javascript" src="<?php echo DIR_WS_IMAGES ?>/fancybox/jquery.mousewheel-3.0.4.pack.js"></script> <script type="text/javascript" src="<?php echo DIR_WS_IMAGES ?>/fancybox/jquery.easing-1.3.pack.js"></script> <link rel="stylesheet" href="<?php echo DIR_WS_IMAGES ?>/fancybox/jquery.fancybox-1.3.4.css" type="text/css" media="screen"> <script type="text/javascript"> $.noConflict(); jQuery(document).ready(function($) { // Code that uses jQuery's $ can follow here. $(document).ready(function() { $("div#fancy a").fancybox({ 'transitionIn' : '<?php echo (FBEFFECT); ?>', 'transitionOut' : '<?php echo (FBEFFECT); ?>', 'easingIn' : '<?php echo (FBSWING1); ?>', 'easingOut' : '<?php echo (FBSWING2); ?>', 'speedIn' : 600, 'speedOut' : 400, 'overlayShow': <?php echo (DIM_BACKGROUND); ?>, 'overlayOpacity' : <?php echo (BKG_LUMA/10); ?>, //Opacity of the overlay (from 0 to 1; default - 0.3) 'overlayColor': '#666', //Color of the overlay 'titleShow': true, 'titlePosition' : 'outside', 'changeSpeed': 300, 'changeFade': 'fast', 'autoScale' : true, 'autoDimensions': true, 'centerOnScroll': true, 'hideOnContentClick' : true, 'hideOnOverlayClick' : true, 'zoomOpacity': true, 'opacity': true, 'cyclic': true, 'padding': <?php echo (FBPADDING); ?>, 'margin': 0 }); }); }); // Code that uses other library's $ can follow here. </script> Now, I put the script and images in my osCommerce images directory under "fancybox." You might want to put it somewhere else, but I like things labeled accordingly. (w00t) OK, since the upgrade I could not get certian functions to work in the original contribution. Add the contribution as the instructions are given, only add these to your database using PHPmyAdmin below. 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 ('Fancybox 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 ('Fancybox 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 ('Fancybox Effect', 'FBEFFECT', 'elastic', 'The transition type. Can be set to Elastic, Fade or None.', 4, 26, NULL, now(), '', 'tep_cfg_select_option(array(\'elastic\', \'fade\',\'none\'),'); 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 ('Fancybox Padding', 'FBPADDING', '10', 'Space between FancyBox wrapper and content.', 4, 27, 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 ('Fancybox Swing In', 'FBSWING1', 'swing', 'Easing used for elastic animations or bouncing effect when image comes in. The Swing option is direct to the screen.', 4, 28, NULL, now(), '', 'tep_cfg_select_option(array(\'swing\', \'easeOutBack\'),'); 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 ('Fancybox Swing Out', 'FBSWING2', 'swing', 'Easing used for elastic animations or bouncing effect when image goes out. The Swing option is direct to the screen.', 4, 29, NULL, now(), '', 'tep_cfg_select_option(array(\'swing\', \'easeInBack\'),'); That will give you everything and more. I wanted to be able to adjust certian parameters via the admin and fixed some that were not up to speed after the update. WIth luck your admin -> config -> images should have the options shown in my attached images. :thumbsup: With any luck I will have this site up and running for you to try it out: http://comicunderground.net/catalog

Just to add to what this contribution is doing, I wanted the search function to list just like the product listing. To do that open "product_listing.php" and look for this: $listing_sql = $select_str . $from_str . $where_str . $order_str; require(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?> Replace with this: $listing_sql = $select_str . $from_str . $where_str . $order_str; if (PRODUCT_LIST_STYLE == 'List') { include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); } elseif (PRODUCT_LIST_STYLE == 'Columns') { include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING_COL); } ?> Now the search results will use the same listing style as the rest of the site.

K, I've done this twice so far, first time was almost 2 years ago when I started to look into shopping cart software. Tonight is the second time and I was a little confused at first. So here are a few questions to clearify what we are attempting. 1. What version on the contribution page is the right starting point? I am using the most recent date of "Wishlist 2.1 (built from wishslit 2.0 with spanish support and more) pparrilla 5 Jan 2007". If you open that version it will have the install instruction in html that states, "Guest Enchanced Wishlist 3.5 for osCommerce-ms2". Go figure. The label says 2.1, but the instructions say "3.5"? Somebody is mislabeling this? Anyway, let me know what you have used for reference. 2. My order of installation. I usually start a text file and keep track of the names of the contribs and the order of implementation. As it turns out, I managed to create the SQL error, then had the same error you are getting. Here is that order: Base install wishlist2.1.zip - Wishlist 2.1 (built from wishslit 2.0 with spanish support and more) pparrilla 5 Jan 2007 wishlist.php.zip - Wishlist Update dannyb 91979 6 Dec 2007 (replace for e-mail) SQL Error fixed with wishlist 3.5 mysql 5 FIX - FIX for people using Wishlist 3.5x with MySQL 5.x phorbidden 16 Apr 2007 Corrected catalog/includes/modules/product_listing.php with FIX_product_list - FIX problem with product list witalis 8 Mar 2008 Added FIX_1054_problem to boxes/wishlist.php and catalog/wishlist.php - FIX 1054 witalis 8 Mar 2008 Added 1054 to wishlist_public - FIX 1054 in wishlist_pubilc.php witalis 19 Mar 2008 All said and done I have it working. Is it right? Not so sure, but I am looking into it further. I will eventually have my prototype site up soon, so I will post it here when it is ready for you to review if you would like. Thanks and let me know if that helps. George

Oddly enough, I downloaded a sample template ( http://www.theoscommercestore.com/osCommer.../sample_osc.zip ) and loaded on my server to demo. The demo has UPS available in its admin/catalog (and it worked). Now not sure what version is may be using, so I just extracted the UPS shipping modules out (ALL UPS.php files) and plugged it into my running/up to date version of osCommerce. And it worked! Now understand that I already edited the othe files for UPS Choice 1.8 Tested it with several addresses and got decent results. Prices are skewed by $2 or so. Not sure if thats because of its access level with UPS (retail vs. wholesale/corporate pricing). See I have an account with UPS, by logging in I can get direct pricing with them. If I were Joe Blow from off the street, I would pay more than the guy with a UPS account (wholesale/discounted price). So, as far I knew, XML was the way to go. But on a hunch I tried the latter. Now, if I were to use this function the way it is, I would edit the shipping label to state it is "estimated". I found a add-on that will allow you to edit an invoice. If you were to correct the price of shipping to reflect a lower price, then there ya go. Note that it is illegal to change an invoice and charge MORE than what was agreed to at time of purchase. However, it isn't if you want to adjust an invoice for LESS (who doesn't want to pay less?). You can also just leave it at a "retail" shipping cost and figure the $2 or so dollars are for "handling." Handling is also a plug-in variable in admin, with a percentage or flat fee figure. So long story short, the regular UPS module from the demo works, question how long? I swear that I read XML was the base UPS has chosen to use from now on. For now this works, so be it. I'll figure the XML anyway, if only to have more options/accuracy. If you are intrested, try it out: http://www.bitoftackct.com/catalog/ It is completely functional, but is only a demo so make a dummy order if you like and see the UPS mod. I also added other features to it, like Customer Pick-up and a Address link for that choice. Have fun, and I'll keep posting my progress! George

Apparently I answered my own question. UPS only supports XML requests to its site and requires an account now for quotes. This was information provided through the forum contributors. I haven't gotten the XML to work just yet, but I am on my way. All the implementations are there, only the account isn't entered yet. If previous UPS modules like "UPS Choice" are no longer usable, why are they offered? Well, I guess from a development standpoint it helps to have it there for use. UPSXML was created from the UPS Choice code. I will update this forum, with my results. Wish me LUCK!

This maybe a dumb question, but after the installation of osCommerce there appears to be no UPS selection avaliable in the Shipping admin. Am I lost? The guidebook and online tutorial state it being there right in front. Appreciate some help with this. Thanks.