如何调用僵尸会员(从未发过帖的会员) 迅睿框架 更新 2021-07-21 11:42:03 大勇 模板标签里面如何调用僵尸会员(从未发过帖的会员) {list action=member groupid=2 more=1 num=50 }{/list}我希望调用到用户组为2里面没有发过帖的会员显示在首页。
<?php $sql = urlencode('select uid from `'.\Phpcmf\Service::M()->dbprefix('member_group_index').'` where gid=2 and uid not in (select uid from `'.\Phpcmf\Service::M()->dbprefix(SITE_ID.'_wenda').'`)'); ?> {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 target="_blank" target="_blank" target="_blank" href="#"><img width="60" height="60" src="{dr_avatar($t.uid)}"></a> </div> <h6><a target="_blank" target="_blank" target="_blank" href="#">{$user.name}</a></h6> <span class="comment">{$t.ct}</span> </li> {/if} {/sql}