修改了栏目页的样式想做DIGG排名~~

[/loop]

代码如下

<script src="/ks_inc/digg.js" language="javascript"></script>
[loop=10]
<table width="100%" border="0">
  <tr>
    <td width="45" rowspan="2">
      <div style="width:35px;text-align:center;background:url(/images/diggbg1.gif) #FFF no-repeat;height:45px;margin-right:10px;">
     <div style="padding-top:8px;">
     <span id="s{$Field(id,GetInfoUrl,1,2)}" style="font-weight:bold;"></span><br />
      </div>
    <div style="padding-top:8px;" id="d{$Field(id,GetInfoUrl,1,2)}"><a href="javascript:digg(1,{$Field(id,GetInfoUrl,1,2)},'/');">我顶</a></div>
  </div>
  <script language="javascript">show_digg(1,{$Field(id,GetInfoUrl,1,2)},'/');</script></td>
    <td width="944"><a href="{$Field(id,GetInfoUrl,1,1)}" target="_blank"><font style="color:#003592;font-size:12px;">{$Field(title,Text,26,,0,)}</font></a></td>
  </tr>
  <tr>
   <td valign="top">{$Field(intro,Text,58,,2,)}</td>
  </tr>
</table>

<div style="border-bottom:1px dashed #bdbdbd; margin-bottom: 4px;"></div>

[/loop]

在此向大家求一个DIGG的SQL查询语句~~~~查询的是整个Artile模型~~

查询语句：（我这个屏蔽了三个栏目，你可以根据需要做调整）

select top 10 KS_Article.Tid,KS_Article.ID,KS_Article.Title,KS_Class.FolderName from KS_Article,KS_DiggList,KS_Class where KS_Article.Tid not in(20110652915206,20110476654181,20117396515655) and KS_DiggList.InfoID=KS_Article.ID And KS_Class.ID=KS_Article.Tid  Order by KS_DiggList.DiggNum desc

循环输出：

[loop=10]<li><span class="list_classname">[<a href="{$Field(Tid,GetClassUrl,1,1)}" target="_blank">{$Field(FolderName,Text,0,...,0,)}</a>]</span><a href="{$Field(ID,GetInfoUrl,1,1)}" target="_self" title="{$Field(Title,Text,0,...,0,)}">{$Field(Title,Text,40,...,0,)}</a></li>
[/loop]