<?php
function jhc_update_groupid($userid,$users,$gotogroupid=3){
global $empire,$dbtbpre;
$user=islogin();
if($user['groupid']<>4)return 0;
return $empire->query("update ".eReturnMemberTable()." u LEFT JOIN {$dbtbpre}enewsmemberadd ui ON u.".egetmf('userid')."=ui.userid set u.groupid='$gotogroupid' where ui.zip='$userid' and u.".egetmf('userid')." in(".$users.")");
}
require("../../class/connect.php");
require("../../class/q_functions.php");
require("../../class/db_sql.php");
require("../class/user.php");
require("../../data/dbcache/MemberLevel.php");
require "../".LoadLang("pub/fun.php");
$link=db_connect();
$empire=new mysqlquery();
$editor=1;
eCheckCloseMods('member');//关闭模块
$user=islogin();
//修改会员组
$userid=$user['userid'];
$enews=$_POST['enews'];
if($enews=='update_groupid'){
$users=$_POST['userid'];
if(!$users) printerror2("修改会员组失败！");
$users=join(',',$users);
if(jhc_update_groupid($userid,$users,3)){
printerror2("修改会员组成功！");
}else{
printerror2("修改会员组失败！");
}
}
$start=0;
$page=(int)$_GET['page'];
$page=RepPIntvar($page);
$add='';
$search='';
$line=20;//每行显示
$page_line=10;
$offset=$page*$line;
$totalquery="select count(*) as total from {$dbtbpre}enewsmemberadd where zip='$user[userid]'";
$query="select u.* from ".eReturnMemberTable()." u LEFT JOIN {$dbtbpre}enewsmemberadd ui ON u.".egetmf('userid')."=ui.userid where ui.zip='$userid'";
$num=$empire->gettotal($totalquery);
$query.=" order by u.userid desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page1($num,$line,$page_line,$start,$page,$search);
//导入模板
if(!defined('InEmpireCMS'))
{
exit();
}
?>
<?php
$public_diyr['pagetitle']='会员列表';
$url="<a href=../../../>首页</a> > <a href=../cp/>会员中心</a> > 会员列表 ";
require(ECMS_PATH.'e/template/incfile/header.php');
?>
<script>
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall')
e.checked = form.chkall.checked;
}
}
</script>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr>
<td width="50%" height="30" bgcolor="#FFFFFF"> </td>
<td width="50%" bgcolor="#FFFFFF"></td>
</tr>
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<form name="listmsg" method="post" action="" onsubmit="return confirm('确认要操作?');">
<tr class="header">
<td width="4%" height="23"> <div align="center"></div></td>
<td width="45%"><div align="center">会员id</div></td>
<td width="18%"><div align="center">会员名称</div></td>
<td width="23%"><div align="center">会员组id</div></td>
<td width="10%"><div align="center">备注</div></td>
</tr>
<?php
while($r=$empire->fetch($sql))
{
?>
<tr bgcolor="#FFFFFF">
<td height="25"> <div align="center">
<input name="userid[]" type="checkbox" value="<?=$r[userid]?>">
</div></td>
<td>
<div align="center">
<?=$r['userid']?>
</div>
</td>
<td><div align="center">
<?=$r['username']?>
</div></td>
<td><div align="center">
<?=$r[groupid]?>
</div></td>
<td> <div align="center"></div></td>
</tr>
<?php
}
?>
<tr bgcolor="#FFFFFF">
<td><div align="center">
<input type=checkbox name=chkall value=on onclick=CheckAll(this.form)>
</div></td>
<td colspan="4"><input type="submit" name="Submit2" value="升级选中">
<input name="enews" type="hidden" value="update_groupid"> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="center"></div></td>
<td colspan="4">
<?=$returnpage?> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="23" colspan="5"></td>
</tr>
</form>
</table>
<?php
require(ECMS_PATH.'e/template/incfile/footer.php');
db_close();
$empire=null;
?>
|
