Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by g2777

  1. 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
  2. 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
  3. 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
  4. 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
  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.
  16. Sorry that I'm late to the party. I wondered if anybody is still working through this or if everyone has given up hope? I have devised a horibble and messy work around for the indentation issue. I found that trying to put the corrections in to my CSS file didn't work unless I specified every level of <li> in my store which was tedious. SO instead I did a little inline editing to the box. In includes/modules/boxes/bm_enhanced_categories.php, on line 39, change: $categories_string = '<ul class="enhcat">'; to: $categories_string = '<ul class="enhcat" style="margin: -2px 0 0 -40px; list-style-type: none;">'; In includes/modules/boxes/bm_enhanced_categories.php, on line 39, change: $categories_string = '<li>'; to: $categories_string .= '<li style="margin-left: -' . ($cat['level']*15) . 'px;"> That gives a recurring negative margin of 15px per level. I did it like this because I couldn't find the actual problem. Maybe if I spent more time I could but it's late and I'm annoyed. Also, it's only viable in FireFox and Chrome. IE pushes the menu too far to the left and it's useless. Then you're in to conditional statements and whatnot... sigh. The Drop Down Menu at the bottom doesn't work because it calls a non-existent function on mine like this: onchange="changePrice(this.id)" I can't find where this changes because it should be: onchange="this.form.submit(this.id)" which works perfectly and yet changes back to the previous on page refresh. All in all, it needs quite a bit of work (and a few files) but it's a base to work off if I (or anyone else) can be bothered. Good luck.
  17. Actually I haven't touched the html_output.php or the general.php files at all so I don't know what's going on. If I find out I'll let you know just in case you come across it again. Thank you. This was the reason I was trying to get this to work. I wanted to thumbnail the images everywhere but not have to make copies. I'd only just started to implement OPI so I hadn't reached all the files yet. Just finishing that off now. I didn't say it before but this contribution is amazing. Just what I needed, thank you. Off topic question: I noticed on the demo site that you linked to earlier (http://www.rhinebutik.com/en/product_info.php?products_id=2) that you had a drop down box that changes depending on the option selected. Do you know of any contributions that do something like that? Many thanks again for all your help, Graham
  18. Sorry zaenal, I forgot about the Maintenance mode. My pc bypasses it. I've turned it off now so you can see it if you need to. I've been crawling through the code all evening trying to find the cause and I think I have, but not a solution. It turns out that my tep_image() function doesn't work with 'thumbs/def/****' in the path. There is no "<img src=" at all in the html source because the function doesn't output. I can't figure out why. If I take out the relative thumbs/ path and have an absolute path to the image on the server then it will display it. The href links work and I can see them in the source just not the actual images themselves. It's probably worth noting that I've tried this with 1 picture on a product and 4 pictures on a product. No images display either way.. At the moment the only products with more than one image are: http://www.rain-e-daze.co.uk/shop/product_info.php/cPath/29_30/products_id/43 and http://www.rain-e-daze.co.uk/shop/product_info.php/cPath/29_30/products_id/51 Thanks for your input, Graham
  19. Hi zaenal, I hate to be a pain and bring up something that you've already been through but I cannot get my images to show up on my products page. I followed the instructions for manually editing the required files (I already have a fairly modified osC) and the admin side works fine and everything is inserted into the database properly. My server has mod rewrite enabled and I have tried a direct link to the images and using the /thumbs/def/***** url, both of which work fine. Absolute path: http://www.rain-e-daze.co.uk/shop/images/products/0-3-months-yellow-lily-1.jpg Thumbnail paths: http://www.rain-e-daze.co.uk/shop/images/thumbs/def/display/products/0-3-months-yellow-lily-1.jpg http://www.rain-e-daze.co.uk/shop/images/thumbs/def/small/products/0-3-months-yellow-lily-1.jpg http://www.rain-e-daze.co.uk/shop/images/thumbs/def/large/products/0-3-months-yellow-lily-1.jpg But I still get the spinning 'loading' image on my product_info.php. I already had this file modified with QTPro 4.6.1 so I used winmerge to compare the differences I thought I had it all ok. Apparently not. I'm not great with .htaccess files so there may be a problem with it, I don't know. Any ideas on where to look would be grateful. If you need more info, just say so. Thanks, Graham
  20. g2777


    Nevermind. Took me all night trying to figure out what was wrong and I still couldn't. In the end I just added the info to the db manually and had to put in a text box on the Verify Customers page in Admin so that I could see and change the Verification Date. Problem with me or a problem with the script? I don't suppose anyone else has had this problem as I don't see anyone saying so.
  21. believes that he was not entirely cut out for thinking in variables... (or spelling 'believes' correctly the first time round)

  22. believes that he was not entirely cut out for thinking in variables... (or spelling 'believes' correctly the first time round)

  23. beleives that he was not entirely cut out for thinking in variables...

  24. g2777


    Dear anybody, I installed this last night as it was better than my original system but I have two issues. 1. In the Verify Customers panel in Admin when I press 'Update' I constantly get the error " The values entered as the account verification date must be seperated by a dash "-"" This is annoying because there is nowhere for me to change the date in the Admin section. I have the 'Account verification start date (yyyy-MM-dd)' in the Settings panel and I assume that there is supposed to be a box to type the date in but not on mine. As a consequence of this error the script will not update the database. Is this just me? The files in the admin folder where new files, so I didn't have to merge anything, just a straight copy over. The only file I had to mess around with was create_account.php in the root because I already had other things in it. I have another issue with the e-mail not sending correctly, but I'm assuming it's me and the bad job of merging the file I did. Any thoughts at all would be welcome. Regards, Graham
  25. g2777

    [Addon] Banner Box for 2.3

    OK, so now I look like a complete noob. It turns out that the image was fractionally over the 137px size limit. I dropped it to 130px and it's fine now in everything.I've got. I wouldn't have got that it I hadn't checked the HTML, thank you JIm Regards, Graham