query("insert into {$dbtbpre}enewsag(agname,isadmin,auids) values('$add[agname]','$add[isadmin]','');");
if($sql)
{
$agid=$empire->lastid();
//更新缓存
GetConfig();
GetMemberLevel();
insert_dolog("agid=$agid&agname=$add[agname]");//操作日志
printerror("AddMAdminGroupSuccess","AddMAdminGroup.php?enews=AddMAdminGroup".hReturnEcmsHashStrHref2(0));
}
else
{
printerror("DbError","history.go(-1)");
}
}
//修改会员管理组
function EditMAdminGroup($add,$userid,$username){
global $empire,$dbtbpre;
$agid=intval($add['agid']);
if(empty($add['agname'])||!$agid)
{
printerror('EmptyMAdminGroup','history.go(-1)');
}
$add['agname']=hRepPostStr($add['agname'],1);
$add['isadmin']=(int)$add['isadmin'];
$addupdate='';
if($agid==1||$agid==2)
{
$addupdate='';
}
else
{
$addupdate=",isadmin='$add[isadmin]'";
}
$sql=$empire->query("update {$dbtbpre}enewsag set agname='$add[agname]'".$addupdate." where agid='$agid'");
//更新缓存
GetConfig();
GetMemberLevel();
if($sql)
{
insert_dolog("agid=$agid&agname=$add[agname]");//操作日志
printerror("EditMAdminGroupSuccess","ListMAdminGroup.php".hReturnEcmsHashStrHref2(1));
}
else
{
printerror("DbError","history.go(-1)");
}
}
//删除会员管理组
function DelMAdminGroup($add,$userid,$username){
global $empire,$dbtbpre;
$agid=intval($add['agid']);
if(!$agid)
{
printerror('EmptyMAdminGroupid','history.go(-1)');
}
$r=$empire->fetch1("select agid,agname from {$dbtbpre}enewsag where agid='$agid'");
if(!$r['agid'])
{
printerror('EmptyMAdminGroupid','history.go(-1)');
}
if($agid==1||$agid==2)
{
printerror('NotDelSysMAdminGroupid','history.go(-1)');
}
$sql=$empire->query("delete from {$dbtbpre}enewsag where agid='$agid'");
$empire->query("update ".eReturnMemberTable()." set ".egetmf('agid')."=0 where ".egetmf('agid')."='$agid'");
//更新缓存
GetConfig();
GetMemberLevel();
if($sql)
{
insert_dolog("agid=$gid&agname=$r[agname]");//操作日志
printerror("DelMAdminGroupSuccess","ListMAdminGroup.php".hReturnEcmsHashStrHref2(1));
}
else
{
printerror("DbError","history.go(-1)");
}
}
//增加会员管理员
function AddMAgUser($add,$userid,$username){
global $empire,$dbtbpre;
$agid=(int)$add['agid'];
$adduserid=(int)$add['adduserid'];
$addusername=RepPostVar($add['addusername']);
if(!$agid||!$adduserid||!$addusername)
{
printerror("EmptyMAgUser","history.go(-1)");
}
$magr=$empire->fetch1("select * from {$dbtbpre}enewsag where agid='$agid'");
if(!$magr['agid'])
{
printerror("EmptyMAgUser","history.go(-1)");
}
$mr=$empire->fetch1("select ".eReturnSelectMemberF('userid')." from ".eReturnMemberTable()." where ".egetmf('userid')."='$adduserid' and ".egetmf('username')."='$addusername' limit 1");
if(!$mr['userid'])
{
printerror("ErrorMAgUser","history.go(-1)");
}
//是否存在
if(strstr($magr['auids'],','.$adduserid.','))
{
printerror("HaveMAgUser","history.go(-1)");
}
$num=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsag where auids like '%,".$adduserid.",%' limit 1");
if($num)
{
printerror("HaveMAgUser","history.go(-1)");
}
if($magr['auids'])
{
$new_auids=$magr['auids'].$adduserid.',';
}
else
{
$new_auids=','.$adduserid.',';
}
$sql=$empire->query("update {$dbtbpre}enewsag set auids='$new_auids' where agid='$agid' limit 1");
$empire->query("update ".eReturnMemberTable()." set ".egetmf('agid')."='$agid' where ".egetmf('userid')."='$adduserid'");
//更新缓存
GetConfig();
GetMemberLevel();
if($sql)
{
//操作日志
insert_dolog("agid=".$agid."
userid=".$adduserid."&username=".$addusername);
printerror("AddMAgUserSuccess","ListMAgUser.php?agid=$agid".hReturnEcmsHashStrHref2(0));
}
else
{printerror("DbError","history.go(-1)");}
}
//删除会员管理员
function DelMAgUser($add,$userid,$username){
global $empire,$dbtbpre;
$agid=(int)$add['agid'];
$adduserid=(int)$add['adduserid'];
if(!$agid||!$adduserid)
{
printerror("EmptyMAgUser","history.go(-1)");
}
$magr=$empire->fetch1("select * from {$dbtbpre}enewsag where agid='$agid'");
if(!$magr['agid'])
{
printerror("EmptyMAgUser","history.go(-1)");
}
$new_auids=str_replace(",".$adduserid.",",",",$magr['auids']);
if($new_auids==',')
{
$new_auids='';
}
$sql=$empire->query("update {$dbtbpre}enewsag set auids='$new_auids' where agid='$agid' limit 1");
$empire->query("update ".eReturnMemberTable()." set ".egetmf('agid')."=0 where ".egetmf('userid')."='$adduserid'");
//更新缓存
GetConfig();
GetMemberLevel();
if($sql)
{
//操作日志
insert_dolog("agid=".$agid."
userid=".$adduserid);
printerror("DelMAgUserSuccess","ListMAgUser.php?agid=$agid".hReturnEcmsHashStrHref2(0));
}
else
{printerror("DbError","history.go(-1)");}
}
$enews=$_POST['enews'];
if(empty($enews))
{$enews=$_GET['enews'];}
if($enews)
{
hCheckEcmsRHash();
}
if($enews=="AddMAdminGroup")
{
AddMAdminGroup($_POST,$logininid,$loginin);
}
elseif($enews=="EditMAdminGroup")
{
EditMAdminGroup($_POST,$logininid,$loginin);
}
elseif($enews=="DelMAdminGroup")
{
DelMAdminGroup($_GET,$logininid,$loginin);
}
elseif($enews=="AddMAgUser")
{
AddMAgUser($_POST,$logininid,$loginin);
}
elseif($enews=="DelMAgUser")
{
DelMAgUser($_GET,$logininid,$loginin);
}
$search=$ecms_hashur['ehref'];
$page=(int)$_GET['page'];
$page=RepPIntvar($page);
$start=0;
$line=50;//每页显示条数
$page_line=25;//每页显示链接数
$offset=$page*$line;//总偏移量
$query="select * from {$dbtbpre}enewsag";
$totalquery="select count(*) as total from {$dbtbpre}enewsag";
$num=$empire->gettotal($totalquery);//取得总条数
$query=$query." order by agid desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page2($num,$line,$page_line,$start,$page,$search);
?>
会员管理组
fetch($sql))
{
$color="#ffffff";
$movejs=' onmouseout="this.style.backgroundColor=\'#ffffff\'" onmouseover="this.style.backgroundColor=\'#C3EFFF\'"';
$membernum=0;
if($r['auids'])
{
$mr=explode(",",$r['auids']);
$membernum=count($mr)-2;
}
if($r['isadmin']==9)
{
$isadminname='管理员';
}
elseif($r['isadmin']==5)
{
$isadminname='版主';
}
elseif($r['isadmin']==1)
{
$isadminname='实习版主';
}
else
{
$isadminname='';
}
?>
>
|
|
|
|
|
|
|
|