Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

craftables

Archived
  • Posts

    19
  • Joined

  • Last visited

Profile Information

craftables's Achievements

  1. Just as an update: I caught sight of this happening again. I checked out the ip of the pc accessing this file and it was reported back to be of a paypal domain - so I assume that this is simply a part of the paypal ipn process. However this time I didnt get an error email sent to me and so the email error I got last time still confuses me. :huh:
  2. It was noticed today that someone browsing the shop had directly accessed the following file: / ext / modules / payment / paypal_ipn / ipn.php :'( And soon after I recieved an email from our shop with the subject PayPal Ipn Invalid Process. The email contacted: $_POST: $_GET: After checking my paypal account there seems to be nothing unusual but is this something I should be worried about ? And if so is there any steps I can take like password protecting directories etc ? Thanks in advance for any advice Steven
  3. Did you find that your order status no long updated after the order payement was made Mike ? We found that we suffered from the above problems of invoice 'already paid' and so I have gone through the steps outlined above. Unfortunatly this paypal error seems to be random and all our own live payement tests always work for us, but we have had comments from a customer of the error and wish to solve it happeneing to other customers in the future. :'( Anyway, The code changes above have been made and I can only hope its fixed the problem as I cant test it - however after making these changes our shop no longer updates a cart from Paypal Preparing to Pending (I am assuming the new invoice number code isnt linking to a database record or something but this is all above my head.) Can anyone point this newbie in the right direction on how to address this ? :-" Thanks for any help in advance. Steven
  4. Righto, After a few other issues where my admin seemed to be getting ignored I disabled the Configuration Cache contribution and this and other contrubutions fired up. There seems to be a problem with either my web space allowing the cache file to be updated or general weirdness with the contribution. But anyway, All sorted! :thumbsup:
  5. Hi all, I hope you can help me and I hope even more that this hasnt already be discussed - Ive looked, but I cant even find my own messages here sometimes :blush: , Anyways. Take it easy on me, this is my first shop and much of what I am doing is new to me. This great contribution looks ideal for my shop and it appeared to install like a charm (v1.60) - no errors etc (Although I was initially confused by the installer, but I took a guess and hit jackpot) I configured the points system in admin as below: Enable Points System: TRUE Enable Redeptions system: TRUE Points per ?1.00 purchase: 1 The value of 1 point when redeemed: 0.1 Autocredit points: FALSE Award points for shipping: FALSE Award points for tax: FALSE Award points for specials: TRUE Award points for order with redeemed points: TRUE Enable points restriction: FALSE Enable products price restriction: FALSE Limit points before redemption: 250 Limit points to be used per order: 1000 Limit points redemption to exact amount: FALSE Restrict points redemption for minimum purchase amount: 25 New signup customers welcome points: 50 The points system seems to total up fine as I buy products etc but the point limits are being ignored at the checkout. Currently I have made an order totalling ?6.60 (less than the ?25 limit) and my stored points are 9.7 (less then the 250 limit) but the option to use my points is still being displayed in the checkout_payment page. I tried changing the ?25 limit from 25 to 25.00 to 2500 with no change. I have checked over the code and everything is inserted as the installation text as far as I can see. I have double checked the checkout_payments.php and everything is good there. I have few contributions installed like xsell & paypal_ipn etc, but the primary addition that I think has the potential to be causing a problem is: Configuration Cache v1.30 Can anyone point me in the right direction as to where I should look (not thats I will know what I am looking for) to solve this problem ? Thanks in advance for your patients and help, Steven :blink:
  6. Hi all, can anyone help me with my problem when trying to install the Enable/Disable Catagories contribution. I havent totally grasped PHP and mySql but I am getting quite good at hacking the code around according to the contribution instructions - but this contribution has stopped me in my tracks. The problem is with the calalog/includes/module/xsell_products.php changes where the contribution help file indicates the following changes to the query line (With existing line commented out): // ################" Added Enable / Disable Catgories ################### // $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by xp.products_id asc limit " . MAX_DISPLAY_ALSO_PURCHASED); $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where c.categories_status='1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by xp.products_id asc limit " . MAX_DISPLAY_ALSO_PURCHASED); // ################" End Added Enable / Disable Catgories ################### However when opening my file to edit, my query line does not reflect the indicated line to change... Infact my line is two query lines within an if statement and so I am not entirly sure how to correct my existing code to use the new enable/disable catagory code. I assume I need 2 variations of the new code for each IF result - although not knowing what the if statement is comparing and not understanding the queries I am stuck. Below is my existing code: if ($HTTP_GET_VARS['products_id']) { if ($customer_group_id != '0') { $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, IF(pg.customers_group_price IS NOT NULL, pg.customers_group_price, p.products_price) as products_price from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_GROUPS . " pg using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' and pg.customers_group_id = '".$customer_group_id."' order by sort_order asc limit " . MAX_DISPLAY_ALSO_PURCHASED); } else { $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by sort_order asc limit " . MAX_DISPLAY_ALSO_PURCHASED); } Can anyone help me with the correct queries ? I assume this is quite important to ensure that products dont appear in the X-sell listings when they are technically unavailable due to its catagory being disabled. Thanks in advance for any help you guys can offer.
×
×
  • Create New...