DEDECMS上一篇下一篇解決方案-按發布時間排序(pubdate)

修改 dede/include/inc_archives_view.php

最下面兩行是原來的，注掉，加入我上面添加的部分, 如果需要在管理文檔時也按PUBDATE排序請修改相關文檔 content_list.htm, content_list.php.

//add by 沙加 QQ5364241
          $des_arc = $this->dsql->GetOne("Select arc.pubdate from `{$this->MainTable}` arc where arc.ID='$aid'");
          $des_pubdate = $des_arc['pubdate'];
           $next = " arc.pubdate>'$des_pubdate' And arc.arcrank>-1 And typeid='{$this->Fields['typeid']}' order by arc.pubdate asc ";
           $pre = " arc.pubdate<'$des_pubdate' And arc.arcrank>-1 And typeid='{$this->Fields['typeid']}' order by arc.pubdate desc ";
//end add

           //$next = " arc.ID>'$aid' And arc.arcrank>-1 And typeid='{$this->Fields['typeid']}' order by arc.ID asc ";
           //$pre = " arc.ID<'$aid' And arc.arcrank>-1 And typeid='{$this->Fields['typeid']}' order by arc.ID desc ";