应用插件
版主：官方插件技术组
用户自定义字段如何调用
| 插件 | 建站系统大众版 V3.26 |
| 应用作者 | 迅睿官方团队 |
| 发布时间 | 2022-03-01 15:30:06 |
| 更新时间 | 2025-10-09 09:03:09 |
想用用户自定义字段调用用户的信息和排名，为啥加了字段tuijian，前端调用不出来？
<?php $query=urlencode('SELECT uid, COUNT(*) AS total FROM `@#1_news_index` WHERE status=9 GROUP BY uid ORDER BY total DESC');?>
{sql sql='$query' MONTH_updatetime=0}
{if $t['tuijian'] == "1"}
{php $member = dr_member_info($t.uid);}
<tr>
<td height="40" align="center" style="border: #e9eff8 solid 1px;">{$key+1}</td>
<td align="center" style="border: #e9eff8 solid 1px;"> {$member.username}</td>
<td align="center" style="border: #e9eff8 solid 1px;">{$t.total} 篇</td>
</tr>
{/if}
{/sql}
开源社区插件技术-小鹏
<?php $query=urlencode('SELECT uid, COUNT(*) AS total FROM `@#1_news_index` WHERE status=9 and uid in （select id from @#member_data where tuijian=1） GROUP BY uid ORDER BY total DESC');?> {sql sql='$query'} {php $member = dr_member_info($t.uid);} <tr> <td height="40" align="center" style="border: #e9eff8 solid 1px;">{$key+1}</td> <td align="center" style="border: #e9eff8 solid 1px;"> {$member.username}</td> <td align="center" style="border: #e9eff8 solid 1px;">{$t.total} 篇</td> </tr> {/sql}