Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  1. fixion

    NEW! Complete Order Editing Tool!

    ot_tax missing after using order_editor 5.0.6_6 to edit an order :( Hi. I wanted to use order_editor to edit my orders - as the normal OSC order editor can't handle shipping without a VAT charge. I edited an order - but now the ot_tax entry in the orders_total table is missing for that order :( I tried searching this thread for notes on this, but I can't figure out how to see which (of the 29 pages - with many posts on each) actually mentions ot_tax.. Anyone know how to see the posts in this thread, that mentions ot_tax ? Any help is appreciated - I am a programmer - I'm just not experienced with the order_editor code.. I was hoping someone could give me a pointer. I'll glady insert trigger_error("whatever info you want",E_USER_WARNING); lines in the code to pull out data that could help.
  2. I have a problem I actually thought QTpro solved, but I can't see how - so I'm going to "throw it outthere" to see if you have any idea how I can solve this :) I have an item which has 2 option types: subscription type, and subscription period. My problem is that, I want the price to differ, depending on both. ie. subscriptiontype1 has a price for a 1 year period and a 2 year period. subscriptiontype2 has a different(!) price for a 1 year period and 2 year period. This means I need some sort of "correlation" between options, and differing in price, depending on which was chosen. Would be no problem if all options were simply shown in 1 dropdown. I know qtpro does it in regards to stock, but how do I do the same (it seems to be the same) with prices on options?
  3. No, I simply didn't have that one - and for some reason I missed it when I diff'ed for differences :(
  4. It seems I fixed it by adding a } right before this line: // Update products_ordered (for bestsellers list) I just hope that didn't "screw" with the logic :)
  5. I just tried to simply replace my checkout_process.php with the one included in qtpro4.0 package - and it fails the exact same way. IE. it's a bug in the qtpro4.0 example :( PHP Parse error: parse error, unexpected T_ELSE in /www/customers/linuxpusher2/html/checkout_process.php on line 199 (it's line 199 - because it's the original file - no longer my own file). I use php-4.3.10. Anyone have a checkout_process.php file that works for them? I'd like to see it, and compare it to the one in qtpro4.0.
  6. OOPS (thought it worked). I copy'pasted from qtpro4 - but it still complains on the exact same line - so something must be up.. I've put the file here: http://vsen.dk/files/checkout_process.php.txt it's line 251 as before :( I hope to get my shop ready soon - then I'll start on looking at writing other options, than the "drop-down" - so qtpro4 can be made to support the same as the "option type feature" enables (which does not support qtpro4). If anyone succeedes in adding another "option type" for qtpro (which seems much easier - using Ralph's clever plugin design) I would very much like it if you'd share the code.. with small "intro" how to merge with qtpro4.0.
  7. They are completely different things - which can complement each other. master products allows you to show products, as sub-products on a products page - nothing else. qtpro allows you to add stock control of options to a product (not the same as sub-products! - you should know options already - as they are in the base OSC)
  8. Hi, Have an odd error, I can't see could ever have worked -but I can't figure out to fix it either.. hope you could shed some light on it.. PHP Parse error: parse error, unexpected T_ELSE in /www/customers/linuxpusher2/html/checkout_process.php on line 251 and my line 251 looks like this (it's the one with --line251--> in the beginning :) //++++ QT Pro: Begin Changed code $actual_stock_bought = $order->products[$i]['qty']; } else { if (is_array($products_attributes)) { $all_nonstocked = true; $products_stock_attributes_array = array(); foreach ($products_attributes as $attribute) { if ($attribute['track_stock'] == 1) { $products_stock_attributes_array[] = $attribute['option_id'] . "-" . $attribute['value_id']; $all_nonstocked = false; } if ($all_nonstocked) { $actual_stock_bought = $order->products[$i]['qty']; } else { asort($products_stock_attributes_array, SORT_NUMERIC); $products_stock_attributes = implode(",", $products_stock_attributes_array); $attributes_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); if (tep_db_num_rows($attributes_stock_query) > 0) { $attributes_stock_values = tep_db_fetch_array($attributes_stock_query); $attributes_stock_left = $attributes_stock_values['products_stock_quantity'] - $order->products[$i]['qty']; tep_db_query("update " . TABLE_PRODUCTS_STOCK . " set products_stock_quantity = '" . $attributes_stock_left . "' where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); $actual_stock_bought = ($attributes_stock_left < 1) ? $attributes_stock_values['products_stock_quantity'] : $order->products[$i]['qty']; } else { $attributes_stock_left = 0 - $order->products[$i]['qty']; tep_db_query("insert into " . TABLE_PRODUCTS_STOCK . " (products_id, products_stock_attributes, products_stock_quantity) values ('" . tep_get_prid($order->products[$i]['id']) . "', '" . $products_stock_attributes . "', '" . $attributes_stock_left . "')"); $actual_stock_bought = 0; } } --line251--> else { $actual_stock_bought = $order->products[$i]['qty']; } //++++ QT Pro: End Changed Code
  9. Any other "known bugs" we should know about ? ;)
  10. read the message - Table 'testshop.TABLE_PRODUCTS_STOCK' doesn't exist.. hmm. I'm pretty sure it doesn't. Shouldn't TABLE_PRODUCTS_STOCK have been "converted" to the actual table name? Where is this done.. hmm. try looking at includes/database_tables.php (or whatever it's name is).. ;)
  11. fixion

    Multiple Newsletters contribution

    If you could post exactly(!) what part of the install.txt (linenumbers pls.) you have problems with, perhaps we can help. Also - you do know how to use diff? (or some windows diff program if you use windows). That's how I did it. diff with -bduNr options.
  12. fixion

    Multiple Newsletters contribution

    I found the problem. The contribution creates lists with the language ID chosen in the admin. But when the admin is in english - and the user is in danish - they don't see the newsletters (as they don't exist for the chosen language). IMHO my proposed solution, would be to add a "language selection" box, to the newsletter - which would contain the enabled languages, AND a "All Languages" having the value of 0 - indicating it was valid for all languages.
  13. Hi guys, I was heavily missing a forum for discussing the "newsindex" aka. Multiple Newsletters contribution. http://www.oscommerce.com/community/contributions,2445 This contribution allows you to create an arbitrary amount of newsletters, with an indication of a type. This type indication, makes it a good candidate for further developments, such as creating a newsletter of the type "MailMan List" - which when you send a mail to that list, it will do it through mailman (I'm going to code this feature - cause I need it :) Also - one might consider merging this, and the contrib that allows none-users to subscribe to your newsletter http://www.oscommerce.com/community/contributions,535 I currently have a "small" problem with this contrib, as it does NOT show the newsletters in the account_newsletters.php file as it should (it simply returns blank). everything else seems(!) to work fine. All help is appreciated.
  14. Just to get my last post in 2004 in ;) - has the admin side of qtpro changed from 3.1 to 4? (just before I rip out qtpro-3.1 to integrate qtpro-4 :)
  15. It just dawned on me that you (or someone else) might think I was just bitching - so I just wanted to assert, that the reason I'm having to do the "crap job", is ofcourse because qtpro4 is sooo great (it really is), that I think it's worth it :) IMHO QTPro4 should be added to 2.2MS3-CVS, as it is definetely a much needed feature, AND IMHO the plugins structure and the javascript-that makes sure customers can't order, what isn't in stock is REALLY REALLY BRILLIANT. If anyone knows somewhere to suggest to the devs to look at qtpro4, I'd gladly do it. I'll start with ripping out my own integration work (back to scratch on product_info.php :) and then I'll learn to write plugins, by writing a static options plugin, that works like the static options contrib does now (so it will work with "compare options" contribution as the orig does) - and that'll hopefully make some users happy :) Have a great new year.