gettotal("select count(*) as total from {$dbtbpre}enewsvglist where vgid='$vgid'");
$mlist=$membernum?1:0;
$sql=$empire->query("update {$dbtbpre}enewsvg set mlist='$mlist' where vgid='$vgid'");
}
//增加会员白名单
function AddViewGroupMList($add,$userid,$username){
global $empire,$dbtbpre;
$vgid=(int)$add['vgid'];
$usertype=(int)$add['usertype'];
$adduserid=RepPostVar($add['adduserid']);
if(!$vgid||!$usertype||!$adduserid)
{
printerror("EmptyViewGroupMList","history.go(-1)");
}
$addtime=time();
$outtime=$add['outtime'];
if($outtime)
{
$outtime=to_time($outtime);
}
$outtime=(int)$outtime;
//会员
$havem=0;
$r=explode(',',$adduserid);
$count=count($r);
for($i=0;$i<$count;$i++)
{
$thisuid=trim($r[$i]);
if(empty($thisuid))
{
continue;
}
//类型
if($usertype==2)
{
$thisuid=RepPostVar($thisuid);
$mr=$empire->fetch1("select ".eReturnSelectMemberF('userid')." from ".eReturnMemberTable()." where ".egetmf('username')."='$thisuid' limit 1");
}
else
{
$thisuid=(int)$thisuid;
$mr=$empire->fetch1("select ".eReturnSelectMemberF('userid')." from ".eReturnMemberTable()." where ".egetmf('userid')."='$thisuid' limit 1");
}
if(!$mr['userid'])
{
continue;
}
//是否存在
$vgnum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsvglist where vgid='$vgid' and userid='$mr[userid]' limit 1");
if(!$vgnum)
{
$empire->query("insert into {$dbtbpre}enewsvglist(vgid,addtime,userid,outtime) values('$vgid','$addtime','$mr[userid]','$outtime');");
$havem=1;
}
}
ToUpViewGroupMList($vgid);
//操作日志
insert_dolog("vgid=".$vgid."&usertype=".$usertype."
adduserid=".$adduserid);
printerror("AddViewGroupMListSuccess","ListVgMember.php?vgid=$vgid".hReturnEcmsHashStrHref2(0));
}
//修改会员白名单
function EditViewGroupMList($add,$userid,$username){
global $empire,$dbtbpre;
$vgid=(int)$add['vgid'];
$adduserid=(int)$add['adduserid'];
if(!$vgid||!$adduserid)
{
printerror("EmptyViewGroupMList","history.go(-1)");
}
$outtime=$add['outtime'];
if($outtime)
{
$outtime=to_time($outtime);
}
$outtime=(int)$outtime;
$sql=$empire->query("update {$dbtbpre}enewsvglist set outtime='$outtime' where vgid='$vgid' and userid='$adduserid' limit 1");
if($sql)
{
//操作日志
insert_dolog("vgid=".$vgid."
userid=".$adduserid);
printerror("EditViewGroupMListSuccess",EcmsGetReturnUrl());
}
else
{printerror("DbError","history.go(-1)");}
}
//删除会员白名单
function DelViewGroupMList($add,$userid,$username){
global $empire,$dbtbpre;
$vgid=(int)$add['vgid'];
$adduserid=(int)$add['adduserid'];
if(!$vgid||!$adduserid)
{
printerror("EmptyViewGroupMList","history.go(-1)");
}
$sql=$empire->query("delete from {$dbtbpre}enewsvglist where vgid='$vgid' and userid='$adduserid'");
ToUpViewGroupMList($vgid);
if($sql)
{
//操作日志
insert_dolog("vgid=".$vgid."
userid=".$adduserid);
printerror("DelViewGroupMListSuccess",EcmsGetReturnUrl());
}
else
{printerror("DbError","history.go(-1)");}
}
$enews=$_POST['enews'];
if(empty($enews))
{$enews=$_GET['enews'];}
if($enews)
{
hCheckEcmsRHash();
}
if($enews=="AddViewGroupMList")
{
AddViewGroupMList($_POST,$logininid,$loginin);
}
elseif($enews=="EditViewGroupMList")
{
EditViewGroupMList($_POST,$logininid,$loginin);
}
elseif($enews=="DelViewGroupMList")
{
DelViewGroupMList($_GET,$logininid,$loginin);
}
else
{}
$vgid=(int)$_GET['vgid'];
if(!$vgid)
{
printerror("ErrorUrl","history.go(-1)");
}
$vgr=$empire->fetch1("select * from {$dbtbpre}enewsvg where vgid='$vgid'");
if(!$vgr['vgid'])
{
printerror("ErrorUrl","history.go(-1)");
}
$page=(int)$_GET['page'];
$page=RepPIntvar($page);
$start=0;
$line=30;//每页显示条数
$page_line=12;//每页显示链接数
$offset=$page*$line;//总偏移量
$search='&vgid='.$vgid;
$search.=$ecms_hashur['ehref'];
$totalquery="select count(*) as total from {$dbtbpre}enewsvglist";
$num=$empire->gettotal($totalquery);
$query="select * from {$dbtbpre}enewsvglist order by addtime desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page2($num,$line,$page_line,$start,$page,$search);
?>
位置:管理会员访问组 > =$vgr['gname']?> > 会员白名单 |
会员ID |
用户名 |
增加时间 |
过期时间 |
操作 |
=$returnpage?> |