<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>

wenda