Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


g2777 last won the day on October 25 2014

g2777 had the most liked content!


About g2777

  • Birthday 02/18/1984

Profile Information

  1. I did it! Yay! Thank you so much for your help. I had a problem getting the SQL statement in 16b working to begin with but in the end It was simply so that you can select the products associated with a particular sale by using the drop down list. So I used this: $listing_sql = "select " . $select_column_list . " p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . (is_numeric($sale_id) ? "' and s.sale_id = '" . (int)$sale_id : "") . "' and s.status = '1'"; Basically just replace '" . (int)$languages_id . "' with '" . (int)$languages_id . (is_numeric($sale_id) ? "' and s.sale_id = '" . (int)$sale_id : "") . "' in the original statement. It works flawlessly as far as I can tell and I got to keep the sorting options. Thank you again; to both of you. Regards, Graham
  2. If you're willing to give it a shot then, by all means, feel free. My eternal thanks to you for even considering it. Here are the instructions for modifying specials.php: The bm_specials.php box file also needs the following change and that has the same problem: There are a number of other files that still need to be modified but I don't know which ones or whether the changes are problematic or not as I haven't proceeded past the current issue yet. If anyone does have any ideas then I will tip my hat to you (firstly; I will buy a hat). If I get it to work then I'll repackage the changes and upload a new version to the add-ons area. Constantly stunned at how helpful everyone is, Graham
  3. Thank you for your reply Gary. However, I have already modified product_listing.php with very similar code from the instructions. In the standard 2.3.4, product_listing.php and specials.php both duplicate much of the same code and I assume that this is the reason that you condensed it to just a file inclusion as it was unnecessary, but the add-on assumed this was still the case and wants me to change parts that aren't there anymore. You are right, of course. I should change the add-on to fit with the osC version. I just don't know how. I'll take another look then and see if I can work round it. Many thanks for your time. Graham
  4. Hello, Has anyone had any luck getting Multiple Sales Per Product for osCommerce 2.3 (http://addons.oscommerce.com/info/8593) working with the bootstrapped versions? Specifically, the /catalog/specials.php and catalog/includes/modules/boxes/bm_specials.php files. In specials.php I am instructed to find a line that begins: echo ' <td align="center" width="33%"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) except in the bootstrap version the only 'echo' statement in the whole file is the heading. Similar problem with the bm_specials.php file. Is it possible to put these two together? It seems to me that specials.php creates a query that pulls the special items from the database and then calls product_listing.php to display them instead of duplicating the code. Is that right? If that's the case I won't be able to install this add-on without re-writing specials.php. True? Or am I confused? Many thanks in advance. Graham
  5. g2777

    add on validation

    Like Geoffrey said: Nice idea. But sadly, prohibitive. With the amount of add-ons that are submitted here it would be a full time job for any amount of people to check each one on every possible variation of osC and add-ons. Having a bundled list of the add-ons that can cause problems with a newly submitted add-on is also great, but then you have to check with possibly thousands of different combinations of add-ons to make sure none conflict or overwrite or workaround or ... etc. Then, for every new add-on submitted everyone has to check their respective add-ons for compatibility. I assume, with the new system in v3, that most of this will be redundant anyway (I live in hope), but for now, at least, not practical. Very unfortunately, mind you.
  6. @@vampirehunter I haven't, no. After trying to get Simple Checkout working and failing I decided to stick to the basic osC checkout for a while. Then I found this thread that discusses the pros and cons. I use PayPal Express as my main payment method so at the time I was looking for a shorter checkout experience because PayPal adds at least two pages to my checkout. I finally decided that a more clearly defined and smoother checkout was the answer instead. It's probably possible to combine the steps into one but it would be very complex and you may end up with the same issues as Simple Checkout in the end anyway. @@nobodyfamous You're welcome. The worst thing about osC is also the best thing about it; it's basic and standard. It gives you the tools to do what you want and change it how you see fit but at the expense of features or functionality out-of-the-box. It's possible to have the web shop you want but it's takes time (and usually experience) that most people just don't have. Of course, a decent developer would help enormously if the money is available... v3.x is looking nice so far. 2.4 is my next point of call though. Just for laughs, mind you. I don't think I could port my site to 2.4 as I've got it now.
  7. @@vampirehunter I've tried this on all the 2.3.x versions, both fresh installs, with other contributions and completely hacked to death. I've tried with and without the compatibilty files and Guest Checkout/Discount Codes and I've not got it to work properly, apart from once which seemed to be a fluke because I couldn't do it again. It's seems to be random. It probably isn't. My biggest problems with it are: It doesn't load at all and I get a blank screen. It doesn't pass the information when a guest checks out. The cart quite often doesn't show or breaks on the checkout page. The discount isn't automatically updated when a code is entered (if you have Discount Codes installed). The page has to be refreshed to show the discount but you aren't told that. Jetta had a nice idea but I think without a rewrite this isn't going to get better. It has too many bugs for me, but then other people don't seem to have a problem, so it could just be me. Also, if you want to put anything else in the checkout or login areas, such as Must Accept Terms and Conditions, it's a complete pain to find where to put it. To be honest, though, I bought Better Checkout by mattjt83 recently and found that it's a much cleaner way of doing the checkout. Granted it costs money and it's still over more than one page but it doesn't crash half as often (i.e. at all) for me and has a guest function from the start. Sorry to sound like I'm slating it. I don't mean to, it was a brilliant idea but I think it tries to do too much in one place. EDIT: The guest contrib to use with this checkout is in the "compatibility_files" folder. It's this one: http://addons.oscommerce.com/info/8434
  8. I received the same e-mail yesterday. Sadly it seems that Google have decide to make all this hard work moot and pointless. "Switch to Google Wallet or suck it up." As far as I know there isn't an add on for Google Wallet integration on here (correct me if I'm wrong). Sucks for those who use it.
  9. The recent tension on here makes me moderately sad. *tear rolls down cheek* It's usually so civil.

  10. Good morning ladies and gents. I've been using this for a while to keep an eye on things and have found that Baiduspider, Googlebot, YandexBot and Ezooms aren't filtered out in the entries. Is this a simple case of adding more exclusions? I have taken a look at the supertracker class file but I don't understand preg_match at the best of times. Regex is not something I'm good at, at all. I've tried replacing preg_match with stristr and checking for != false but that just broke it. Probably my ridiculous understanding of php. Does anyone else have a bot free data set? I find they just get in the way of my actual customers. And they tend to skew the reports. Any help: much appreciated. Graham
  11. Need... more time... to sift... through... add-ons.

  12. Hey Martin. Can I suggest that you read this thread: http://forums.oscommerce.com/topic/389419-questions-about-enhanced-categories-box/ Enhanced Categories Box has a few problems but can work quite well if tweaked correctly. I use it on my site if you want to have a look. www.rain-e-daze.co.uk It took a bit of work to get right and it's still not perfect, especially if IE is in anything less than IE8 Standards mode. If you follow my instructions in that other thread and IE isn't in IE7, emulated or quirks mode then the box should work. Regards, Graham
  13. Good morning. If anyone still reads this thread I'm hoping that one of you can help me. I have Simple Checkout, Discount Code and Consolidated Login installed (all latest versions) and I like the way that they work together but I cannot get Simple Checkout to pass guest information correctly. When you try to buy something without an account and input your guest information it doesn't pass that information to the checkout page. If you then refresh the checkout page you get the guests name and address but no payment and shipping selection. If you leave that page, visit a different part of the site and then come back to it everything is fine. Consequently, when you try to move on to payment the first time round (I only use PayPal at the moment) you get a blank page because it either hasn't sent the correct/full info or hasn't got a payment type selected. You can try this yourself. My site is in my profile. The osC version and Add-on's I use are in my signature for reference. More info? Just ask. If this is too much or can't be fixed then can someone throw me a link to a shorter checkout option that I could try? It's a shame that Jetta seems to have vanished.
  14. tinkering = mistakes = tinkering (repeat)

  15. Ok, so my changePrice function was in my html_ouput.php file under the tep_draw_pull_down_menu function. My drop down works fine now. It was obviously something that I'd put in and forgotten to take out again ages ago. :- I'd still like to find the cause of the indentation issue though if anyone has any ideas. Or at least a work around for IE.