Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

cube

Pioneers
  • Posts

    78
  • Joined

  • Last visited

Everything posted by cube

  1. I have added a diff listing to the download area - hopefully it will help people in upgrading a modified store.
  2. Hi, It's not clear what you are trying to achieve. If you want TABLE_CUSTOMERS to ALWAYS be the inner join of those two tables, you could use define('TABLE_CUSTOMERS', 'customers, customers_store3'); but you would need to alter the 'where' statement wherever TABLE_CUSTOMERS is referenced.
  3. Both stores connect to the same database, and so could have the same username, password and database name. Alternatively, you could have a separate DB login for each store, and set the username and password in each configure.php - the database name is still the same, though.
  4. Hi, Has anyone come across this type of outtput in User Tracking before, showing the user alledgedy returning to the home page between each click - obviously they aren't, but the page impressions are ending up in the database, and a knock-on effect is that checkout information (in particular billing information) is lost. Can't see the image above? Try http://www.outtoplay.co.nz/images/user_tracking_problem.jpg This is happening during a witnessed session (with the store owner). His PC has this issue, but another PC in his office does not - both running the same version of IE. One worrying thought is that there may be some tracking software running on his PC? Thanks in advance. Quentin
  5. Hi, I too suffer from the mysterious missing credi card details, as reported in Bug 1693 I have found that the session data is present on the 'Confirm Order' page, but when the user clicks 'Confirm', the details have disappeared when the next .php page loads. My solution has been to capture the CC details at various points through the checkout, so that they can at least be recovered if the order turns up and they are not present. My next step will be to automagically re-populate them if they are found to be AWOL. I'm still at a loss as to why they disappear. Quentin
  6. Its part of the webserver's environment. A path is a ':' separated list of directories that are searched in order, so .:/usr/share/php:/usr/share/pear means look in . (the current directory) and then /usr/share/php and then /usr/share/pear for the file in question. If it isn't found, then it can't be loaded. Now, I know you have said that the files are in place, but PHP isn't going to get this wrong, so check and double check (including spelling, case, extenstion etc.). Also, check the permissions of the files to ensure that the webserver can read them. If you are using Apache, then the error logs may help, too. Quentin
  7. Hi David, Yes, you can email a voucher to anyone, not just customers - when they create an account, they can redeem it. You can also set it up to automatically send a voucher to every new account. Hope this helps Quentin
  8. Hi, I've almost got the forums going on my shop, but I sent myself a Private Message, and got an e-mail notification in Chinese. Anyone know how to control the language character set for the e-mails? Regular osC emails work just fine. Thanks Quentin
  9. Can you post that section of your order_details.php - I haven't got that file, so I guess its from a different contrib? Quentin
  10. Hi, I tried that sequence CCard Info & voucher -> Redeem -> CCard Info -> Continue and the voucher details showed correctly in Order Confirmation. Not sure what to suggest :( Quentin
  11. Hi, Not sure where I got it from, but my 'if' statement is: if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) { This will certainly stop the 'each' error, but I'd check that discounts/coupons continue to work as expected for priced attributes, just to make sure. Quentin
  12. Not sure if that link is right? http://catalog/includes/modules/order_total/ot_gv.php Quentin
  13. Maybe - its not replacing the tep_get_product_path, its a new function that returns a list of all categories and their parents that a product belongs to. Any exsting call to tep_get_product_path excepth the one in ot_coupon should be left as is. cube
  14. Hi, I have the coupon above the CC info, which is why I did it that way. I'll check what happens if I follow your sequence. Quentin
  15. Whilst working through this [the fix for where items have attributes], I also found that, where a product is in multiple category trees (I've got Brand, Age and Activity for toys), things fail if the selected category is not the first one found by tep_get_product_path in general.php. This is cured by adding to general.php function tep_get_product_full_path($products_id) { $cPath = ''; $category_query = tep_db_query("select p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = '" . (int)$products_id . "' and p.products_status <> '0' and p.products_id = p2c.products_id"); $categories = array(); while ($category = tep_db_fetch_array($category_query)) { tep_get_parent_categories($categories, $category['categories_id']); $categories = array_reverse($categories); $categories[] = $category['categories_id']; } $cPath = implode('_', $categories); return $cPath; } and replacing the call to tep_get_product_path in ot_coupon.php with a call to this new function. Hope this helps someone. Quentin
  16. Agreed - good catch. Whilst working through this, I also found that, where a product is in multiple category trees (I've got Brand, Age and Activity for toys), things fail if the selected category is not the first one found by tep_get_product_path in general.php. This is cured by adding to general.php function tep_get_product_full_path($products_id) { $cPath = ''; $category_query = tep_db_query("select p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = '" . (int)$products_id . "' and p.products_status <> '0' and p.products_id = p2c.products_id"); $categories = array(); while ($category = tep_db_fetch_array($category_query)) { tep_get_parent_categories($categories, $category['categories_id']); $categories = array_reverse($categories); $categories[] = $category['categories_id']; } $cPath = implode('_', $categories); return $cPath; } and replacing the call to tep_get_product_path in ot_coupon.php with a call to this new function. Hope this helps someone. Quentin
  17. Hi, In modules/order_total/ot_coupon.php, just before the tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'payment_error='.$this->code.'&error=' . urlencode(ERROR_REDEEMED_AMOUNT), 'SSL')); // Added in v5.13a by Rigadin add if ($HTTP_POST_VARS['submit_redeem_x']) This will redirect back to the payment page if they click Redeem. If they continue down the page, enter CC info etc., and click Continue, then all will be well. If they continue down the page, enter CC info and go back up again and click redeem, then the CC info is still lost, but I think that this minor addition makes things a little more sensible. Quentin
  18. This contribution displays 'New Low Price' in the Product Info screen, and shows the old price struck out next to the new price (like specials) in a product list. This happens a. After you adjust a price downwards by more than a defined percentage b. for a defined number of days after the price adjustment. All credit to those that have gone before. This is my first contribution, so 'all care, no responsibility'! Available at New Low Price Enjoy! Quentin
  19. Me again.... from ot_gv.php // Amended line, was giving an error when a zero value was arriving here. v5.13 by Rigadin //$ratio1 = tep_round($od_amount / $amount,2); $ratio1= ($amout==0? 0 : tep_round($od_amount / $amount,2) ); Shouldn't "amout" be "amount"? Quentin
  20. In the order_total.php 5.13 changes there is: if (!tep_session_is_registered($post_var)) tep_session_register($post_var); // START modification for Credit Class v5.13 by Rigadin: have to register the new created variable as global cause we are in a function $post_var = $HTTP_POST_VARS[$post_var]; // Rigadin: does not work because not global variable // END modification v5.13 } Apart from the comments, I can't see any difference with 5.12 - am I missing something subtle?
  21. In ot_gv.php, collect_posts, change the last section: if ($HTTP_POST_VARS['submit_redeem_x'] && $gv_result['coupon_type'] == 'G') tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_REDEEM_CODE), 'SSL')); to if ($HTTP_POST_VARS['submit_redeem_x'] && !$HTTP_POST_VARS['gv_redeem_code']) tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(ERROR_NO_REDEEM_CODE), 'SSL')); The sharp eyed amongst you will see that the new code has been (almost) ripped from ot_coupon.php, which correctly detects the non-entry of a coupon code! Quentin
  22. Easily - Change ot_gv.php, process() function: $this->output[] = array('title' => $this->title . ':', 'text' => '<b>-' . $currencies->format($od_amount) . '</b>', 'value' => $od_amount); Note the '-' after the <b> tag. Haven't fully verified that this works, but looks OK at first glance. Quentin
  23. The issue with that idea, Rigadin, is that the redemption code checking is all in checkout_confirmation - you'd need to move that to checkout_payment, which may not be trivial. Also, if you tick 'use gift vouchers', and your balance exceeds your order total, 'credit_covers' ensures that you progress smoothly to the next stage. I have moved the redeem box before the payment options, and also (in the past) have made Credit Card the default payment option (too many customers entering credit card data, and then selecting the next option down!). So now, when someone puts in a valid voucher code and hits redeem, they get ugly error messages to say that the credit card info is missing. The obvious way to do this is to squash the CC error code if there was a voucher code entered, but no credit card number (i.e. still get an error if there was CC data entered), but to make the verification of one module (credit card) dependent on data in another (presence of a voucher code) seems a bit 'ham-fisted' - is there better way? Quentin
  24. Thanks for that - did I stuff up on reading the instructions? Quentin
  25. ... and another thing. ot_coupon.php/credit_selection will output a 'Redeem Code' box unconditionally. ot_gv.php/credit_selection outputs a 'Redeem Code' box if there are any active Gift Vouchers. This means that if you have Discount Coupons and Gift Vouchers enabled, you get two identically named boxes!!? Apologies if this has been covered before, but it seems strange that such a widely used contribution has two seemingly fundamental bugs - I'm happy to post my fixes, so long as I'm not undoing someone else's good work! Thanks Quentin
×
×
  • Create New...