帝国cms调用会员名及投稿数量排名

1、调用会员发布文章数

1
<table>

2
[e:loop={'SELECT userid, username, count(username) as total from [!db.pre!]ecms_news group by username order by total desc',0,24,0}]

3
<tr>

4
<td><?=$bqno?></td>

5
<td><?=$bqr[username]?></td>

6
<td><?=$bqr[total]?></td>

7
</tr>

8
[/e:loop]

9
</table>

2、只调用会员发布文章数，增加（序号、会员id）

01
<table>

02
<tr>

03
<td>排名号</td>

04
<td>会员名</td>

05
<td>文章数</td>

06
<td>会员ID</td>

07
</tr>

08
[e:loop={'select userid, username,count(username) as num from [!db.pre!]ecms_news group by username order by num desc',0,24,0}]

09
<tr>

10
<td><?=$bqno?></td>

11
<td><?=$bqr[username]?></td>

12
<td><?=$bqr[num]?></td>

13
<td><?=$bqr[userid]?></td>

14
</tr>

15
[/e:loop]

16
</table>

注释：在sql语句“ SELECT userid, username, count(username) as total from [!db.pre!]ecms_news group by username order by total desc ”

中的“(username)”和“group by username”中的 “username”也能用 “userid” 调用但会出项一个问题就是管理员的ID会与前台会员的ID重复

即：管理员的ID=1，前台会员的ID=1（所以管理员的ID=前台会员的ID），最后统计出来的文章会是：管理员+前台会员=总数

月排行

1
where newstime > UNIX_TIMESTAMP()-86400*30 （月：30、周：7）

举例：月排行

1
<table><tr><td>排名号</td><td>会员名</td><td>文章数</td><td>会员ID</td></tr>

2
[e:loop={'select userid, username,count(username) as num from [!db.pre!]ecms_news where newstime > UNIX_TIMESTAMP()-86400*7 group by username order by num desc',0,24,0}]

3
<tr><td><?=$bqno?></td><td><?=$bqr[username]?></td><td><?=$bqr[num]?></td><td><?=$bqr[userid]?></td></tr>

4
[/e:loop]

5
</table>