File "keywords.php"

Full Path: /www/wwwroot/shphe-en.com/wp-admin/pdf-demo/keywords.php
File size: 6.86 KB
MIME-type: --
Charset: utf-8

<?php
define( 'SITE_URL', $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['HTTP_HOST'] );
define( 'DOING_AJAX', true );
define( 'WP_ADMIN', true );

/** Load WordPress Bootstrap */
require_once( dirname( dirname( __FILE__ ) ) . '/wp-load.php' );

/** Allow for cross-domain requests (from the frontend). */
send_origin_headers();


/** Load WordPress Administration APIs */
require_once( ABSPATH . 'wp-admin/includes/admin.php' );

/** Load Ajax Handlers for WordPress Core */
require_once( ABSPATH . 'wp-admin/includes/ajax-actions.php' );

@header( 'Content-Type: text/html; charset=' . get_option( 'blog_charset' ) );
@header( 'X-Robots-Tag: noindex' );

send_nosniff_header();
nocache_headers();

do_action( 'admin_init' );

if ( !is_user_logged_in() ){
    echo json_encode(array('errorcode'=>2,'msg'=>'登录超时！请重新登录！'));exit;
}
if(!isset($_POST['keywords'])||!$_POST['keywords']){
    echo json_encode(array('errorcode'=>2,'msg'=>'请输入关键字！'));exit;
}
$tempArr=$_POST['keywords'];
$tagNameArr = array_filter($tempArr);//去空数组
foreach ($tagNameArr as $k => $v) {
    $tagNameArr[$k] = trim($v);//去除两端空字符
}

$tagNameArr = array_unique($tagNameArr);//去除重复值

if ($tagNameArr && count($tagNameArr) > 0) {
    $taxonomy = !empty($_POST['taxonomy']) ? $_POST['taxonomy'] : 'post_tag';
    global $wpdb;
    if(isset($_POST['is_del'])){//删除关键词

        foreach($tagNameArr as $vo){
            $tag = array();
            $slug=sanitize_title(stripslashes(wp_unslash($vo)));//去除特殊字符 大写并且转小写 别名
            $term=get_term_by('slug',$slug,'post_tag');//获取关键词id
            if($term){
                wp_delete_term( $term->term_id, 'post_tag' );
            }
        }
        do_action("wpfc_clear_all_cache", true);
        echo json_encode(array('errorcode'=>1,'msg'=>'刪除成功！'));exit;



    }else{//添加关键词

        $level = 0;
        $return_arr=array();
        $term_id_arr=array();
        $level=0;
        $description='';
        $parent='';
        foreach($tagNameArr as $vo){
            $tag = array();
            $slug=sanitize_title(stripslashes(wp_unslash($vo)));//去除特殊字符 大写并且转小写 别名

            //根据别名查询
            $existing_term = $wpdb->get_row( $wpdb->prepare( "SELECT name,term_id FROM $wpdb->terms WHERE slug = %s", $slug), ARRAY_A );
            if(!$existing_term){
                $name=wp_unslash($vo);
                $term_res = $wpdb->insert( $wpdb->terms, compact( 'name', 'slug' ));//添加关键词表
                if(!$term_res){
                    echo json_encode(array('errorcode'=>2,'msg'=>'关键词添加失败，请稍后重试！'));exit;
                }
                $term_id= (int) $wpdb->insert_id;
                $term_taxonomy_res=  $wpdb->insert( $wpdb->term_taxonomy, compact( 'term_id', 'taxonomy', 'description', 'parent') + array( 'count' => 0 ) );//添加关键词分类数据
                if(!$term_taxonomy_res){
                    echo json_encode(array('errorcode'=>2,'msg'=>'关键词分类添加失败，请稍后重试！'));exit;
                }
                $term_taxonomy_id = (int) $wpdb->insert_id;

                $tag['term_id']=$term_id;
                $tag['term_taxonomy_id']=$term_taxonomy_id;
                $tag['count']=$level;

                do_action("create_term", $term_id, $term_taxonomy_id, $taxonomy);
                do_action("create_$taxonomy", $term_id, $term_taxonomy_id);

                $term_id = apply_filters('term_id_filter', $term_id, $term_taxonomy_id);

                clean_term_cache($term_id, $taxonomy);

                do_action("created_term", $term_id, $term_taxonomy_id, $taxonomy);
                do_action("created_$taxonomy", $term_id, $term_taxonomy_id);

            }else{
                $term_id=$existing_term['term_id'];
                $term_taxonomy_res = $wpdb->get_row( $wpdb->prepare( "SELECT term_taxonomy_id,count FROM $wpdb->term_taxonomy WHERE term_id = %d", $term_id), ARRAY_A );

                if(!$term_taxonomy_res){
                    $term_taxonomy_res=  $wpdb->insert( $wpdb->term_taxonomy, compact( 'term_id', 'taxonomy', 'description', 'parent') + array( 'count' => 0 ) );//添加关键词分类数据
                    if(!$term_taxonomy_res){
                        echo json_encode(array('errorcode'=>2,'msg'=>'关键词分类添加失败，请稍后重试！'));exit;
                    }
                    $term_taxonomy_id = (int) $wpdb->insert_id;
                }else{
                    $term_taxonomy_id=$term_taxonomy_res['term_taxonomy_id'];
                }
                $tag['term_id']=$term_id;
                $tag['term_taxonomy_id']=$term_taxonomy_id;
                $tag['count']=$term_taxonomy_res['count']?$term_taxonomy_res['count']:0;
            }

            $tbnm = 'wp_term_flag';
            $is_tab= $wpdb->query('SHOW TABLES LIKE "' . $tbnm . '"');
            if($is_tab){
                $term_flag=$wpdb->get_var( $wpdb->prepare( "SELECT tfalg FROM wp_term_flag   WHERE  term_id = %d", $tag['term_id'] ) );
                if(!$term_flag){
                    $tm=date('Y-m-d H:i:s');
                    $term_res = $wpdb->query($wpdb->prepare("INSERT INTO wp_term_flag (term,term_id,intime) VALUES (%s,%d,%s)",$vo,$tag['term_id'],$tm));
                    $term_id_arr[$tag['term_id']]=$vo;
                }
            }
            $return_arr[]='<tr id="tag-"'.$tag['term_id'].' class="alternate"><th scope="row" class="check-column"><label class="screen-reader-text" for="cb-select-"'.$tag['term_id'].'>'.$vo.'</label><div class="cata"'.$tag['term_id'].'><input type="checkbox" name="delete_tags[]" value='.$tag['term_id'].' id="cb-select-"'.$tag['term_id'].'></div></th><td class="name column-name"><strong><a class="row-title" style="margin:0 20px 0 0" href="'.SITE_URL.'/'.$slug.'/'.'" target="_bank" title="查看分类页面">'.$vo.'</a></strong> <a class="row-title" href="'.SITE_URL.'/wp-admin/edit-tags.php?action=edit&taxonomy=post_tag&tag_ID='.$tag['term_id'].'&post_type=post">编辑</a><br><div class="row-actions"><span class="edit"><div style="float:left;" class="cata_"'.$tag['term_id'].'><a href="'.SITE_URL.'/wp-admin/edit-tags.php?action=edit&taxonomy=post_tag&tag_ID='.$tag['term_id'].'&post_type=post">编辑</a><span class="view"></span></div></span></div><div class="hidden" id="inline_"'.$tag['term_id'].'><div class="name">'.$vo.'</div><div class="slug">'.$slug.'</div><div class="parent">0</div></div></td><td class="description column-description"></td><td class="slug column-slug">'.$slug.'</td><td class="posts column-posts"><a href="'.SITE_URL.'/wp-admin/edit.php?tag='.$slug.'">'.$tag['count'].'</a></td></tr>';
        }
        echo json_encode(array('errorcode'=>1,'return_data'=>$return_arr));exit;

    }



} else {
    echo json_encode(array('errorcode'=>2,'msg'=>'请输入关键字！'));exit;
}