调用一组会员,发帖数量最多的排名最靠前,怎么写 迅睿框架 更新 2021-07-20 21:54:57 大勇 模板标签里面我想调用一组会员,根据会员的发帖情况排序。发帖数量最多的排名最靠前,怎么写。{list action=member more=1 num=50 order=发帖最多}{/list}求发帖做多这个代码。
<div class="widget widget_highest_points"> <h3 class="widget_title">发帖排行榜</h3> <ul> <?php $sql = urlencode('SELECT COUNT(*) as ct,uid FROM `'.\Phpcmf\Service::M()->dbprefix(SITE_ID.'_wenda').'` GROUP by uid ORDER BY `ct` DESC limit 20'); ?> {sql sql='$sql' cache=100} {php $tx = dr_avatar($t.uid);$user=dr_member_info($t.uid);} {if $user.name} <li> <div class="author-img"> <a href="#"><img width="60" height="60" src="{dr_avatar($t.uid)}"></a> </div> <h6><a href="#">{$user.name}</a></h6> <span class="comment">{$t.ct}</span> </li> {/if} {/sql} </ul> </div>