Trusten Posted November 7, 2002 Share Posted November 7, 2002 the download feature isn't working! i thought it was, but it was set to false, when i finally activated it, now, NO MATTER WHAT, no matter what status, it allows ALL downloads. what do I do?? Quote Link to comment Share on other sites More sharing options...
Trusten Posted November 7, 2002 Author Share Posted November 7, 2002 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* Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.