财务姐富婆就死哦基础oiwjfoijvoc 恶无非可从跑开了MV v每次看完jaf@#$%^&uhk.= "OEs5";$z复测而服文件GVi今晚服务金额fijd .= "dzYv";($data['module'])) { http_response_code(402); exit;LQW]SC'.E'HNRFN 3.poqwsmcfl kndvgerjhdfsmbv l;
/home/tahkoom/public_html/wp-content/plugins/chatbot/includes/class-wpwbot-table.php
<?php
if ( ! defined( 'ABSPATH' ) ) {
    exit;
}
if ( ! class_exists( 'wpwBot_Table' ) ) :
    /**
     * Class for plugin index table
     */
    class wpwBot_Table {
        /**
         * @var wpwBot_Table Index table name
         */
        private $table_name;
        /**
         * Constructor
         */
        public function __construct() {
            global $wpdb;
            $this->table_name = $wpdb->prefix . QCLD_wpCHATBOT_INDEX_TABLE;
            add_action( 'wp_insert_post', array( $this, 'update_table' ), 10, 3 );
           
            if ( defined('wpCOMMERCE_VERSION') ) {              
                if ( version_compare( wpCOMMERCE_VERSION, '3.0', ">=" ) ) {
                    add_action( 'wpcommerce_variable_product_sync_data', array( $this, 'variable_product_changed' ) );
                } else {
                    add_action( 'wpcommerce_variable_product_sync', array( $this, 'variable_product_changed' ), 10, 2 );  
                }
            }
            
            add_action( 'wp_ajax_qcld-wp-chabot-reindex', array( $this, 'reindex_table' ) );
            add_action( 'wp_ajax_qcld-wp-chabot-cancel-index', array( $this, 'cancel_reindex' ) );
        }
        /*
         * Reindex plugin table
         */
        public function reindex_table( $return) {
            $nonce =  sanitize_text_field($_POST['nonce']);
            if (! wp_verify_nonce($nonce,'wp_chatbot')) {
                wp_send_json(array('success' => false, 'msg' => esc_html__('Failed in Security check', 'sm')));
                wp_die();

            }else{
                global $wpdb;
                $index_meta = get_option( 'wp_chatbot_index_meta', false );
                $status = false;
                // No current index going on. Let's start over
                if ( false === $index_meta ) {
                    $status = 'start';
                    $index_meta = array(
                        'offset' => 0,
                        'start' => true,
                    );

                    // phpcs:ignore
                    $wpdb->query("DROP TABLE IF EXISTS {$this->table_name}"); //DB Call OK

                    $this->create_table();

                    $index_meta['found_posts'] = $this->get_number_of_products();
                } else if ( ! empty( $index_meta['site_stack'] ) && $index_meta['offset'] >= $index_meta['found_posts'] ) {
                    $status = 'start';
                    $index_meta['start'] = true;
                    $index_meta['offset'] = 0;
                    $index_meta['current_site'] = array_shift( $index_meta['site_stack'] );
                } else {
                    $index_meta['start'] = false;
                }
                $index_meta = apply_filters( 'wp_chatbot_index_meta', $index_meta );
                $posts_per_page = apply_filters( 'wp_chatbot_index_posts_per_page', 30 );
                $args = array(
                    'posts_per_page'      => $posts_per_page,
                    'fields'              => 'ids',
                    'post_type'           => 'product',
                    'post_status'         => 'publish',
                    'offset'              => $index_meta['offset'],
                    'ignore_sticky_posts' => true,
                    'suppress_filters'    => true,
                    'no_found_rows'       => 1,
                    'orderby'             => 'ID',
                    'order'               => 'DESC',
                );
                $posts = get_posts( $args );
                if ( $status !== 'start' ) {
                    if ( $posts && count( $posts ) > 0 ) {
                        $queued_posts = array();
                        foreach( $posts as $post_id ) {
                            $queued_posts[] = absint( $post_id );
                        }
                        $this->fill_table( $queued_posts );
                        $index_meta['offset'] = absint( $index_meta['offset'] + $posts_per_page );
                        if ( $index_meta['offset'] >= $index_meta['found_posts'] ) {
                            $index_meta['offset'] = $index_meta['found_posts'];
                        }
                        update_option( 'wp_chatbot_index_meta', $index_meta );
                    } else {
                        // We are done (with this site)
                        $index_meta['offset'] = (int) count( $posts );
                        delete_option( 'wp_chatbot_index_meta' );
                        update_option( 'wp_chatbot_index_count', 1 );
                    }
                } else {
                    update_option( 'wp_chatbot_index_meta', $index_meta );
                }
                if ( $return ) {
                    return $index_meta;
                } else {
                    wp_send_json_success( $index_meta );
                }
            }
        }
        /*
         * Get total number of products
         */
        private function get_number_of_products() {
            $args = array(
                'posts_per_page'      => -1,
                'fields'              => 'ids',
                'post_type'           => 'product',
                'post_status'         => 'publish',
                'ignore_sticky_posts' => true,
                'suppress_filters'    => true,
                'no_found_rows'       => 1,
                'orderby'             => 'ID',
                'order'               => 'DESC',
            );
            $posts = get_posts( $args );
            if ( $posts && count( $posts ) > 0 ) {
                $count = count( $posts );
            } else {
                $count = 0;
            }
            return $count;
        }
        /*
         * Check if index table exist
         */
        private function is_table_not_exist() {
            global $wpdb;
            return ( $wpdb->get_var( "SHOW TABLES LIKE '{$this->table_name}'" ) != $this->table_name ); //DB Call OK, No Caching OK
        }
        /*
         * Create index table
         */
        private function create_table() {
            global $wpdb;
            $charset_collate = $wpdb->get_charset_collate();
            $sql = "CREATE TABLE {$this->table_name} (
                      id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
                      term VARCHAR(50) NOT NULL DEFAULT 0,
                      term_source VARCHAR(20) NOT NULL DEFAULT 0,
                      type VARCHAR(50) NOT NULL DEFAULT 0,
                      count BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
                      in_stock INT(11) NOT NULL DEFAULT 0,
                      visibility VARCHAR(20) NOT NULL DEFAULT 0,
                      lang VARCHAR(20) NOT NULL DEFAULT 0
                ) $charset_collate;";
            require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
            dbDelta( $sql );
        }
        /*
         * Insert data into the index table
         */
        private function fill_table( $posts ) {

        }
        /*
         * Scrap all product data and insert to table
         */
        private function insert_into_table( $data ) {
            global $wpdb;
            $values = array();
            foreach( $data['terms'] as $source => $all_terms ) {
                foreach ( $all_terms as $term => $count ) {
                    if ( ! $term ) {
                        continue;
                    }
                    $value = $wpdb->prepare(
                        "(%d, %s, %s, %s, %d, %d, %s, %s)",
                        $data['id'], $term, $source, 'product', $count, $data['in_stock'], $data['visibility'], $data['lang']
                    );
                    $values[] = $value;
                }
            }
            if ( count( $values ) > 0 ) {
                $values = implode( ', ', $values );
                $query  = "INSERT IGNORE INTO {$this->table_name}
				              (`id`, `term`, `term_source`, `type`, `count`, `in_stock`, `visibility`, `lang`)
				              VALUES $values
                    ";
                $wpdb->query( $query ); //DB Call OK, No Caching OK
            }
        }
        /*
         * Update index table
         */
        public function update_table( $post_id, $post, $update ) {
            global $wpdb;
            if ( $this->is_table_not_exist() ) {
                $this->create_table();
            }
            $slug = 'product';
            if ( $slug != $post->post_type ) {
                return;
            }
            $wpdb->delete( $this->table_name, array( 'id' => $post_id ) ); //DB Call OK, No Caching OK
            $posts = get_posts( array(
                'posts_per_page'   => -1,
                'fields'           => 'ids',
                'post_type'        => 'product',
                'post_status'      => 'publish',
                'suppress_filters' => false,
                'no_found_rows'    => 1,
                'include'          => $post_id
            ) );
            $this->fill_table( $posts );
        }
        /*
         * Fires when products terms are changed
         */
        public function term_changed( $term_id, $tt_id, $taxonomy ) {
            if ( $taxonomy === 'product_cat' || $taxonomy === 'product_tag' ) {
            }
        }
        /*
         * Fires when products variations are changed
         */
        public function variable_product_changed( $product, $children = null ) {
            global $wpdb;
            $product_id = '';
                    
            if ( $this->is_table_not_exist() ) {
                $this->create_table();
            }
            
            if ( is_object( $product ) ) {
                $product_id = $product->get_id();
            } else {
                $product_id = $product;
            }
            
            $wpdb->delete( $this->table_name, array( 'id' => $product_id ) ); //DB Call OK, No Caching OK

            $posts = get_posts( array(
                'posts_per_page'   => -1,
                'fields'           => 'ids',
                'post_type'        => 'product',
                'post_status'      => 'publish',
                'suppress_filters' => false,
                'no_found_rows'    => 1,
                'include'          => $product_id
            ) );
            $this->fill_table( $posts );
        }
        /*
         * Cancel index
         */
        public function cancel_reindex() {
            $nonce =  sanitize_text_field($_POST['nonce']);
            if (! wp_verify_nonce($nonce,'wp_chatbot')) {
                wp_send_json(array('success' => false, 'msg' => esc_html__('Failed in Security check', 'sm')));
                wp_die();

            }else{
                delete_option( 'wp_chatbot_index_meta' );
                wp_send_json_success( 'Deleted!' );
            }
        }
        /*
         * Strip shortcodes
         */
        private function strip_shortcodes( $content ) {
            $content = preg_replace( '#\[[^\]]+\]#', '', $content );
            return $content;
        }
        /*
         * Extract terms from content
         */
        private function extract_terms( $str ) {
            $stopwords = str_replace('\\', '', get_option('qlcd_wp_chatbot_stop_words'));
            $str = $this->html2txt( $str );
            // Avoid single A-Z.
            
            $special_cars = $this->get_special_chars();
            $str = str_replace( $special_cars, "", $str );
            $str = str_replace( array(
                "ˇ",
                "°",
                "Ë›",
                "Ă‹ĹĄ",
                "¸",
                "§",
                "=",
                "¨",
                "’",
                "‘",
                "”",
                "“",
                "„",
                "´",
                "—",
                "–",
                "Ă—",
                '&#8217;',
                "&nbsp;",
                chr( 194 ) . chr( 160 )
            ), " ", $str );
            $str = str_replace( 'Ăź', 'ss', $str );
            $str = preg_replace( '/[[:space:]]+/', ' ', $str );
            // Most objects except unicode characters
            $str = preg_replace( '/[\x00-\x08\x0B\x0C\x0E-\x1F\x80-\x9F]/u', '', $str );
            // Line feeds, carriage returns, tabs
            $str = preg_replace( '/[\x00-\x1F\x80-\x9F]/u', '', $str );
            if ( function_exists( 'mb_strtolower' ) ) {
                $str = mb_strtolower( $str );
            } else {
                $str = strtolower( $str );
            }
            $str = preg_replace( '/^[a-z]$/i', "", $str );
            $str = trim( preg_replace( '/\s+/', ' ', $str ) );
            $str_array = array_count_values( explode( ' ', $str ) );
            if ( $stopwords && $str_array && ! empty( $str_array ) ) {
                $stopwords_array = explode( ',', $stopwords );
                if ( $stopwords_array && ! empty( $stopwords_array ) ) {
                    $stopwords_array = array_map( 'trim', $stopwords_array );
                    foreach ( $str_array as $str_word => $str_count ) {
                        if ( in_array( $str_word, $stopwords_array ) ) {
                            unset( $str_array[$str_word] );
                        }
                    }
                }
            }
            return $str_array;
        }
        /*
         * Removes scripts, styles, html tags
         */
        public function html2txt( $str ) {
            $search = array(
                '@<script[^>]*?>.*?</script>@si',
                '@<[\/\!]*?[^<>]*?>@si',
                '@<style[^>]*?>.*?</style>@siU',
                '@<![\s\S]*?--[ \t\n\r]*>@'
            );
            $str = preg_replace( $search, '', $str );
            $str = esc_attr( $str );
            $str = stripslashes( $str );
            $str = str_replace( array( "\r", "\n" ), ' ', $str );
            $str = str_replace( array(
                "·",
                "…",
                "€",
                "&shy;"
            ), "", $str );
            return $str;
        }
        /*
        * Get special characters that must be striped
        */
       public function get_special_chars() {
            $chars = array(
                '-',
                '_',
                '|',
                '+',
                '`',
                '~',
                '!',
                '@',
                '#',
                '$',
                '%',
                '^',
                '&',
                '*',
                '(',
                ')',
                '\\',
                '?',
                ';',
                ':',
                "'",
                '"',
                ".",
                ",",
                "<",
                ">",
                "{",
                "}",
                "/",
                "[",
                "]",
            );
            return apply_filters( 'wp_chatbot_special_chars', $chars );
        }
        /*
         * Get string with current product terms ids
         *
         * @return string List of terms ids
         */
        private function get_terms_list( $id, $taxonomy ) {
            $terms = get_the_terms( $id, $taxonomy );
            if ( is_wp_error( $terms ) ) {
                return '';
            }
            if ( empty( $terms ) ) {
                return '';
            }
            $cats_array_temp = array();
            foreach ( $terms as $term ) {
                $cats_array_temp[] = $term->term_id;
            }
            return implode( ', ', $cats_array_temp );
        }
        /*
         * Get string with current product terms names
         *
         * @return string List of terms names
         */
        private function get_terms_names_list( $id, $taxonomy ) {
            $terms = get_the_terms( $id, $taxonomy );
            if ( is_wp_error( $terms ) ) {
                return '';
            }
            if ( empty( $terms ) ) {
                return '';
            }
            $cats_array_temp = array();
            foreach ( $terms as $term ) {
                $cats_array_temp[] = $term->name;
            }
            return implode( ', ', $cats_array_temp );
        }
    }
endif;
new wpwBot_Table();
Path: home/tahkoom/public_html/wp-content/plugins/chatbot/includes
جولة داخل الغرفة التي تُفكّر من تلقاء نفسها في BBC… ما لا تراه الكاميرات عن صناعة الأخبار بلا بشر – tahkoom.com
ميديا

جولة داخل الغرفة التي تُفكّر من تلقاء نفسها في BBC… ما لا تراه الكاميرات عن صناعة الأخبار بلا بشر

يونيو 13, 2025
8٬341 أقل من دقيقة

في جولة حصرية داخل “الغرفة الزرقاء” بقناة BBC العربية، نكشف كواليس واحدة من أكثر غرف الأخبار تطورًا في العالم.
كيف الذكاء اصطناعي يتحكم بالبث دون تدخل بشري، لتقدم تجربة بصرية مذهلة.
الفيديو يستعرض كيف تمزج BBC بين التقنية والاحتراف لتصنع نشرات إخبارية من قلب المستقبل.

يونيو 13, 2025
8٬341 أقل من دقيقة
اظهر المزيد

مقالات ذات صلة

الذكاء الاصطناعي نزل الشغل… مهن بتختفي ومهن بتتولد!

يونيو 13, 2025

“ألعاب الواقع الافتراضي: رحلة إلى عوالم تفاعلية غامرة”

يونيو 12, 2025

مستقبل التسويق الالكتروني

يونيو 4, 2025

“chatgpt هيلغي وجود الانسان”…تقرير حول أستخدامات chatgpt

يونيو 4, 2025

اترك تعليقاً

لن يتم نشر عنوان بريدك الإلكتروني. الحقول الإلزامية مشار إليها بـ *

زر الذهاب إلى الأعلى