帝国cms投稿排行榜序号会员名投稿数

正文概述管理员 2025-09-06 4

将以下代码加到首页模板里面

<table>   
[e:loop={'SELECT news . * FROM phome_enewsmember member INNER JOIN (SELECT userid, username, COUNT( userid ) AS total FROM phome_ecms_news WHERE ismember =1 GROUP BY userid)news WHERE member.userid = news.userid order by news.total desc',10,24,0}]
<tr>   
<td><?=$bqno?></td>   
<td><?=$bqr[username]?></td>   
<td><?=$bqr[total]?></td>   
</tr>   
[/e:loop]   
</table>

注：调用的是会员组id为1的会员发布的新闻数据表数量排序