新云V3_未審核的統(tǒng)計標簽|新云CMS

2024-07-09 22:56:04

字體：大中小

供稿：網(wǎng)友

打開INC/Cls_Public.asp
查找函數(shù)名 "LoadStatistic"轉(zhuǎn)載本站任何文章，請貼明源處 www.jz00.com.cn 歡迎大家轉(zhuǎn)載.

'================================================
'函數(shù)名：LoadStatistic
'作用：裝載頻道統(tǒng)計
'參數(shù)：moduleid ----所屬模塊
'        ChannelID ----頻道ID
'        strClass ----所調(diào)用的分類ID或者軟件類型
'        stype ----統(tǒng)計類型，0=全部統(tǒng)計，1=今日更新統(tǒng)計，2=點擊數(shù)統(tǒng)計，3=軟件容量統(tǒng)計
'================================================

新云的函數(shù)模塊一般都有很好的注釋。轉(zhuǎn)載本站任何文章，請貼明源處 www.jz00.com.cn 歡迎大家轉(zhuǎn)載.
找到Select Case moduleid 這里是用判斷模塊ID
Case 1 文章模塊/Case 2 軟件模塊/Case 4 留言本/Case 5 flash(動畫)/其他用戶列表
現(xiàn)在我們要審計未審核的文章數(shù)，那就在Case 1 這段話里做文章增加一段,意是就是類型填為9的時候，就讀取未審核的全部文章。轉(zhuǎn)載本站任何文章，請貼明源處 www.jz00.com.cn 歡迎大家轉(zhuǎn)載.

ElseIf stype = 9 Then
SQL = "SELECT * FROM NC_Article WHERE isAccept=0 " & foundsql

具體如下轉(zhuǎn)載本站任何文章，請貼明源處 www.jz00.com.cn 歡迎大家轉(zhuǎn)載.

Case 1
   If stype = 1 Then
    If isSqlDataBase = 1 Then
     SQL = "SELECT COUNT(ArticleID) FROM NC_Article WHERE isAccept>0 " & foundsql & " And Datediff(d,WriteTime,GetDate())=0"
    Else
     SQL = "SELECT COUNT(ArticleID) FROM NC_Article WHERE isAccept>0 " & foundsql & " And WriteTime>=Date()"
    End If
   ElseIf stype = 2 Then
    SQL = "SELECT SUM(AllHits) FROM NC_Article WHERE isAccept>0 " & foundsql
   ElseIf stype = 4 Then
    SQL = "SELECT SUM(DayHits) FROM NC_Article WHERE isAccept>0 " & foundsql
   ElseIf stype = 9 Then
    SQL = "SELECT * FROM NC_Article WHERE isAccept=0 " & foundsql
   Else
    SQL = "SELECT COUNT(ArticleID) FROM NC_Article WHERE isAccept>0 " & foundsql
   End If

紅色部分為新增其他的模塊異曲同工。大家學著改改看。。

上一篇：新云4.0怎么批量修改軟件聯(lián)系方式|新云CMS

下一篇：新云4.0 文章模塊config.xml詳解|新云CMS