Module Search

19.10.2011 13:02
#1
usaipaola
Joomshopping forum user no avatar
Name: paola
06.10.2011
Posts: 12
Quote
Module Search

I have a problem with the Search Module, if I search two words the result includes all products that contain at least one word, you can limit the results to products that contain all words. thanks


Joomla: 1.7
JoomShopping: 3.2.7
Website Url: www.compatibile.eu
 
10.12.2011 22:44
#2
Fredy80
Joomshopping forum user no avatar
Name: Alfredo
10.12.2011
Posts: 7
Quote
Aw: Module Search

I have the same issue. It seem that you solved it already. Did you solve this issue? if you did, how? Thank you


Joomla: 1.7.0
Website Url: www.evomas.com
 
10.02.2012 16:55
#3
kockas
Joomshopping forum user no avatar
Name: kockas
10.07.2008
Posts: 1
Quote
Aw: Module Search

Hello! Serach problem SOLVED!

components/com_jshopping/controllers/search.php (229-233 Line) :

foreach($words as $word){
$word = addcslashes($db->getEscaped($word), "_%");
$search_word[] = "LOWER(prod.`".$lang->get('name')."`) LIKE '%" . $word . "%' OR LOWER(prod.`".$lang->get('short_description')."`) LIKE '%" . $word . "%' OR LOWER(prod.`".$lang->get('description')."`) LIKE '%" . $word . "%' OR prod.product_ean LIKE '%" . $word . "%'";
}
$where_search = implode(" OR ", $search_word);



REPLACE with this:


foreach($words as $word){
$word = addcslashes($db->getEscaped($word), "_%");
$search_word[] = "(LOWER(prod.`".$lang->get('name')."`) LIKE '%" . $word . "%' OR LOWER(prod.`".$lang->get('short_description')."`) LIKE '%" . $word . "%' OR LOWER(prod.`".$lang->get('description')."`) LIKE '%" . $word . "%' OR prod.product_ean LIKE '%" . $word . "%')";
}
$where_search = implode(" AND ", $search_word);

 
30.03.2012 19:03
#4
Fredy80
Joomshopping forum user no avatar
Name: Alfredo
10.12.2011
Posts: 7
Quote
Aw: Module Search

Problem Solved!!! Thank you for your support guys !!!

 
06.04.2012 16:55
#5
ciccio3
Joomshopping forum user no avatar
Name: ciccio
07.09.2011
Posts: 47
Quote
Aw: Module Search

Kokcas: thank you so very much!!
I was getting mad at this for days and I couldn't figure out how easy it was to fix it!

I have joomshopping 3.5.1 and to fix it you just have to change "or" at line 405 with "and"


Letzte Ă„nderung: 06.04.2012 16:56
 
10.04.2012 11:50
#6
ming67152001
Joomshopping forum user no avatar
Name: jack
06.04.2012
Posts: 1
Quote
Aw: Module Search

Hi,I want to disable Manufacturers in products search function. Anyone can help me?or tell me how to setting? tks.
Aw: Module Search


Joomla: joomla 1.7.2
JoomShopping: Version 3.2.7
 
21.04.2012 06:19
#7
rolyat100
Joomshopping forum user no avatar
Name: Taylor Ruble
16.03.2009
Posts: 44
Quote
Aw: Module Search

I have made the changes below but I am still having the problem that when I put in a word like "tent" it will pull up tents and everything else. How can I get the search function to only pull relevant products to the search?


Joomla: 2.5.4
JoomShopping: latest
 
Copyrights MAXXmarketing GmbH. All Rights Reserved