Jump to content


  • Content count

  • Joined

  • Last visited

  1. omenwebdesign

    Urgent Help Needed with ePDQ Payments

    Good work Joe, i haven't had time to look at it myself, let me know when you post it please. Tim
  2. omenwebdesign

    Urgent Help Needed with ePDQ Payments

    It would be great if you could do that, but I don't think order information is passed to ePDQ, just the total cost. And when ePDQ posts to complete.php it is in a new session. So the basket/order details don't exist to add into the database. I think that it is better to add the order into the database, and set the status to something like 'unprocessed', then update it if epdq says so. Then set up a cronjob to clear the old unprocessed orders from the DB every couple of days. does that make sense? Tim
  3. omenwebdesign

    Urgent Help Needed with ePDQ Payments

    As Chris said I am loking at this. I am finding that the system is a little weak on this area. It processes the paymen before any order details are stored permenantly in the system. This makes transactions really quite unsafe. Before the customer gets diverted in to the ePDQ page, osc needs to insert the data into the database, so that the 'epdq/complete.php' script can update it. Check out the paypal_IPN contrib, if you are in a rush and you need to get something working. It should point you in the right direction and give you some working code that you can alter. Hope this helps Tim
  4. omenwebdesign

    Urgent Help Needed with ePDQ Payments

    After searching the osCommerce documentation i found this link: http://www.oscommerce.info/kb/osCommerce/Common_Problems/208 Which means that it isn't going to work without a new module until MS3 (whenever that'll be). I'm going to try and use some of the PayPal_IPN contribution to create a new module that'll store the info before it gets redirected. hope this helps. Tim
  5. omenwebdesign

    Urgent Help Needed with ePDQ Payments

    Hi Guys, I've just worked out that I've got this problem too. The order should be added to the database before the user gets redirected to the ePDQ site. I am going to rewrite the module to make it work. it should be done by tomorrow afternoon. Stay tuned!! Cheers Tim
  6. oops, i meant this: if ($_SERVER['REQUEST_METHOD']="GET") { $VARS=$HTTP_GET_VARS; } else { $VARS=$HTTP_POST_VARS; } $product_id = $VARS['product_id']; it worked for me. Tim
  7. You probably have it running on an older vesion of PHP. I had this problem, and I changed the first few lines of stock.php from if ($_SERVER['REQUEST_METHOD']="GET"){ $VARS=$_GET; } else { $VARS=$_POST; } to if ($_SERVER['REQUEST_METHOD']="GET"){ $VARS=$HTTP_GET_VARS; } else { $VARS=$HTTP_POST_VARS; } Try this and see if it works. Tim
  8. omenwebdesign

    own quantity for every attribute-value

    You might want to look here... http://forums.oscommerce.com/index.php?showtopic=31484 Tim
  9. Hey Island man, I reckon thats what I'm going to have to do as well. How are you going to do it? Change the actual options or rewrite the QTPro code? Tim
  10. After a little more testing, it seems that it's going to be pretty hard to set multiple options up with multiple select boxes. If you use the hack that I provided above then the Stock output will be the stock quantity of the first option it comes to. ie. Say I have options colour and size, with 2 values in each option: 'Red' and 'Blue', and 'S' and 'L'. I set the option quantities to be Red S = 20 Red L = 40 Blue S = 30 Blue L = 10 If you have a different select box for each option, which quantity will the query return if you try and look up the quantity for 'S'? The first one is comes to, which may not be the correct value. I think the only way would be to have one select box that lists the combined options. what do you all think? Tim
  11. Hey all. been looking at the product_info.php page and I've worked out what the problem with multiple attributes is. //START get attribute stock values $attribute_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and products_stock_attributes = '" . (int)$products_options['options_id'] . "-" . (int)$products_options['options_values_id'] . "'"); ... This code would evaluate to SELECT products_stock_quantity FROM products_stock WHERE products_id = '28' AND products_stock_attributes = '1-3' But because of the way multiple options are put into the table the values in the column products_stock_attributes look like this: '1-3,2-6' So the select statement is never going to select anything. It'll return 0 results so you'll get an out of stock message. I think the query should be something like this: "SELECT products_stock_quantity FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' AND products_stock_attributes LIKE '%" . (int)$products_options['options_id'] . "-" . (int)$products_options['options_values_id'] . "%'" But I have a feeling this would give false stock counts. Anyone have any comment? Tim http://www.omenwebdesign.co.uk
  12. omenwebdesign

    A new contrib

    Hello, Does anybody know whether this contribution ever got anywhere? I'd love to use it if it's available. Cheers, Tim ====================== www.omenwebdesign.co.uk ======================