query("select id,classid,tid,tagid from {$dbtbpre}enewstagsdata where tid>$start order by tid limit ".$line);
while($r=$empire->fetch($sql))
{
$b=1;
$newstart=$r['tid'];
if(empty($class_r[$r[classid]]['tbname']))
{
$empire->query("delete from {$dbtbpre}enewstagsdata where tid='$r[tid]'");
$empire->query("update {$dbtbpre}enewstags set num=num-1 where tagid='$r[tagid]'");
continue;
}
$index_r=$empire->fetch1("select id,classid,checked from {$dbtbpre}ecms_".$class_r[$r[classid]]['tbname']."_index where id='$r[id]' limit 1");
if(!$index_r['id'])
{
$empire->query("delete from {$dbtbpre}enewstagsdata where tid='$r[tid]'");
$empire->query("update {$dbtbpre}enewstags set num=num-1 where tagid='$r[tagid]'");
}
else
{
//返回表
$infotb=ReturnInfoMainTbname($class_r[$r[classid]]['tbname'],$index_r['checked']);
//主表
$infor=$empire->fetch1("select stb from ".$infotb." where id='$r[id]' limit 1");
//返回表信息
$infodatatb=ReturnInfoDataTbname($class_r[$r[classid]]['tbname'],$index_r['checked'],$infor['stb']);
//副表
$finfor=$empire->fetch1("select infotags from ".$infodatatb." where id='$r[id]' limit 1");
$tagr=$empire->fetch1("select tagname from {$dbtbpre}enewstags where tagid='$r[tagid]'");
if(!stristr(','.$finfor['infotags'].',',','.$tagr['tagname'].','))
{
$empire->query("delete from {$dbtbpre}enewstagsdata where tid='$r[tid]'");
$empire->query("update {$dbtbpre}enewstags set num=num-1 where tagid='$r[tagid]'");
}
elseif($index_r['classid']!=$r[classid])
{
$empire->query("update {$dbtbpre}enewstagsdata set classid='$index_r[classid]' where tid='$r[tid]'");
}
}
}
if(empty($b))
{
//操作日志
insert_dolog("");
printerror('ClearTagsSuccess','ClearTags.php');
}
echo"".$fun_r[OneClearTagsSuccess]."(ID:".$newstart.")";
exit();
}
$enews=$_GET['enews'];
if($enews)
{
include("../../data/dbcache/class.php");
include "../".LoadLang("pub/fun.php");
ClearTags($_GET[start],$_GET[line],$logininid,$loginin);
}
db_close();
$empire=null;
?>
TAGS