[zardos]

Hi Jon

Jon wrote

I'm evaluating the code for ezRecommends and will be fixing some issues with gift certificates and with the points mod shortly.

I wrote

Have you sorted this yet jon, when i'am taken back to ezrecommends when using gift certificate i need to have a message to let people know they are using a secondary payment method. I have tried this fix below but now message. 

I found all the "mode=checkout" in cart.php and changed them to "mode=checkout&ezrecommends=Y"

I could not find this

func_header_location($current_location.DIR_CUSTOMER."/cart.php?mode=checkout&paymentid=".@$paymentid);

in /payment/payment_giftcert.php but did find this

#
# Not enough money
#
        func_header_location($current_location.DIR_CUSTOMER."/cart.php?mode=checkout");
    }

and then i added this to it

#
# Not enough money
#
        func_header_location($current_location.DIR_CUSTOMER."/cart.php?mode=checkout&ezrecommends=Y&giftcertapplied=Y");
    }

I now get a message the message that i entered in

txt_giftcertapplied - Your gift certificate has been applied. Please select a secondary payment method to complete your order.

and it is working so far

But i still recieve this error when i purchase a gift certificate

[12-Apr-2005 16:59:33] SQL error: /megapcs/cart.php
SELECT DISTINCT productid2 as productid FROM xcart_product_links where ()) AND (productid2!='64' AND productid2!='70') ORDER BY RAND() LIMIT 4
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 ')) AND (productid2!='64' AND productid2!='70') ORDER BY RAND() 
Backtrace:
/home/xxxxx/public_html/megapcs/include/func.php:120
/home/xxxxx/public_html/megapcs/include/func.php:80
/home/xxxxx/public_html/megapcs/include/func.php:164
/home/xxxxx/public_html/megapcs/modules/ezRecommends/ezrecommends.php(20) : eval()'d code(1) : eval()'d code(1) : eval()'d code:72
/home/xxxxx/public_html/megapcs/modules/ezRecommends/ezrecommends.php(20) : eval()'d code(1) : eval()'d code:1
/home/xxxxx/public_html/megapcs/modules/ezRecommends/ezrecommends.php(20) : eval()'d code:1
/home/xxxxx/public_html/megapcs/modules/ezRecommends/ezrecommends.php:20
/home/xxxxx/public_html/megapcs/cart.php:731

Cart.php :731 points to this:

#
elseif($mode=="checkout" && !func_is_cart_empty($cart)) {
      include $xcart_dir."/modules/ezRecommends/ezrecommends.php";
      $smarty->assign("main","ezrecommends");
}
#
# End Upselling Module
#

What are the settings to be changed to Jon if the settings are causing the problem.

This setting seems to be OK.

$upsell_limit = "3";

This one does not,

$upsell_omit = array('');

Any idears??? Jon

Thanks again