1) { // Avoid stemming single letters
// Remove 's' (e.g., 'inspections' -> 'inspection')
if (substr($word, -1) === 's') {
$variations[] = substr($word, 0, -1);
} else { // Add 's' (e.g., 'inspection' -> 'inspections')
$variations[] = $word . 's';
}
// Handle 'er' suffix (e.g., 'inspector' -> 'inspect')
if (substr($word, -2) === 'er') {
$variations[] = substr($word, 0, -2);
}
// Handle 'ing' suffix (e.g., 'inspecting' -> 'inspect')
if (substr($word, -3) === 'ing') {
$variations[] = substr($word, 0, -3);
}
// Add 'er' if the base word is 'inspect' and 'inspector' is not present
if (strpos($word, 'inspect') !== false && strpos($word, 'inspector') === false) {
$variations[] = str_replace('inspect', 'inspector', $word);
}
}
$all_word_variations[] = array_filter(array_unique($variations));
}
return $all_word_variations;
}
}
// Filter function to modify WP_Query search for flexible matching
if ( ! function_exists( 'wpbot_flexible_search_filter' ) ) {
function wpbot_flexible_search_filter($search, $wp_query) {
global $wpdb, $wpbot_search_word_variations;
// Only apply if it's the main search query and our variations are set
if (empty($wpbot_search_word_variations) || !$wp_query->is_search || !$wp_query->is_main_query()) {
return $search;
}
$search_parts_for_and = [];
foreach ($wpbot_search_word_variations as $word_variations) {
$search_parts_for_or = [];
foreach ($word_variations as $term) {
$term = $wpdb->esc_like($term);
// Search in both post_title and post_content
$search_parts_for_or[] = "(({$wpdb->posts}.post_title LIKE '%{$term}%') OR ({$wpdb->posts}.post_content LIKE '%{$term}%'))";
}
if (!empty($search_parts_for_or)) {
$search_parts_for_and[] = '(' . implode(' OR ', $search_parts_for_or) . ')';
}
}
if (!empty($search_parts_for_and)) {
// Completely replace the default search clause generated by WP_Query's 's' parameter
// This ensures our flexible matching takes precedence.
$search = ' AND ' . implode(' AND ', $search_parts_for_and);
}
return $search;
}
}
function wpbo_search_site() {
// Verify nonce for security
$nonce = isset($_POST['security']) ? sanitize_text_field(wp_unslash($_POST['security'])) : (isset($_POST['nonce']) ? sanitize_text_field(wp_unslash($_POST['nonce'])) : '');
if ( ! wp_verify_nonce( $nonce, 'wp_chatbot' ) && ! wp_verify_nonce( $nonce, 'qcsecretbotnonceval123qc' ) ) {
wp_send_json_error( array( 'status' => 'fail', 'message' => 'Security check failed.' ) );
wp_die();
}
global $wpdb;
// Limit results to 5 items.
$limit = 5;
$response = array('status' => 'fail', 'html' => ''); // Initialize response array
// Get default language for load more button text and other language-specific checks.
$default_language = get_locale();
if(get_option('enable_wp_chatbot_post_content') == 1){
$keyword = isset( $_POST['keyword'] ) ? sanitize_text_field(wp_unslash($_POST['keyword'])) : '';
$all_word_variations = _wpbot_generate_word_variations($keyword);
// Temporarily store the variations for the filter
global $wpbot_search_word_variations;
$wpbot_search_word_variations = $all_word_variations;
// Add the custom search filter
add_filter('posts_search', 'wpbot_flexible_search_filter', 10, 2);
$enable_post_types = array( 'post', 'page', 'product' );
$total_items = $limit;
$query_arg = array(
'post_type' => $enable_post_types,
'post_status' => 'publish',
'posts_per_page'=> $total_items,
's' => stripslashes( $keyword ), // Keep original for WP_Query to initiate search, filter will override
'paged' => 1,
'suppress_filters' => false // Crucial for filters to run
);
$resultss = new WP_Query( $query_arg );
$results = $resultss->posts;
// Remove the filter after the query to avoid affecting other queries
remove_filter('posts_search', 'wpbot_flexible_search_filter', 10);
unset($wpbot_search_word_variations); // Clean up global
}else{
$keyword = isset( $_POST['keyword'] ) ? sanitize_text_field(wp_unslash($_POST['keyword'])) : '';
$all_word_variations = _wpbot_generate_word_variations($keyword);
$sql_parts_for_and = [];
$sql_params = [];
foreach ($all_word_variations as $word_variations) {
$sql_parts_for_or = [];
foreach ($word_variations as $term) {
$sql_parts_for_or[] = "post_title LIKE %s";
$sql_params[] = '%' . $wpdb->esc_like($term) . '%';
}
if (!empty($sql_parts_for_or)) {
$sql_parts_for_and[] = '(' . implode(' OR ', $sql_parts_for_or) . ')';
}
}
$where_clause = '';
if (!empty($sql_parts_for_and)) {
$where_clause = ' AND ' . implode(' AND ', $sql_parts_for_and);
} else {
// Fallback to original behavior if no variations generated (e.g., empty keyword)
$where_clause = " AND (post_title LIKE %s)";
$sql_params[] = '%' . $wpdb->esc_like($keyword) . '%';
}
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter
$results = $wpdb->get_results( $wpdb->prepare(
"SELECT * FROM " . $wpdb->prefix . "posts WHERE post_status = %s " . $where_clause . " ORDER BY ID DESC LIMIT %d",
array_merge(['publish'], $sql_params, [$limit])
) );
}
if(!empty( $results )){
$response['status'] = 'success';
$response['html'] = '';
$total_post = 0;
$responses = '';
foreach ( $results as $result ) {
$featured_img_url = get_the_post_thumbnail_url( $result->ID, 'full' );
$excerpt = '';
if ( isset( $result->ID ) ) {
$post_obj = get_post( $result->ID );
if ( $post_obj ) {
if ( has_excerpt( $result->ID ) ) {
$excerpt = get_the_excerpt( $result->ID );
} else {
$content = $post_obj->post_content;
// Remove ALL WPBakery shortcodes (paired + self-closing)
$content = preg_replace( '/\[vc_[^\]]*\](.*?)\[\/vc_[^\]]*\]/s', '$1', $content ); // paired
$content = preg_replace( '/\[vc_[^\]]*\]/s', '', $content ); // self-closing
$content = preg_replace('/\[\/?[\w\-]+[^\]]*\]/', '', $content);
// Extra: remove any leftover [] shortcodes (just in case)
$content = strip_shortcodes( $content );
// Run through normal WP content filters
$content_filtered = apply_filters( 'the_content', $content );
// Strip HTML tags, then trim
$excerpt = wp_trim_words( wp_strip_all_tags( $content_filtered ), 20, '...' );
}
}
}
$total_post = $total_post + 1;
$responses .='
';
$responses .= '
';
$responses .='
';
}
$response['html'] .= $responses;
$response['html'] .='
'. ( !empty($load_more) && isset($load_more[$default_language]) ? $load_more[$default_language] : 'Load More').' ';
}
}else{
// Fuzzy search if initial search yields no results
$response['status'] = 'success';
// Use the same word variation logic for fuzzy search
$all_word_variations_for_fuzzy = _wpbot_generate_word_variations($keyword);
$unique_posts = array(); // Store unique post objects
$seen_ids = array(); // Keep track of seen post IDs
// Iterate through each word's variations to find matching posts
foreach ( $all_word_variations_for_fuzzy as $word_variations ) {
foreach ($word_variations as $term) {
$term = $wpdb->esc_like( $term );
$term_results = $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$wpdb->prepare("SELECT * FROM ". $wpdb->prefix."posts WHERE post_type IN (%s, %s) AND post_status = %s AND (post_title LIKE %s) ORDER BY ID DESC", 'page', 'post', 'publish', '%'. $term .'%')
);
foreach ($term_results as $res) {
if (!in_array($res->ID, $seen_ids)) {
$unique_posts[] = $res;
$seen_ids[] = $res->ID;
}
}
}
}
$results = $unique_posts; // Now $results contains unique WP_Post objects
if( !empty( $results) ){
$response['html'] = '';
$total_post = 0;
$responses = '';
$selected_lan = get_option('qlcd_wp_chatbot_default_language');
foreach ($results as $value) { // $value is a single post object here
if(!empty($value->guid)){
$post_id = $value->ID;
$current_featured_img_url = get_the_post_thumbnail_url( $post_id, 'full' );
// Corrected URL segment parsing for language check
$url_path = wp_parse_url(get_permalink($post_id), PHP_URL_PATH);
$url_segments = array_filter(explode('/',$url_path));
// Assuming the language slug is the first non-empty segment of the URL path.
$first_segment = !empty($url_segments) ? reset($url_segments) : '';
// If $selected_lan is empty, the language check is effectively skipped.
$language_match = empty($selected_lan) || ($first_segment == $selected_lan);
if($language_match){
$total_post = $total_post + 1;
$responses .='
';
$responses .= '
';
$responses .='
';
}
}
}
if($total_post > 2 ){ // This condition is different from the first block ($total_post >= $limit)
$load_more = maybe_unserialize(get_option('qlcd_wp_chatbot_load_more_search'));
$response['html'] .='
'. ( !empty($load_more) && isset($load_more[$default_language]) ? $load_more[$default_language] : 'Load More').' ';
$response['status'] = 'success';
}else{
$response['status'] = 'fail';
}
$response['html'] .= $responses;
$response['html'] .='
';
foreach ( $total_results as $result ) {
if ( $result->post_type == 'product' ) {
if ( ! class_exists( 'WooCommerce' ) ) {
continue;
}
}
$featured_img_url = get_the_post_thumbnail_url( $result->ID, $thumb );
$excerpt = '';
if ( isset( $result->ID ) ) {
$post_obj = get_post( $result->ID );
if ( $post_obj ) {
if ( has_excerpt( $result->ID ) ) {
$excerpt = get_the_excerpt( $result->ID );
} else {
$content = $post_obj->post_content;
// Remove ALL WPBakery shortcodes (paired + self-closing)
$content = preg_replace( '/\[vc_[^\]]*\](.*?)\[\/vc_[^\]]*\]/s', '$1', $content ); // paired
$content = preg_replace( '/\[vc_[^\]]*\]/s', '', $content ); // self-closing
$content = preg_replace('/\[\/?[\w\-]+[^\]]*\]/', '', $content);
// Extra: remove any leftover [] shortcodes (just in case)
$content = strip_shortcodes( $content );
// Run through normal WP content filters
$content_filtered = apply_filters( 'the_content', $content );
// Strip HTML tags, then trim
$excerpt = wp_trim_words( wp_strip_all_tags( $content_filtered ), 20, '...' );
}
}
}
$response['html'] .= '
';
$response['html'] .= '
';
$response['html'] .= '
';
}
$response['html'] .= '
' . esc_html__( 'Offer Details', 'wpchatbot' ) . ':
' . str_replace( '%%username%%', $name, $offertexts[ array_rand( $offertexts ) ] ) . '
';
} elseif ( is_string( $offertexts ) && ! empty( $offertexts ) ) {
$bodyContent .= '' . str_replace( '%%username%%', $name, $offertexts ) . '
';
} else {
$bodyContent .= '
';
}
$bodyContent .= '' . esc_html__( 'Mail Generated on', 'wpchatbot' ) . ': ' . current_time( 'F j, Y, g:i a' ) . '
';
$to = $toEmail;
$body = $bodyContent;
$headers = array();
$headers[] = 'Content-Type: text/html; charset=UTF-8';
$headers[] = 'From: ' . $fromname . ' <' . $fromEmail . '>';
$headers[] = 'Reply-To: ' . $fromname . ' <' . ( $replyto ) . '>';
wp_mail( $to, $subject, $body, $headers );
$response['email'] = 'Send! to ' . $to . ' from ' . $fromEmail;
}
echo json_encode( $response );
die();
}
}
add_action( 'wp_ajax_qcld_wb_chatbot_email_subscription', 'qcld_wb_chatbot_email_subscription' );
add_action( 'wp_ajax_nopriv_qcld_wb_chatbot_email_subscription', 'qcld_wb_chatbot_email_subscription' );
add_action( 'admin_post_wpbprint.csv', 'qcld_wpb_export_email_csv' );
if ( ! function_exists( 'qcld_wpbd_array2csv' ) ) {
function qcld_wpbd_array2csv( array &$array ) {
if ( count( $array ) == 0 ) {
return null;
}
ob_start();
$df = fopen( 'php://output', 'w' );
fputcsv( $df, array( 'Name', 'Email' ), ',', '"', '\\' );
foreach ( $array as $row ) {
fputcsv( $df, $row, ',', '"', '\\' );
}
fclose( $df );
return ob_get_clean();
}
}
function qcld_wpb_export_email_csv() {
global $wpdb;
$table = $wpdb->prefix . 'wpbot_subscription';
if ( ! current_user_can( 'manage_options' ) ) {
return;
}
$emails = $wpdb->get_results( $wpdb->prepare( "select * from %i WHERE %d", $table, 1 ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter
$childArray = array();
foreach ( $emails as $email ) {
$innerArray = array();
$innerArray[0] = $email->name;
$innerArray[1] = $email->email;
array_push( $childArray, $innerArray );
}
qcld_wpbd_download_send_headers( 'wpb_email_lists_' . current_time( 'Y-m-d' ) . '.csv' );
$result = qcld_wpbd_array2csv( $childArray );
print $result; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped
die();
}
function qcld_wpbd_download_send_headers( $filename ) {
// disable caching
$now = gmdate( 'D, d M Y H:i:s' );
header( 'Expires: Tue, 03 Jul 2001 06:00:00 GMT' );
header( 'Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate' );
header( "Last-Modified: {$now} GMT" );
// force download
header( 'Content-Type: application/force-download' );
// disposition / encoding on response body
header( "Content-Disposition: attachment;filename={$filename}" );
header( 'Content-Transfer-Encoding: binary' );
}
add_action( 'wp_ajax_wpbo_search_response_catlist', 'wpbo_search_response_catlist' );
add_action( 'wp_ajax_nopriv_wpbo_search_response_catlist', 'wpbo_search_response_catlist' );
if( !function_exists( 'wpbo_search_response_catlist' )){
function wpbo_search_response_catlist(){
global $wpdb;
$table = $wpdb->prefix.'wpbot_response_category';
$status = array('status'=>'fail');
$results = $wpdb->get_results($wpdb->prepare("SELECT * FROM %i", $table)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$response_result = array();
if(!empty($results)){
foreach($results as $result){
$response_result[] = array('name'=>$result->name);
}
}
if(!empty($response_result)){
$status = array('status'=>'success', 'data'=>$response_result);
}
echo wp_json_encode($status);
die();
}
}
add_action( 'wp_ajax_wpbo_search_response', 'qcld_wpbo_search_response' );
add_action( 'wp_ajax_nopriv_wpbo_search_response', 'qcld_wpbo_search_response' );
function qcld_wpbo_search_response(){
global $wpdb;
$keyword = isset( $_POST['keyword'] ) ? (sanitize_text_field(wp_unslash($_POST['keyword']))) : '';
$strid = isset( $_POST['strid'] ) ? (sanitize_text_field(wp_unslash($_POST['strid']))) : '';
$table = $wpdb->prefix.'wpbot_response';
$response_result = array();
$status = array('status'=>'fail', 'multiple'=>false);
$field = "ID";
if(($strid != '') && empty($response_result)){
$results = $wpdb->get_results($wpdb->prepare("SELECT * FROM %i WHERE %i = %d",$table,$field,$strid)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
if(!empty($results)){
foreach($results as $result){
$response_result[] = array('id'=>$result->id,'query'=>$result->query, 'response'=>$result->response, 'score'=>1);
}
}
}
$field = "query";
$results = $wpdb->get_results( $wpdb->prepare("SELECT `id`, `query`, `response` FROM %i WHERE 1 and %i = %s", $table, $field,$keyword) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
if(!empty($results)){
foreach($results as $result){
$response_result[] = array('id'=>$result->id,'query'=>$result->query, 'response'=>$result->response, 'score'=>1);
}
}
$field = "category";
if(empty($response_result)){
$results = $wpdb->get_results( $wpdb->prepare("SELECT `id`, `query`, `response` FROM %i WHERE 1 and %i = %s", $table,$field, $keyword) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
if(!empty($results)){
foreach($results as $result){
$response_result[] = array('id'=>$result->id,'query'=>$result->query, 'response'=>$result->response, 'score'=>1);
}
if(count($response_result)>1){
$status = array('status'=>'success','category'=> true, 'multiple'=>true, 'data'=>$response_result);
}else{
$status = array('status'=>'success', 'category'=> true, 'multiple'=>false, 'data'=>$response_result);
}
echo wp_json_encode($status);
die();
}
}
if(class_exists('Qcld_str_pro')){
if(get_option('qc_bot_str_remove_stopwords') && get_option('qc_bot_str_remove_stopwords')==1){
$keyword = qcld_strpro_remove_stopwords($keyword);
}
}
if(empty($response_result)){
$fields = get_option('qc_bot_str_fields');
$allowed_fields = array('query', 'keyword', 'response');
$valid_fields = array();
if($fields && !empty($fields) && is_array($fields)){
foreach($fields as $field){
if(in_array($field, $allowed_fields)){
$valid_fields[] = '`' . $field . '`';
}
}
}
if(!empty($valid_fields)){
$qfields = implode(', ', $valid_fields);
}else{
$qfields = '`query`,`keyword`,`response`';
}
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter
$results = $wpdb->get_results( $wpdb->prepare("SELECT `id`, `query`, `response`, MATCH($qfields) AGAINST(%s IN NATURAL LANGUAGE MODE) as score FROM %i WHERE MATCH($qfields) AGAINST(%s IN NATURAL LANGUAGE MODE) order by score desc limit 15",$keyword,$table,$keyword) );
$weight = get_option('qc_bot_str_weight')!=''?get_option('qc_bot_str_weight'):'0.4';
if(!empty($results)){
$max_score = max(array_column($results, 'score'));
if ($max_score <= 0) {
$max_score = 1; // Set to 1 to avoid division by zero
}
foreach($results as $result){
if(($result->score/$max_score) >= $weight){
$response_result[] = array('id'=>$result->id,'query'=>$result->query, 'response'=>$result->response, 'score'=>$result->score);
}
}
}
}
$field = "keyword";
if( empty( $response_result ) ){
$results = $wpdb->get_results($wpdb->prepare("SELECT * FROM %i WHERE %i REGEXP %s", $table,$field,$keyword)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
if(!empty($results)){
foreach($results as $result){
$response_result[] = array('id'=>$result->id,'query'=>$result->query, 'response'=>$result->response, 'score'=>1);
}
}
}
if(!empty($response_result)){
if(count($response_result)>1){
$status = array('status'=>'success', 'multiple'=>true, 'data'=>$response_result);
}else{
$status = array('status'=>'success', 'multiple'=>false, 'data'=>$response_result);
}
}
if(empty($result->query)){
$status = array('status'=>'fail', 'multiple'=>false, 'data'=>$response_result);
}
if(empty($status['data']) || (isset($status['status']) && $status['status']==='fail')){
// Check for space before question mark and try again.
if(preg_match('/ \?$/', $keyword)){
$keyword2 = preg_replace('/ \?$/', '?', $keyword);
// Try again with new keyword.
// Repeat the main search logic with $keyword2.
$response_result = array();
$field = "query";
$results = $wpdb->get_results( $wpdb->prepare("SELECT `id`, `query`, `response` FROM %i WHERE 1 and %i = %s", $table, $field, $keyword2) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
if(!empty($results)){
foreach($results as $result){
$response_result[] = array('id'=>$result->id,'query'=>$result->query, 'response'=>$result->response, 'score'=>1);
}
if(count($response_result)>1){
$status = array('status'=>'success', 'multiple'=>true, 'data'=>$response_result);
}else{
$status = array('status'=>'success', 'multiple'=>false, 'data'=>$response_result);
}
}else{
$status = array('status'=>'fail', 'multiple'=>false, 'data'=>[]);
}
}
}
if(empty($status['data']) || (isset($status['status']) && $status['status']==='fail')){
// Try a partial match if still nothing found.
if(empty($status['data'])) {
$keyword_like = '%' . preg_replace('/[\\s\\?]+/', '%', $keyword) . '%';
$results = $wpdb->get_results( $wpdb->prepare("SELECT `id`, `query`, `response` FROM %i WHERE `query` LIKE %s", $table, $keyword_like) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$response_result = array();
if(!empty($results)){
foreach($results as $result){
$response_result[] = array('id'=>$result->id,'query'=>$result->query, 'response'=>$result->response, 'score'=>1);
}
if(count($response_result)>1){
$status = array('status'=>'success', 'multiple'=>true, 'data'=>$response_result);
}else{
$status = array('status'=>'success', 'multiple'=>false, 'data'=>$response_result);
}
} else {
$status = array('status'=>'fail', 'multiple'=>false, 'data'=>[], 'message'=>'Sorry, I found nothing');
}
}
}
if(empty($status['data'])){
$status = array('status'=>'fail', 'multiple'=>false, 'data'=>[], 'message'=>'no result found');
}
echo wp_json_encode($status);
die();
}
function qcld_strpro_remove_stopwords($keyword){
if(get_option('qlcd_wp_chatbot_stop_words') && get_option('qlcd_wp_chatbot_stop_words')!=''){
$commonWords = explode(',', get_option('qlcd_wp_chatbot_stop_words'));
return preg_replace('/\b('.implode('|',$commonWords).')\b/','',$keyword);
}else{
return $keyword;
}
}