文章列表类别(95)
End If
ElseIf stype = 2 Then
SQL = "SELECT SUM(AllHits) FROM NC_FlashList WHERE isAccept>0 " & foundsql
ElseIf stype = 3 Then
SQL = "SELECT SUM(filesize) FROM NC_FlashList WHERE isAccept>0 " & foundsql
ElseIf stype = 4 Then
SQL = "SELECT SUM(DayHits) FROM NC_FlashList WHERE isAccept>0 " & foundsql
Else
SQL = "SELECT COUNT(flashid) FROM NC_FlashList WHERE isAccept>0 " & foundsql
End If
Case Else
If stype = 1 Then
If isSqlDataBase = 1 Then
SQL = "SELECT COUNT(userid) FROM NC_User WHERE Datediff(d,JoinTime,GetDate())=0"
Else
SQL = "SELECT COUNT(userid) FROM NC_User WHERE JoinTime>=Date()"
End If
Else
SQL = "SELECT COUNT(userid) FROM NC_User"
End If
End Select
Set Rs = Newasp.Execute(SQL)
If Rs.BOF And Rs.EOF Then
内容版权声明:除非注明,否则皆为本站原创文章。