applications/dashboard/models/class.searchmodel.php
public function AddMatchSql($Sql, $Columns, $LikeRelavenceColumn = '') {
      if ($this->_SearchMode == 'like') {
         if ($LikeRelavenceColumn)
            $Sql->Select($LikeRelavenceColumn, '', 'Relavence');
         else
            $Sql->Select(1, '', 'Relavence');

         $Sql->BeginWhereGroup();

         $ColumnsArray = explode(',', $Columns);
         
         $First = TRUE;
         foreach ($ColumnsArray as $Column) {
            $Column = trim($Column);

            $Param = $this->Parameter();
            if ($First) {
               $Sql->Where("$Column like $Param", NULL, FALSE, FALSE);
               $First = FALSE;
            } else {
               $Sql->OrWhere("$Column like $Param", NULL, FALSE, FALSE);
            }
         }

         $Sql->EndWhereGroup();
      } else {
         $Boolean = $this->_SearchMode == 'boolean' ? ' in boolean mode' : '';

         $Param = $this->Parameter();
         $Sql->Select($Columns, "match(%s) against($Param{$Boolean})", 'Relavence');
         $Param = $this->Parameter();
         $Sql->Where("match($Columns) against ($Param{$Boolean})", NULL, FALSE, FALSE);
      }
	}
public function AddMatchSql($Sql, $Columns, $LikeRelavenceColumn = '') {
      if ($this->_SearchMode == 'like') {
         if ($LikeRelavenceColumn)
            $Sql->Select($LikeRelavenceColumn, '', 'Relavence');
         else
            $Sql->Select(1, '', 'Relavence');

         $Sql->BeginWhereGroup();

         $ColumnsArray = explode(',', $Columns);
         
         $First = TRUE;
         foreach ($ColumnsArray as $Column) {
            $Column = trim($Column);

            $Param = $this->Parameter();
            if ($First) {
               $Sql->Where("$Column like $Param", NULL, FALSE, FALSE);
               $First = FALSE;
            } else {
               $Sql->OrWhere("$Column like $Param", NULL, FALSE, FALSE);
            }
         }

         $Sql->EndWhereGroup();
      } else {
         $Boolean = $this->_SearchMode == 'boolean' ? ' in boolean mode' : '';

         $Param = $this->Parameter();
         $Sql->Select($Columns, "match(%s) against($Param{$Boolean})", 'Relavence');
         $Param = $this->Parameter();
         $Sql->Where("match($Columns) against ($Param{$Boolean})", NULL, FALSE, FALSE);
      }
	}
public function AddMatchSql ( $ Sql , $ Columns , $ LikeRelavenceColumn = '' ) { if ( $ this -> _SearchMode == 'like' ) { if ( $ LikeRelavenceColumn ) $ Sql -> Select ( $ LikeRelavenceColumn , '' , 'Relavence' ) ; else $ Sql -> Select ( 1 , '' , 'Relavence' ) ; $ Sql -> BeginWhereGroup ( ) ; $ ColumnsArray = explode ( ',' , $ Columns ) ; $ First = TRUE ; foreach ( $ ColumnsArray as $ Column ) { $ Column = trim ( $ Column ) ; $ Param = $ this -> Parameter ( ) ; if ( $ First ) { $ Sql -> Where ( "$Column like $Param" , NULL , FALSE , FALSE ) ; $ First = FALSE ; } else { $ Sql -> OrWhere ( "$Column like $Param" , NULL , FALSE , FALSE ) ; } } $ Sql -> EndWhereGroup ( ) ; } else { $ Boolean = $ this -> _SearchMode == 'boolean' ? ' in boolean mode' : '' ; $ Param = $ this -> Parameter ( ) ; $ Sql -> Select ( $ Columns , "match(%s) against($Param{$Boolean})" , 'Relavence' ) ; $ Param = $ this -> Parameter ( ) ; $ Sql -> Where ( "match($Columns) against ($Param{$Boolean})" , NULL , FALSE , FALSE ) ; } }
Add the sql to perform a search.

@param Gdn_SQLDriver $Sql
@param string $Columns a comma seperated list of columns to search on.
Add the sql to perform a search .