帝国cms会员主表附表联合查询

<?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>&nbsp;>&nbsp;<a href=../cp/>会员中心</a>&nbsp;>&nbsp;会员列表&nbsp;&nbsp;";
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">&nbsp;</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;
?>