帝国CMS二次开发调用关注我的列表

最终二次开发完成后的作用

帝国CMS调用重视我的列表查询代码

$totalquery="selectcount(*)astotalfrom{$dbtbpre}enewshywherefname='$username'".$a;
$num=$empire->gettotal($totalquery);
$query="select*from{$dbtbpre}enewshywherefname='$user[username]'".$a;
$query.="orderbyfiddesclimit$offset,$line";
$sql=$empire->query($query);
$returnpage=page1($num,$line,$page_line,$start,$page,$search);

前台展现代码

<?php
while($r=$empire->fetch($sql)){
$fuaddr=$empire->fetch1("selectuserpic,faxfrom{$dbtbpre}enewsmemberaddwhereuserid='$r[userid]'limit1");
$fuaddr2=$empire->fetch1("selectuserfen,usernamefrom{$dbtbpre}enewsmemberwhereuserid='$r[userid]'limit1");
?>
<li>
<imgsrc="<?=$fuaddr[userpic]?$fuaddr[userpic]:$public_r[newsurl].'e/data/images/nouserpic.gif'?>"width="60"height="60">
<pclass="gz_info">
<aclass="gz_name"href="../ShowInfo/?username=<?=$fuaddr2[username]?>"target="_blank"><?=$fuaddr2[username]?></a>
<span>性别：<?=$fuaddr[fax]?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;积分：<?=$fuaddr2[userfen]?></span>
</p>
<pclass="gz_opera">
<aclass="qx_gz"href="/e/member/friend/add/?fcid=0?<?=$fuaddr2[username]?>"target="_blank">增加重视</a>
<aclass="sendInfo"href="/e/member/msg/AddMsg/?enews=AddMsg"target="_blank">发送短信</a>
</p>
</li>
<?php
}
?>