易优会员升级列表显示
2022-11-28 加入收藏
{eyou:sql sql='SELECT ul.level_name,um.money,um.add_time,u.nickname,u.head_pic FROM ey_users_money AS um LEFT JOIN ey_users AS u on um.users_id = u.users_id LEFT JOIN ey_users_level AS ul on ul.level_id = um.level_id WHERE um.cause_type = 0 AND um.status = 2 ORDER BY um.moneyid DESC LIMIT 0,10' cachetime='-1'}
<li>
<img src="{$field.head_pic}">
<a><strong>{$field.nickname}</strong><em>￥{$field.money}</em>升级了<span>{$field.level_name}</span><i>[{$field.add_time|MyDate='Y-m-d H:i:s',###}]</i></a>
</li>
{/eyou:sql}