function ajaxsearchpro_deactivate_fulltext()
{
global $wpdb;
$fulltext = wpdreamsFulltext::getInstance();
$indexes = array('posts' => array('asp_title', 'asp_content', 'asp_excerpt', 'asp_title_content', 'asp_title_excerpt', 'asp_content_excerpt', 'asp_title_content_excerpt'));
$blogs = wpdreams_get_blog_list(0, 'all');
if (is_multisite() && is_array($blogs) && count($blogs)) {
foreach ($blogs as $k => $blog) {
switch_to_blog($blog['blog_id']);
$fulltext->removeIndexes($indexes);
}
restore_current_blog();
} else {
$fulltext->removeIndexes($indexes);
}
update_option('asp_fulltext_indexed', 0);
print "<div class='psuccessMsg'>Indexes removed!</div>";
die;
}
/**
* Checks if fulltext is available
*/
function fulltext()
{
global $wpdb;
$fulltext = wpdreamsFulltext::getInstance();
$tables = array('posts');
$blogs = wpdreams_get_blog_list(0, 'all');
update_option('asp_fulltext', $fulltext->isFulltextAvailable());
update_option('asp_fulltext_indexed', 0);
}
/**
* The search function
*
* @return array|string
*/
protected function do_search()
{
global $wpdb;
global $q_config;
$options = $this->options;
$searchData = $this->searchData;
$parts = array();
$relevance_parts = array();
$types = array();
$post_types = "";
$s = $this->s;
// full keyword
$_s = $this->_s;
// array of keywords
$_si = implode('|', $_s);
// imploded phrase for regexp
$_si = $_si != '' ? $_si : $s;
//$kw_logic = w_isset_def($searchData['keyword_logic'], 'or');
$q_config['language'] = $options['qtranslate_lang'];
if (isset($wpdb->base_prefix)) {
$_prefix = $wpdb->base_prefix;
} else {
$_prefix = $wpdb->prefix;
}
/*------------------------- Statuses ----------------------------*/
$statuses = array('publish');
if ($searchData['searchinpending']) {
$statuses[] = 'pending';
}
if ($searchData['searchindrafts']) {
$statuses[] = 'draft';
}
$words = implode('|', $statuses);
$post_statuses = "(lower({$wpdb->posts}.post_status) REGEXP '{$words}')";
/*---------------------------------------------------------------*/
/*----------------------- Gather Types --------------------------*/
if ($options['set_inposts'] == 1) {
$types[] = "post";
}
if ($options['set_inpages']) {
$types[] = "page";
}
if (isset($options['customset']) && count($options['customset']) > 0) {
$types = array_merge($types, $options['customset']);
}
if (count($types) < 1) {
return '';
} else {
$words = implode('[[:>:]]|[[:<:]]', $types);
$post_types = "({$wpdb->posts}.post_type REGEXP '[[:<:]]" . $words . "[[:>:]]')";
}
/*---------------------------------------------------------------*/
$is_too_short = false;
$not_exact_phrase = '';
$fulltext = wpdreamsFulltext::getInstance();
foreach ($_s as $_pp) {
if (strlen($_pp) < $fulltext->getMinWordLength() || !$options['set_exactonly']) {
$is_too_short = true;
$not_exact_phrase .= " *" . $_pp . "*";
} else {
$not_exact_phrase .= " " . $_pp;
}
}
$not_exact_phrase = trim($not_exact_phrase);
$exact_phrase = '"' . $s . '"';
$ful_options = get_option('asp_fulltexto');
if (w_isset_def($ful_options['dbuseregularwhenshort'], 0) && $is_too_short) {
return parent::do_search();
}
/**
* Construct the INDEX name to search
*/
$match_against = '1';
$relevance = '';
$fixed_phrase = $options['set_exactonly'] ? $exact_phrase : $not_exact_phrase;
$boolean_mode = get_option('asp_fulltext_indexed') == 0 || $is_too_short || !$options['set_exactonly'] ? ' IN BOOLEAN MODE' : '';
$index_name = $options['set_intitle'] ? "{$wpdb->posts}.post_title" : '';
if ($index_name == '') {
$index_name .= $options['set_incontent'] ? "{$wpdb->posts}.post_content" : '';
} else {
$index_name .= $options['set_incontent'] ? ", {$wpdb->posts}.post_content" : '';
}
if ($index_name == '') {
$index_name .= $options['set_inexcerpt'] ? "{$wpdb->posts}.post_excerpt" : '';
} else {
$index_name .= $options['set_inexcerpt'] ? ", {$wpdb->posts}.post_excerpt" : '';
}
if ($index_name != '') {
$match_against = " MATCH(" . $index_name . ") AGAINST ('" . $fixed_phrase . "'" . $boolean_mode . ") ";
}
if ($match_against != '1') {
$relevance = "\r\n (\r\n MATCH(" . $index_name . ") AGAINST ('" . $exact_phrase . "'" . $boolean_mode . ") +\r\n MATCH(" . $index_name . ") AGAINST ('" . $not_exact_phrase . "'" . $boolean_mode . ")\r\n )\r\n ";
}
// ------------------------ Categories/taxonomies ----------------------
if (!isset($options['categoryset']) || $options['categoryset'] == "") {
$options['categoryset'] = array();
}
if (!isset($options['termset']) || $options['termset'] == "") {
$options['termset'] = array();
}
$exclude_categories = array();
$searchData['selected-exsearchincategories'] = w_isset_def($searchData['selected-exsearchincategories'], array());
$searchData['selected-excludecategories'] = w_isset_def($searchData['selected-excludecategories'], array());
$_all_cat = get_terms('category', array('fields' => 'ids'));
$_needed_cat = array_diff($_all_cat, $searchData['selected-exsearchincategories']);
$_needed_cat = !is_array($_needed_cat) ? array() : $_needed_cat;
$exclude_categories = array_diff(array_merge($_needed_cat, $searchData['selected-excludecategories']), $options['categoryset']);
$exclude_terms = array();
$exclude_showterms = array();
$searchData['selected-showterms'] = w_isset_def($searchData['selected-showterms'], array());
$searchData['selected-excludeterms'] = w_isset_def($searchData['selected-excludeterms'], array());
foreach ($searchData['selected-excludeterms'] as $tax => $terms) {
$exclude_terms = array_merge($exclude_terms, $terms);
}
foreach ($searchData['selected-showterms'] as $tax => $terms) {
$exclude_showterms = array_merge($exclude_showterms, $terms);
}
$exclude_terms = array_diff(array_merge($exclude_terms, $exclude_showterms), $options['termset']);
$all_terms = array();
$all_terms = array_merge($exclude_categories, $exclude_terms);
if (count($all_terms) > 0) {
$words = '--' . implode('--|--', $all_terms) . '--';
$term_query = "HAVING (ttid NOT REGEXP '{$words}')";
}
// ---------------------------------------------------------------------
/*------------- Custom Fields with Custom selectors -------------*/
if (isset($options['aspf']) && isset($options['aspfdata'])) {
$parts = array();
foreach ($options['aspfdata'] as $u_data) {
$data = json_decode(base64_decode($u_data));
$posted = $options['aspf'][$data->asp_f_field];
$ll_like = "";
$rr_like = "";
$operator = "=";
if (isset($data->asp_f_operator)) {
switch ($data->asp_f_operator) {
case 'eq':
$operator = "=";
break;
case 'neq':
$operator = "<>";
break;
case 'lt':
$operator = "<";
break;
case 'gt':
$operator = ">";
break;
case 'elike':
$operator = "=";
$ll_like = "'";
$rr_like = "'";
break;
case 'like':
$operator = "LIKE";
$ll_like = "'%";
$rr_like = "%'";
break;
default:
$operator = "=";
break;
}
}
//var_dump($data);
/*if (w_isset_def($searchData['cf_null_values'], 1) == 1) {
$cf_key_is_null .= " OR $wpdb->postmeta.meta_key IS NULL";
$cf_val_is_null .= " OR $wpdb->postmeta.meta_value IS NULL";
}*/
if ($data->asp_f_type == 'range' && isset($posted['lower'])) {
$parts[] = " ( ({$wpdb->postmeta}.meta_key='{$data->asp_f_field}') AND\r\n ({$wpdb->postmeta}.meta_value BETWEEN " . $posted['lower'] . " AND " . $posted['upper'] . " ) )";
} else {
if ($data->asp_f_type == 'slider' && isset($posted)) {
$parts[] = " ( ({$wpdb->postmeta}.meta_key='{$data->asp_f_field}') AND\r\n ({$wpdb->postmeta}.meta_value {$operator} {$posted} ) )";
} else {
if ($data->asp_f_type == 'radio' && isset($posted)) {
$parts[] = " ( ({$wpdb->postmeta}.meta_key='{$data->asp_f_field}') AND\r\n ({$wpdb->postmeta}.meta_value {$operator} " . $ll_like . $posted . $rr_like . " ) )";
} else {
if ($data->asp_f_type == 'dropdown' && isset($posted)) {
if (isset($data->asp_f_dropdown_multi) && count($posted) > 0) {
// The AND logic doesn't make any sense
$logic = 'OR';
$values = '';
foreach ($posted as $v) {
if ($values != '') {
$values .= " {$logic} {$wpdb->postmeta}.meta_value {$operator} " . $ll_like . $v . $rr_like;
} else {
$values .= "{$wpdb->postmeta}.meta_value {$operator} " . $ll_like . $v . $rr_like;
}
}
$values = $values == '' ? '0' : $values;
$parts[] = "( ({$wpdb->postmeta}.meta_key='{$data->asp_f_field}') AND ({$values}) )";
} else {
$parts[] = "( ({$wpdb->postmeta}.meta_key='{$data->asp_f_field}') AND\r\n ({$wpdb->postmeta}.meta_value {$operator} " . $ll_like . $posted . $rr_like . " ) )";
}
} else {
if ($data->asp_f_type == 'checkboxes' && isset($posted)) {
$logic = $data->asp_f_checkboxes_logic;
$values = '';
foreach ($posted as $v => $vv) {
if ($values != '') {
$values .= " {$logic} {$wpdb->postmeta}.meta_value {$operator} " . $ll_like . $v . $rr_like;
} else {
$values .= "{$wpdb->postmeta}.meta_value {$operator} " . $ll_like . $v . $rr_like;
}
}
$values = $values == '' ? '0' : $values;
$parts[] = "( ({$wpdb->postmeta}.meta_key='{$data->asp_f_field}') AND ({$values}) )";
}
}
}
}
}
}
$this->cf_parts = $parts;
}
$meta_count = count($this->cf_parts);
$cf_query = implode(" OR ", $this->cf_parts);
if ($cf_query == "") {
$cf_select = "0";
$cf_having = "";
} else {
$cf_select = "\r\n SELECT COUNT(*) FROM {$wpdb->postmeta} WHERE\r\n {$wpdb->postmeta}.post_id = {$wpdb->posts}.ID\r\n AND\r\n ({$cf_query})";
if (w_isset_def($searchData['cf_logic'], 'AND') == 'AND') {
$cf_having = "meta_matches >= " . $meta_count;
} else {
$cf_having = "meta_matches >= 1";
}
if ($term_query != '') {
$cf_having = " AND " . $cf_having;
} else {
$cf_having = "HAVING " . $cf_having;
}
}
/*---------------------------------------------------------------*/
/*---------------------- Custom Fields --------------------------*/
if (isset($searchData['selected-customfields'])) {
$selected_customfields = $searchData['selected-customfields'];
if (is_array($selected_customfields) && count($selected_customfields) > 0) {
$words = $options['set_exactonly'] == 1 ? $s : $_si;
foreach ($selected_customfields as $cfield) {
$parts[] = "({$wpdb->postmeta}.meta_key='{$cfield}' AND\r\n lower({$wpdb->postmeta}.meta_value) REGEXP '{$words}')";
}
}
}
/*---------------------------------------------------------------*/
/*------------------------ Exclude id's -------------------------*/
if (isset($searchData['excludeposts']) && $searchData['excludeposts'] != "") {
$exclude_posts = "{$wpdb->posts}.ID NOT IN (" . $searchData['excludeposts'] . ")";
} else {
$exclude_posts = "{$wpdb->posts}.ID NOT IN (-55)";
}
/*---------------------------------------------------------------*/
/*------------------------- Build like --------------------------*/
$like_query = implode(' OR ', $parts);
if ($like_query == "") {
$like_query = "(0)";
} else {
$like_query = "({$like_query})";
}
/*---------------------------------------------------------------*/
/*------------------------- WPML filter -------------------------*/
$wpml_join = "";
if (defined('ICL_LANGUAGE_CODE') && ICL_LANGUAGE_CODE != '' && w_isset_def($searchData['wpml_compatibility'], 1) == 1) {
$wpml_join = "RIGHT JOIN " . $wpdb->base_prefix . "icl_translations ON ({$wpdb->posts}.ID = " . $wpdb->base_prefix . "icl_translations.element_id AND " . $wpdb->base_prefix . "icl_translations.language_code = '" . ICL_LANGUAGE_CODE . "')";
}
/*---------------------------------------------------------------*/
$orderby = isset($searchData['selected-orderby']) && $searchData['selected-orderby'] != '' ? $searchData['selected-orderby'] : "post_date DESC";
$querystr = "\r\n \t\tSELECT \r\n {$wpdb->posts}.post_title as title,\r\n {$wpdb->posts}.ID as id,\r\n {$wpdb->posts}.post_date as date, \r\n {$wpdb->posts}.post_content as content,\r\n {$wpdb->posts}.post_excerpt as excerpt,\r\n {$wpdb->users}.user_nicename as author,\r\n 'pagepost' as content_type,\r\n {$wpdb->posts}.post_type as post_type,\r\n ({$cf_select}) as meta_matches,\r\n CASE WHEN " . $_prefix . "ajaxsearchpro_priorities.priority IS NULL\r\n THEN 100\r\n ELSE " . $_prefix . "ajaxsearchpro_priorities.priority\r\n END AS priority,\r\n CONCAT('--', GROUP_CONCAT(DISTINCT {$wpdb->terms}.term_id SEPARATOR '----'), '--') as ttid,\r\n {$wpdb->posts}.post_type as post_type,";
if ($searchData['userelevance'] == 1 && $relevance != '') {
$querystr .= $relevance;
} else {
$querystr .= "1 ";
}
$querystr .= "\r\n as relevance\r\n \t\tFROM {$wpdb->posts}\r\n LEFT JOIN {$wpdb->postmeta} ON {$wpdb->postmeta}.post_id = {$wpdb->posts}.ID\r\n LEFT JOIN " . $_prefix . "ajaxsearchpro_priorities ON (" . $_prefix . "ajaxsearchpro_priorities.post_id = {$wpdb->posts}.ID AND " . $_prefix . "ajaxsearchpro_priorities.blog_id = " . get_current_blog_id() . ")\r\n LEFT JOIN {$wpdb->users} ON {$wpdb->users}.ID = {$wpdb->posts}.post_author\r\n LEFT JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID = {$wpdb->term_relationships}.object_id\r\n LEFT JOIN {$wpdb->term_taxonomy} ON {$wpdb->term_taxonomy}.term_taxonomy_id = {$wpdb->term_relationships}.term_taxonomy_id\r\n LEFT JOIN {$wpdb->terms} ON {$wpdb->term_taxonomy}.term_id = {$wpdb->terms}.term_id\r\n {$wpml_join}\r\n \t\tWHERE\r\n {$post_types}\r\n AND {$post_statuses}\r\n AND (" . $match_against . " OR (" . $like_query . "))\r\n AND (" . $exclude_posts . ")\r\n GROUP BY\r\n {$wpdb->posts}.ID\r\n {$term_query}\r\n {$cf_having}\r\n ";
$querystr .= " ORDER BY priority DESC, relevance DESC, " . $wpdb->posts . "." . $orderby . "\r\n LIMIT " . $searchData['maxresults'];
$pageposts = $wpdb->get_results($querystr, OBJECT);
//var_dump($querystr); var_dump($pageposts);die("!!");
$this->results = $pageposts;
return $pageposts;
}
<?php
/* Prevent direct access */
defined('ABSPATH') or die("You can't access this file directly.");
$com_options = get_option('asp_compatibility');
$ful_options = get_option('asp_fulltexto');
$fulltext = wpdreamsFulltext::getInstance();
/**
* @deprecated since 4.5
* $fulltext_enabled = $fulltext->check(array('posts'));
* $fulltext_indexed = $fulltext->indexExists('posts', 'asp_title');
*/
$fulltext_enabled = false;
$fulltext_indexed = false;
if (ASP_DEMO) {
$_POST = null;
}
?>
<div id="wpdreams" class='wpdreams wrap'>
<div class="wpdreams-box">
<?php
ob_start();
?>
<div tabid="1">
<fieldset>
<legend>CSS and JS compatibility</legend>
<?php
