帝国cms会员中心调好友列表

2024-08-28 12:24:58

字体：大中小

来源：转载

供稿：网友

<?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"> <a href="<?=$public_r[newsurl]?>e/space/?userid=<?=$r['userid']?>" target="_blank"><?=$r['username']?></a> 最后登录时间：<a href="/e/member/card/" target="_blank">VIP可见</a> </dd>
<dd> <?=$r['sex']?>，<?=$r['year']?>岁，来自 <?=$pro?>/<?=$r['city']?>，<?=$r['height']?>CM，<?=$r['tizhong']?>KG，<?=$r['job']?> </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> 
<?=date('Y-m-d',$spacer[registertime])?> 
<?=$spacer[pro]?> <?=$spacer[year]?>岁 <?=$spacer[job]?></dd>
</dl>

<?php
}
?>

上一篇：帝国cms灵动标签调信息带会员字段,灵动sql语句调用

下一篇：帝国CMS无限联动插件优化解决方案