gettotal("select count(*) as total from {$dbtbpre}enewssearchall_load where tbname='$tbname'");
if($tbnum)
{
printerror("ReSearchLoadTb","history.go(-1)");
}
$lasttime=time();
$sql=$empire->query("insert into {$dbtbpre}enewssearchall_load(tbname,titlefield,infotextfield,smalltextfield,loadnum,lasttime,lastid) values('$tbname','$titlefield','$infotextfield','$smalltextfield',$loadnum,$lasttime,0);");
$lid=$empire->lastid();
GetSearchAllTb();
if($sql)
{
//操作日志
insert_dolog("lid=".$lid."&tbname=".$tbname);
printerror("AddSearchLoadTbSuccess","AddSearchLoadTb.php?enews=AddSearchLoadTb".hReturnEcmsHashStrHref2(0));
}
else
{printerror("DbError","history.go(-1)");}
}
//修改搜索数据源
function EditSearchLoadTb($add,$userid,$username){
global $empire,$dbtbpre;
$lid=(int)$add['lid'];
$tbname=RepPostVar($add['tbname']);
$titlefield=RepPostVar($add['titlefield']);
$infotextfield=RepPostVar($add['infotextfield']);
$smalltextfield=RepPostVar($add['smalltextfield']);
$loadnum=(int)$add['loadnum'];
if(!$tbname||!$titlefield||!$infotextfield||!$smalltextfield||!$loadnum)
{
printerror("EmptySearchLoadTb","history.go(-1)");
}
//操作权限
CheckLevel($userid,$username,$classid,"searchall");
if($tbname<>$add['oldtbname'])
{
//表是否存在
$tbnum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewssearchall_load where tbname='$tbname' and lid<>$lid limit 1");
if($tbnum)
{
printerror("ReSearchLoadTb","history.go(-1)");
}
}
$sql=$empire->query("update {$dbtbpre}enewssearchall_load set tbname='$tbname',titlefield='$titlefield',infotextfield='$infotextfield',smalltextfield='$smalltextfield',loadnum='$loadnum' where lid='$lid'");
GetSearchAllTb();
if($sql)
{
//操作日志
insert_dolog("lid=".$lid."&tbname=".$tbname);
printerror("EditSearchLoadTbSuccess","ListSearchLoadTb.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//删除搜索数据源
function DelSearchLoadTb($lid,$userid,$username){
global $empire,$dbtbpre;
$lid=(int)$lid;
if(!$lid)
{
printerror("NotDelSearchLoadTbid","history.go(-1)");
}
//操作权限
CheckLevel($userid,$username,$classid,"searchall");
$r=$empire->fetch1("select tbname from {$dbtbpre}enewssearchall_load where lid='$lid'");
if(!$r['tbname'])
{
printerror("NotDelSearchLoadTbid","history.go(-1)");
}
$sql=$empire->query("delete from {$dbtbpre}enewssearchall_load where lid='$lid'");
$classids=ReturnTbGetClassids($r['tbname']);
if($classids)
{
$delsql=$empire->query("delete from {$dbtbpre}enewssearchall where classid in (".$classids.")");
}
GetSearchAllTb();
if($sql)
{
//操作日志
insert_dolog("lid=".$lid."&tbname=".$r['tbname']);
printerror("DelSearchLoadTbSuccess","ListSearchLoadTb.php".hReturnEcmsHashStrHref2(1));
}
else
{printerror("DbError","history.go(-1)");}
}
//删除数据源数据
function SearchallDelData($add,$userid,$username){
global $empire,$dbtbpre;
//操作权限
CheckLevel($userid,$username,$classid,"searchall");
$lid=$add['lid'];
$count=count($lid);
for($i=0;$i<$count;$i++)
{
$id=(int)$lid[$i];
if(empty($id))
{
continue;
}
$lr=$empire->fetch1("select tbname from {$dbtbpre}enewssearchall_load where lid='$id'");
if(empty($lr['tbname']))
{
continue;
}
$classids=ReturnTbGetClassids($lr['tbname']);
if($classids)
{
$empire->query("delete from {$dbtbpre}enewssearchall where classid in (".$classids.")");
$empire->query("update {$dbtbpre}enewssearchall_load set lastid=0 where lid='$id'");
}
}
//操作日志
insert_dolog("");
printerror("SearchallDelDataSuccess","ListSearchLoadTb.php".hReturnEcmsHashStrHref2(1));
}
//全站搜索设置
function SetSearchAll($add,$userid,$username){
global $empire,$dbtbpre;
//操作权限
CheckLevel($userid,$username,$classid,"searchall");
$openschall=(int)$add['openschall'];
$schallfield=(int)$add['schallfield'];
$schallminlen=(int)$add['schallminlen'];
$schallmaxlen=(int)$add['schallmaxlen'];
$schallnotcid=','.$add['schallnotcid'].',';
$schallnum=(int)$add['schallnum'];
$schallpagenum=(int)$add['schallpagenum'];
$schalltime=(int)$add['schalltime'];
$schallnotcid=hRepPostStr($schallnotcid,1);
$sql=$empire->query("update {$dbtbpre}enewspublic set openschall=$openschall,schallfield=$schallfield,schallminlen=$schallminlen,schallmaxlen=$schallmaxlen,schallnotcid='$schallnotcid',schallnum='$schallnum',schallpagenum='$schallpagenum',schalltime='$schalltime' limit 1");
GetConfig();
//操作日志
insert_dolog("");
printerror("SetSearchAllSuccess","SetSearchAll.php".hReturnEcmsHashStrHref2(1));
}
//返回数据表里的栏目列表
function ReturnTbGetClassids($tbname){
global $empire,$dbtbpre;
$ids='';
$sql=$empire->query("select classid from {$dbtbpre}enewsclass where tbname='$tbname' and islast=1");
while($r=$empire->fetch($sql))
{
$dh=',';
if($ids=='')
{
$dh='';
}
$ids.=$dh.$r['classid'];
}
return $ids;
}
$enews=$_POST['enews'];
if(empty($enews))
{$enews=$_GET['enews'];}
if($enews)
{
hCheckEcmsRHash();
}
//增加搜索数据源
if($enews=="AddSearchLoadTb")
{
AddSearchLoadTb($_POST,$logininid,$loginin);
}
//修改搜索数据源
elseif($enews=="EditSearchLoadTb")
{
EditSearchLoadTb($_POST,$logininid,$loginin);
}
//删除搜索数据源
elseif($enews=="DelSearchLoadTb")
{
$lid=$_GET['lid'];
DelSearchLoadTb($lid,$logininid,$loginin);
}
//删除数据源数据
elseif($enews=="SearchallDelData")
{
SearchallDelData($_GET,$logininid,$loginin);
}
//全站搜索设置
elseif($enews=="SetSearchAll")
{
SetSearchAll($_POST,$logininid,$loginin);
}
$query="select lid,tbname,lasttime,lastid from {$dbtbpre}enewssearchall_load order by lid";
$sql=$empire->query($query);
?>
管理搜索数据源