帝国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;

?>