Jump to content

  2. → Viewing Profile: pafranklin

Corporate Sponsors


Latest News: (loading..)

pafranklin

Member Since 04 Oct 2005
Offline Last Active Jan 26 2012, 18:18
-----

Posts I've Made

In Topic: MySQL Script

26 January 2012, 09:23

Sorted, so in case it helps someone else the revised MySQL script looks as follows:

update products set products_availability_id = 5 where products_id in (select products_id from products_to_categories where categories_id = 22)

This will update the products in category 22 and set the product availability id to 5 for all of these.

In Topic: [Contribution] Ship In Cart

11 January 2012, 15:56

Hi there,

I haven't trawled every page in this thread but wanted to post an update for all of those who have experienced an error on the product page whereby anyone clicking on the "update cart" button gets an error of page cannot be dispayed and the url appears something like http://www.xyzdomain.com/_.

To correct this find:

<tr>
	<td>
<br>
<?php
	$cart->add_cart($product_info['products_id']); //add current to cart for estimator
if (CARTSHIP_ONOFF == 'Enabled') { require(DIR_WS_MODULES . 'product_shipping_estimator.php'); } else {};
	$cart->remove($product_info['products_id']);   //lets remove current product from cart
?>
	</td>
</tr>

and add </form> just before it so that the code looks something like:

</form>
<tr>
	<td>
<br>
<?php
	$cart->add_cart($product_info['products_id']); //add current to cart for estimator
if (CARTSHIP_ONOFF == 'Enabled') { require(DIR_WS_MODULES . 'product_shipping_estimator.php'); } else {};
	$cart->remove($product_info['products_id']);   //lets remove current product from cart
?>
	</td>
</tr>

I hope this helps someone - It worked for me and the module works well, so thanks to those for developing it.

Paul.

  1. osCommerce Support Forum
  2. → Viewing Profile: pafranklin
  3. Forum Rules