Latest News: (loading..)
ArtcoInc
Members-
Content count
730 -
Joined
-
Last visited
-
Days Won
13
-
@t000 Oh, and as @Dan Cole mentioned, you are going to have to join tables in your query. More to learn If you don't feel that you can learn how to do this, you can always post in the commercial area of the forum and hire someone to do it for you. Malcolm
-
@t000 Tom, will you always want to only exclude the Keyboard category, or will what you exclude change each time? As you know, the tep_count_products() function counts *all* products. function tep_count_products() { $products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " WHERE products_status = '1'"); $products = tep_db_fetch_array($products_query); return $products['total']; } If you wanted to exclude the Keyboard category, you would have to change the function to *something* like this: function tep_count_products() { $products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " WHERE products_status = '1' and Category ! Keyboards "); $products = tep_db_fetch_array($products_query); return $products['total']; } (No, that's not proper SQL code ... I'm just showing you *where* to adjust the query, not *how* to. You'll learn more about how to manage your own store by figuring it out yourself ) Two points: 1) You don't want to CHANGE the existing tep_count_products() function, you want to COPY and RENAME it (to something like tep_count_products_except_keyboards() ). Don't change the core code! 2) If you will be changing what you will be excluding each time, you could a) write a function for each category you might exclude (not too practical, especially if you may want to exclude more than one category, and/or you add new categories to your store often), or b) write a function that accepts a parameter with the category (or categories) you want to exclude. For example, you could write a function called tep_count_products_with_exceptions() , and would have to pass the name or number of the category (or categories) that you want to exclude. See what you can come up with. If you need more help, tell us what you have tried that worked or didn't work. HTH Malcolm
-
The US Post Office does not deliver mail on Sunday. However, Amazon has partnered with them, resulting in having the Post Office deliver Amazon's items on Sundays. I wonder what *that* cost Amazon?
-
@ce7 <html<?php echo HTML_PARAMS; ?>> Try putting a space between <html and <?php Malcolm
-
(I'm sure @burt will pull this if it is inappropriate ... ) For anyone else wanting to try @burt's Fuzzy search http://clubosc.com/29daysofcode/16.php Malcolm
-
@Dan Cole As I mentioned, I was able to get the back end of Sphider to work. It basically goes through your site and indexes every word, and stores it in several database tables. Here's a screen shot from the admin side: For example, you can see that the word 'kevlar' is the most used word on my site. Several points: 1) I'm sure you *could* add words to the database, but they are spread out across multiple tables, with cross indexes, etc. I think it would take a bit of work to figure out how everything is stored and sorted. 2) This only indexes real words, and your 'marineflake' example probably would not find a match. 3) As I also said, I only got the back end working. I'm sure we *could* resolve the issues on the front end, but I'm not sure it would be worth the effort. As you noted, support for this has all but died. And, even if you/we were to revive it, I don't know if this search function is any better than other options. Finally, @burt has shown that his Fuzzy search does pretty much what you want. So, unless Google search installed on our stores offers better search capabilities, I think that @burt's Fuzzy is the current winner. Wow, this 'Search Review' sure has taken on a life of it's own. Who'd have thought? Malcolm
-
@Dan Cole Have you looked at this one? I started to mess with it, but life got in the way. https://apps.oscommerce.com/caQMT It seems that the people who developed Sphider stopped working on it. There is a spin-off, but (if I remember correctly) it is a commercial product. That said, I was able to integrate the above add-on into the admin side, and was able to generate the index through the back end. I ran into snags on the front end (beyond my coding skills), though. HTH Malcolm
-
One other observation ... I find that I can get so involved when working on our stores that we 'know' how thing work, and may assume that our customers do too. For example ... When I was testing the Twitter Type-Ahead search function, I asked someone to try it and tell me what they thought. I watched them... 1) they clicked on the search box 2) they looked down at the keyboard as they typed their search term, and pressed enter (as they were typing, the search box had a number of suggestions, with the first one highlighted. When the user pressed Enter, it selected the highlighted suggestion) 3) they looked up at the screen, and wondered why search returned something other than what they wanted Just an observation .... Malcolm
-
@Dan Cole @burt already answered you about his Fuzzy module. There is another way ... You can add Google Search to your site. You'd have to create an account with Google, add the bit of code to your site, and wait for them to crawl your site (or, submit a site map to Google to speed things up). I started to play with this, but didn't get too deep into it, so I don't know how smart it's search capability is, nor if it would be able to handle your "marineflake" example. Beyond these, I don't think that any of the osC search modules would be smart enough to handle your example. As far as I can tell, they all just search for the specified word (or words). Malcolm
-
@radhavallabh As I understand it, a Modal is a bootstrap feature. I do not think that it would work in the 'standard' version of osCommerce. Malcolm
-
@raiwa Thanks. That's what I was thinking too, but haven't tested it. Malcolm
-
@rpdesign As we discussed a couple of years ago, you were using an array that dealt with the customer's ID. If a customer was not logged in, or was a guest, that array didn't exist. As I recall (I can't find records of those conversations), I pointed out a different array that did work, both with customers with or without accounts, checked in or not, and/or guests. I had also mentioned that there were two guest checkout modules available. One was never updated for 2.3.4 (let alone Bootstrap), but the other one is fully up to date, and is quite popular: https://apps.oscommerce.com/5f3nn I haven't looked at how this addon would work in conjunction with SSPP, or if it would resolve the issue I first mentioned. HTH Malcolm
-
@rpdesign Have you added the ability for this to work with a guest, or someone not logged it? Malcolm
-
Also, the latest Edge version is PHP 7 ready. The 'standard' 2.3.4 version won't work under PHP 7. Malcolm
-
222 is the correct country code for the United Kingdom. I do not see 242 as a valid country code in my database(s). It looks like you will have to do a search through the code where you create a customer's account to see where the country code in created and/or defined. HTH Malcolm
