[nfc5382]

Originally Posted by Grant

I'd like to know this too before trying to install this mod.

This is for 4.0.18. It also searches the productid by default. Both admin and customers constantly search by the product id!

find:

# Search for substring in some fields...

replace with:

    # Search for substring in some fields...
    
    ## new advanced search
    $ss = split(" ",$data["substring"]); 
    $ss_condition = ""; 
    foreach($ss as $s) 
    { 
      $condition = array();
      ## //new advanced search  
       
      if (!empty($data["by_title"])) {
        if($current_area == 'C' || $current_area == 'P') {
          $condition[] = "IF($sql_tbl[products_lng].product IS NOT NULL AND $sql_tbl[products_lng].product != '', $sql_tbl[products_lng].product, $sql_tbl[products].product) LIKE '%".$s."%'";
        } else {
          $condition[] = "$sql_tbl[products].product LIKE '%".$s."%'";
        }
      }
      
      if (!empty($data["by_shortdescr"])) {
        if($current_area == 'C' || $current_area == 'P') {
          $condition[] = "IF($sql_tbl[products_lng].descr IS NOT NULL AND $sql_tbl[products_lng].descr != '', $sql_tbl[products_lng].descr,  $sql_tbl[products].descr) LIKE '%".$s."%'";
        } else {
          $condition[] = "$sql_tbl[products].descr LIKE '%".$s."%'";
        }
      }
  
      if (!empty($data["by_fulldescr"])) {
        if($current_area == 'C' || $current_area == 'P') {
          $condition[] = "IF($sql_tbl[products_lng].full_descr IS NOT NULL AND $sql_tbl[products_lng].full_descr != '', $sql_tbl[products_lng].full_descr, $sql_tbl[products].fulldescr) LIKE '%".$s."%'";
        } else {
          $condition[] = "$sql_tbl[products].fulldescr LIKE '%".$s."%'";
        }
      }
      
      ## always search productid
      if($current_area == 'C' || $current_area == 'P') {          
          $condition[] = "IF($sql_tbl[products_lng].productid IS NOT NULL AND $sql_tbl[products_lng].productid != '', $sql_tbl[products_lng].productid, $sql_tbl[products].productid) LIKE '%".$s."%'";
        } else {
          $condition[] = "$sql_tbl[products].productid LIKE '%".$s."%'";
      }
      ## //always search productid
  
      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).")";
      }   
    ## new advanced search
    }
    
    $search_condition .= $ss_condition;
    ## //new advanced search

    # Search statistics
    if ($page == '0') {
      db_query("INSERT INTO $sql_tbl[stats_search] (search, date) VALUES ('$data[substring]', '".time()."')");
    }
  } # /if (!empty($data["substring"]))

#
# Search by product features
#

until:

#
# Search by product features
#