Dedecms feedback.php評(píng)論頁(yè)面調(diào)用最近熱門評(píng)論 插件

2011-04-18 14:39?來(lái)源 未知

修改feedback.php，在“評(píng)論內(nèi)容類表”代碼的前面加上以下代碼：
  //最近熱門評(píng)論
  $feedback_hot = "";
    $nearTime = 60;  //最近評(píng)論的文章的發(fā)布日期(表示多少天前)
    $minTime = time() - (3600 * 24 * $nearTime);
    
    if($topID==0) $hotquery = "Select ID,title From cmsxx_archives where ID<>'$aid' And senddate>$minTime order by goodpost desc limit 0,25";
    else $hotquery = "Select ID,title From cmsxx_archives where ID<>'$aid' And senddate>$minTime And typeid=$topID order by goodpost desc limit 0,25";
  
  $dlist->dsql->Execute("hotq",$hotquery);
  while($myrow = $dlist->dsql->GetArray("hotq")){
      $feedback_hot .= "<div class='nndiv'>·<a href='feedback.php?aid={$myrow['ID']}'>{$myrow['title']}</a></div>\r\n";
  }
  $dlist->dsql->FreeResult("hotq");

這樣就可以在feedback_templet.htm模板中，用代碼 <?php echo $feedback_hot ?>來(lái)調(diào)用了。

編輯： 溫州視線