select * from @#'.SITE_ID.'_news where title LIKE "%'.$keywords.'%" ORDER BY id DESC
# 关键字列表
{php $query='select * from @#'.SITE_ID.'_news where title LIKE "%'.$keywords.'%" ORDER BY id DESC ';}
{list action=sql module=news sql='$query' page=1 pagesize=10 urlrule=?page=[page]}# 栏目
[get_cache('module-'.SITE_ID.'-news', 'category', $t['catid'], 'url')}>{$ci->get_cache('module-'.SITE_ID.'-news', 'category', $t['catid'], 'name')}]
{$t.title}
{dr_date($t._updatetime, 'm-d')}
# 网站导航
{list action=sql sql='select * from @#site LIMIT 8'}
{$t.name}
{/list}# 最新更新
{list action=table table=".$t.id."_news join=".$t.id."_news_category on=catid,id order=updatetime num=5 return=site}
{$key_site+1} {dr_strcut($site.title, 32)}
{/list}# 热门更新
{list action=table table=".$t.id."_news join=".$t.id."_news_category on=catid,id order=hits num=5 return=site}
{$key_site+1} {dr_strcut($site.title, 32)}
{/list}# 最新发布
{list action=table table=".$t.id."_news join=".$t.id."_news_category on=catid,id order=id num=5 return=site}
{$key_site+1} {dr_strcut($site.title, 32)}
{/list}
# 循环分站输出:
{list action=sql sql='select * from @#site LIMIT 8'}
{list action=category module=news pid=0 site=".$t.id." return=cat}
{$cat.name}
{/list}
...
{list action=page pid=0 site=".$t.id." return=cat}
{$cat.name}
{/list}
...
{/list}
...
签名:这个人很懒,什么也没有留下!