X-Cart forums

[adpboss]

Originally Posted by BHMedia

Does anyone read what other people say in these forums?
*sigh*

All the time. Help youself out by reading the Forum Rules and the sticky threads posted in each forum.

Sometimes questions don't get answered because they are too obvious and haven't been researched. Sometimes it is because members don't have version info in their signatures. And sometimes, people just don't know an answer that they can contribute.

[ifalu]

I believe for all the people that are not experts as you in this a straight answer would be beneficial. I am aware of the rules but I think that for us non experts a simple answer like:

For 4.0.x

do
1
2
3...

But is OK, if you don't have the time for this

Ian
GOLD 4.0.4

[adpboss]

Sure you want your answer your way, but because this is a user supported forum, sometimes you aren't going to get an answer or the one you want.

I don't use this mod anymore, I can't help you. My advice, is to help yourself.

[ProjectShadow]

Hey, anyway to get the sub-cats to show up in the categories drop-down?

[ProjectShadow]

TTT

[ProjectShadow]

.....???

[guphed]

Well I think this thread started out by being a mod for changing the exact phrase search to multiple word search before it deviated somewhat before anybody had posted any code for v4.x so I've had to have a pop myself...

This seems to work for me, although I don't use Extra Fields so I've not tested it with that... I'm on 4.0.7.

Change:

		# Search for substring in some fields...
		
		if (!empty($data["by_title"]))
			$condition[] = "$sql_tbl[products].product LIKE '%".$data["substring"]."%'";
		
	 	if (!empty($data["by_shortdescr"]))
		 	$condition[] = "$sql_tbl[products].descr LIKE '%".$data["substring"]."%'";

	 	if (!empty($data["by_fulldescr"]))
			$condition[] = "$sql_tbl[products].fulldescr LIKE '%".$data["substring"]."%'";

		if (!empty($data["extra_fields"]) && $active_modules['Extra_Fields']) {
			foreach($data["extra_fields"] as $k => $v)
				$condition[] = "($sql_tbl[extra_field_values].value LIKE '%".$data["substring"]."%' AND $sql_tbl[extra_fields].fieldid = '$k')";
			$join['extra_field_values'] = "$sql_tbl[products].productid = $sql_tbl[extra_field_values].productid";
			$join['extra_fields'] = "$sql_tbl[extra_field_values].fieldid = $sql_tbl[extra_fields].fieldid AND $sql_tbl[extra_fields].active = 'Y'";
		}
		if (!empty($condition))
			$search_condition .= " AND (".implode(" OR ", $condition).")";

To:

    $ss = split(" ",$data["substring"]);
    $ss_condition = "";
    foreach($ss as $s)
    {
			# Search for substring in some fields...
	      $condition = array();		
			if (!empty($data["by_title"]))
				$condition[] = "$sql_tbl[products].product LIKE '%".$s."%'";
			
		 	if (!empty($data["by_shortdescr"]))
			 	$condition[] = "$sql_tbl[products].descr LIKE '%".$s."%'";
	
		 	if (!empty($data["by_fulldescr"]))
				$condition[] = "$sql_tbl[products].fulldescr LIKE '%".$s."%'";
	
			if (!empty($data["extra_fields"]) && $active_modules['Extra_Fields']) {
				foreach($data["extra_fields"] as $k => $v)
					$condition[] = "($sql_tbl[extra_field_values].value LIKE '%".$s."%' AND $sql_tbl[extra_fields].fieldid = '$k')";
				$join['extra_field_values'] = "$sql_tbl[products].productid = $sql_tbl[extra_field_values].productid";
				$join['extra_fields'] = "$sql_tbl[extra_field_values].fieldid = $sql_tbl[extra_fields].fieldid AND $sql_tbl[extra_fields].active = 'Y'";
			}
	
			if (!empty($condition))
				$ss_condition .= " AND (".implode(" OR ", $condition).")";
    }
  $search_condition .= $ss_condition;
    

[guphed]

Oops, maybe I should say the above file is /include/search.php...

[chilll33]

Originally Posted by guphed

Well I think this thread started out by being a mod for changing the exact phrase search to multiple word search before it deviated somewhat before anybody had posted any code for v4.x so I've had to have a pop myself...

This seems to work for me, although I don't use Extra Fields so I've not tested it with that... I'm on 4.0.7.

Change:

		# Search for substring in some fields...
		
		if (!empty($data["by_title"]))
			$condition[] = "$sql_tbl[products].product LIKE '%".$data["substring"]."%'";
		
	 	if (!empty($data["by_shortdescr"]))
		 	$condition[] = "$sql_tbl[products].descr LIKE '%".$data["substring"]."%'";

	 	if (!empty($data["by_fulldescr"]))
			$condition[] = "$sql_tbl[products].fulldescr LIKE '%".$data["substring"]."%'";

		if (!empty($data["extra_fields"]) && $active_modules['Extra_Fields']) {
			foreach($data["extra_fields"] as $k => $v)
				$condition[] = "($sql_tbl[extra_field_values].value LIKE '%".$data["substring"]."%' AND $sql_tbl[extra_fields].fieldid = '$k')";
			$join['extra_field_values'] = "$sql_tbl[products].productid = $sql_tbl[extra_field_values].productid";
			$join['extra_fields'] = "$sql_tbl[extra_field_values].fieldid = $sql_tbl[extra_fields].fieldid AND $sql_tbl[extra_fields].active = 'Y'";
		}
		if (!empty($condition))
			$search_condition .= " AND (".implode(" OR ", $condition).")";

To:

    $ss = split(" ",$data["substring"]);
    $ss_condition = "";
    foreach($ss as $s)
    {
			# Search for substring in some fields...
	      $condition = array();		
			if (!empty($data["by_title"]))
				$condition[] = "$sql_tbl[products].product LIKE '%".$s."%'";
			
		 	if (!empty($data["by_shortdescr"]))
			 	$condition[] = "$sql_tbl[products].descr LIKE '%".$s."%'";
	
		 	if (!empty($data["by_fulldescr"]))
				$condition[] = "$sql_tbl[products].fulldescr LIKE '%".$s."%'";
	
			if (!empty($data["extra_fields"]) && $active_modules['Extra_Fields']) {
				foreach($data["extra_fields"] as $k => $v)
					$condition[] = "($sql_tbl[extra_field_values].value LIKE '%".$s."%' AND $sql_tbl[extra_fields].fieldid = '$k')";
				$join['extra_field_values'] = "$sql_tbl[products].productid = $sql_tbl[extra_field_values].productid";
				$join['extra_fields'] = "$sql_tbl[extra_field_values].fieldid = $sql_tbl[extra_fields].fieldid AND $sql_tbl[extra_fields].active = 'Y'";
			}
	
			if (!empty($condition))
				$ss_condition .= " AND (".implode(" OR ", $condition).")";
    }
  $search_condition .= $ss_condition;
    

Works great with 4.0.8

[DogByteMan]

It does work great.

If I had one wish left on the subject, I would wish that it would also search product number like it did in 3.4.x