<?phpfunction 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><?phprequire(ECMS_PATH.'e/template/incfile/footer.php');db_close();$empire=null;?>
很赞哦 ()