MAIAN MEDIA

// Advanced search options..
  $advsearch = '';
  $filterArr = array();
  if (!isset($_GET['sKey'])) {
    if (isset($_GET['adv'])) {
      if (isset($_GET['from'],$_GET['to']) && mc_checkValidDate($_GET['from'])!='0000-00-00' && mc_checkValidDate($_GET['to'])!='0000-00-00') {
        $advsearch .= mc_defineNewline().'AND `pDateAdded` BETWEEN \''.mc_convertCalToSQLFormat($_GET['from']).'\' AND \''.mc_convertCalToSQLFormat($_GET['to']).'\'';
      }
      if (isset($_GET['cat']) && (int)$_GET['cat']>0) {
        $advsearch           .= mc_defineNewline().'AND `category` = \''.(int)$_GET['cat'].'\'';
        $_SESSION['thisCat']  = (int)$_GET['cat'];
        $filterArr['cat']     = (int)$_GET['cat'];
      }
      if (isset($_GET['brand']) && (int)$_GET['brand']>0) {
        $advsearch          .= mc_defineNewline().'AND FIND_IN_SET(\''.(int)$_GET['brand'].'\',`pBrands`)';
        $filterArr['brand']  = (int)$_GET['brand'];
      } else {
        if ($SETTINGS->showBrands=='yes' && isset($_GET['brand']) && strpos($_GET['brand'],',')!==false) {
          $advsearch          .= mc_defineNewline().'AND FIND_IN_SET(\''.$_GET['brand'].'\',`pBrands`)';
          $filterArr['brand']  = $_GET['brand'];
        }
      }
      if ($_GET['price1']>0 || $_GET['price2']>0) {
        // Tidy up prices..
        $_GET['price1']  = number_format(str_replace(array(','),array(''),$_GET['price1']),2,'.','');
        $_GET['price2']  = number_format(str_replace(array(','),array(''),$_GET['price2']),2,'.','');
        // Multiply fields by 100 to remove decimal places..
        $advsearch      .= mc_defineNewline().'AND IF(`pOffer`>0,`pOffer`,`pPrice`)*100 >= \''.($_GET['price1']*100).'\' AND IF(`pOffer`>0,`pOffer`,`pPrice`)*100 <= \''.($_GET['price2']*100).'\'';
        // If keys are empty, have price points as the search term..
        if (trim($_GET['keys'])=='') {
          $_SESSION['store_SearchResultsPricePoints'] = $_GET['price1'].' - '.$_GET['price2'];
          // We can also skip the download filter..
          define('SKIP_DOWNLOADS_IN_SEARCH', 1);
        }
      }
      if (isset($_GET['download']) && !defined('SKIP_DOWNLOADS_IN_SEARCH')) {
        $advsearch .= mc_defineNewline().'AND `pDownload` = \''.(in_array($_GET['download'],array('yes','no')) ? $_GET['download'] : 'no').'\'';
      }
      if (isset($_GET['stock'])) {
        $advsearch .= mc_defineNewline().'AND IF (`pDownload`=\'yes\',`pStock` >= \'0\',`pStock` >= \''.($SETTINGS->searchLowStockLimit>0 ? $SETTINGS->searchLowStockLimit : '1').'\')';
      }
      if (isset($_GET['specials'])) {
        $advsearch .= mc_defineNewline().'AND `pOffer` > \'0\'';
      }
      if (isset($_GET['sortby']) && in_array($_GET['sortby'],array_keys($orderByItems))) {
        $filterArr['sortby'] = $_GET['sortby'];
      }
    }
  }

This places the advanced search parameters in the right place without breaking the query.

Great!  But we're still not there yet.  Because MaianCart logs searches, we've got some more work to do.

What MaianCart does when it logs searches is take the results from our search and save them to a table (mc_search_index).  This allows MaianCart to cache searches and reduce load on the server (Identical searches don't get searched twice, and saves processing power), as well as logging the search term.  What does this mean?  Well MaianCart actually passes this cached search to another function to be displayed on the site.  As such, our scores, which are vital to the whole search functionality, get lost!  I was stuck on this for a very long time before the solution became apparent.

Open up /control/classes/products.php again and navigate find lines 1651-1682: