SoFunction
Updated on 2025-04-09

Classes used in domain name query system


<%
Dim Domain
Set Domain = New Cls_DomainFunction
Class Cls_DomainFunction
    Private vListURL
    Private Thief_
    Private vDomainArr, vDomainName
    Private vLoopI
    Private vDomainsName, vDomainMainBody
    Private TLDCode
    Private Rs, Sql
    Private ExtraDataArr
    Private WhoisArr, WhoisCreationDate, WhoisExpirationDate, WhoisORG, WhoisName, WhoisBaiduSite, WhoisBaiduBody, WhoisPageRank
    Public SqlQueryLengthID, SqlQueryComposeTypeID, SqlQueryTLDID, SqlOrderByID
    Private SqlQueryLength, SqlQueryComposeType, SqlQueryTLD, SqlOrderBy

    Public Function GetDomainList(vListID)
        Select Case vListID
            Case 1 : vListURL = "/download/registar_list/"
            Case 2 : vListURL = "/download/registar_list/"
            Case 3 : vListURL = "/download/registar_list/"
            Case 4 : vListURL = "/download/registar_list/"
            Case 5 : vListURL = "/download/registar_list/"
            Case 6 : vListURL = "/download/registar_list/"
            Case Else : vListURL = "/download/registar_list/"
        End Select
        Set Thief_ = New Cls_Thief
        Thief_.Source = vListURL
        Thief_.Steal
        vDomainArr = Split(Thief_.Value, vbLf)
        Set Thief_ = Nothing

If UBound(vDomainArr) < 2 Then Call ("The latest CNNIC database has not been released yet.")

        Call ConnDB()
        For vLoopI = 0 To UBound(vDomainArr)
            vDomainsName = LCase(vDomainArr(vLoopI))
            If Instr(vDomainsName, ".") > 0 Then
                vDomainMainBody = Split(vDomainsName, ".")(0)
                ("INSERT INTO [CNDomainList](DomainName, Body, Length, ComposeType, TLD) VALUES('" & vDomainsName & "', '" & vDomainMainBody & "', " & Len(vDomainMainBody) & ", " & GetDomainComposeType(vDomainMainBody) & ", " & GetDomainLTD(vDomainsName) & ")") 
            End If
        Next
        Call DisconnDB()
        Call CompactDataBase(vDatabasePath, False)
    End Function

    Public Function ClearUpDatabase()
        Call ConnDB()
        ("DELETE * FROM [CNDomainList]")
        Call DisconnDB()
        Call CompactDataBase(vDatabasePath, False)
    End Function

    Private Function GetDomainComposeType(DomainName)
        If (DomainName) Then
            GetDomainComposeType=1
        ElseIf (DomainName) Then
            GetDomainComposeType=2
        ElseIf (DomainName) Then
            GetDomainComposeType=3
        Else
            GetDomainComposeType=4
        End If
    End Function

    Private Function GetDomainLTD(DomainName)
        If UBound(Split(DomainName, ".")) > 1 Then
            Select Case Split(DomainName, ".")(1)
                Case "com"
                    TLDCode = 10011
                Case "net"
                    TLDCode = 10021
                Case "org"
                    TLDCode = 10051
                Case "gov"
                    TLDCode = 10061
                Case "ac"
                    TLDCode = 10071
                Case Else
                    TLDCode = 10041
            End Select
        Else
            TLDCode = 10001
        End If
        GetDomainLTD = TLDCode
    End Function

    Private Sub CompactDataBase(DataBasePath, boolIs97)
        On Error Resume Next
        Dim Fso, Engine, strDataBasePath,JET_3X
        strDataBasePath = Left(DataBasePath,InstrRev(DataBasePath,"\"))
        Set Fso = CreateObject("")
        If  <> 0 Then
            ()
            Exit Sub
        End If
        If (DataBasePath) Then
                 DataBasePath,strDataBasePath & ""
                Set Engine = CreateObject("")
                If BoolIs97 = "True" Then
                     "Provider=.4.0;Data Source=" & strDataBasePath & "", _
                    "Provider=.4.0;Data Source=" & strDataBasePath & ";" _
                    & "Jet OLEDB:Engine Type=" & JET_3X
                Else
                     "Provider=.4.0;Data Source=" & strDataBasePath & "", _
                    "Provider=.4.0;Data Source=" & strDataBasePath & ""
                End If
             strDataBasePath & "",DataBasePath
            (strDataBasePath & "")
            (strDataBasePath & "")
            Set Fso = nothing
            Set Engine = nothing
            If  <> 0 Then
                ()
                Exit Sub
            End If
        End If
    End Sub
End Class
%>