Jump to content

cube

Members
  • Content count

    78
  • Joined

  • Last visited

Profile Information

  1. cube

    OSCOMMERCE IN AJAX

    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. cube

    phpBB2 Implementation Contribtion

    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
×