It's simple – really simple!
It's really tough!
Empire CMS boasts an astonishingly high article capacity!
As a result, some users need to import articles in bulk into Empire CMS!
And so, this plugin was born!
Configured PHP:
<?php
//存放txt的文件夹
$AddNews['target'] = '物理知识16-3万';
//分类ID
$AddNews['class'] = '4';
//用户名
$AddNews['user'] = 'admin';
//发布起始时间
$AddNews['addTime'] = "2024-4-10 17:56:36";
//每篇文章，相互间隔多少，单位秒，可设置随机
$AddNews['addTimeSecond'] = 60;
// 每次发布多少篇文章
$AddNews['pagnum'] = '1000';
// 随机浏览量
$AddNews['readMin'] = '100'; //最小值
$AddNews['readMax'] = '800'; //最大值
// 生成简介的字数
$AddNews['num'] = '100';Access the generated PHP file:
隐藏内容：付费阅读
<?php
require('./config.php');
/****以下代码非专业人员不建议修改***************/
define('EmpireCMSAdmin','1');
require("../class/connect.php");
require("../class/db_sql.php");
require("../class/functions.php");
require LoadLang("pub/fun.php");
require("../class/delpath.php");
require("../class/copypath.php");
require("../class/t_functions.php");
require("../data/dbcache/class.php");
require("../data/dbcache/MemberLevel.php");
if($_GET['endTime']){
$AddNews['addTime'] = $_GET['endTime'];
}
$POST = array(
"enews" => "AddNews", // 操作类型
"classid" => $AddNews['class'], // 类别ID
"bclassid" => "0", // 父类别ID
"id" => "0", // 文章ID
"filepass" => "[Timestamp:时间]", // 文件密码
"username" => $AddNews['user'], // 用户名
"oldfilename" => "", // 旧文件名
"oldgroupid" => "", // 旧用户组ID
"oldchecked" => "1", // 旧审核状态
"newstext_url" => "", // 新闻链接
"ecmsfrom" => "", // 来源
"ecmsnfrom" => "1", // 是否显示来源
"fstb" => "", // 标题加粗
"oldttid" => "", // 旧标题分类ID
"ecmscheck" => "0", // 是否审核
"ztids" => "", // 所属专题ID
"zcids" => "", // 所属专栏ID
"oldztids" => "", // 旧所属专题ID
"oldzcids" => "", // 旧所属专栏ID
"havetmpic" => "0", // 是否有临时图片
"title" => "", // 标题
"titlecolor" => "", // 标题颜色
"ftitle" => "", // 副标题
"checked" => "1", // 审核状态
"isgood" => "0", // 是否推荐
"firsttitle" => "0", // 是否头条
"keyboard" => "", // 关键词
"titleurl" => "", // 标题链接
"newstime" => "2023-11-22 17:56:36", // 发布时间
"titlepic" => "", // 缩略图
"smalltext" => "", // 简介
"writer" => "", // 作者
"w_id" => "", // 作者ID
"befrom" => "", // 资讯来源
"befrom_id" => "选择信息来源", // 资讯来源ID
"newstext" => "", // 正文内容
"dokey" => "1", // 是否生成关键词
"qz_url" => "", // 网址前缀
"autosize" => "5000", // 自动提取摘要字数
"getfirsttitlepic" => "", // 是否获取第一个标题图片
"getfirsttitlespicw" => "105", // 获取第一个标题图片宽度
"getfirsttitlespich" => "118", // 获取第一个标题图片高度
"istop" => "0", // 是否置顶
"newstempid" => "1", // 内容模板ID
"groupid" => "0", // 用户组ID
"userfen" => "0", // 用户积分
"onclick" => "62", // 点击数
"totaldown" => "0", // 下载数
"newspath" => "", // 存放目录
"filename" => "", // 文件名
"infotags" => "", // 信息标签
"oldinfotags" => "", // 旧信息标签
"info_diyotherlink" => "0", // 是否自定义相关链接
"info_keyid" => "", // 相关信息关联ID
"info_infouptime" => "2023-11-22 17:56:36", // 信息发布时间
"info_infodowntime" => "", // 信息下架时间
"vote_title" => "", // 投票标题
"vote_name" => ["", "", "", "", "", "", "", ""], // 投票选项名称
"vote_num" => ["0", "0", "0", "0", "0", "0", "0", "0"], // 投票选项初始票数
"v_vote_num" => "1", // 投票选项总数
"v_editnum" => "8", // 可编辑的投票选项数
"vote_class" => "0", // 投票类型
"dovote_ip" => "0", // 投票限制方式
"vote_olddotime" => "0000-00-00", // 投票开始时间
"vote_dotime" => "0000-00-00", // 投票结束时间
"vote_width" => "500", // 投票宽度
"vote_height" => "300", // 投票高度
"vote_tempid" => "1", // 投票模板ID
"addnews" => "提交" // 提交操作标识
);
//获取分类列表
foreach($class_r as $kv)
{
if($kv['modid']=='1')
{
$cates[]=array('cname'=>$kv['classname'],'cid'=>$kv['classid'],'pid'=>$kv['bclassid']);
}
}
$link=db_connect();
$empire=new mysqlquery();
//验证用户
$loginin=$AddNews['user'];
$lur=$empire->fetch1("select * from {$dbtbpre}enewsuser where `username` = '{$loginin}'");
if(!$lur) exit('不存在的用户名'.$loginin);
$loginin = $lur['username'];
$logininid=$lur['userid'];
$loginrnd=$lur['rnd'];
$loginlevel=$lur['groupid'];
$loginadminstyleid=$lur['adminstyleid'];
$incftp=0;
if($public_r['phpmode'])
{
include("../class/ftp.php");
$incftp=1;
}
require("../class/hinfofun.php");
$navtheid=(int)$_POST['filepass'];
if ($dh = opendir('./'.$AddNews['target'].'/')) {
$fileCount = 0; // 计算已读取的文件数量
while (($file = readdir($dh)) !== false) {
if ($file != '.' && $file != '..' && pathinfo($file, PATHINFO_EXTENSION) == 'txt') {
$filePath = './'.$AddNews['target'].'/'.$file;
$content = file_get_contents($filePath);
$title = basename($filePath,'.txt');
//处理post数据
$_POST = '';
$_POST = $POST;
// 文章标题
$_POST['title'] = $title;
$_POST['newstext'] = $content;
$_POST['onclick'] = mt_rand($AddNews['readMin'],$AddNews['readMax']);
$_POST['smalltext'] = SubSmalltextVal($content,$AddNews['num']*2);
$AddNews['addTime'] = add_seconds_to_time($AddNews['addTime'],$AddNews['addTimeSecond'],'Y-m-d H:i:s');
$_POST['newstime'] = $AddNews['addTime'];
$_POST['info_infouptime'] = $AddNews['addTime'];
$navtheid=(int)$_POST['filepass'];
// print_r($_POST);
// 将文件内容插入数据库表
AddNewsTwo($_POST,$logininid,$loginin,$filePath,$fileCount);
$fileCount++;
if($fileCount == ($AddNews['pagnum'])){
$url = 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']."?endTime=".$_POST['newstime'];
echo '<meta http-equiv="refresh" content="0; url='.$url.'">';
}
// 如果已读取的文件数量达到设定的限制，停止读取
if ($fileCount >= $AddNews['pagnum']) {
break;
}
}
}
closedir($dh);
}
/**
* 将指定时间与时间戳相加减后，输出指定格式时间
*
* @param string $time 日期时间字符串，格式为 'Y-m-d H:i:s'
* @param int $seconds 要添加或减去的秒数，正数为加，负数为减
* @param string $format 输出的日期时间格式，默认为 'Y-m-d H:i:s'
* @return string 格式化后的日期时间字符串
*/
function add_seconds_to_time($time, $seconds, $format = 'Y-m-d H:i:s') {
// 将日期时间字符串转换为时间戳
$timestamp = strtotime($time);
// 计算加减后的时间戳
$new_timestamp = $timestamp + $seconds;
// 将时间戳格式化为指定格式的日期时间字符串
$new_time = date($format, $new_timestamp);
// 返回格式化后的日期时间字符串
return $new_time;
}
//增加信息
function AddNewsTwo($add,$userid,$username,$filePath,$fileCount){
global $empire,$class_r,$class_zr,$bclassid,$public_r,$dbtbpre,$emod_r,$lur;
$add[classid]=(int)$add[classid];
$userid=(int)$userid;
if(!$add[title]||!$add[classid])
{
printerrorTwo("EmptyTitle","history.go(-1)");
}
//操作权限
$doselfinfo=CheckLevel($userid,$username,$add[classid],"news");
if(!$doselfinfo['doaddinfo'])//增加权限
{
printerrorTwo("NotAddInfoLevel","history.go(-1)");
}
$ccr=$empire->fetch1("select classid,modid,listdt,haddlist,sametitle,addreinfo,wburl,repreinfo from {$dbtbpre}enewsclass where classid='$add[classid]' and islast=1 limit 1");
if(!$ccr['classid']||$ccr['wburl'])
{
printerrorTwo("ErrorUrl","history.go(-1)");
}
// if($ccr['sametitle'])//标题
// {
// if(ReturnCheckRetitle($add))
// {
// printerrorTwo("ReInfoTitle","history.go(-1)");
// }
// }
//修改文件名权限
if(!$doselfinfo['doinfofile'])
{
$add['newspath']=date($class_r[$add['classid']]['newspath']);
$add['filename']='';
}
$add=DoPostInfoVar($add);//返回变量
$ret_r=ReturnAddF($add,$class_r[$add[classid]][modid],$userid,$username,0,0,1);//返回自定义字段
$newspath=FormatPath($add[classid],$add[newspath],1);//查看目录是否存在，不存在则建立
//审核权限
if(!$doselfinfo['docheckinfo'])
{
$add['checked']=$class_r[$add[classid]][checked];
}
//必须审核
if($doselfinfo['domustcheck'])
{
$add['checked']=0;
}
//推荐权限
if(!$doselfinfo['dogoodinfo'])
{
$add['isgood']=0;
$add['firsttitle']=0;
$add['istop']=0;
}
else
{
if(!eFirstTitleCheckLevel($add['isgood'],0))//推荐
{
$add['isgood']=0;
}
if(!eFirstTitleCheckLevel($add['firsttitle'],1))//头条
{
$add['firsttitle']=0;
}
}
//签发
$isqf=0;
if($class_r[$add[classid]][wfid])
{
$userisqf=EcmsReturnDoIsqf($userid,$username,$lur['groupid'],0);
if(!$userisqf)
{
$add[checked]=0;
$isqf=1;
}
}
$newstime=empty($add['newstime'])?time():to_time($add['newstime']);
$truetime=time();
$lastdotime=$truetime;
//是否生成
$havehtml=0;
if($add['checked']==1&&$ccr['addreinfo'])
{
$havehtml=1;
}
//返回关键字组合
if($add['info_diyotherlink'])
{
$keyid=DoPostDiyOtherlinkID($add['info_keyid']);
}
else
{
$keyid=GetKeyid($add[keyboard],$add[classid],0,$class_r[$add[classid]][link_num]);
}
//附加链接参数
$addecmscheck=empty($add['checked'])?'&ecmscheck=1':'';
//索引表
$sql=$empire->query("insert into {$dbtbpre}ecms_".$class_r[$add[classid]][tbname]."_index(classid,checked,newstime,truetime,lastdotime,havehtml) values('$add[classid]','$add[checked]','$newstime','$truetime','$lastdotime','$havehtml');");
$id=$empire->lastid();
$pubid=ReturnInfoPubid($add['classid'],$id);
$infotbr=ReturnInfoTbname($class_r[$add[classid]][tbname],$add['checked'],$ret_r['tb']);
//主表
$infosql=$empire->query("insert into ".$infotbr['tbname']."(id,classid,ttid,onclick,plnum,totaldown,newspath,filename,userid,username,firsttitle,isgood,ispic,istop,isqf,ismember,isurl,truetime,lastdotime,havehtml,groupid,userfen,titlefont,titleurl,stb,fstb,restb,keyboard".$ret_r['fields'].") values('$id','$add[classid]','$add[ttid]','$add[onclick]',0,'$add[totaldown]','$newspath','$filename','$userid','".addslashes($username)."','$add[firsttitle]','$add[isgood]','$add[ispic]','$add[istop]','$isqf',0,'$add[isurl]','$truetime','$lastdotime','$havehtml','$add[groupid]','$add[userfen]','".addslashes($add[my_titlefont])."','".addslashes($add[titleurl])."','$ret_r[tb]','$public_r[filedeftb]','$public_r[pldeftb]','".addslashes($add[keyboard])."'".$ret_r['values'].");");
//副表
$finfosql=$empire->query("insert into ".$infotbr['datatbname']."(id,classid,keyid,dokey,newstempid,closepl,haveaddfen,infotags".$ret_r['datafields'].") values('$id','$add[classid]','$keyid','$add[dokey]','$add[newstempid]','$add[closepl]',0,'".addslashes($add[infotags])."'".$ret_r['datavalues'].");");
//更新栏目信息数
AddClassInfos($add['classid'],'+1','+1',$add['checked']);
//更新新信息数
DoUpdateAddDataNum('info',$class_r[$add['classid']]['tid'],1);
//签发
if($isqf==1)
{
InfoInsertToWorkflow($id,$add[classid],$class_r[$add[classid]][wfid],$userid,$username);
}
//更新附件表
UpdateTheFile($id,$add['filepass'],$add['classid'],$public_r['filedeftb']);
//取第一张图作为标题图片
if($add['getfirsttitlepic']&&empty($add['titlepic']))
{
$firsttitlepic=GetFpicToTpic($add['classid'],$id,$add['getfirsttitlepic'],$add['getfirsttitlespic'],$add['getfirsttitlespicw'],$add['getfirsttitlespich'],$public_r['filedeftb']);
if($firsttitlepic)
{
$addtitlepic=",titlepic='".addslashes($firsttitlepic)."',ispic=1";
}
}
//文件命名
if($add['filename'])
{
$filename=$add['filename'];
}
else
{
$filename=ReturnInfoFilename($add[classid],$id,'');
}
//信息地址
$updateinfourl='';
if(!$add['isurl'])
{
$infourl=GotoGetTitleUrl($add['classid'],$id,$newspath,$filename,$add['groupid'],$add['isurl'],$add['titleurl']);
$updateinfourl=",titleurl='$infourl'";
}
$usql=$empire->query("update ".$infotbr['tbname']." set filename='$filename'".$updateinfourl.$addtitlepic." where id='$id'");
//替换图片下一页
if($add['repimgnexturl'])
{
UpdateImgNexturl($add[classid],$id,$add['checked']);
}
//投票
AddInfoVote($add['classid'],$id,$add);
//加入专题
InsertZtInfo($add['ztids'],$add['zcids'],$add['oldztids'],$add['oldzcids'],$add['classid'],$id,$newstime);
//TAGS
if($add[infotags]&&$add[infotags]<>$add[oldinfotags])
{
eInsertTags($add[infotags],$add['classid'],$id,$newstime);
}
//处理函数
DoMFun($class_r[$add['classid']]['modid'],$add['classid'],$id,1,0);
//增加信息是否生成文件
if($ccr['addreinfo']&&$add['checked'])
{
GetHtml($add['classid'],$id,'',0);
}
//生成上一篇
$epreid=0;
if($ccr['repreinfo']&&$add['checked'])
{
$prer=$empire->fetch1("select * from {$dbtbpre}ecms_".$class_r[$add[classid]][tbname]." where id<$id and classid='$add[classid]' order by id desc limit 1");
$epreid=$prer['id'];
GetHtml($add['classid'],$prer['id'],$prer,1);
}
//生成栏目
if($ccr['haddlist']&&$add['checked'])
{
hAddListHtml($add['classid'],$ccr['modid'],$ccr['haddlist'],$ccr['listdt']);//生成信息列表
if($add['ttid'])//生成标题分类列表
{
ListHtml($add['ttid'],'',5);
}
}
//同时发布
$copyclassid=$add[copyclassid];
$cpcount=count($copyclassid);
if($cpcount)
{
$copyids=AddInfoToCopyInfo($add[classid],$id,$copyclassid,$userid,$username,$doselfinfo);
if($copyids)
{
UpdateInfoCopyids($add['classid'],$id,$copyids);
}
}
//更新动态缓存
if($public_r['ctimeopen']&&$add['checked'])
{
eUpCacheInfo(1,$add['classid'],0,$epreid,$add['ttid'],'',$add['infotags'],0,0);
}
if($sql)
{
//返回地址
if($add['ecmsfrom']&&(stristr($add['ecmsfrom'],'ListNews.php')||stristr($add['ecmsfrom'],'ListAllInfo.php')))
{
$ecmsfrom=$add['ecmsfrom'];
}
else
{
$ecmsfrom=$add['ecmsnfrom']==1?"ListNews.php?bclassid=$add[bclassid]&classid=$add[classid]":"ListAllInfo.php?tbname=".$class_r[$add[classid]][tbname];
$ecmsfrom.=hReturnEcmsHashStrHref2(0);
}
$GLOBALS['ecmsadderrorurl']=$ecmsfrom.$addecmscheck;
insert_dolog("classid=$add[classid]<br>id=".$id."<br>title=".$add[title],$pubid);//操作日志
echo("{$fileCount}、成功导入文章：{$add[title]}<br>");
if(unlink($filePath)){
echo '已删除文件：' . str_replace('./','',$filePath) . '<br>';
}
}
else
{
echo '请检查数据库连接';
}
}
function printerrorTwo($msg = '',$targe = ''){
echo $msg,$targe;
}
db_close();
$empire=null;
