KingCMS digg插件自动排序实现方法
利用sql标签，用广告系统实现自动更新
1、新建广告
广告名称：movie_digg
广告内容：
<ul>{king:sql cmd="select c.ktitle,c.kpath,c.digg0,d.listname,d.listpath from (select top 20 * from(select a.digg0,b.ktitle,b.kpath,b.listid from kingdigg a inner join king__movie_page b on a.kid=b.kid order by a.digg0 desc)) c left outer join king__movie_list d on c.listid=d.listid"}
<li>[<a href="/(king:#4/)" target="_blank">(king:#3/)</a>] <a href="/(king:#4/)/(king:#1/)" target="_blank">(king:#0/)</a> ((king:#2/))</li>
{/king}</ul>
2、在页面模板里调用
{king:ad name="movie_digg" type="js"/}
3、在页面模板底部加自动更新，比如3小时
{king:ad#update time="3"/}
