Search text box not working

Below is my function, please dont laugh if anything stupid written.

  class WPCustomFieldsSearch_Customallresult extends WPCustomFieldsSearch_DataType {

        function get_name(){ return __("Custom All Result","wp_custom_fields_search"); }

        function getFieldMap(){

            global $wpdb;
			
			
			return array(
				
                "customallresult"    =>    __("customallresult","wp_custom_fields_search"),

            );
			
			

            $results = $wpdb->get_results("SELECT DISTINCT(meta_key) FROM $wpdb->postmeta ORDER BY meta_key");

            $fields = array();

            foreach($results as $result){

                $fields[$result->meta_key] = $result->meta_key;

            }

            return $fields;

        }

        function getAvailableFields(){

            return array_values($this->getFieldMap());

        }

        function get_table_name(){

            global $wpdb;

            return $wpdb->postmeta;

        }
	  
	  
	  function get_field_aliases($config,$count){

            if($config['datatype_field']=='all'){

                $aliases = array();

                foreach(array('post_title','post_author','post_content') as $field){

                    $aliases[] = $this->get_field_alias($config,$field,$count);

                }

                return $aliases;

            } else {

                return parent::get_field_aliases($config,$count);

            }

        }
	  

        function get_field_alias($config,$field_name,$count){

            return $this->get_table_alias($config,$count).".meta_value";

        }

        function add_joins($config,$join,$count){

            $join = parent::add_joins($config,$join,$count);

            for($a = 0 ; $a<$count ; $a++){

                $alias = $this->get_table_alias($config,$a);

                $join = str_replace("AS $alias ON ","AS $alias ON $alias.meta_key='".wpcfs_escape_string($config['datatype_field'])."' AND ",$join);

            }

            return $join;

        }

        function get_suggested_values($config){

            global $wpdb;
			
			
			 switch($config['datatype_field']){

                case 'customallresult':
                    
                   $values = $wpdb->get_col($wpdb->prepare("SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key=%s ORDER BY meta_value",$config['datatype_field']));

                   return $this->_array_to_suggestions_list($values);

            }
			

        }

    }

• This reply was modified 4 years, 7 months ago by Amol Sawant.