帝国cms会员中心调好友列表
2018-09-02 站长 站长日志
| <?php //配置查询自定义字段列表,逗号开头，多个用逗号格开，格式“ui.字段名” $useraddf=',ui.userpic,ui.sex,ui.pro,ui.job,ui.city,ui.job,ui.odds,ui.tizhong,ui.height,ui.year'; //分页SQL $query='select '.eReturnSelectMemberF('userid,username,email,registertime,groupid','u.').$useraddf.' from '.eReturnMemberTable().' u'.$add." order by u.".egetmf('userid')." desc limit $offset,$line"; $sql=$empire->query($query); //导航 $public_diyr['pagetitle']='会员列表'; $url="<a href='../../../'>首页</a> > 会员列表"; ?> |
<?php while($r=$empire->fetch($sql)) { //注册时间 $registertime=eReturnMemberRegtime($r['registertime'],"Y-m-d H:i:s"); //用户组 $groupname=$level_r[$r['groupid']]['groupname']; //用户头像 $userpic=$r['userpic']?$r['userpic']:$public_r[newsurl].'e/data/images/nouserpic.gif'; ?> <dl class="f-clear"> <dt> <a href="<?=$public_r[newsurl]?>e/space/?userid=<?=$r['userid']?>" target="_blank" class="pfa"> <img src='<?=$userpic?>' width='97' height='97'> </a> </dt> <dd class="pf_ddtop"> <span class="pfs1"><a href="<?=$public_r[newsurl]?>e/space/?userid=<?=$r['userid']?>" target="_blank"><?=$r['username']?></a></span> <span class="pfs4"> 最后登录时间：<a href="/e/member/card/" target="_blank">VIP可见</a> </span> </dd> <dd> <span class="yellow"><?=$r['sex']?>，<?=$r['year']?>岁，来自 <?=$pro?>/<?=$r['city']?>，<?=$r['height']?>CM，<?=$r['tizhong']?>KG，<?=$r['job']?></span> </dd> <dd class="purple" "line-height:150%;"><?=$r['odds']?></dd> <dd><a href="<?=$public_r[newsurl]?>e/space/?userid=<?=$r['userid']?>" class="comma" target="_blank">查看详细资料</a> <a href="/e/member/msg/AddMsg/?username=<?=$r['username']?>" class="comma" target="_blank">给她发站内信</a> <a href="memberliwu.php?naviid=5&smemberid=21540&cityid=1" class="comma" target="_blank">送她礼物</a> <a href="/jubao.php?smemberid=21540&cityid=1" class="comma" target="_blank">举报此人</a> <img src="/skin/static/images/qq.png" "vertical-align:middle;" title="她已留QQ号码，VIP会员可点击网页版QQ联系" class="contact" /> <img src="/skin/static//images/weixin.png" "vertical-align:middle;" title="她已留微信号，VIP会员可点击查看微信联系" class="contact" /> <img src="/skin/static/images/tel.png" "vertical-align:middle;" title="她已留手机号，VIP会员可点击查看手机联系" class="contact" /> </dd> </dl> <? } ?> |
php调会员空间信息列表
<?php $spacesql=$empire->query("select u.username,u.registertime,u.userid,userpic,ui.company,ui.pro,ui.job,ui.year,ui.sex from phome_enewsmember u LEFT JOIN phome_enewsmemberadd ui ON u.userid=ui.userid where u.groupid=1 and ui.sex ='女' limit 6"); while($spacer=$empire->fetch($spacesql)) { $titleurl=sys_ReturnBqTitleLink($spacer);//链接 ?> <dl class="f-clear"> <dt><a href="/e/space/?userid=<?=$spacer[userid]?>" target="_blank"><img src="<?=$spacer[userpic]?>" height="66" width="66"></a></dt> <dd><a href="/e/space/?userid=<?=$spacer[userid]?>" target="_blank"><?=$spacer[username]?></a><br> <span><?=date('Y-m-d',$spacer[registertime])?></span><br> <?=$spacer[pro]?> <?=$spacer[year]?>岁 <?=$spacer[job]?></dd> </dl> <?php } ?> |