<?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; ?>