Jump to content

shazzed

Members
  • Content count

    1
  • Joined

  • Last visited

Profile Information

  • Real Name
    Shannon
  1. shazzed

    OsCommerce Download Feature

    Great guide. Does anyone know why the download is accessible on pending status and not delivered!? Seems stupid especially if you are using a manual CC entry system. Credit Cards that are bogous or the fake test number could allow people to steal your download without payment. If anyone has a work around that works so you can change the Status that the link is active for download that would be super. Have tried replacing this code in the dowload.php from >>HERE<< CODE USED: // Check that order_id, customer_id and filename match $downloads_query = tep_db_query("select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, opd.download_count, opd.download_maxdays, opd.orders_products_filename from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . $customer_id . "' and o.orders_id = '" . (int)$HTTP_GET_VARS['order'] . "' and o.order_status = '3' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '" . (int)$HTTP_GET_VARS['id'] . "' and opd.orders_products_filename != ''"); ERROR: 1054 - Unknown column 'o.order_status' in 'where clause' select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, opd.download_count, opd.download_maxdays, opd.orders_products_filename from orders o, orders_products op, orders_products_download opd where o.customers_id = '2' and o.orders_id = '3' and o.order_status = '3' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '3' and opd.orders_products_filename != '' [TEP STOP]
×