{dim islist:islist=1}
{sdcms:rs field="id,title,fromid,createdate,isread,(select username from sd_user where id=fromid) as fromname,replydate" table="sd_user_message" where="1=1 [sqlwhere][wherekey]" order="id desc" pagesize="20" isadminurl="0"}
{rs:eof}
<%islist=0%>
没有资料 |
{/rs:eof}
|
{$rs[title]} |
{$rs[fromname]} |
{if $rs[fromid]>0}好友互动{/if}{if $rs[fromid]=-1}系统通知{/if}{if $rs[fromid]=-2}消费提醒{/if}{if $rs[fromid]=-3}用户成长{/if} |
{$rs[createdate]} |
{if $rs[isread]=1}是{else}否{/if} |
删除 |
{/sdcms:rs}