| @@ -14,9 +14,9 @@ | ||
| 14 | 14 | $wp_chatbot_custom_agent_path = QCLD_wpCHATBOT_IMG_URL . get_option('wp_chatbot_agent_image'); |
| 15 | 15 | } else { |
| 16 | 16 | $wp_chatbot_custom_agent_path = QCLD_wpCHATBOT_IMG_URL . 'custom-agent.png'; |
| 17 | 17 | } |
| 18 | - $hidden_field = '<a class="wp-chatbot qc_wpbot_chat_link" id="wp-chatbot-search-btn" data-search-type="product" data-search-term="" style="max-height: 50px; margin-left: 10px;padding: 0 !important;position: absolute;top: -9px;right: -60px;"><img src="'. esc_url($wp_chatbot_custom_agent_path) .'" alt=""></a>'; | |
| 18 | + $hidden_field = '<a class="wp-chatbot qc_wpbot_chat_link" id="wp-chatbot-search-btn" data-search-type="product" data-search-term="" style="max-height: 50px; margin-left: 10px;padding: 0 !important;position: absolute;top: -9px;right: -60px;"><img src="'. esc_attr($wp_chatbot_custom_agent_path) .'" alt=""></a>'; | |
| 19 | 19 | $block_content = str_replace( '</form>', $hidden_field . '</form>', $form ); |
| 20 | 20 | return $block_content; |
| 21 | 21 | } |
| 22 | 22 | if(get_option('wpbot_enable_on_search') == 1 && (get_option('disable_floating_button') != '1') && get_option('disable_wp_chatbot') != 1 ){ |
| @@ -33,9 +33,9 @@ | ||
| 33 | 33 | $wp_chatbot_custom_agent_path = QCLD_wpCHATBOT_IMG_URL . get_option('wp_chatbot_agent_image'); |
| 34 | 34 | } else { |
| 35 | 35 | $wp_chatbot_custom_agent_path = QCLD_wpCHATBOT_IMG_URL . 'custom-agent.png'; |
| 36 | 36 | } |
| 37 | - $hidden_field = '<button type="button" class="wp-chatbot qc_wpbot_chat_link" id="wp-chatbot-search-btn" data-search-type="product" data-search-term="" style="max-height: 50px; margin-left: 10px;padding: 0 !important"><img src="'. esc_url($wp_chatbot_custom_agent_path) .'" alt=""></button>'; | |
| 37 | + $hidden_field = '<button type="button" class="wp-chatbot qc_wpbot_chat_link" id="wp-chatbot-search-btn" data-search-type="product" data-search-term="" style="max-height: 50px; margin-left: 10px;padding: 0 !important"><img src="'. esc_attr($wp_chatbot_custom_agent_path) .'" alt=""></button>'; | |
| 38 | 38 | // Inject the hidden field before the closing </form> tag |
| 39 | 39 | $block_content = str_replace( '</div></form>', $hidden_field . '</div></form>', $block_content ); |
| 40 | 40 | return $block_content; |
| 41 | 41 | } |
| @@ -58,62 +58,8 @@ | ||
| 58 | 58 | }); |
| 59 | 59 | </script> |
| 60 | 60 | <?php |
| 61 | 61 | } |
| 62 | -/** | |
| 63 | - * Extract a YouTube video ID from common URL formats. | |
| 64 | - * | |
| 65 | - * @param string $url YouTube watch, embed, short, or youtu.be URL. | |
| 66 | - * @return string Video ID or empty string. | |
| 67 | - */ | |
| 68 | -if ( ! function_exists( 'qcld_wpbot_extract_youtube_id' ) ) { | |
| 69 | - function qcld_wpbot_extract_youtube_id( $url ) { | |
| 70 | - $url = trim( (string) $url ); | |
| 71 | - if ( $url === '' ) { | |
| 72 | - return ''; | |
| 73 | - } | |
| 74 | - | |
| 75 | - if ( preg_match( '/(?:youtube\.com\/(?:embed\/|shorts\/|live\/|watch\?(?:.*&)?v=)|youtu\.be\/)([A-Za-z0-9_-]{11})/', $url, $matches ) ) { | |
| 76 | - return $matches[1]; | |
| 77 | - } | |
| 78 | - | |
| 79 | - $path = (string) wp_parse_url( $url, PHP_URL_PATH ); | |
| 80 | - $base = basename( $path ); | |
| 81 | - if ( preg_match( '/^[A-Za-z0-9_-]{11}$/', $base ) ) { | |
| 82 | - return $base; | |
| 83 | - } | |
| 84 | - | |
| 85 | - return ''; | |
| 86 | - } | |
| 87 | -} | |
| 88 | -if ( ! function_exists( 'qcld_wpbot_youtube_icon_embed_src' ) ) { | |
| 89 | - function qcld_wpbot_youtube_icon_embed_src( $url ) { | |
| 90 | - $video_id = qcld_wpbot_extract_youtube_id( $url ); | |
| 91 | - if ( $video_id === '' ) { | |
| 92 | - return ''; | |
| 93 | - } | |
| 94 | - | |
| 95 | - return add_query_arg( | |
| 96 | - array( | |
| 97 | - 'autoplay' => '1', | |
| 98 | - 'mute' => '1', | |
| 99 | - 'loop' => '1', | |
| 100 | - 'playlist' => $video_id, | |
| 101 | - 'controls' => '0', | |
| 102 | - 'showinfo' => '0', | |
| 103 | - 'rel' => '0', | |
| 104 | - 'fs' => '0', | |
| 105 | - 'iv_load_policy' => '3', | |
| 106 | - 'cc_load_policy' => '0', | |
| 107 | - 'disablekb' => '1', | |
| 108 | - 'playsinline' => '1', | |
| 109 | - 'modestbranding' => '1', | |
| 110 | - 'color' => 'white', | |
| 111 | - ), | |
| 112 | - 'https://www.youtube.com/embed/' . rawurlencode( $video_id ) | |
| 113 | - ); | |
| 114 | - } | |
| 115 | -} | |
| 116 | 62 | function wp_chatbot_load_footer_html(){ |
| 117 | 63 | if ( get_option('disable_wp_chatbot') != 1 && wp_chatbot_load_controlling() === true) { |
| 118 | 64 | |
| 119 | 65 | ?> |
| @@ -119,9 +65,9 @@ | ||
| 119 | 65 | ?> |
| 120 | 66 | <style> |
| 121 | 67 | <?php if(get_option('wp_chatbot_custom_css')!="") { |
| 122 | 68 | |
| 123 | - echo wp_strip_all_tags( get_option('wp_chatbot_custom_css') );// phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped | |
| 69 | + echo wp_strip_all_tags( get_option('wp_chatbot_custom_css') ); | |
| 124 | 70 | } |
| 125 | 71 | ?> |
| 126 | 72 | </style> |
| 127 | 73 | |
| @@ -133,27 +79,10 @@ | ||
| 133 | 79 | } |
| 134 | 80 | ?> |
| 135 | 81 | <style> |
| 136 | 82 | .wp-chatbot-container { |
| 137 | - background-color: #eceef3 !important; | |
| 138 | 83 | background-image: url(<?php echo esc_url($qcld_wb_chatbot_board_bg_path); ?>) !important; |
| 139 | - background-size: cover !important; | |
| 140 | - background-position: center !important; | |
| 141 | - background-repeat: no-repeat !important; | |
| 142 | 84 | } |
| 143 | - .wp-chatbot-template-01 #wp-chatbot-board-container, | |
| 144 | - .wp-chatbot-template-01 .wp-chatbot-board-container { | |
| 145 | - background-color: #eceef3 !important; | |
| 146 | - background-image: none !important; | |
| 147 | - } | |
| 148 | - .wp-chatbot-template-01 #wp-chatbot-board-container::before, | |
| 149 | - .wp-chatbot-template-01 .wp-chatbot-board-container::before { | |
| 150 | - background-color: #eceef3 !important; | |
| 151 | - background-image: url(<?php echo esc_url($qcld_wb_chatbot_board_bg_path); ?>) !important; | |
| 152 | - background-size: cover !important; | |
| 153 | - background-position: center !important; | |
| 154 | - background-repeat: no-repeat !important; | |
| 155 | - } | |
| 156 | 85 | </style> |
| 157 | 86 | <?php } |
| 158 | 87 | $wp_chatbot_enable_rtl = ""; |
| 159 | 88 | if (get_option('enable_wp_chatbot_rtl') == '1') { |
| @@ -226,9 +155,9 @@ | ||
| 226 | 155 | } |
| 227 | 156 | ?> |
| 228 | 157 | <div class="wp-chatbot-notification-agent-profile"> |
| 229 | 158 | <div class="wp-chatbot-notification-widget-avatar" ><img |
| 230 | - src="<?php echo esc_url($wp_chatbot_custom_agent_path); ?>" alt=""></div> | |
| 159 | + src="<?php echo esc_attr($wp_chatbot_custom_agent_path); ?>" alt=""></div> | |
| 231 | 160 | <div class="wp-chatbot-notification-welcome"><?php echo wp_kses_post(wpb_randmom_message_handle(maybe_unserialize(get_option('qlcd_wp_chatbot_welcome')))) . ' <strong>' . esc_html(get_option('qlcd_wp_chatbot_host')) . '</strong>'; ?></div> |
| 232 | 161 | </div> |
| 233 | 162 | <?php |
| 234 | 163 | //update_option('qlcd_wp_chatbot_notifications','Welcome to WpBot'); |
| @@ -251,72 +180,14 @@ | ||
| 251 | 180 | $wp_chatbot_custom_icon_path = QCLD_wpCHATBOT_IMG_URL . get_option('wp_chatbot_icon'); |
| 252 | 181 | } else { |
| 253 | 182 | $wp_chatbot_custom_icon_path = QCLD_wpCHATBOT_IMG_URL . 'custom.png'; |
| 254 | 183 | } |
| 255 | - $_wpbot_icon_video = get_option('wp_chatbot_icon_video', ''); | |
| 256 | - $_wpbot_video_is_youtube = ( strpos( $_wpbot_icon_video, 'youtube.com' ) !== false || strpos( $_wpbot_icon_video, 'youtu.be' ) !== false ); | |
| 257 | - $_wpbot_youtube_embed_src = $_wpbot_video_is_youtube ? qcld_wpbot_youtube_icon_embed_src( $_wpbot_icon_video ) : ''; | |
| 258 | - $_wpbot_video_delay_ms = absint( get_option( 'wp_chatbot_icon_video_delay', 0 ) ) * 1000; | |
| 259 | - | |
| 260 | - $wp_chatbot_ball_is_youtube = ($_wpbot_icon_video !== '' && (strpos($_wpbot_icon_video, 'youtube.com') !== false || strpos($_wpbot_icon_video, 'youtu.be') !== false)); | |
| 261 | - $wp_chatbot_ball_is_video = ($_wpbot_icon_video !== '' && !$wp_chatbot_ball_is_youtube); | |
| 262 | - $wp_chatbot_ball_has_video = ($wp_chatbot_ball_is_youtube || $wp_chatbot_ball_is_video); | |
| 263 | 184 | ?> |
| 264 | 185 | <img src="<?php echo esc_url($wp_chatbot_custom_icon_path); ?>" |
| 265 | - alt="wpChatIcon" qcld_agent="<?php echo esc_url($wp_chatbot_custom_icon_path); ?>" | |
| 266 | - id="wp-chatbot-ball-icon-img" | |
| 267 | - <?php if ($wp_chatbot_ball_has_video) { echo 'style="display:none;"'; } ?> > | |
| 268 | - <?php if ( $_wpbot_icon_video !== '' ) : ?> | |
| 269 | - <?php if ( $_wpbot_video_is_youtube && $_wpbot_youtube_embed_src !== '' ) : ?> | |
| 270 | - <iframe class="wpbot-icon-video" src="<?php echo $_wpbot_video_delay_ms > 0 ? 'about:blank' : esc_url( $_wpbot_youtube_embed_src ); ?>" data-wpbot-yt-src="<?php echo esc_url( $_wpbot_youtube_embed_src ); ?>" frameborder="0" allow="autoplay; fullscreen; encrypted-media; picture-in-picture"></iframe> | |
| 271 | - <?php elseif ( ! $_wpbot_video_is_youtube ) : ?> | |
| 272 | - <video class="wpbot-icon-video" src="<?php echo esc_url( $_wpbot_icon_video ); ?>" autoplay muted loop playsinline preload="auto"></video> | |
| 273 | - <?php endif; ?> | |
| 274 | - <?php endif; ?> | |
| 186 | + alt="wpChatIcon" qcld_agent="<?php echo esc_url($wp_chatbot_custom_icon_path); ?>" > | |
| 187 | + | |
| 275 | 188 | </div> |
| 276 | - | |
| 277 | 189 | </div> |
| 278 | - <?php | |
| 279 | - if ( $_wpbot_icon_video !== '' ) : | |
| 280 | - ?> | |
| 281 | - <script> | |
| 282 | - (function(){ | |
| 283 | - var wpbotDelay = <?php echo (int) $_wpbot_video_delay_ms; ?>; | |
| 284 | - function wpbotForcePlay(){ | |
| 285 | - var v = document.querySelector('#wp-chatbot-ball video.wpbot-icon-video'); | |
| 286 | - if( v ){ | |
| 287 | - v.muted = true; | |
| 288 | - v.volume = 0; | |
| 289 | - v.loop = true; | |
| 290 | - var tries = 0, maxTries = 30; | |
| 291 | - var timer = setInterval(function(){ | |
| 292 | - tries++; | |
| 293 | - v.play().then(function(){ clearInterval(timer); }).catch(function(){}); | |
| 294 | - if( tries >= maxTries ) clearInterval(timer); | |
| 295 | - }, 300); | |
| 296 | - } | |
| 297 | - var yt = document.querySelector('#wp-chatbot-ball iframe.wpbot-icon-video'); | |
| 298 | - if( yt ){ | |
| 299 | - var ytSrc = yt.getAttribute('data-wpbot-yt-src'); | |
| 300 | - if( ytSrc && ( !yt.getAttribute('src') || yt.getAttribute('src') === 'about:blank' || yt.getAttribute('src').indexOf('autoplay=1') === -1 ) ){ | |
| 301 | - yt.setAttribute('src', ytSrc); | |
| 302 | - } | |
| 303 | - } | |
| 304 | - } | |
| 305 | - function wpbotDelayedPlay(){ | |
| 306 | - setTimeout(wpbotForcePlay, wpbotDelay); | |
| 307 | - } | |
| 308 | - if( document.readyState === 'loading' ){ | |
| 309 | - document.addEventListener('DOMContentLoaded', wpbotDelayedPlay); | |
| 310 | - } else { | |
| 311 | - wpbotDelayedPlay(); | |
| 312 | - } | |
| 313 | - window.addEventListener('load', function(){ | |
| 314 | - setTimeout(wpbotForcePlay, wpbotDelay); | |
| 315 | - }); | |
| 316 | - })(); | |
| 317 | - </script> | |
| 318 | - <?php endif; ?> | |
| 319 | 190 | <?php |
| 320 | 191 | $fb_app_id = get_option('qlcd_wp_chatbot_fb_app_id'); |
| 321 | 192 | $fb_page_id = get_option('qlcd_wp_chatbot_fb_page_id'); |
| 322 | 193 | $fb_mgs_color = get_option('qlcd_wp_chatbot_fb_color') != '' ? get_option('qlcd_wp_chatbot_fb_color') : '#0084ff'; |
| @@ -467,15 +338,8 @@ | ||
| 467 | 338 | */ |
| 468 | 339 | add_action('wp_ajax_qcld_wb_chatbot_keyword', 'qcld_wb_chatbot_keyword'); |
| 469 | 340 | add_action('wp_ajax_nopriv_qcld_wb_chatbot_keyword', 'qcld_wb_chatbot_keyword'); |
| 470 | 341 | function qcld_wb_chatbot_keyword(){ |
| 471 | - // Verify nonce for security | |
| 472 | - $nonce = isset($_POST['security']) ? sanitize_text_field(wp_unslash($_POST['security'])) : (isset($_POST['nonce']) ? sanitize_text_field(wp_unslash($_POST['nonce'])) : ''); | |
| 473 | - if ( ! wp_verify_nonce( $nonce, 'wp_chatbot' ) && ! wp_verify_nonce( $nonce, 'qcsecretbotnonceval123qc' ) ) { | |
| 474 | - wp_send_json_error( array( 'status' => 'fail', 'message' => 'Security check failed.' ) ); | |
| 475 | - wp_die(); | |
| 476 | - } | |
| 477 | - | |
| 478 | 342 | $keyword = sanitize_text_field(wp_unslash($_POST['keyword'])); |
| 479 | 343 | $product_per_page = get_option('qlcd_wp_chatbot_ppp') != '' ? get_option('qlcd_wp_chatbot_ppp') : 10; |
| 480 | 344 | if (get_option('qlcd_wp_chatbot_search_option') == 'standard') { |
| 481 | 345 | $product_orderby = sanitize_text_field(get_option('qlcd_wp_chatbot_product_orderby') != '' ? get_option('qlcd_wp_chatbot_product_orderby') : 'title'); |
| @@ -522,9 +386,9 @@ | ||
| 522 | 386 | endwhile; |
| 523 | 387 | wp_reset_postdata(); |
| 524 | 388 | $html .= '</ul>'; |
| 525 | 389 | if ($total_product_num > $product_per_page && $product_per_page > 0 ) { |
| 526 | - $html .= '<p style="text-align: center"><button type="button" id="wp-chatbot-loadmore" data-offset="' . $product_per_page . '" data-search-type="product" data-search-term="' . esc_attr($keyword) . '" >' . wp_kses_post(wpb_randmom_message_handle(unserialize(get_option('qlcd_wp_chatbot_load_more')))) . ' <span id="wp-chatbot-loadmore-loader"></span></button> </p>'; | |
| 390 | + $html .= '<p style="text-align: center"><button type="button" id="wp-chatbot-loadmore" data-offset="' . $product_per_page . '" data-search-type="product" data-search-term="' . $keyword . '" >' . wp_kses_post(wpb_randmom_message_handle(unserialize(get_option('qlcd_wp_chatbot_load_more')))) . ' <span id="wp-chatbot-loadmore-loader"></span></button> </p>'; | |
| 527 | 391 | } |
| 528 | 392 | } |
| 529 | 393 | $html .= '</div>'; |
| 530 | 394 | } else if (get_option('qlcd_wp_chatbot_search_option') == 'advanced') { |
| @@ -552,9 +416,9 @@ | ||
| 552 | 416 | } |
| 553 | 417 | } |
| 554 | 418 | $html .= '</ul>'; |
| 555 | 419 | if ($total_product_num > $product_per_page && $product_per_page > 0) { |
| 556 | - $html .= '<p style="text-align: center"><button type="button" id="wp-chatbot-loadmore" data-offset="' . $product_per_page . '" data-search-type="product" data-search-term="' . esc_attr($more_product_ids) . '" >' . wp_kses_post(wpb_randmom_message_handle(unserialize(get_option('qlcd_wp_chatbot_load_more')))) . ' <span id="wp-chatbot-loadmore-loader"></span></button> </p>'; | |
| 420 | + $html .= '<p style="text-align: center"><button type="button" id="wp-chatbot-loadmore" data-offset="' . $product_per_page . '" data-search-type="product" data-search-term="' . $more_product_ids . '" >' . wp_kses_post(wpb_randmom_message_handle(unserialize(get_option('qlcd_wp_chatbot_load_more')))) . ' <span id="wp-chatbot-loadmore-loader"></span></button> </p>'; | |
| 557 | 421 | } |
| 558 | 422 | } |
| 559 | 423 | $html .= '</div>'; |
| 560 | 424 | } |
| @@ -1402,9 +1266,9 @@ | ||
| 1402 | 1266 | $html .= get_the_post_thumbnail(get_the_ID(), 'shop_catalog') . ' |
| 1403 | 1267 | <div class="wp-chatbot-product-summary"> |
| 1404 | 1268 | <div class="wp-chatbot-product-table"> |
| 1405 | 1269 | <div class="wp-chatbot-product-table-cell"> |
| 1406 | - <h3 class="wp-chatbot-product-title">' . esc_html($product->post->post_title) . '</h3> | |
| 1270 | + <h3 class="wp-chatbot-product-title">' . $product->post->post_title . '</h3> | |
| 1407 | 1271 | <div class="price">' . $product->get_price_html() . '</div>'; |
| 1408 | 1272 | $html .= ' </div> |
| 1409 | 1273 | </div> |
| 1410 | 1274 | </div></a> |
| @@ -1473,9 +1337,9 @@ | ||
| 1473 | 1337 | $html .= get_the_post_thumbnail(get_the_ID(), 'shop_catalog') . ' |
| 1474 | 1338 | <div class="wp-chatbot-product-summary"> |
| 1475 | 1339 | <div class="wp-chatbot-product-table"> |
| 1476 | 1340 | <div class="wp-chatbot-product-table-cell"> |
| 1477 | - <h3 class="wp-chatbot-product-title">' . esc_html($product->post->post_title) . '</h3> | |
| 1341 | + <h3 class="wp-chatbot-product-title">' . $product->post->post_title . '</h3> | |
| 1478 | 1342 | <div class="price">' . $product->get_price_html() . '</div>'; |
| 1479 | 1343 | $html .= ' </div> |
| 1480 | 1344 | </div> |
| 1481 | 1345 | </div></a> |
| @@ -1649,9 +1513,8 @@ | ||
| 1649 | 1513 | //Updating the cart items. |
| 1650 | 1514 | add_action('wp_ajax_qcld_wb_chatbot_update_cart_item_number', 'qcld_wb_chatbot_update_cart_item_number'); |
| 1651 | 1515 | add_action('wp_ajax_nopriv_qcld_wb_chatbot_update_cart_item_number', 'qcld_wb_chatbot_update_cart_item_number'); |
| 1652 | 1516 | function qcld_wb_chatbot_update_cart_item_number(){ |
| 1653 | - check_ajax_referer( 'wp_chatbot', 'nonce' ); | |
| 1654 | 1517 | //getting cart items n |
| 1655 | 1518 | $cart_item_key = sanitize_text_field(wp_unslash($_POST['cart_item_key'])); |
| 1656 | 1519 | $qnty = sanitize_text_field(wp_unslash($_POST['qnty'])); |
| 1657 | 1520 | global $wpcommerce; |
| @@ -1661,9 +1524,8 @@ | ||
| 1661 | 1524 | //Show item after removing from cart page. |
| 1662 | 1525 | add_action('wp_ajax_qcld_wb_chatbot_cart_item_remove', 'qcld_wb_chatbot_cart_item_remove'); |
| 1663 | 1526 | add_action('wp_ajax_nopriv_qcld_wb_chatbot_cart_item_remove', 'qcld_wb_chatbot_cart_item_remove'); |
| 1664 | 1527 | function qcld_wb_chatbot_cart_item_remove(){ |
| 1665 | - check_ajax_referer( 'wp_chatbot', 'nonce' ); | |
| 1666 | 1528 | //getting cart items n |
| 1667 | 1529 | $cart_item_key = sanitize_text_field(wp_unslash($_POST['cart_item'])); |
| 1668 | 1530 | global $wpcommerce; |
| 1669 | 1531 | $result = $wpcommerce->cart->remove_cart_item($cart_item_key); |
| @@ -1721,9 +1583,9 @@ | ||
| 1721 | 1583 | |
| 1722 | 1584 | if(class_exists('Qcformbuilder_Forms_Admin')){ |
| 1723 | 1585 | |
| 1724 | 1586 | |
| 1725 | - $results = $wpdb->get_results($wpdb->prepare("SELECT * FROM ". $wpdb->prefix."wfb_forms WHERE type= %s",'primary')); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching | |
| 1587 | + $results = $wpdb->get_results($wpdb->prepare("SELECT * FROM ". $wpdb->prefix."wfb_forms WHERE type= %s",'primary')); //DB Call OK, No Caching OK | |
| 1726 | 1588 | |
| 1727 | 1589 | if(!empty($results)){ |
| 1728 | 1590 | |
| 1729 | 1591 | foreach($results as $result){ |
| @@ -1876,12 +1738,9 @@ | ||
| 1876 | 1738 | } |
| 1877 | 1739 | } |
| 1878 | 1740 | |
| 1879 | 1741 | function qcld_choose_random($array){ |
| 1880 | - if (is_array($array) && !empty($array)) { | |
| 1881 | - return $array[array_rand($array)]; | |
| 1882 | - } | |
| 1883 | - return $array; | |
| 1742 | + return $array[array_rand($array)]; | |
| 1884 | 1743 | } |
| 1885 | 1744 | |
| 1886 | 1745 | //User session count |
| 1887 | 1746 | add_action('wp_ajax_qcld_wb_chatbot_session_count', 'qcld_wb_chatbot_session_count'); |
| @@ -1894,22 +1753,22 @@ | ||
| 1894 | 1753 | $tableuser = $wpdb->prefix.'wpbot_sessions'; |
| 1895 | 1754 | $response = array(); |
| 1896 | 1755 | |
| 1897 | 1756 | |
| 1898 | - $session_exists = $wpdb->get_row($wpdb->prepare("select * from {$tableuser} where 1 and id = %d",1)); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter | |
| 1757 | + $session_exists = $wpdb->get_row($wpdb->prepare("select * from $tableuser where 1 and id = %d",1)); //DB Call OK, No Caching OK | |
| 1899 | 1758 | |
| 1900 | 1759 | if(empty($session_exists)){ |
| 1901 | - $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery | |
| 1760 | + $wpdb->insert( | |
| 1902 | 1761 | $tableuser, |
| 1903 | 1762 | array( |
| 1904 | 1763 | 'session' => 1, |
| 1905 | 1764 | ) |
| 1906 | - ); | |
| 1765 | + ); //DB Call OK, No Caching OK | |
| 1907 | 1766 | }else{ |
| 1908 | 1767 | |
| 1909 | 1768 | $session_id = $session_exists->id; |
| 1910 | 1769 | |
| 1911 | - $wpdb->update( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching | |
| 1770 | + $wpdb->update( | |
| 1912 | 1771 | $tableuser, |
| 1913 | 1772 | array( |
| 1914 | 1773 | 'session'=>($session_exists->session+1), |
| 1915 | 1774 | ), |
| @@ -1917,9 +1776,9 @@ | ||
| 1917 | 1776 | array( |
| 1918 | 1777 | '%d', |
| 1919 | 1778 | ), |
| 1920 | 1779 | array('%d') |
| 1921 | - ); | |
| 1780 | + ); //DB Call OK, No Caching OK | |
| 1922 | 1781 | |
| 1923 | 1782 | } |
| 1924 | 1783 | |
| 1925 | 1784 | wp_send_json($response); |
| @@ -1927,9 +1786,9 @@ | ||
| 1927 | 1786 | |
| 1928 | 1787 | /* WPBot Chat History Addon check */ |
| 1929 | 1788 | function qcld_wpbot_is_active_chat_history(){ |
| 1930 | 1789 | |
| 1931 | - if(function_exists('qcwp_chat_session_menu_fnc') || function_exists('qcwp_chat_session_menu_fnc_free') || function_exists( 'qcpdcs_chat_session_menu_fnc' ) ){ | |
| 1790 | + if(function_exists('qcwp_chat_session_menu_fnc') || function_exists( 'qcpdcs_chat_session_menu_fnc' ) ){ | |
| 1932 | 1791 | return 1; |
| 1933 | 1792 | }else{ |
| 1934 | 1793 | return 0; |
| 1935 | 1794 | } |
| @@ -1944,11 +1803,9 @@ | ||
| 1944 | 1803 | return $data; |
| 1945 | 1804 | } |
| 1946 | 1805 | add_action('wp_ajax_qcld_small_talk_import', 'qcld_small_talk_import'); |
| 1947 | 1806 | function qcld_small_talk_import(){ |
| 1948 | - if ( ! current_user_can( 'manage_options' ) ) { | |
| 1949 | - wp_die(); | |
| 1950 | - } | |
| 1807 | + | |
| 1951 | 1808 | global $wpdb; |
| 1952 | 1809 | |
| 1953 | 1810 | $table = $wpdb->prefix.'wpbot_response'; |
| 1954 | 1811 | |
| @@ -1955,10 +1812,9 @@ | ||
| 1955 | 1812 | $csvFile = file(QCLD_wpCHATBOT_PLUGIN_DIR_PATH . 'small_talk.csv'); |
| 1956 | 1813 | |
| 1957 | 1814 | foreach ($csvFile as $line) { |
| 1958 | 1815 | $line = str_getcsv($line, ',', '"'); |
| 1959 | - $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery | |
| 1960 | - $table, array( | |
| 1816 | + $wpdb->insert($table, array( | |
| 1961 | 1817 | 'query' => $line[0], |
| 1962 | 1818 | 'keyword' => $line[1], |
| 1963 | 1819 | 'response' => $line[2], |
| 1964 | 1820 | 'category'=> $line[3], |
| @@ -1963,17 +1819,16 @@ | ||
| 1963 | 1819 | 'response' => $line[2], |
| 1964 | 1820 | 'category'=> $line[3], |
| 1965 | 1821 | 'intent'=> '', |
| 1966 | 1822 | //'lang'=> 'en_US', |
| 1967 | - )); | |
| 1823 | + )); //DB Call OK, No Caching OK | |
| 1968 | 1824 | } |
| 1969 | 1825 | |
| 1970 | 1826 | $table2 = $wpdb->prefix.'wpbot_response_category'; |
| 1971 | 1827 | |
| 1972 | - $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery | |
| 1973 | - $table2, array( | |
| 1828 | + $wpdb->insert($table2, array( | |
| 1974 | 1829 | 'name' => 'smalltalk', |
| 1975 | - )); | |
| 1830 | + )); //DB Call OK, No Caching OK | |
| 1976 | 1831 | |
| 1977 | 1832 | update_option( 'qcld_small_talk_imported', 'yes' ); |
| 1978 | 1833 | |
| 1979 | 1834 | } |
| @@ -2001,12 +1856,8 @@ | ||
| 2001 | 1856 | function qcld_change_language_from_center() { |
| 2002 | 1857 | if ( ! current_user_can( 'manage_options' ) ) { |
| 2003 | 1858 | wp_send_json_error( array( 'message' => 'Unauthorized.' ) ); |
| 2004 | 1859 | } |
| 2005 | - $nonce = isset( $_POST['nonce'] ) ? sanitize_text_field( wp_unslash( $_POST['nonce'] ) ) : ''; | |
| 2006 | - if ( ! wp_verify_nonce( $nonce, 'wp_chatbot' ) ) { | |
| 2007 | - wp_send_json_error( array( 'message' => 'Invalid nonce.' ) ); | |
| 2008 | - } | |
| 2009 | 1860 | $plugin_path = plugin_dir_path( __FILE__ ); |
| 2010 | 1861 | include $plugin_path . 'includes/admin/settings-fields.php'; |
| 2011 | 1862 | $json_file_path = $plugin_path . 'includes/language-center.json'; |
| 2012 | 1863 | |
| @@ -2021,7 +1872,4 @@ | ||
| 2021 | 1872 | |
| 2022 | 1873 | } |
| 2023 | 1874 | } |
| 2024 | 1875 | } |
| 2025 | - | |
| 2026 | -// AI Actions Chat Preview | |
| 2027 | - | |