<?php
$system_password='sem2022';   //这里的密码要和软件里对应
$prefix='wp_';		  //wordpress数据表前缀
require_once("wp-config.php");  //引用路径

if (get_magic_quotes_gpc()) {
    function stripslashes_deep($value)
    {
        $value = is_array($value) ?
                    array_map('stripslashes_deep', $value) :
                    stripslashes($value);
        return $value;
    }
    $_POST = array_map('stripslashes_deep', $_POST);
    $_GET = array_map('stripslashes_deep', $_GET);
    $_COOKIE = array_map('stripslashes_deep', $_COOKIE);
}

if (empty($_REQUEST["password"]))
{
    echo 'parameters_error';
    return;
}

if($system_password!=$_REQUEST["password"])
{
    echo 'password_error';
    return;
}

if(!empty($_REQUEST["filename"]))
{
  $uploadpath=$_REQUEST['uploadpath'];
  $filename=$_REQUEST['filename'];
  $rootPath=GetRootPath();

  if($uploadpath!="")
  {
    createFolder($rootPath.'/'.$uploadpath);
    $savePath=$rootPath.'/'.$uploadpath.'/'.$filename;
  }
  else
  {
    $savePath=$rootPath.'/'.$filename;
  }

  if(file_exists($savePath))
  { 
    chmod($savePath,0777);
  }

  move_uploaded_file($_FILES["upfile"]["tmp_name"],$savePath);

  if(file_exists($savePath))
  { 
    echo "upload success";
    exit;
  }
}

function createFolder($path) 
{
    if (!file_exists($path))
    {
        createFolder(dirname($path));
        mkdir($path, 0777);
    }
}

$conn=mysqli_connect(constant("DB_HOST"),constant("DB_USER"),constant("DB_PASSWORD"));
mysqli_query($conn,"SET NAMES UTF8");
mysqli_select_db($conn,constant("DB_NAME"));

$userid=1;
$siteurl=$_REQUEST['siteurl'];
$post_id=0;
$post_title=$_REQUEST['post_title'];
$post_content=$_REQUEST['post_content'];
$post_name=$_REQUEST['post_name'];
$guid=$_REQUEST['guid'];
$cate_name=$_REQUEST['cate_name'];
$cate_slug=$_REQUEST['cate_slug'];
$tags=explode(',',str_replace("%2c",",",$_REQUEST['tags']));
$slugs=explode(',',str_replace("%2c",",",$_REQUEST['slugs']));
$post_date=$_REQUEST['post_date'];
$post_status='publish';
if(isset($_REQUEST['post_status']))
{
	$post_status=$_REQUEST['post_status'];
}

$post_name=urlencode($post_name);
$cate_slug=urlencode($cate_slug);

$term_id=0;
$term_taxonomy_id=0;

//STEP0
$sql="update ".$prefix."posts set post_status='publish' where post_status='future' and post_date<=now()";
mysqli_query($conn,$sql);

//STEP1=====
$sql="insert into ".$prefix."posts (post_author,post_date,post_date_gmt,post_content,post_title,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count) values (".$userid.",'".$post_date."','".$post_date."','".$post_content."','".$post_title."','','".$post_status."','closed','open','','".$post_name."','','','".$post_date."','".$post_date."','',0,'".$guid."',0,'post','',0)";
mysqli_query($conn,$sql);
$post_id=mysqli_insert_id($conn);

//step2=====
if(!empty($cate_name))
{
    $sql="select term_id from ".$prefix."terms where name='".$cate_name."' limit 0,1";
    $result=mysqli_query($conn,$sql);
    if(mysqli_affected_rows($conn)==0)
    {
        $sql="insert into ".$prefix."terms (name,slug,term_group) values ('".$cate_name."','".$cate_slug."',0)";
        mysqli_query($conn,$sql);
        $term_id=mysqli_insert_id($conn);

        $sql="insert into ".$prefix."term_taxonomy (term_id,taxonomy,description,parent,count) values (".$term_id.",'category','',0,0)";
        mysqli_query($conn,$sql);
        $term_taxonomy_id=mysqli_insert_id($conn);
    }
    else
    {
        $rs=mysqli_fetch_object($result);
        $term_id=$rs->term_id;
        
        $sql="select term_taxonomy_id from ".$prefix."term_taxonomy where term_id=".$term_id." limit 0,1";
        $result=mysqli_query($conn,$sql);
        $rs=mysqli_fetch_object($result);
        $term_taxonomy_id=$rs->term_taxonomy_id;
    }
    
    $sql="insert into ".$prefix."term_relationships (object_id,term_taxonomy_id,term_order) values (".$post_id.",".$term_taxonomy_id.",0)";
    mysqli_query($conn,$sql);
    
    $sql="update ".$prefix."term_taxonomy set count=count+1 where term_taxonomy_id=".$term_taxonomy_id;
    mysqli_query($conn,$sql);
}

//STEP3=====
for($s=0;$s<count($tags);$s++)
{
    if(empty($tags[$s]))
        continue;

    $slug=urlencode($slugs[$s]);
        
    $sql="select term_id from ".$prefix."terms where name='".$tags[$s]."' limit 0,1";
    $result=mysqli_query($conn,$sql);
    if(mysqli_affected_rows($conn)==0)
    {
        $sql="insert into ".$prefix."terms (name,slug,term_group) values ('".$tags[$s]."','".$slug."',0)";
        mysqli_query($conn,$sql);
        $term_id=mysqli_insert_id($conn);
		
        $sql="insert into ".$prefix."term_taxonomy (term_id,taxonomy,description,parent,count) values (".$term_id.",'post_tag','',0,0)";
        mysqli_query($conn,$sql);
        $term_taxonomy_id=mysqli_insert_id($conn);
    }
    else
    {
        $rs=mysqli_fetch_object($result);
        $term_id=$rs->term_id;
        
        $sql="select term_taxonomy_id from ".$prefix."term_taxonomy where term_id=".$term_id." limit 0,1";
        $result=mysqli_query($conn,$sql);
        $rs=mysqli_fetch_object($result);
        $term_taxonomy_id=$rs->term_taxonomy_id;
    }
    
    $sql="insert into ".$prefix."term_relationships (object_id,term_taxonomy_id,term_order) values (".$post_id.",".$term_taxonomy_id.",0)";
    mysqli_query($conn,$sql);
    
    $sql="update ".$prefix."term_taxonomy set count=count+1 where term_taxonomy_id=".$term_taxonomy_id;
    mysqli_query($conn,$sql);
}

//push_to_xiongzhangtian($siteurl,$post_id);
//push_to_xiongzhangzhou($siteurl,$post_id);
//push_to_baidu($siteurl,$post_id);

echo '|success|'.$siteurl.'/?p='.$post_id.'|';
mysqli_close($conn);

//提交熊掌号天
function push_to_xiongzhangtian($SiteUrlPrefix,$ID) {
$url=$SiteUrlPrefix.'/?p='.$ID;
$urls = array($url);
$api ='http://data.zz.baidu.com/urls?appid=1629957525196803&token=Dk9rEnTYH9h5mtW5&type=realtime';//此位置更换熊掌token
$ch = curl_init();
$options = array(
CURLOPT_URL => $api,
CURLOPT_POST => true,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_POSTFIELDS => implode("\n", $urls),
CURLOPT_HTTPHEADER => array('Content-Type: text/plain'),
 );
curl_setopt_array($ch, $options);
$result = curl_exec($ch);
echo $result;
}
//提交熊掌号周
function push_to_xiongzhangzhou($SiteUrlPrefix,$ID) {
$url=$SiteUrlPrefix.'/?p='.$ID;
$urls = array($url);
$api ='http://data.zz.baidu.com/urls?appid=1629957525196803&token=Dk9rEnTYH9h5mtW5&type=batch';//此位置更换熊掌token
$ch = curl_init();
$options = array(
CURLOPT_URL => $api,
CURLOPT_POST => true,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_POSTFIELDS => implode("\n", $urls),
CURLOPT_HTTPHEADER => array('Content-Type: text/plain'),
 );
 curl_setopt_array($ch, $options);
 $result = curl_exec($ch);
 echo $result;
}

//提交百度收录
function push_to_baidu($SiteUrlPrefix,$ID) {
  $url=$SiteUrlPrefix.'?p='.$ID;
  $urls = array($url);
  $api ='http://data.zz.baidu.com/urls?site=www.0511art.com&token=iqasmV28GPCG4WjN';//此位置更换百度token
  $ch = curl_init();
  $options = array(
  CURLOPT_URL => $api,
  CURLOPT_POST => true,
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_POSTFIELDS => implode("\n", $urls),
  CURLOPT_HTTPHEADER => array('Content-Type: text/plain'),
  );
  curl_setopt_array($ch, $options);
  $result = curl_exec($ch);
  echo $result;
}
function GetRootPath()
{
    $returnVal=$_SERVER['DOCUMENT_ROOT'];
    $locationUrl=GetLocationURL();
    $arrParts=explode("/",$locationUrl);
    $prevUrl='';
    for($n=0;$n<count($arrParts)-4;$n++)
    {
        if($n==0)
        {
            $prevUrl.= '/../';
        }
        else
        {
            $prevUrl.= '../';
        }
    }
    $returnVal=realpath(dirname(__FILE__).$prevUrl);
    return $returnVal;
}
function GetLocationURL()
{
  $pageURL = '';
  if ($_SERVER['SERVER_PORT'] != '80')
  {
      $pageURL = 'https://'. $_SERVER['HTTP_HOST'].':'.$_SERVER['PHP_SELF'];
  }
  else
  {
      $pageURL = 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'];
  }
  return $pageURL;
}
?>