query("select id,classid,sid from {$dbtbpre}enewssearchall where sid>$start order by sid limit ".$line); while($r=$empire->fetch($sql)) { $b=1; $newstart=$r['sid']; if(empty($class_r[$r[classid]]['tbname'])) { $empire->query("delete from {$dbtbpre}enewssearchall where sid='".$r['sid']."'"); continue; } $num=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_".$class_r[$r[classid]]['tbname']."_index where id='$r[id]' and classid='$r[classid]' limit 1"); if(!$num) { $empire->query("delete from {$dbtbpre}enewssearchall where sid='".$r['sid']."'"); } } if(empty($b)) { //操作日志 insert_dolog(""); printerror('ClearSearchAllSuccess','ClearSearchAll.php'.hReturnEcmsHashStrHref2(1)); } echo"".$fun_r[OneClearSearchAllSuccess]."(ID:".$newstart.")"; exit(); } $enews=$_GET['enews']; if($enews) { hCheckEcmsRHash(); @set_time_limit(0); include("../../data/dbcache/class.php"); include "../".LoadLang("pub/fun.php"); ClearSearchAll($_GET[start],$_GET[line],$logininid,$loginin); } $total=$empire->gettotal("select count(*) as total from {$dbtbpre}enewssearchall"); db_close(); $empire=null; ?> 清理搜索多余数据
位置:管理全站搜索数据源 -> 清理搜索多余数据
清理搜索多余数据
搜索表总信息数:
每组整理数: