fetch1("select * from {$dbtbpre}enewsinfoclass where classid='$classid'");
//副表
$ra=$empire->fetch1("select * from {$dbtbpre}ecms_infoclass_".$r[tbname]." where classid='$classid'");
//组合两数组
$r=TogTwoArray($r,$ra);
//导入编码文件
if($r['enpagecode'])
{
@include_once(ECMS_PATH."e/class/doiconv.php");
}
//取得模型
$record="";
$field="";
$mr=$empire->fetch1("select cj,tid,tbname from {$dbtbpre}enewsmod where mid='".$class_r[$r[newsclassid]][modid]."'");
$cjr=explode($record,$mr[cj]);
$count=count($cjr);
if(empty($start))
{$start=0;}
$b=0;
$sql=$empire->query("select linkid,newsurl,titlepic from {$dbtbpre}enewslinktmp where checkrnd='$checkrnd' and linkid>".$start." order by linkid limit ".$r[renum]);
//采集时间
$newstime=date("Y-m-d H:i:s");
$truetime=time();
$tmptime=$newstime;
while($nr=$empire->fetch($sql))
{
$b=1;
$newstart=$nr[linkid];
if(!eCheckCjUrl($nr[newsurl],1))
{
continue;
}
//入库数据库是否有记录
if(empty($r[recjtheurl]))
{
$tmpnum=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_infotmp_".$r[tbname]." where oldurl='$nr[newsurl]' limit 1");
if($tmpnum)
{continue;}
}
//取得远程页面，三次取不到值的将不取值
for($i=1;$i<=3;$i++)
{
$info=ReadFiletext($nr[newsurl]);
if(!empty($info))
{
break;
}
}
if(empty($info))
{continue;}
//替换网页变量
$info=RepCjPagetextStr($info,$r);
//替换回车
$info=ReplaceFc($info);
//-----------------
$ifield="";
$ivalue="";
$next=0;
for($c=0;$c<$count-1;$c++)
{
$zzvalue="";
$cjr1=explode($field,$cjr[$c]);
$dofield=$cjr1[1];
$var="zz_".$dofield;
$var1="z_".$dofield;
$var2="qz_".$dofield;
$var3="save_".$dofield;
//标题图片
if($dofield=="titlepic")
{
if($nr[titlepic])
{
$zzvalue=$nr[titlepic];
$ifield.=",".$dofield;
$ivalue.=",'".addslashes($zzvalue)."'";
continue;
}
}
//图片集
if($dofield=="morepic"&&$r[$var])
{
//替换下载链接
$text=$r[$var];
//替换回车
$text=ReplaceFc($text);
$down=explode("[!empirecms!]",$text);
//小图
$zztext=RepInfoZZ($down[0],"ecmsspicurl",0);
$strtext=GetInfoStr($down[0],"ecmsspicurl",1);
$text1=stripSlashes(preg_replace($zztext,$strtext,$info));
//大图
if($down[1])
{
$zztext=RepInfoZZ($down[1],"ecmsbpicurl",0);
$strtext=GetInfoStr($down[1],"ecmsbpicurl",1);
$text2=stripSlashes(preg_replace($zztext,$strtext,$info));
}
//名称
if($down[2])
{
$zztext=RepInfoZZ($down[2],"ecmspicname",0);
$strtext=GetInfoStr($down[2],"ecmspicname",1);
$text3=stripSlashes(preg_replace($zztext,$strtext,$info));
}
$zzvalue=GetCjMorepicpath($text1,$text2,$text3,"ecmsspicurl","ecmsbpicurl","ecmspicname",$r[$var2]);
$ifield.=",".$dofield;
$ivalue.=",'".addslashes($zzvalue)."'";
continue;
}
//下载地址
if($dofield=="downpath"&&$r[$var])
{
//替换下载链接
$text=$r[$var];
//替换回车
$text=ReplaceFc($text);
$down=explode("[!empirecms!]",$text);
//地址
$zztext=RepInfoZZ($down[0],"ecmsdownpathurl",0);
$strtext=GetInfoStr($down[0],"ecmsdownpathurl",1);
$text1=stripSlashes(preg_replace($zztext,$strtext,$info));
//名称
if($down[1])
{
$zztext=RepInfoZZ($down[1],"ecmsdownpathname",0);
$strtext=GetInfoStr($down[1],"ecmsdownpathname",1);
$text2=stripSlashes(preg_replace($zztext,$strtext,$info));
}
$zzvalue=GetCjDownpath($text1,$text2,"ecmsdownpathurl","ecmsdownpathname",$r[$var2],0);
$ifield.=",".$dofield;
$ivalue.=",'".addslashes($zzvalue)."'";
continue;
}
//在线地址
if($dofield=="onlinepath"&&$r[$var])
{
//替换下载链接
$text=$r[$var];
//替换回车
$text=ReplaceFc($text);
$down=explode("[!empirecms!]",$text);
//地址
$zztext=RepInfoZZ($down[0],"ecmsonlinepathurl",0);
$strtext=GetInfoStr($down[0],"ecmsonlinepathurl",1);
$text1=stripSlashes(preg_replace($zztext,$strtext,$info));
//名称
if($down[1])
{
$zztext=RepInfoZZ($down[1],"ecmsonlinepathname",0);
$strtext=GetInfoStr($down[1],"ecmsonlinepathname",1);
$text2=stripSlashes(preg_replace($zztext,$strtext,$info));
}
$zzvalue=GetCjDownpath($text1,$text2,"ecmsonlinepathurl","ecmsonlinepathname",$r[$var2],1);
$ifield.=",".$dofield;
$ivalue.=",'".addslashes($zzvalue)."'";
continue;
}
if(empty($r[$var1]))
{
if($r[$var])
{
$zzvalue=ReturnCJ_str($r[$var],$dofield,$info);
if($zzvalue)
{
$zzvalue=$r[$var2].$zzvalue;
}
}
}
else
{$zzvalue=$r[$var1];}
//------------------------------信息时间
if($dofield=="newstime")
{
$newstime=$zzvalue;
if(empty($newstime))
{
$newstime=$tmptime;
}
else
{
$newstime=CjFormatNewstime($newstime);//时间转换
}
continue;
}
//------------------------------信息来源
if($dofield=="befrom"||$dofield=="writer")
{
//标题去除html代码
$zzvalue=strip_tags(str_replace("\r\n","",$zzvalue));
}
//------------------------------标题
if($dofield=="title")
{
//标题去除html代码
$zzvalue=ehtmlspecialchars(strip_tags(str_replace("\r\n","",$zzvalue)));
if(empty($zzvalue))
{
$next=1;
break;
}
$keyboard=sub($zzvalue,0,$r[keynum],false);
//标题是否包含关键字
if($r[keyboard])
{
$t=HaveKeyboard($zzvalue,$r[keyboard]);
if(empty($t))
{
$next=1;
break;
}
}
if($r[retitlewriter])//标题完全一样
{
//入库比较
$onum=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_".$class_r[$r[newsclassid]][tbname]." where title='".addslashes($zzvalue)."' and classid='$r[newsclassid]' limit 1");
if($onum)
{
$next=1;
break;
}
/*采集库比较
$onum=$empire->num("select id from {$dbtbpre}ecms_infotmp_".$r[tbname]." where title='".addslashes($zzvalue)."' limit 1");
if($onum)
{
$next=1;
break;
}
*/
}
if($r[titlelen])//标题相似
{
//入库比较
$c_title=addslashes(sub($zzvalue,0,$r[titlelen],false));
$onum=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_".$class_r[$r[newsclassid]][tbname]." where title like '%$c_title%' and classid='$r[newsclassid]' limit 1");
if($onum)
{
$next=1;
break;
}
/*采集比较
$onum=$empire->num("select id from {$dbtbpre}ecms_infotmp_".$r[tbname]." where title like '%$c_title%' limit 1");
if($onum)
{
$next=1;
break;
}
*/
}
}
//新闻内容分页
if($dofield=="newstext")
{
//是否有分页
if($r[pagezz]||$r[pageallzz])
{
//上下页式
if(empty($r[pagetype]))
{
$zzvalue.=GetMoreCjPagetext($nr[newsurl],$r[$var],$r[smallpagezz],$r[pagezz],$r[pagetype],$info,$r);
}
//全部列表式
else
{
$zzvalue.=GetMoreCjPagetextall($nr[newsurl],$r[$var],$r[smallpageallzz],$r[pageallzz],$r[pagetype],$info,$r);
}
}
}
//替换关键字
if(stristr($r['repf'],','.$dofield.','))
{
$zzvalue=RepInfoWord($zzvalue,$r[oldword],$r[newword]);
}
//广告过滤
if(stristr($r['repadf'],','.$dofield.','))
{
$zzvalue=RepAd($r[repad],$zzvalue);
}
//新闻内容
if(stristr($r['isnullf'],','.$dofield.','))
{
$ckzzvalue=trim($zzvalue);
if($r['newstextisnull']==1&&empty($ckzzvalue))
{
$next=1;
break;
}
}
$ifield.=",".$dofield;
$ivalue.=",'".addslashes($zzvalue)."'";
}
if($next)
{continue;}
//入临时库
$isql=$empire->query("insert into {$dbtbpre}ecms_infotmp_".$r[tbname]."(classid,oldurl,checked,keyboard,newstime,truetime,tmptime,userid,username".$ifield.") values($classid,'$nr[newsurl]',0,'".addslashes($keyboard)."','$newstime',$truetime,'$tmptime',$userid,'".addslashes($username)."'".$ivalue.");");
}
//采集结束
if(empty($b))
{
//删除记录
$del=$empire->query("delete from {$dbtbpre}enewslinktmp where checkrnd='$checkrnd'");
//更新最后时间
$ucjsql=$empire->query("update {$dbtbpre}enewsinfoclass set lasttime='".time()."' where classid='$classid'");
//自动入库
if($r['justloadin'])
{
echo $fun_r['cjLoadInInfos']."";
exit();
}
//单个节点
if(getcvar('recjnum',1)==1)
{
echo"".$fun_r['CjSuccess']."";
}
else
{
echo"".$r[classname]." ".$fun_r['CjSuccess'].", ";
echo"";
}
exit();
}
//echo"(ID:".$newstart.")";
echo"".$r[classname]." (ID:".$newstart.")";
exit();
}
//#################单个采集文件预览################
function ViewGetNewsInfo($classid,$newspage,$userid,$username){
global $empire,$class_r,$fun_r,$dbtbpre;
$classid=(int)$classid;
if(empty($classid)||empty($newspage))
{printerror("FailCX","history.go(-1)");}
//验证权限
CheckLevel($userid,$username,$classid,"cj");
$r=$empire->fetch1("select * from {$dbtbpre}enewsinfoclass where classid='$classid'");
if(empty($r[classid]))
{printerror("FailCX","history.go(-1)");}
//副表
$ra=$empire->fetch1("select * from {$dbtbpre}ecms_infoclass_".$r[tbname]." where classid='$classid'");
//组合两数组
$r=TogTwoArray($r,$ra);
//导入编码文件
if($r['enpagecode'])
{
@include_once("doiconv.php");
}
//取得模型
$record="";
$field="";
$mr=$empire->fetch1("select cj from {$dbtbpre}enewsmod where mid='".$class_r[$r[newsclassid]][modid]."'");
$cjr=explode($record,$mr[cj]);
$count=count($cjr);
//采集时间
$newstime=date("Y-m-d H:i:s");
eCheckCjUrl($newspage,0);
//入库数据库是否有记录
if(empty($r[recjtheurl]))
{
$tmpnum=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_infotmp_".$r[tbname]." where oldurl='$newspage' limit 1");
if($tmpnum)
{
echo $fun_r['ReCj'];
exit();
}
}
//取得远程页面，三次取不到值的将不取值
for($i=1;$i<=3;$i++)
{
$info=ReadFiletext($newspage);
if(!empty($info))
{
break;
}
}
if(empty($info))
{
echo $fun_r['CanNotOpenUrl'];
exit();
}
//替换网页变量
$info=RepCjPagetextStr($info,$r);
//替换回车
$info=ReplaceFc($info);
//-----------------
$ifield="";
$ivalue="";
$next=0;
for($c=0;$c<$count-1;$c++)
{
$zzvalue="";
$cjr1=explode($field,$cjr[$c]);
$dofield=$cjr1[1];
$dofieldname=$cjr1[0];
$var="zz_".$dofield;
$var1="z_".$dofield;
$var2="qz_".$dofield;
$var3="save_".$dofield;
//图片集
if($dofield=="morepic"&&$r[$var])
{
//替换下载链接
$text=stripSlashes(stripSlashes($r[$var]));
//替换回车
$text=ReplaceFc($text);
$down=explode("[!empirecms!]",$text);
//小图
$zztext=RepInfoZZ($down[0],"ecmsspicurl",0);
$strtext=GetInfoStr($down[0],"ecmsspicurl",1);
$text1=stripSlashes(preg_replace($zztext,$strtext,$info));
//大图
if($down[1])
{
$zztext=RepInfoZZ($down[1],"ecmsbpicurl",0);
$strtext=GetInfoStr($down[1],"ecmsbpicurl",1);
$text2=stripSlashes(preg_replace($zztext,$strtext,$info));
}
//名称
if($down[2])
{
$zztext=RepInfoZZ($down[2],"ecmspicname",0);
$strtext=GetInfoStr($down[2],"ecmspicname",1);
$text3=stripSlashes(preg_replace($zztext,$strtext,$info));
}
$zzvalue=GetCjMorepicpath($text1,$text2,$text3,"ecmsspicurl","ecmsbpicurl","ecmspicname",$r[$var2]);
$data.="".$dofieldname."
(".$dofield.") | ".$zzvalue." |
";
continue;
}
//下载地址
if($dofield=="downpath"&&$r[$var])
{
//替换下载链接
$text=stripSlashes(stripSlashes($r[$var]));
//替换回车
$text=ReplaceFc($text);
$down=explode("[!empirecms!]",$text);
//地址
$zztext=RepInfoZZ($down[0],"ecmsdownpathurl",0);
$strtext=GetInfoStr($down[0],"ecmsdownpathurl",1);
$text1=stripSlashes(preg_replace($zztext,$strtext,$info));
//名称
if($down[1])
{
$zztext=RepInfoZZ($down[1],"ecmsdownpathname",0);
$strtext=GetInfoStr($down[1],"ecmsdownpathname",1);
$text2=stripSlashes(preg_replace($zztext,$strtext,$info));
}
$zzvalue=GetCjDownpath($text1,$text2,"ecmsdownpathurl","ecmsdownpathname",$r[$var2],0);
$data.="".$dofieldname."
(".$dofield.") | ".$zzvalue." |
";
continue;
}
//在线地址
if($dofield=="onlinepath"&&$r[$var])
{
//替换下载链接
$text=stripSlashes(stripSlashes($r[$var]));
//替换回车
$text=ReplaceFc($text);
$down=explode("[!empirecms!]",$text);
//地址
$zztext=RepInfoZZ($down[0],"ecmsonlinepathurl",0);
$strtext=GetInfoStr($down[0],"ecmsonlinepathurl",1);
$text1=stripSlashes(preg_replace($zztext,$strtext,$info));
//名称
if($down[1])
{
$zztext=RepInfoZZ($down[1],"ecmsonlinepathname",0);
$strtext=GetInfoStr($down[1],"ecmsonlinepathname",1);
$text2=stripSlashes(preg_replace($zztext,$strtext,$info));
}
$zzvalue=GetCjDownpath($text1,$text2,"ecmsonlinepathurl","ecmsonlinepathname",$r[$var2],1);
$data.="".$dofieldname."
(".$dofield.") | ".$zzvalue." |
";
continue;
}
if(empty($r[$var1]))
{
if($r[$var])
{
$zzvalue=ReturnCJ_str($r[$var],$dofield,$info);
if($zzvalue)
{
$zzvalue=$r[$var2].$zzvalue;
}
}
}
else
{$zzvalue=$r[$var1];}
//------------------------------信息来源
if($dofield=="befrom"||$dofield=="writer")
{
//标题去除html代码
$zzvalue=strip_tags(str_replace("\r\n","",$zzvalue));
}
//------------------------------标题
if($dofield=="title")
{
//标题去除html代码
$zzvalue=ehtmlspecialchars(strip_tags(str_replace("\r\n","",$zzvalue)));
if(empty($zzvalue))
{
echo $fun_r['CjEmptyTitle'];
exit();
}
//标题是否包含关键字
if($r[keyboard])
{
$t=HaveKeyboard($zzvalue,$r[keyboard]);
if(empty($t))
{
echo $fun_r['CjTitleKey'];
exit();
}
}
if($r[retitlewriter])//标题完全一样
{
//入库比较
$onum=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_".$class_r[$r[newsclassid]][tbname]." where title='".addslashes($zzvalue)."' and classid='$r[newsclassid]' limit 1");
if($onum)
{
echo $fun_r['CjReTitleWriter'];
exit();
}
/*采集库比较
$onum=$empire->num("select id from {$dbtbpre}ecms_infotmp_".$r[tbname]." where title='".addslashes($zzvalue)."' limit 1");
if($onum)
{
echo $fun_r['CjReTitleWriter'];
exit();
}
*/
}
if($r[titlelen])//标题相似
{
//入库比较
$c_title=addslashes(sub($zzvalue,0,$r[titlelen],false));
$onum=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_".$class_r[$r[newsclassid]][tbname]." where title like '%$c_title%' and classid='$r[newsclassid]' limit 1");
if($onum)
{
echo $fun_r['CjSingTitlelen'].$r[titlelen].$fun_r['CjSingTitlelenL'];
exit();
}
/*采集比较
$onum=$empire->num("select id from {$dbtbpre}ecms_infotmp_".$r[tbname]." where title like '%$c_title%' limit 1");
if($onum)
{
echo $fun_r['CjSingTitlelen'].$r[titlelen].$fun_r['CjSingTitlelenL'];
exit();
}
*/
}
}
//新闻内容分页
if($dofield=="newstext")
{
//是否有分页
if($r[pagezz]||$r[pageallzz])
{
//上下页式
if(empty($r[pagetype]))
{
$zzvalue.=GetMoreCjPagetext($newspage,$r[$var],$r[smallpagezz],$r[pagezz],$r[pagetype],$info,$r);
}
//全部列表式
else
{
$zzvalue.=GetMoreCjPagetextall($newspage,$r[$var],$r[smallpageallzz],$r[pageallzz],$r[pagetype],$info,$r);
}
}
}
//替换关键字
if(stristr($r['repf'],','.$dofield.','))
{
$zzvalue=RepInfoWord($zzvalue,$r[oldword],$r[newword]);
}
//替换广告
if(stristr($r['repadf'],','.$dofield.','))
{
$zzvalue=RepAd($r[repad],$zzvalue);
}
//新闻内容
if(stristr($r['isnullf'],','.$dofield.','))
{
$ckzzvalue=trim($zzvalue);
if($r['newstextisnull']==1&&empty($ckzzvalue))
{
echo $dofield.$fun_r['CjEmptyNewstext'];
exit();
}
}
$data.="".$dofieldname."
(".$dofield.") | ".$zzvalue." |
";
}
//输出数据
$data="";
echo $data;
exit();
}
//是否有关键字
function HaveKeyboard($title,$keyboard) {
$r=explode(",",$keyboard);
$b=0;
for($i=0;$i1)
{
$b=1;
break;
}
}
return $b;
}
//替换关键字
function RepInfoWord($title,$oldword,$newword){
if(empty($oldword))
{
return $title;
}
$oldword=stripSlashes($oldword);
$newword=stripSlashes($newword);
//替换回车
$oldword=ReplaceFc($oldword);
$newword=ReplaceFc($newword);
$repmore=0;
if(strstr($newword,","))
{
$repmore=1;
$nr=explode(",",$newword);
}
$r=explode(",",$oldword);
for($i=0;$ifetch1("select * from {$dbtbpre}enewsinfoclass where classid='$classid'");
if(!$cr['classid'])
{
printerror('LoadOutCjEmptyClassid','');
}
if(!$cr['newsclassid'])//非采集节点
{
printerror('LoadOutCjMustNewsclassid','');
}
//主表
$mainfield=LoadOutCjMainField();
$mainstr=LoadOutCjMainstr($cr,$mainfield,$fieldexp,$sfieldexp);
//副表
$infocr=$empire->fetch1("select * from {$dbtbpre}ecms_infoclass_".$cr[tbname]." where classid='$classid'");
$datafield=LoadOutCjDataField($cr['tid'],$cr['tbname']);
$datastr=LoadOutCjDatastr($infocr,$datafield,$fieldexp,$sfieldexp);
@include('../class/EmpireCMS_version.php');
$cjstr=EmpireCMS_VERSION.$recordexp.$mainstr.$recordexp.$datafield.$recordexp.$datastr;
$file=$cr['tbname'].time().".cj";
$filepath=ECMS_PATH."e/data/tmp/cj/".$file;
WriteFiletext_n($filepath,$cjstr);
DownLoadFile($file,$filepath,1);
//操作日志
insert_dolog("classid=$classid&classname=$cr[classname]");
exit();
}
//返回主表字段列表
function LoadOutCjMainField(){
$field='classname,infourl,bz,num,copyimg,renum,keyboard,oldword,newword,titlelen,retitlewriter,smalltextlen,zz_smallurl,zz_newsurl,httpurl,repad,imgurl,relistnum,zz_titlepicl,z_titlepicl,qz_titlepicl,save_titlepicl,keynum,insertnum,copyflash,pagetype,smallpagezz,pagezz,smallpageallzz,pageallzz,mark,enpagecode,recjtheurl,hiddenload,justloadin,justloadcheck,delloadinfo,pagerepad,getfirstpic,oldpagerep,newpagerep,keeptime,newstextisnull,getfirstspic,getfirstspicw,getfirstspich,doaddtextpage,infourlispage,repf,repadf,loadkeeptime,isnullf';
return $field;
}
//返回主表组合
function LoadOutCjMainstr($r,$field,$fieldexp,$sfieldexp){
$mainstr='';
$addexp='';
$fr=explode(',',$field);
$fcount=count($fr);
for($i=0;$i<$fcount;$i++)
{
$f=$fr[$i];
$mainstr.=$addexp.$r[$f];
$addexp=$fieldexp;
}
return $mainstr;
}
//返回副表字段列表
function LoadOutCjDataField($tid,$tbname){
global $empire,$dbtbpre;
$field='';
$dh='';
$fsql=$empire->query("select f from {$dbtbpre}enewsf where tid='$tid' and iscj=1");
while($fr=$empire->fetch($fsql))
{
$field.=$dh.$fr['f'];
$dh=',';
}
return $field;
}
//返回副表组合
function LoadOutCjDatastr($r,$field,$fieldexp,$sfieldexp){
if(empty($field))
{
return '';
}
$datastr='';
$addexp='';
$fr=explode(',',$field);
$fcount=count($fr);
for($i=0;$i<$fcount;$i++)
{
$f=$fr[$i];
$zzf='zz_'.$f;
$zf='z_'.$f;
$qzf='qz_'.$f;
$savef='save_'.$f;
$datastr.=$addexp.$r[$zzf].$sfieldexp.$r[$zf].$sfieldexp.$r[$qzf].$sfieldexp.$r[$savef];
$addexp=$fieldexp;
}
return $datastr;
}
//导入采集规则
function LoadInCj($add,$file,$file_name,$file_type,$file_size,$userid,$username){
global $empire,$dbtbpre;
$lineexp='';
$recordexp='';
$fieldexp='';
$sfieldexp='';
//验证权限
CheckLevel($userid,$username,$classid,"loadcj");
$classid=(int)$add['classid'];
if(!$classid)
{
printerror("EmptyLoadInCjFile","history.go(-1)");
}
$cr=$empire->fetch1("select classid,islast,tid,tbname from {$dbtbpre}enewsclass where classid='$classid' and islast=1");
if(!$cr['classid'])
{
printerror("LoadInCjMustLastClass","history.go(-1)");
}
if(!$file_name||!$file_size)
{
printerror("EmptyLoadInCjFile","history.go(-1)");
}
//扩展名
$filetype=GetFiletype($file_name);
if($filetype!=".cj")
{
printerror("LoadInCjErrorfiletype","history.go(-1)");
}
$path=ECMS_PATH.'e/data/tmp/cj/uploadcj'.time().'.cj';
//上传文件
$cp=@move_uploaded_file($file,$path);
DoChmodFile($path);
$data=ReadFiletext($path);
DelFiletext($path);
$r=explode($recordexp,$data);
$empirecmsver=$r[0];
$mainstr=$r[1];
$datafield=$r[2];
$datastr=$r[3];
if(empty($mainstr))
{
printerror("EmptyLoadInCjFile","history.go(-1)");
}
//主表
$infoclassid=LoadInCjInsertMainstr($classid,$cr['tid'],$cr['tbname'],$mainstr,$fieldexp,$sfieldexp);
//副表
LoadInCjInsertDatastr($classid,$cr['tid'],$cr['tbname'],$infoclassid,$datafield,$datastr,$fieldexp,$sfieldexp);
$cjr=$empire->fetch1("select classname from {$dbtbpre}enewsinfoclass where classid='$infoclassid'");
//操作日志
insert_dolog("classid=".$infoclassid."
classname=".$cjr[classname]);
printerror("LoadInCjSuccess","cj/LoadInCj.php?from=".ehtmlspecialchars($_POST[from]).hReturnEcmsHashStrHref2(0));
}
//写入主表组合
function LoadInCjInsertMainstr($classid,$tid,$tbname,$mainstr,$fieldexp,$sfieldexp){
global $empire,$dbtbpre;
$mainfield=LoadOutCjMainField();
$mainfieldr=explode(',',$mainfield);
$fcount=count($mainfieldr);
$mainr=explode($fieldexp,$mainstr);
$mainvalues='';
$count=count($mainr);
if($fcount<$count)
{
$count=$fcount;
}
for($i=0;$i<$count;$i++)
{
if($i==0)
{
$mainr[$i]=ehtmlspecialchars($mainr[$i],ENT_QUOTES);
}
$mainvalues.=",'".addslashes($mainr[$i])."'";
}
//字段不一致
if($fcount>$count)
{
$addcount=$fcount-$count;
for($addi=0;$addi<$addcount;$addi++)
{
if($addi==0)
{
$addval=',title,newstext,';
}
elseif($addi==1)
{
$addval=',newstext,';
}
elseif($addi==2)
{
$addval='0';
}
elseif($addi==3)
{
$addval=',newstext,';
}
else
{
$addval='';
}
$mainvalues.=",'$addval'";
}
}
$empire->query("insert into {$dbtbpre}enewsinfoclass(classid,bclassid,newsclassid,tid,tbname,".$mainfield.") values(NULL,'0','$classid','$tid','$tbname'".$mainvalues.");");
$lastid=$empire->lastid();
return $lastid;
}
//写入副表组合
function LoadInCjInsertDatastr($classid,$tid,$tbname,$infoclassid,$dataf,$datastr,$fieldexp,$sfieldexp){
global $empire,$dbtbpre;
if(empty($dataf))
{
$empire->query("insert into {$dbtbpre}ecms_infoclass_".$tbname."(classid) values('$infoclassid');");
return '';
}
//返回表字段
$tbfield=LoadOutCjDataField($tid,$tbname);
$datafr=explode(',',$dataf);
$datar=explode($fieldexp,$datastr);
$datafield='';
$datavalues='';
$count=count($datafr);
for($i=0;$i<$count;$i++)
{
$f=$datafr[$i];
if(!stristr(','.$tbfield.',',','.$f.','))
{
continue;
}
$zzf='zz_'.$f;
$zf='z_'.$f;
$qzf='qz_'.$f;
$savef='save_'.$f;
$zzr=explode($sfieldexp,$datar[$i]);
$datafield.=",$zzf,$zf,$qzf,$savef";
$datavalues.=",'".addslashes($zzr[0])."','".addslashes($zzr[1])."','".addslashes($zzr[2])."','".addslashes($zzr[3])."'";
}
$empire->query("insert into {$dbtbpre}ecms_infoclass_".$tbname."(classid".$datafield.") values('$infoclassid'".$datavalues.");");
}
?>