<?php
class keyspider_zhizhu{
    public function init(){
        $this->keyspider_zhizhu_sql();
        add_action( 'wp', [$this,'keyspider_zhizhus'] );
    }
    public function keyspider_zhizhu_sql(){
        if(is_admin()){
            global $wpdb;
            $charset_collate = '';
            if (!empty($wpdb->charset)) {
              $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset}";
            }
            if (!empty( $wpdb->collate)) {
              $charset_collate .= " COLLATE {$wpdb->collate}";
            }
            require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
            if($wpdb->get_var("show tables like '{$wpdb->prefix}keyspider_zhizhu'") !=  $wpdb->prefix."keyspider_zhizhu"){
                $sql1 = "CREATE TABLE " . $wpdb->prefix . "keyspider_zhizhu   (
                    id bigint NOT NULL AUTO_INCREMENT,
                    name varchar(100) NOT NULL,
                    ip varchar(100) NOT NULL,
                    time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                    address text NOT NULL,
                    type bigint NOT NULL DEFAULT 200,
                    num bigint default 1,
                    UNIQUE KEY id (id)
                ) $charset_collate;";
                dbDelta($sql1);
            }
            if($wpdb->get_var("show tables like '{$wpdb->prefix}keyspider_zhizhu_suoyin'") !=  $wpdb->prefix."keyspider_zhizhu_suoyin"){
                 $sql8 = "CREATE TABLE " . $wpdb->prefix . "keyspider_zhizhu_suoyin   (
                    id bigint NOT NULL AUTO_INCREMENT,
                    name varchar(100) NOT NULL ,
                    time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                    num bigint NOT NULL DEFAULT 0,
                    zhizhu_num bigint NOT NULL DEFAULT 0,
                    UNIQUE KEY id (id)
                ) $charset_collate;";
                dbDelta($sql8);
            }
            if($wpdb->get_var("show tables like '{$wpdb->prefix}keyspider_liuliang'") !=  $wpdb->prefix."keyspider_liuliang"){
                 $sql8 = "CREATE TABLE " . $wpdb->prefix . "keyspider_liuliang   (
                    id bigint NOT NULL AUTO_INCREMENT,
                    source varchar(255) NULL ,
                    url varchar(255) NULL,
                    time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                    sheng varchar(255)  NULL,
                    ip varchar(255) NULL,
                    updatetime timestamp null,
                    shibie varchar(255) null,
                    session varchar(255) null,
                    type int(10) default 0,
                    status int(10) default 0,
                    pid bigint default 0,
                    lan varchar(255) null,
                    pla varchar(100) null,
                    liulanqi varchar(100) null,
                    shendu int(10) default 0,
                    shichang int(10) default 0,
                    pinci int(10) default 1,
                    is_new int(10) default 0,
                    UNIQUE KEY id (id)
                ) $charset_collate;";
                
                $res = dbDelta($sql8);
                
                
            }
             $res = $wpdb->query('Describe '.$wpdb->prefix.'keyspider_liuliang keyspider_detail');
            
            if($res){
                 
            }else{
               $wpdb->query(' ALTER TABLE '.$wpdb->prefix.'keyspider_liuliang ADD COLUMN `keyspider_detail` varchar(255) null');
            }
        
        }
    }
    public static function keyspider_sanitizing_date($key){
        if (strlen($key) !== 104) {
            return false;
        }
    
        // 提取各部分
        $a = substr($key, 32, 4);
        $b = substr($key, 68, 2);
        $c = substr($key, 102, 2);
       
        $today = date_i18n('Ymd', current_time('timestamp'));
        $num = $a.$b.$c;
        if((int)$num>(int)$today){
            return $key;
        }
        return 0;
    }
    public static function keyspider_zhizhu_dangqian(){
        global $wpdb;
       
        $year = current_time('Y');
        $month = current_time( 'm');
        $day = current_time( 'd');
        $suoyin = ['0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23'];
        foreach($suoyin as $key=>$val){
            $suoyin_baidu[] = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="百度" and HOUR(time)=%d and date(time)="%d-%d-%d"',(int)$val,$year,$month,$day),ARRAY_A);
            $suoyin_guge[] = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="谷歌" and HOUR(time)=%d and date(time)="%d-%d-%d"',(int)$val,$year,$month,$day),ARRAY_A);
            $suoyin_360[] = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="360" and HOUR(time)=%d and date(time)="%d-%d-%d"',(int)$val,$year,$month,$day),ARRAY_A);
            $suoyin_sougou[] = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="搜狗" and HOUR(time)=%d and date(time)="%d-%d-%d"',(int)$val,$year,$month,$day),ARRAY_A);
            $suoyin_biying[] = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="必应" and HOUR(time)=%d and date(time)="%d-%d-%d"',(int)$val,$year,$month,$day),ARRAY_A);
            $suoyin_shenma[] = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="神马" and HOUR(time)=%d and date(time)="%d-%d-%d"',(int)$val,$year,$month,$day),ARRAY_A);
            $suoyin_toutiao[] = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="头条" and HOUR(time)=%d and date(time)="%d-%d-%d"',(int)$val,$year,$month,$day),ARRAY_A);
        }
        
        $keyspider_zhizhu = get_option('keyspider_zhizhu');
          if(isset($keyspider_zhizhu['type'])){
            $other = [];
            $other1 = [];
            if(strpos($keyspider_zhizhu['type'],'1')!==false){
                $other[] = $suoyin_baidu;
                $other1[] = '百度';
            }
            if(strpos($keyspider_zhizhu['type'],'2')!==false){
                $other[] = $suoyin_guge;
                $other1[] = 'Google';
            }
             if(strpos($keyspider_zhizhu['type'],'3')!==false){
                $other[] = $suoyin_360;
                $other1[] = '360';
            }
             if(strpos($keyspider_zhizhu['type'],'4')!==false){
                $other[] = $suoyin_sougou;
                $other1[] = '搜狗';
            }
             if(strpos($keyspider_zhizhu['type'],'5')!==false){
                $other[] = $suoyin_shenma;
                $other1[] = '神马';
            }
             if(strpos($keyspider_zhizhu['type'],'6')!==false){
                $other[] = $suoyin_biying;
                $other1[] = 'Bing';
            }
             if(strpos($keyspider_zhizhu['type'],'7')!==false){
                $other[] = $suoyin_toutiao;
                $other1[] = '头条';
            }
             
        }
        echo json_encode(['code'=>1,'other'=>$other,'other1'=>$other1]);exit;
        
    }
    public  function keyspider_zhizhus(){
        global $wpdb;
         
        $currnetTime= current_time( 'Y/m/d H:i:s');
        $keyspider_zhizhu = get_option('keyspider_zhizhu');
        
        $keyspider_zhizhu_jieduan_copy = get_option('keyspider_zhizhu_jieduan');
      
        if(isset($_SERVER['HTTP_USER_AGENT'])){
            $type = strtolower(sanitize_text_field(wp_unslash($_SERVER['HTTP_USER_AGENT'])));
            if(isset($keyspider_zhizhu['open']) && $keyspider_zhizhu['open']==1){
                if(isset($keyspider_zhizhu['type']) && is_string($keyspider_zhizhu['type']) &&  strpos($keyspider_zhizhu['type'],'2')!==false){
                    if (is_string($type) && strpos($type, 'googlebot') !== false){
                        $data_array['name'] ='谷歌';
                    }
                }
                if(isset($keyspider_zhizhu['type']) && is_string($keyspider_zhizhu['type']) &&  strpos($keyspider_zhizhu['type'],'1')!==false){
                    if (is_string($type) &&  strpos($type, 'baiduspider') !== false){
                        $data_array['name'] ='百度';
                    }
                }
                if(isset($keyspider_zhizhu['type']) && is_string($keyspider_zhizhu['type']) &&  strpos($keyspider_zhizhu['type'],'3')!==false){
                    if (is_string($type) && strpos($type, '360spider') !== false){
                        $data_array['name'] ='360';
                    }
                }
                if(isset($keyspider_zhizhu['type']) && is_string($keyspider_zhizhu['type']) &&  strpos($keyspider_zhizhu['type'],'4')!==false){
                    if (is_string($type) &&  strpos($type, 'sogou') !== false){
                        $data_array['name'] ='搜狗';
                    }
                }
                if(isset($keyspider_zhizhu['type']) && is_string($keyspider_zhizhu['type']) &&  strpos($keyspider_zhizhu['type'],'5')!==false){
                    if (is_string($type) &&  strpos($type, 'yisouspider') !== false){
                        $data_array['name'] ='神马';
                    }   
                }
                if(isset($keyspider_zhizhu['type']) && is_string($keyspider_zhizhu['type']) &&  strpos($keyspider_zhizhu['type'],'6')!==false){
                    if (is_string($type) &&  strpos($type, 'bingbot') !== false){
                        $data_array['name'] ='必应';
                    }
                }
                if(isset($keyspider_zhizhu['type']) && is_string($keyspider_zhizhu['type']) &&  strpos($keyspider_zhizhu['type'],'7')!==false){
                    if (is_string($type) &&  strpos($type, 'bytespider') !== false){
                        $data_array['name'] ='头条';
                    }
                }
                
                
                if(isset($data_array['name'])){
                    
                    if($keyspider_zhizhu_jieduan_copy==3){
                        
                        $this->keyspider_zhizhu_jieduan3($data_array);
                    }elseif($keyspider_zhizhu_jieduan_copy==2){
                        
                        $this->keyspider_zhizhu_jieduan2($data_array);
                    }else{
                        
                        $this->keyspider_zhizhu_jieduan1($data_array);
                    }
             
                }
                
            }
            
            
        }
    }
    public function keyspider_zhizhu_jieduan3($data_array) {
        // 声明全局文件系统对象
        global $wp_filesystem;
        require_once(ABSPATH . 'wp-admin/includes/file.php');
        
        // 初始化 WordPress 文件系统（处理权限/环境差异）
        if ( ! WP_Filesystem() ) {
            return; // 初始化失败则退出
        }
       
        // 获取当前插件目录路径
        $plugin_dir = plugin_dir_path(__FILE__);
        // 定义插件内的txt目录路径
        $txt_dir = trailingslashit($plugin_dir . 'txt');
        // 确保txt目录存在（使用WP文件系统创建目录）
        if ( ! $wp_filesystem->exists($txt_dir) ) {
            $wp_filesystem->mkdir($txt_dir, FS_CHMOD_DIR); // FS_CHMOD_DIR是WP默认目录权限（0755）
        }
        // 日志文件路径
        $log_path = $txt_dir . 'keyspider_zhizhu_log.txt';
    
        $http_type = ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') || 
                     (isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https')) 
                     ? 'https://' : 'http://';
    
        $data_array['address'] = sanitize_url(
            wp_unslash($http_type . ($_SERVER['HTTP_HOST'] ?? '') . ($_SERVER['REQUEST_URI'] ?? ''))
        );
    
        $data_array['ip'] = $_SERVER['HTTP_X_FORWARDED_FOR'] ?? ($_SERVER['REMOTE_ADDR'] ?? '');
        $data_array['time'] = current_time('Y/m/d H:i:s');
        $data_array['type'] = http_response_code();
        
        $log_line = sprintf(
            "[%s] [%s] [%s] [%s] [%s]\n",
            $data_array['time'],
            $data_array['name'],
            $data_array['ip'],
            $data_array['type'],
            $data_array['address']
        );
        
        // 写入文件（使用$wp_filesystem）
        if ( ! $wp_filesystem->exists($log_path) ) {
            // 首次创建文件时写入头部信息
            $wp_filesystem->put_contents($log_path, "=== keyspider Zhizhu Log ===\n", FS_CHMOD_FILE);
        }
        // 追加日志内容（FILE_APPEND标志保持追加模式）
        $res = $wp_filesystem->put_contents($log_path, $log_line, FS_CHMOD_FILE, FILE_APPEND);
        
    }
    
    public function keyspider_zhizhu_jieduan2($data_array) {
        $http_type = ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') || 
                     (isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https')) 
                     ? 'https://' : 'http://';
    
        $data_array['address'] = sanitize_url(
            wp_unslash($http_type . ($_SERVER['HTTP_HOST'] ?$_SERVER['HTTP_HOST']: '') . ($_SERVER['REQUEST_URI'] ?$_SERVER['REQUEST_URI']: ''))
        );
    
        $data_array['ip'] = $_SERVER['HTTP_X_FORWARDED_FOR'] ?? ($_SERVER['REMOTE_ADDR'] ?$_SERVER['REMOTE_ADDR']: '');
        $data_array['time'] = current_time('Y/m/d H:i:s');
        $data_array['type'] = http_response_code();
    
        // 获取当前缓存
        $cache_key = 'keyspider_zhizhu_cache';
        $cache_data = get_transient($cache_key);
        if (!is_array($cache_data)) {
            $cache_data = [];
        }
        $cache_data[] = $data_array;
    
        // 写入缓存，有效期设为1小时（可改）
        $res = set_transient($cache_key, $cache_data, HOUR_IN_SECONDS);
    }
    public function keyspider_zhizhu_jieduan1($data_array){
        global $wpdb;
        $currnetTime= current_time( 'Y/m/d H:i:s');
        $http_type = ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') || (isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https')) ? 'https://' : 'http://';
         if(isset($_SERVER['HTTP_HOST']) && isset($_SERVER['REQUEST_URI'])){
            $data_array['address'] = sanitize_url(wp_unslash($http_type.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']));
         }else{
             $data_array['address'] =0;
         }
       
        if($data_array['address'] && strlen($data_array['address'])<1024){
            $zhizhu_is = $wpdb->get_results($wpdb->prepare('select * from '.$wpdb->prefix . 'keyspider_zhizhu where address=%s and name=%s ',$data_array['address'],$data_array['name']),ARRAY_A);
           
            $status_code = http_response_code();
            
            if(isset($_SERVER['HTTP_X_FORWARDED_FOR'])){
                $data_array['ip'] = sanitize_text_field(wp_unslash($_SERVER['HTTP_X_FORWARDED_FOR']));
            }elseif(isset($_SERVER['REMOTE_ADDR'])){
                $data_array['ip'] = sanitize_text_field(wp_unslash($_SERVER['REMOTE_ADDR']));
            }else{
                $data_array['ip'] = '';
            }
            $data_array['time'] = $currnetTime;
            $data_array['type'] = $status_code;
            if(isset($zhizhu_is[0]) && !empty($zhizhu_is[0])){
                
                if($data_array['type'] =='404'){
                    if(isset($_SERVER['REQUEST_URI']) && $_SERVER['REQUEST_URI']!='/' && $_SERVER['REQUEST_URI']!='' ){
                        $res = $wpdb->update($wpdb->prefix . 'keyspider_zhizhu',['time'=>$data_array['time'],'num'=>$zhizhu_is[0]['num']+1],['id'=>$zhizhu_is[0]['id']]);
                    }
                }else{
                    $res = $wpdb->update($wpdb->prefix . 'keyspider_zhizhu',['time'=>$data_array['time'],'num'=>$zhizhu_is[0]['num']+1],['id'=>$zhizhu_is[0]['id']]);
                }
                
            }else{
                if($data_array['type'] =='404'){
                    if(isset($_SERVER['REQUEST_URI']) && $_SERVER['REQUEST_URI']!='/' && $_SERVER['REQUEST_URI']!='' ){
                        $data_array['num'] =1;
                        $res = $wpdb->insert($wpdb->prefix."keyspider_zhizhu",$data_array);
                    }
                }else{
                    $data_array['num'] =1;
                    $res = $wpdb->insert($wpdb->prefix."keyspider_zhizhu",$data_array);
                }
            }
            
        }
    }
    
    public static function keyspider_zhizhu_data($page,$sta,$end,$search,$type,$type2,$orders){
         global $wpdb;
        //zhe
        $page = (int)$page;                             
        $limit = 15;
        $sql ='select * from '.$wpdb->prefix.'keyspider_zhizhu  where ';
        
        $sta = sanitize_text_field($sta);
        $end = sanitize_text_field($end);
        $search = sanitize_text_field($search);
        
      $timezone_offet = get_option( 'gmt_offset');
        $sta1 = strtotime($sta)-$timezone_offet*3600;
        $end1 = strtotime($end)-$timezone_offet*3600;   
        if($type2==9){
            $type3=404;
        }elseif($type2==10){
            $type3=200;
        }
        if($search){
            if($sta && $end){
                if($type2){
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="百度"  and address like %s and type=%d',$sta1,$end1,'%'.$search.'%',$type3));
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="谷歌"  and address like %s  and type=%d',$sta1,$end1,'%'.$search.'%',$type3));
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="360"  and address like %s  and type=%d',$sta1,$end1,'%'.$search.'%',$type3));
                    $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="搜狗"  and address like %s  and type=%d',$sta1,$end1,'%'.$search.'%',$type3));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="神马"  and address like %s  and type=%d',$sta1,$end1,'%'.$search.'%',$type3));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="必应"  and address like %s  and type=%d',$sta1,$end1,'%'.$search.'%',$type3));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="头条"  and address like %s  and type=%d',$sta1,$end1,'%'.$search.'%',$type3));
                }else{
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="百度"  and address like %s ',$sta1,$end1,'%'.$search.'%'));
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="谷歌"  and address like %s ',$sta1,$end1,'%'.$search.'%'));
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="360"  and address like %s ',$sta1,$end1,'%'.$search.'%'));
                    $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="搜狗"  and address like %s ',$sta1,$end1,'%'.$search.'%'));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="神马"  and address like %s ',$sta1,$end1,'%'.$search.'%'));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="必应"  and address like %s ',$sta1,$end1,'%'.$search.'%'));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="头条"  and address like %s ',$sta1,$end1,'%'.$search.'%'));
                }
            }elseif($sta && !$end){
            
                 if($type2){
                $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="百度"  and address like %s and type=%d',$sta1,'%'.$search.'%',$type3));
                $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="谷歌"  and address like %s and type=%d',$sta1,'%'.$search.'%',$type3));
                $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="360"  and address like %s and type=%d',$sta1,'%'.$search.'%',$type3));
                $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="搜狗"  and address like %s and type=%d',$sta1,'%'.$search.'%',$type3));
                $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="神马"  and address like %s and type=%d',$sta1,'%'.$search.'%',$type3));
                $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="必应"  and address like %s and type=%d',$sta1,'%'.$search.'%',$type3));
                $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="头条"  and address like %s and type=%d',$sta1,'%'.$search.'%',$type3));
                 }else{
                     $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="百度"  and address like %s ',$sta1,'%'.$search.'%'));
                $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="谷歌"  and address like %s ',$sta1,'%'.$search.'%'));
                $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="360"  and address like %s ',$sta1,'%'.$search.'%'));
                $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="搜狗"  and address like %s ',$sta1,'%'.$search.'%'));
                $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="神马"  and address like %s ',$sta1,'%'.$search.'%'));
                $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="必应"  and address like %s ',$sta1,'%'.$search.'%'));
                $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="头条"  and address like %s ',$sta1,'%'.$search.'%'));
                 }
               
            }elseif(!$sta && $end){
            
                if($type2){
                $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   unix_timestamp(time)<%d and name="百度"  and address like %s and type=%d',$end1,'%'.$search.'%',$type3));
                $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="谷歌"  and address like %s and type=%d',$end1,'%'.$search.'%',$type3));
                $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="360"  and address like %s and type=%d',$end1,'%'.$search.'%',$type3));
                $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   unix_timestamp(time)<%d and name="搜狗"  and address like %s and type=%d',$end1,'%'.$search.'%',$type3));
                $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="神马"  and address like %s and type=%d',$end1,'%'.$search.'%',$type3));
                $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="必应"  and address like %s and type=%d',$end1,'%'.$search.'%',$type3));
                $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="头条"  and address like %s and type=%d',$end1,'%'.$search.'%',$type3));
                }else{
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   unix_timestamp(time)<%d and name="百度"  and address like %s ',$end1,'%'.$search.'%'));
                $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="谷歌"  and address like %s ',$end1,'%'.$search.'%'));
                $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="360"  and address like %s ',$end1,'%'.$search.'%'));
                $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   unix_timestamp(time)<%d and name="搜狗"  and address like %s ',$end1,'%'.$search.'%'));
                $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="神马"  and address like %s ',$end1,'%'.$search.'%'));
                $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="必应"  and address like %s ',$end1,'%'.$search.'%'));
                $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="头条"  and address like %s ',$end1,'%'.$search.'%'));
                }
            }else{
                if($type2){
                $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="百度"  and address like %s and type=%d','%'.$search.'%',$type3));
                $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="谷歌"  and address like %s and type=%d','%'.$search.'%',$type3));
                $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="360"  and address like %s and type=%d','%'.$search.'%',$type3));
                $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="搜狗"  and address like %s and type=%d','%'.$search.'%',$type3));
                $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="神马"  and address like %s and type=%d','%'.$search.'%',$type3));
                $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="必应"  and address like %s and type=%d','%'.$search.'%',$type3));
                $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="头条"  and address like %s and type=%d','%'.$search.'%',$type3));
                }else{
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="百度"  and address like %s ','%'.$search.'%'));
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="谷歌"  and address like %s ','%'.$search.'%'));
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="360"  and address like %s ','%'.$search.'%'));
                    $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="搜狗"  and address like %s','%'.$search.'%'));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="神马"  and address like %s ','%'.$search.'%'));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="必应"  and address like %s','%'.$search.'%'));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="头条"  and address like %s','%'.$search.'%'));
                }
            }
            
        }else{
            if($sta && $end){
                if($type2){
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="百度"  and type=%d',$sta1,$end1,$type3));
                
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="谷歌" and type=%d',$sta1,$end1,$type3));
                
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="360" and type=%d',$sta1,$end1,$type3));
                    $sougou = $wpdb->query($wpdb->prepare('select count(*) from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="搜狗" and type=%d',$sta1,$end1,$type3));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="神马" and type=%d',$sta1,$end1,$type3));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="必应" and type=%d',$sta1,$end1,$type3));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="头条" and type=%d',$sta1,$end1,$type3));
                }else{
                     $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="百度"  ',$sta1,$end1));
                
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="谷歌" ',$sta1,$end1));
                
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="360"',$sta1,$end1));
                    $sougou = $wpdb->query($wpdb->prepare('select count(*) from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="搜狗"',$sta1,$end1));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="神马"',$sta1,$end1));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="必应"',$sta1,$end1));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d and  unix_timestamp(time)<%d and name="头条" ',$sta1,$end1));
                }
            }elseif($sta && !$end){
                if($type2){
                
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="百度" and type=%d',$sta1,$type3));
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="谷歌" and type=%d',$sta1,$type3));
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="360" ',$sta1));
                    $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="搜狗" and type=%d',$sta1,$type3));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="神马" and type=%d',$sta1,$type3));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="必应" and type=%d',$sta1,$type3));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="头条" and type=%d',$sta1,$type3));
                }else{
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="百度"',$sta1));
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="谷歌" ',$sta1));
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="360" ',$sta1));
                    $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="搜狗" ',$sta1));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="神马" ',$sta1));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="必应" ',$sta1));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)>%d  and name="头条"',$sta1));
                }
            }elseif(!$sta && $end){
                
                if($type2){
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="百度" and type=%d',$end1,$type3));
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="谷歌" and type=%d',$end1,$type3));
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="360" and type=%d',$end1,$type3));
                    $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="搜狗" and type=%d',$end1,$type3));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   unix_timestamp(time)<%d and name="神马" and type=%d',$end1,$type3));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   unix_timestamp(time)<%d and name="必应" and type=%d',$end1,$type3));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)<%d and name="头条"  and type=%d',$end1,$type3));
                }else{
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="百度" ',$end1));
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="谷歌" ',$end1));
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="360"',$end1));
                    $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  unix_timestamp(time)<%d and name="搜狗" ',$end1));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   unix_timestamp(time)<%d and name="神马"',$end1));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   unix_timestamp(time)<%d and name="必应" ',$end1));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where unix_timestamp(time)<%d and name="头条"  ',$end1));
                }
            }else{
                if($type2){
                    $baidu = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="百度" and type=%d',$type3));
                    $guge = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="谷歌"  and type=%d',$type3));
                    $a360 = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="360"   and type=%d',$type3));
                    $sougou = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="搜狗" and type=%d ',$type3));
                    $shenma = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where    name="神马" and type=%d',$type3));
                    $biying = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where    name="必应"  and type=%d',$type3));
                    $toutiao = $wpdb->query($wpdb->prepare('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="头条" and type=%d',$type3));
                }else{
                     $baidu = $wpdb->query('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="百度" ');
                    $guge = $wpdb->query('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="谷歌"  ');
                    $a360 = $wpdb->query('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="360"   ');
                    $sougou = $wpdb->query('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where   name="搜狗"  ');
                    $shenma = $wpdb->query('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where    name="神马" ');
                    $biying = $wpdb->query('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where    name="必应"  ');
                    $toutiao = $wpdb->query('select id from '.$wpdb->prefix . 'keyspider_zhizhu  where  name="头条" ');
                }
            }
           
        }
        
        
        if($search){
            $search = '%'.$search.'%';
            $sql .= "address like %s ";
        }else{
            $search = '1';
            $sql .= " %d ";
        }
        if($sta){
            $sta = strtotime($sta)-$timezone_offet*3600;
            $sql .= 'and unix_timestamp(time)>%d ';
        }else{
            $sta =0;
            $sql .= 'and unix_timestamp(time)>%d ';
        }
        if($end){
            $end = strtotime($end)-$timezone_offet*3600;
            $sql .= 'and  unix_timestamp(time)<%d ';
        }else{
            $end = time()+$timezone_offet*3600;
            $sql .= 'and  unix_timestamp(time)<%d ';
        }
        
        $type = (int)$type;
        if($type==0){
            $type='1';
            $sql .= 'and %d ';
        }else{
            switch($type){
                case 1://百度
                    $type='百度';
                    $sql .= 'and name = %s ';
                    break;
                case 2://谷歌
                    $type='谷歌';
                    $sql .= 'and name = %s ';
                    break;
                case 3:
                    $type='360';
                    $sql .= 'and name = %s ';
                    break;
                case 4:
                    $type='搜狗';
                    $sql .= 'and name = %s ';
                    break;
                case 5:
                    $type='神马';
                    $sql .= 'and name = %s ';
                    break;
                case 6:
                    $type='必应';
                    $sql .= 'and name = %s ';
                    break;
                case 7:
                    $type='头条';
                    $sql .= 'and name = %s ';
                    break;
            }
        }
        if($type2){
            switch($type2){
                case 8:
                    $type2='301';
                    $sql .= 'and type =%s ';
                    break;
                case 9:
                    $type2='404';
                    $sql .= 'and type =%s ';
                    break;
                case 10:
                    $type2='200';
                    $sql .= 'and type =%s ';
                    break;
            }
        }else{
            $type2='1';
            $sql .= 'and %d ';
        }
        $start = ($page-1)*$limit;
      
        $count = $wpdb->query($wpdb->prepare($sql,$search,$sta,$end,$type,$type2));
        if($orders==1){
            $sql .= 'order by num desc limit %d,%d ';
        }elseif($orders==2){
            $sql .= 'order by num asc limit %d,%d ';
        }else{
            $sql .= 'order by time desc limit %d,%d ';
        }
        $zhizhu = $wpdb->get_results($wpdb->prepare($sql,$search,$sta,$end,$type,$type2,$start,$limit),ARRAY_A);
        $keyspider_zhizhu = get_option('keyspider_zhizhu');
          $other = [];
            $other1 = [];
        if(isset($keyspider_zhizhu['type'])){
            if($type==1){
                if(strpos($keyspider_zhizhu['type'],'1')!==false){
                    $other[] = $baidu;
                    $other1[] = '百度';
                }
                if(strpos($keyspider_zhizhu['type'],'2')!==false){
                    $other[] = $guge;
                    $other1[] = 'Google';
                }
                 if(strpos($keyspider_zhizhu['type'],'3')!==false){
                    $other[] = $a360;
                    $other1[] = '360';
                }
                 if(strpos($keyspider_zhizhu['type'],'4')!==false){
                    $other[] = $sougou;
                    $other1[] = '搜狗';
                }
                 if(strpos($keyspider_zhizhu['type'],'5')!==false){
                    $other[] = $shenma;
                    $other1[] = '神马';
                }
                 if(strpos($keyspider_zhizhu['type'],'6')!==false){
                    $other[] = $biying;
                    $other1[] = 'Bing';
                }
                 if(strpos($keyspider_zhizhu['type'],'7')!==false){
                    $other[] = $toutiao;
                    $other1[] = '头条';
                }
            }elseif($type=='百度'){
                if(strpos($keyspider_zhizhu['type'],'1')!==false){
                    $other[] = $baidu;
                    $other1[] = '百度';
                }
            }elseif($type=='谷歌'){
                 if(strpos($keyspider_zhizhu['type'],'2')!==false){
                    $other[] = $guge;
                    $other1[] = 'Google';
                }
            }elseif($type=='360'){
                if(strpos($keyspider_zhizhu['type'],'3')!==false){
                    $other[] = $a360;
                    $other1[] = '360';
                }
            }elseif($type=='搜狗'){
                if(strpos($keyspider_zhizhu['type'],'4')!==false){
                    $other[] = $sougou;
                    $other1[] = '搜狗';
                }
            }elseif($type=='神马'){
                if(strpos($keyspider_zhizhu['type'],'5')!==false){
                    $other[] = $shenma;
                    $other1[] = '神马';
                }
            }elseif($type=='必应'){
                  if(strpos($keyspider_zhizhu['type'],'6')!==false){
                    $other[] = $biying;
                    $other1[] = 'Bing';
                }
            }elseif($type=='头条'){
                if(strpos($keyspider_zhizhu['type'],'7')!==false){
                    $other[] = $toutiao;
                    $other1[] = '头条';
                }
            }
             
        }
        
        echo json_encode(['code'=>1,'msg'=>'','count'=>$count,'data'=>$zhizhu,'other'=>$other,'other1'=>$other1,'pagesize'=>15,'total'=>ceil($count/15)]);exit; 
    }
    public static function pay_money(){
        global $keyspider_wzt_log;
        if(!$keyspider_wzt_log){
            return 0;
        }
        $data =  isset($_SERVER['SERVER_NAME'])?sanitize_text_field(wp_unslash($_SERVER['SERVER_NAME'])):'';
        $url = "https://api.seoceo.cn/api/index/pay_money?url={$data}&type=4&log={$keyspider_wzt_log}";
        $defaults = array(
            'timeout' => 4000,
            'connecttimeout'=>4000,
            'redirection' => 3,
            'user-agent' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36',
            'sslverify' => FALSE,
        );
        $result = wp_remote_get($url,$defaults);
        if(!is_wp_error($result)){
            $content = wp_remote_retrieve_body($result);
            $content = json_decode($content,true);
            if(isset($content['status']) && $content['status']==1){
                if(isset($content['token1']) && $content['token1']){
                    $keyspider_wzt_token1 = get_option('keyspider_wzt_token1');
                    if($keyspider_wzt_token1===false){
                        add_option('keyspider_wzt_token1',$content['token1']);
                    }else{
                        update_option('keyspider_wzt_token1',$content['token1']);
                    }
                }
                if(isset($content['token2']) && $content['token2']){
                    $keyspider_wzt_token2 = get_option('keyspider_wzt_token2');
                    if($keyspider_wzt_token2===false){
                        add_option('keyspider_wzt_token2',$content['token2']);
                    }else{
                        update_option('keyspider_wzt_token2',$content['token2']);
                    }
                }
                if(isset($content['token3']) && $content['token3']){
                    $keyspider_wzt_token3 = get_option('keyspider_wzt_token3');
                    if($keyspider_wzt_token3===false){
                        add_option('keyspider_wzt_token3',$content['token3']);
                    }else{
                        update_option('keyspider_wzt_token3',$content['token3']);
                    }
                }
                return 1;
            }
        }else{
            return keyspider_tag::pay_money();
        }
    }
    public static function keyspider_zhizhu_tubiao($year,$month){
        global $wpdb;
       
        
        $year = $year?$year:current_time('Y');
        $month = $month?$month:current_time( 'm');
        $month_31 = ['01','03','05','07','08','10','12'];
        $month_30 = ['04','06','09','11'];
        
       
        if($month=='02'){
            if($year%4==0){
                $suoyin_day =['01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29'];
                
               
            }else{
               $suoyin_day =['01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28'];
            }
             
        }elseif(in_array($month,$month_31)){
            $suoyin_day =['01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31'];
        }elseif(in_array($month,$month_30)){
            $suoyin_day =['01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30'];
        }
        foreach($suoyin_day as $val){
           
            $suoyin_baidu = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="百度" and num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_guge = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="谷歌" and num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_360 = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="360" and num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_sougou = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="搜狗" and num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_biying = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="必应" and num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_shenma = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="神马" and num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_toutiao = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="头条" and num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             
             
              $suoyin_baidu3 = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="百度" and zhizhu_num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_guge3 = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="谷歌" and zhizhu_num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_3603 = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="360" and zhizhu_num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_sougou3 = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="搜狗" and zhizhu_num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_biying3 = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="必应" and zhizhu_num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_shenma3 = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="神马" and zhizhu_num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             $suoyin_toutiao3 = $wpdb->get_results($wpdb->prepare('select num,zhizhu_num from '.$wpdb->prefix . 'keyspider_zhizhu_suoyin  where  name="头条" and zhizhu_num>0 and date(time)="%d-%d-%d"',$year,$month,$val),ARRAY_A);
             if(isset($suoyin_baidu[0]['num'])){
                 $suoyin_baidu1[] = $suoyin_baidu[0]['num'];
             }else{
                 $suoyin_baidu1[] = 0; 
             }
             if(isset($suoyin_360[0]['num'])){
                 $suoyin_3601[] = $suoyin_360[0]['num'];
             }else{
                 $suoyin_3601[] = 0; 
             }
             if(isset($suoyin_sougou[0]['num'])){
                 $suoyin_sougou1[] = $suoyin_sougou[0]['num'];
             }else{
                 $suoyin_sougou1[] = 0; 
             }
             if(isset($suoyin_biying[0]['num'])){
                 $suoyin_biying1[] = $suoyin_biying[0]['num'];
             }else{
                 $suoyin_biying1[] = 0; 
             }
             if(isset($suoyin_baidu3[0]['zhizhu_num'])){
                 $suoyin_baidu2[] = $suoyin_baidu3[0]['zhizhu_num'];
             }else{
                 $suoyin_baidu2[] = 0; 
             }
             if(isset($suoyin_guge3[0]['zhizhu_num'])){
                 $suoyin_guge2[] = $suoyin_guge3[0]['zhizhu_num'];
             }else{
                 $suoyin_guge2[] = 0; 
             }
             if(isset($suoyin_3603[0]['zhizhu_num'])){
                 $suoyin_3602[] = $suoyin_3603[0]['zhizhu_num'];
             }else{
                 $suoyin_3602[] = 0; 
             }
             if(isset($suoyin_sougou3[0]['zhizhu_num'])){
                 $suoyin_sougou2[] = $suoyin_sougou3[0]['zhizhu_num'];
             }else{
                 $suoyin_sougou2[] = 0; 
             }
             if(isset($suoyin_biying3[0]['zhizhu_num'])){
                 $suoyin_biying2[] = $suoyin_biying3[0]['zhizhu_num'];
             }else{
                 $suoyin_biying2[] = 0; 
             }
             if(isset($suoyin_shenma3[0]['zhizhu_num'])){
                 $suoyin_shenma2[] = $suoyin_shenma3[0]['zhizhu_num'];
             }else{
                 $suoyin_shenma2[] = 0; 
             }
             if(isset($suoyin_toutiao3[0]['zhizhu_num'])){
                 $suoyin_toutiao2[] = $suoyin_toutiao3[0]['zhizhu_num'];
             }else{
                 $suoyin_toutiao2[] = 0; 
             }
        }
        $suoyin_day = implode(',',$suoyin_day);
        $suoyin_baidu1 = implode(',',$suoyin_baidu1);
        $suoyin_3601 = implode(',',$suoyin_3601);
        $suoyin_sougou1 = implode(',',$suoyin_sougou1);
        $suoyin_biying1 = implode(',',$suoyin_biying1);
        $suoyin_baidu2 = implode(',',$suoyin_baidu2);
        $suoyin_3602 = implode(',',$suoyin_3602);
        $suoyin_sougou2 = implode(',',$suoyin_sougou2);
        $suoyin_biying2 = implode(',',$suoyin_biying2);
        $suoyin_guge2 = implode(',',$suoyin_guge2);
        $suoyin_shenma2 = implode(',',$suoyin_shenma2);
        $suoyin_toutiao2 = implode(',',$suoyin_toutiao2);
        $year_month = $year.'-'.$month;
        $keyspider_zhizhu = get_option('keyspider_zhizhu');
        
        if(isset($keyspider_zhizhu['type'])){
            $other = [];
            $other1 = [];
            $suoyin = [];
            if(strpos($keyspider_zhizhu['type'],'1')!==false){
                $other[] = $suoyin_baidu2;
                $other1[] = '百度';
                $suoyin['baidu'] = $suoyin_baidu1;
            }
            if(strpos($keyspider_zhizhu['type'],'2')!==false){
                $other[] = $suoyin_guge2;
                $other1[] = 'Google';
            }
             if(strpos($keyspider_zhizhu['type'],'3')!==false){
                $other[] = $suoyin_3602;
                $other1[] = '360';
                // $suoyin['360'] = $suoyin_sougou1;
            }
             if(strpos($keyspider_zhizhu['type'],'4')!==false){
                $other[] = $suoyin_sougou2;
                $other1[] = '搜狗';
                // $suoyin['sougou'] = $suoyin_3601;
            }
             if(strpos($keyspider_zhizhu['type'],'5')!==false){
                $other[] = $suoyin_shenma2;
                $other1[] = '神马';
            }
             if(strpos($keyspider_zhizhu['type'],'6')!==false){
                $other[] = $suoyin_biying2;
                $other1[] = 'Bing';
                // $suoyin['bing'] = $suoyin_biying1;
            }
             if(strpos($keyspider_zhizhu['type'],'7')!==false){
                $other[] = $suoyin_toutiao2;
                $other1[] = '头条';
            }
             
        }
        
        echo json_encode(['code'=>1,'suoyin'=>$suoyin,'zhizhu'=>['day'=>$suoyin_day,'time'=>$year_month],'other'=>$other,'other1'=>$other1]);exit;
    }
    
}
?>