1036 replies to this topic

[DunWeb]

@Winston_C

As far as I know, there is no file size limit.  However, the SDS contribution does allow for group file downloads so multiple files can be downloaded with a single product purchase.


Chris

[Winston_C]

@DunWeb

Thanks for your repsonse. I'll add SDS and post back my results.

[Winston_C]

I installed the contrib. When I place an order for product with 1 file, it shows up double. Any idea why?

Also, notice the formatting is off.

Please advise!

Sorry for the foul language in my clip name!




 Untitled.png   17.22K   5 downloads

[DunWeb]

@Winston_C

I suggest checking the code edits to the checkout_success.php file to see if you duplicated the code.



Chris

[Winston_C]

I didnt modify that file, do you mean this file, checkout_process.php  ?

Thank you

DunWeb, on 15 May 2012 - 10:23 PM, said:

@Winston_C

I suggest checking the code edits to the checkout_success.php file to see if you duplicated the code.



Chris

[DunWeb]

@Winston_C

My apologies Mitch, I was thinking of a different contribution.

Does that product have two download attributes by chance ?  I can't think of any reason it would duplicate the download link.


Chris

[Winston_C]

Figured it out! Thank you so much!

DunWeb, on 15 May 2012 - 10:45 PM, said:

@Winston_C

My apologies Mitch, I was thinking of a different contribution.

Does that product have two download attributes by chance ?  I can't think of any reason it would duplicate the download link.


Chris

[vmjarala]

@winston, can you share?  I will try this contrib next, but the one I have tried today, the other super downloads, did the same thing...

[vmjarala]

I see there's a version of this contrib for v2.3. It didn't work for me. Has anyone tried this one on v2.3?

[steve-doherty]

I installed this, it's working great. But, now everything that was previously added set as 0 for Expiry Days now comes up as expiring the same day of purchase, instead of never expiring. Any idea about this?

Thanks,
Steve

[DunWeb]

@vmjarala

The v2.3.x contribution DOES work.  The 2.2 version of this contribution WILL NOT work on v2.3.x




Chris

[DunWeb]

@steve-doherty


This contribution does not allow for ZERO days to expiry.  Zero would indicate same day.  You will need to set an exact number of days for the file to expire, up to 999 I believe.



Chris

[steve-doherty]

Thanks DunWeb

[herbsandhelpers]

Hello!

I've just installed this on 2.3.3 and got the Tuesday December 1999 date problem it was rather easily resolved by applying the following from ConradAskLand:


OsCommerce 2.2 Download Mod – Problems with:

• Download Expires Tuesday December 1999″
  
  
• Download link not showing (not clickable linking – no link) after approval of payment.

I’m posting this here off the support forums because the search functions wouldn’t allow me to search and find this fix, I had to find it on Google. Assuming others are doing the same, here it is. Keyword help to find this: Osc MS2, Super Download Mod, error, problem, downloads expiry, no link not showing unable to download.
Within download.php in modules I changed the following:

$downloads_query = tep_db_query(“select o.orders_status, date_format(o.last_modified, ‘%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 o.customers_id = ‘” . (int)$customer_id . “‘ and o.orders_status >= ‘” . DOWNLOADS_CONTROLLER_ORDERS_STATUS . “‘ and o.orders_id = ‘” . (int)$last_order . “‘ and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ””);

$downloads_query = tep_db_query(“select o.orders_status, date_format(o.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 o.customers_id = ‘” . (int)$customer_id . “‘ and o.orders_status >= ‘” . DOWNLOADS_CONTROLLER_ORDERS_STATUS . “‘ and o.orders_id = ‘” . (int)$last_order . “‘ and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ””);

Its actually a very small change: Within the quiry I changed “o.last_modified” to “o.date_purchased”.

Edited by herbsandhelpers, 24 March 2013 - 11:55 PM.

[herbsandhelpers]

If it's not too clear then all you need to do is modify BOTH download.php files changing o.last_modified to o.date_purchased in the line:

$downloads_query = tep_db_query(“select o.orders_status, date_format(o.last_modified, ‘%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 o.customers_id = ‘” . (int)$customer_id . “‘ and o.orders_status >= ‘” . DOWNLOADS_CONTROLLER_ORDERS_STATUS . “‘ and o.orders_id = ‘” . (int)$last_order . “‘ and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ””);

to

$downloads_query = tep_db_query(“select o.orders_status, date_format(o.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 o.customers_id = ‘” . (int)$customer_id . “‘ and o.orders_status >= ‘” . DOWNLOADS_CONTROLLER_ORDERS_STATUS . “‘ and o.orders_id = ‘” . (int)$last_order . “‘ and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ””);

Yep! that's it!

Lorraine

Edited by herbsandhelpers, 25 March 2013 - 12:07 AM.

[herbsandhelpers]

[/background][/size][/font][/color]
[color=#151515][font=Verdana, Georgia, 'Times New Roman', Times, serif][size=3][background=rgb(248, 248, 236)]$downloads_query = tep_db_query(“select o.orders_status, date_format(o.last_modified, ‘%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 o.customers_id = ‘” . (int)$customer_id . “‘ and o.orders_status >= ‘” . DOWNLOADS_CONTROLLER_ORDERS_STATUS . “‘ and o.orders_id = ‘” . (int)$last_order . “‘ and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ””);[/background][/size][/font][/color]

[color=#151515][font=Verdana, Georgia, 'Times New Roman', Times, serif][size=3][background=rgb(248, 248, 236)]$downloads_query = tep_db_query(“select o.orders_status, date_format(o.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 o.customers_id = ‘” . (int)$customer_id . “‘ and o.orders_status >= ‘” . DOWNLOADS_CONTROLLER_ORDERS_STATUS . “‘ and o.orders_id = ‘” . (int)$last_order . “‘ and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ””);

[herbsandhelpers]

[/background][/size][/font][/color]
[color=#151515][font=Verdana, Georgia, 'Times New Roman', Times, serif][size=3][background=rgb(248, 248, 236)]$downloads_query = tep_db_query(“select o.orders_status, date_format(o.last_modified, ‘%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 o.customers_id = ‘” . (int)$customer_id . “‘ and o.orders_status >= ‘” . DOWNLOADS_CONTROLLER_ORDERS_STATUS . “‘ and o.orders_id = ‘” . (int)$last_order . “‘ and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ””);[/background][/size][/font][/color]

[color=#151515][font=Verdana, Georgia, 'Times New Roman', Times, serif][size=3][background=rgb(248, 248, 236)]$downloads_query = tep_db_query(“select o.orders_status, date_format(o.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 o.customers_id = ‘” . (int)$customer_id . “‘ and o.orders_status >= ‘” . DOWNLOADS_CONTROLLER_ORDERS_STATUS . “‘ and o.orders_id = ‘” . (int)$last_order . “‘ and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != ””);