Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

PayPal IPN (SCREAMS) the downloads don'twork no matter what!


Trusten

Recommended Posts

ok

 

see, if it's not under paypal processing, it'll keep the download from happening, but what if someone with a CC purchased? or someone with a money order, SOOOO

 

i decided to go look at my good buddy Download Controller.

 

I noticed that the maker used the same method ossy did, so, i changed the code a LITTLE and now, if anything is pending, it will NOT be download able. if they use the paypal IPN and they complete checkout, then it will make the download available.

 

however, if they did things the old fashion way, no download will show up for them.

 

here ya go

 

// Now get all downloadable products in that order

 $downloads_query_raw = "SELECT DATE_FORMAT(date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays

                         FROM " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd

                         WHERE customers_id = '" . $customer_id . "'

                         AND o.orders_status >= '2'

                         AND o.orders_status != 99999

                         AND o.orders_id = '" . $last_order . "'

                         AND op.orders_id = '" . $last_order . "'

                         AND opd.orders_products_id=op.orders_products_id

                         AND opd.orders_products_filename<>''";

 

see, i just added

 

[code AND o.orders_status >= '2'

[/code]

 

that's all. and it did the trick. now, if only someone could make a module that will allow free downloads to be available right away.

 

*sigh*

 

anyone?? *looks around*

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...