OsCommerce 2.2 Download Mod – Problems with:<\/p>\n
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.<\/p>\n
Within download.php in modules I changed the following:<\/p>\n
FROM:<\/p>\n
$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 != ””);<\/p>\n
TO:<\/p>\n
$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 != ””);<\/p>\n
Its actually a very small change: Within the quiry I changed “o.last_modified” to “o.date_purchased”.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[6],"tags":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3C0LX-wL","_links":{"self":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts\/2031"}],"collection":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/comments?post=2031"}],"version-history":[{"count":0,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts\/2031\/revisions"}],"wp:attachment":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/media?parent=2031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/categories?post=2031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/tags?post=2031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}