<%@ LANGUAGE="vbscript" %> <% Response.Buffer = True %> <% Response.Clear %> <% 'Get Browser Info and clear variables Set bc = Server.CreateObject("MSWC.BrowserType") Session("Browser") = bc.browser & " " & bc.version 'Function Hits(ThisPage, URLRoot) ' - Adds This Page to the Database for Visitors 'Hits "Visitors Report", "http://www.evantageone.com" %> <% 'TEST InstrRev 'i="123.456.789.45" 'answer = Left(i,(InstrRev(i,"."))-1) 'response.write "answer = " & answer 'response.end 'Create IP Array from 123 Easy Card SQLStr = "SELECT IPAddress FROM tCard WHERE IPAddress <> '' ORDER BY IPAddress" 'Response.write SQLStr 'response.end Set rs123IP = Conn.Execute(SQLStr) %> Visitor Information (eVantage WEB Sites) <% 'response.write "HERE" 'response.end %> <% 'If IsNull(Session("ckCrawler")) OR IsEmpty(Session("ckCrawler")) OR Len(Session("ckCrawler")) = 0 Then ' Session("ckCrawler") = "ON" 'End If If Session("ckCrawler") = "ON" Then checked = "checked" Crawler = "(IsCrawler = 'Y' or IsCrawler = 'N')" Else checked = Null Crawler = "IsCrawler = 'N'" End If DayNumber = 1 SortBanner = "" Sort = request.querystring 'response.write "Sort = " & Sort 'response.end stDate = Trim(Right(Sort,Len(Sort)-Instr(Sort,"-"))) 'response.write "stDate = " & stDate 'response.end SQLStr = "SELECT Count(DemoDownloadID) AS TotalCountOfDownloads FROM tblDemoDownload WHERE LastName <> 'Schinner'" 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) TotalCountOfDownloads = rs("TotalCountOfDownloads") SQLStr = "SELECT TOP 1 DemoDownloadID, FirstName + ' ' + LastName as FullName, Company, State FROM tblDemoDownload ORDER BY DemoDownloadID DESC" 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) LastDownloadPerson = rs("FullName") LastDownloadCompany = rs("Company") LastDownloadState = rs("State") LastDownloadMessage = "Last Download by: " & LastDownloadPerson & chr(10) & chr(13) & "From: " & LastDownloadCompany & ", " & LastDownloadState DownloadTitle = "Go To the Download Information Page" & chr(10) & chr(13) & "     (" & TotalCountOfDownloads & " Downloads)" & chr(10) & chr(13) & LastDownloadMessage SQLStr = "SELECT Count(VisitorID) AS TotalCountOfVisitors FROM tVisitor WHERE Show = 'Y'" 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) TotalCountOfVisitors = rs("TotalCountOfVisitors") SQLStr = "SELECT Min(VisitDateTime) AS FirstVisitDateTime FROM tVisitor WHERE Show = 'Y'" 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) FirstVisitDateTime = rs("FirstVisitDateTime") 'response.write "FirstVisitDateTime = " & FirstVisitDateTime 'response.end TotalDays = Datevalue(Now()) - Datevalue(FirstVisitDateTime) + 1 'response.write "Total Days = " & TotalDays & "
" 'response.write "Session(LimitNumber) = " & Session("LimitNumber") 'response.end If Len(Session("LimitNumber")) = 0 Then LimitNumber = 1 Else LimitNumber = Session("LimitNumber") End If If LimitNumber = 0 Then LimitNumber = 1 End If LimitDate = Date() - LimitNumber + 1 If LimitNumber = 1 then txtDay = "Day" Else txtDay = "Days" End If 'response.write "Limit Number = " & LimitNumber & "
" 'response.write "Total Days = " & TotalDays 'response.end If Cint(LimitNumber) >= Cint(TotalDays) Then Session("LimitNumber") = TotalDays Else Session("LimitNumber") = LimitNumber End If If Instr(Sort,"/") > 0 Then SQLStr = "SELECT Count(VisitorID) AS CountOfVisitors FROM tVisitor WHERE " & Crawler & " AND VisitDate = '"& Sort &"' AND Show = 'Y'" Else SQLStr = "SELECT Count(VisitorID) AS CountOfVisitors FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y'" End If 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) CountOfVisitors = rs("CountOfVisitors") If Instr(Sort,"/") > 0 Then SQLStr = "SELECT Count(VisitorID) AS CountOfCrawlerYes FROM tVisitor WHERE IsCrawler = 'Y' AND VisitDate = '"& Sort &"' AND Show = 'Y'" Else SQLStr = "SELECT Count(VisitorID) AS CountOfCrawlerYes FROM tVisitor WHERE IsCrawler = 'Y' AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y'" End If 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) CountOfCrawlerYes = rs("CountOfCrawlerYes") If Instr(Sort,"/") > 0 Then SQLStr = "SELECT Count(VisitorID) AS CountOfCrawlerNo FROM tVisitor WHERE IsCrawler = 'N' AND VisitDate = '"& Sort &"' AND Show = 'Y'" Else SQLStr = "SELECT Count(VisitorID) AS CountOfCrawlerNo FROM tVisitor WHERE IsCrawler = 'N' AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y'" End If 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) CountOfCrawlerNo = rs("CountOfCrawlerNo") NotIP = "IPAddress <> '64.68.82.18' OR IPAddress <> '64.68.82.168'" If Len(Sort) = 0 Then SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y' ORDER BY VisitorID DESC" SortBanner = "Sorted By Date/Time (Descending)" ElseIf Instr(Sort,"-Filter") > 0 Then PageAbbrFilter = Trim(Left(Sort,Instr(Sort,"-")-1)) SQLStr = "SELECT Page, PageAbbr FROM tVisitor WHERE PageAbbr='" & PageAbbrFilter & "' AND Show = 'Y'" Set rs = Conn.Execute(SQLStr) Page = rs("Page") SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND PageAbbr = '" & PageAbbrFilter & "' AND Show = 'Y' ORDER BY VisitorID DESC" SortBanner = "Sorted By Date/Time (Descending)" NoRecordBanner = "There are no records for '"& Page &"'" ElseIf Instr(Sort,"-All") > 0 Then PageAbbrAll = Trim(Left(Sort,Instr(Sort,"-")-1)) SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND PageAbbr = '" & PageAbbrAll & "' AND Show = 'Y' ORDER BY VisitorID DESC" SortBanner = "Sorted By Date/Time (Descending)" ElseIf Instr(Sort,"~") > 0 Then CrawlerFilter = Trim(Right(Sort,Len(Sort) - Instr(Sort,"~"))) SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE Crawler = '" & CrawlerFilter & "' AND Show = 'Y' ORDER BY VisitorID DESC" SortBanner = "Visitor Information for " & CrawlerFilter ElseIf Sort = "webpage" Then SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y' ORDER BY Page, VisitorID" SortBanner = "Sorted By WEB Page" ElseIf Sort = "ipaddress" Then SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y' ORDER BY IPAddress, VisitorID" SortBanner = "Sorted By IP Address" ElseIf Sort = "iscrawler" Then SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y' ORDER BY IsCrawler, VisitorID" SortBanner = "Sorted By Crawler?" ElseIf Sort = "who" Then SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y' ORDER BY Crawler, VisitorID" SortBanner = "Sorted By Who?" ElseIf Sort = "dtascending" Then SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y' ORDER BY VisitorID" SortBanner = "Sorted By Date/Time (Ascending)" ElseIf Sort = "dtdescending" Then SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y' ORDER BY VisitorID DESC" SortBanner = "Sorted By Date/Time (Descending)" ElseIf Instr(Sort,"/") > 0 Then SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDate = '"& Sort &"' AND Show = 'Y' ORDER BY VisitorID DESC" SortBanner = "Sorted By Date/Time (Descending)" Else SQLStr = "SELECT tVisitor.* FROM tVisitor WHERE " & Crawler & " AND VisitDateTime > = '"& LimitDate &"' AND Show = 'Y' ORDER BY VisitorID DESC" SortBanner = "Sorted By Date/Time (Descending)" End If 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) %>
<%If Instr(Sort,"/") > 0 Then%> <%ElseIf TotalCountOfVisitors <> CountOfVisitors Then%> <%Else%> <%End If%> <% If Instr(Sort,"/") > 0 Then bxValue = 1 Else bxValue = Session("LimitNumber") End If %>
Visitor Information - <%=FormatNumber(TotalCountOfVisitors,0)%> Visitors In <%=TotalDays%> Days  - (<%=FormatNumber(TotalCountOfVisitors/TotalDays,1)%> per Day Average) <% 'intHour = Hour(Now()) 'response.write "Hour = " & Hour 'response.end %>
Visitor Information For <%=Sort%> - <%=CountOfVisitors%> Visitors
Visitor Information For the Past <%=LimitNumber%> <%=txtDay%>  - <%=CountOfVisitors%> Visitors
Visitor Information For the Past <%=TotalDays%> <%=txtDay%>  - <%=CountOfVisitors%> Visitors
View day(s)   >Show Crawlers     [ <%=TotalCountOfDownloads%> Downloads ]

<%=SortBanner%>
<%If Not rs.eof Then%> <%End If%> <%If rs.eof then%>
<%End If%> <% varDayNumber = 0 DayCount = 1 DaySum = 0 Do while not rs.EOF ' Do While NOT rs123IP.eof ' response.write "123IP = " & rs123IP("IPAddress") & "
" ' response.write "HitIP = " & rs("IPAddress") & "
" ' If rs("IPAddress") = rs123IP("IPAddress") Then ' Match = " *" ' Else ' Match = "" ' End If ' rs123IP.MoveNext ' loop ' response.write "Match = " & Match & "
" DayNumber = DateValue(rs("VisitDateTime"))-DateValue(#8/8/03#) + 1 If DayNumber <> varDayNumber Then D = DayNumber Else D = Null End If 'response.write "Browser = " & rs("Browser") & "
" 'response.end If Isnull(rs("Browser")) OR Isempty(rs("Browser")) OR Len(rs("Browser")) = 0 Then Browser = "Default" Else Browser = rs("Browser") End If If Isnull(rs("IPAddress")) OR Isempty(rs("IPAddress")) OR Len(rs("IPAddress")) = 0 Then IPAddress = "----" Else IPAddress = rs("IPAddress") End If If Isnull(rs("Crawler")) OR Isempty(rs("Crawler")) OR Len(rs("Crawler")) = 0 Then Crawler = " " Else Crawler = rs("Crawler") End If If Isnull(rs("CrawlerURL")) OR Isempty(rs("CrawlerURL")) OR Len(rs("CrawlerURL")) = 0 Then CrawlerURL = Null If Crawler = " " Then CrawlerBanner = " " Else CrawlerBanner = Crawler End If Else CrawlerURL = rs("CrawlerURL") If Crawler = " " Then CrawlerBanner = " " Else If Instr(rs("CrawlerURL"),"@") > 0 Then CrawlerBanner = "" & Crawler & " (eMail)" Else CrawlerBanner = "" & Crawler & "" End If End If End If SQLStr = "SELECT * FROM qryCountOfWHO WHERE Len(crawler)>0 ORDER BY Crawler" 'response.write SQLStr 'response.end Set rsCntOfWho = Conn.Execute(SQLStr) %> <% rs.MoveNext If DayNumber <> varDayNumber Then DaySum = DayCount DayCount = 0 Else DaySum = 0 DayCount = DayCount + 1 End If If DaySum = 0 Then DaySum = Null End If 'response.write "" varDayNumber = DayNumber Loop %>
Web Page IP Address Crawler?
<%If Session("ckCrawler") = "ON" Then%> <%=CountOfCrawlerYes%> Y's
<%End If%> <%=CountOfCrawlerNo%> N's
  Who?     Go To
"Who?" Page
Browser Visitor
  ID #
Date / Time     <%If Sort = "dtascending" Then%> <%Else%> <%End If%>    <%If Sort = "dtdescending" OR Len(Sort) = 0 Then%> <%Else%> <%ENd If%>
<%=NoRecordBanner%>
<%=rs("URL")%> <%=IPAddress%><%=Match%> <%=rs("IsCrawler")%><%=Match%> <%If Crawler = " " Then%>    <%Else%> <% Do While NOT rsCntOfWho.eof If rsCntOfWho("Crawler") = Crawler Then CountOfWho = rsCntOfWho("CountOfHits") End If rsCntOfWho.movenext loop If CountOfWho > 1 Then CountOfWhoBanner = FormatNumber(CountOfWho,0) & " Pages" Else CountOfWhoBanner = CountOfWho & " Page" End If 'CountOfWhoBanner = "Pages" %>    <%End If%> <%=CrawlerBanner%> <%=Browser%> <%=FormatNumber(rs("VisitorID"),0)%> "><%=rs("VisitDateTime")%>
 " & DaySum & "
<% SQLStr = "SELECT Count(qryHitsByPage.Page) AS CountOfPage FROM qryHitsByPage" Set rsCnt = Conn.Execute(SQLStr) TotalPages = rsCnt("CountOfPage") %>
Hits per Page (<%=TotalPages%> Pages) <% If LimitNumber = 1 then %> <%Else%> <%End If%> <% If Instr(Sort,"/") > 0 Then strDate = Sort Else strDate = Date() End If SQLStr = "spHitsPerPage '" & strDate & "'" 'response.write SQLStr 'response.end Set rsLoop = Conn.Execute(SQLStr) 'SQLStr = "SELECT Page, HitsNC FROM qryHitsByPageNC ORDER BY Page" 'response.write SQLStr 'response.end 'Set rsHitsNC = Conn.Execute(SQLStr) Do While NOT rsLoop.eof %> <% rsLoop.movenext loop %>
WEB Page<%=CountOfVisitors%> Hits
<%If Instr(Sort,"/") > 0 Then%> For <%=Sort%> <%Else%> Today <%End If%>
<%If Sort = "hitsPageAsc" Then%> <%Else%> <%End If%> <%If Sort = "hitsWDDesc" Then%> <%Else%> <%End If%>
<%=CountOfVisitors%> Hits for the
Past <%=LimitNumber%> <%=txtDay%>
<%If Sort = "hitsPageAsc" Then%> <%Else%> <%End If%> <%If Sort = "hitsWDDesc" Then%> <%Else%> <%End If%>
<%=TotalCountOfVisitors%> Hits for the
Past <%=TotalDays%> Days
<%=rsLoop("URL")%> -Filter"><%=rsLoop("SmallHits")%> -All"><%=rsLoop("Hits")%>










<% intDays = 31 prevDate = Date() - intDays + 1 'response.write "prevDate = " & prevDate 'response.end If Sort = "hitsDesc" Then SQLStr = "Select qryHitsByDate.* FROM qryHitsByDate WHERE VisitDate >= '" & prevDate & "' ORDER BY Hits DESC" SQLStrNC = "Select qryHitsByDateNC.* FROM qryHitsByDateNC WHERE VisitDate >= '" & prevDate & "'" ElseIf Sort = "hitsAsc" Then SQLStr = "Select qryHitsByDate.* FROM qryHitsByDate WHERE VisitDate >= '" & prevDate & "' ORDER BY Hits" SQLStrNC = "Select qryHitsByDateNC.* FROM qryHitsByDateNC WHERE VisitDate >= '" & prevDate & "'" ElseIf Sort = "DtAsc" Then SQLStr = "Select qryHitsByDate.* FROM qryHitsByDate WHERE VisitDate >= '" & prevDate & "' ORDER BY VisitDate" SQLStrNC = "Select qryHitsByDateNC.* FROM qryHitsByDateNC WHERE VisitDate >= '" & prevDate & "' ORDER BY VisitDate" ElseIf Sort = "DtDesc" Then SQLStr = "Select qryHitsByDate.* FROM qryHitsByDate WHERE VisitDate >= '" & prevDate & "' ORDER BY VisitDate DESC" SQLStrNC = "Select qryHitsByDateNC.* FROM qryHitsByDateNC WHERE VisitDate >= '" & prevDate & "' ORDER BY VisitDate DESC" Else SQLStr = "Select qryHitsByDate.* FROM qryHitsByDate WHERE VisitDate >= '" & prevDate & "' ORDER BY VisitDate DESC" SQLStrNC = "Select qryHitsByDateNC.* FROM qryHitsByDateNC WHERE VisitDate >= '" & prevDate & "' ORDER BY VisitDate DESC" End If 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) 'response.write SQLStrNC 'response.end Set rsNC = Conn.Execute(SQLStrNC) SQLStr = "SELECT Max(Hits) AS MaxHits FROM qryHitsByDate WHERE VisitDate >= '" & prevDate & "'" 'response.write SQLStr 'response.end Set rsMax = Conn.Execute(SQLStr) MaxHits = rsMax("MaxHits") SQLStr = "SELECT Min(Hits) AS MinHits FROM qryHitsByDate WHERE VisitDate >= '" & prevDate & "'" 'response.write SQLStr 'response.end Set rsMin = Conn.Execute(SQLStr) MinHits = rsMin("MinHits") 'response.write "MinHits = " & MinHits 'response.end SQLStr = "SELECT Min(Hits) AS MinHits FROM qryHitsByDateNC WHERE VisitDate >= '" & prevDate & "'" 'response.write SQLStr 'response.end Set rsMinNC = Conn.Execute(SQLStr) MinHitsNC = rsMinNC("MinHits") 'response.write "MinHitsNC = " & MinHitsNC 'response.end SQLStr = "SELECT DISTINCT TOP 4 qryHitsByDate.Hits FROM qryHitsByDate WHERE VisitDate >= '" & prevDate & "' ORDER BY qryHitsByDate.Hits DESC" 'response.write SQLStr 'response.end Set rsTopThree = Conn.Execute(SQLStr) ttCnt = 0 Do While Not rsTopThree.eof ttCnt = ttCnt + 1 if ttCnt = 1 then One = rsTopThree("Hits") End If if ttCnt = 2 then Two = rsTopThree("Hits") End If if ttCnt = 3 then Three = rsTopThree("Hits") End If if ttCnt = 4 then Four = rsTopThree("Hits") End If rsTopThree.movenext Loop 'response.write One & Two & Three 'response.end SQLStr = "SELECT DISTINCT TOP 4 qryHitsByDateNC.Hits FROM qryHitsByDateNC WHERE VisitDate >= '" & prevDate & "' ORDER BY qryHitsByDateNC.Hits DESC" 'response.write SQLStr 'response.end Set rsTopThreeNC = Conn.Execute(SQLStr) Do While Not rsTopThreeNC.eof ttCntNC = ttCntNC + 1 if ttCntNC = 1 then OneNC = rsTopThreeNC("Hits") End If if ttCntNC = 2 then TwoNC = rsTopThreeNC("Hits") End If if ttCntNC = 3 then ThreeNC = rsTopThreeNC("Hits") End If if ttCntNC = 4 then FourNC = rsTopThreeNC("Hits") End If rsTopThreeNC.movenext Loop 'response.write OneNC & TwoNC & ThreeNC & FourNC 'response.end 'If Len(Sort) = 0 OR Sort <> "DtAsc" OR Sort <> "hitsAsc" OR Sort <> "hitsDesc" Then If Len(Sort) = 0 Then Sort = "DtDesc" End If %> <% SQLStr = "SELECT TOP 1 qryHitsByDate.* FROM qryHitsByDate ORDER BY Hits DESC" 'response.write SQLStr 'response.end Set rsATH = Conn.Execute(SQLStr) 'ATHBanner = "All Time High: " & rsATH("Hits") & " hits on rsATH("VisitDate") ATH = rsATH("Hits") ATHDateFull = FormatDateTime(rsATH("VisitDate"),1) ATHDate = rsATH("VisitDate") %>











Hits per Date for <%=intDays%> Days - from <%=prevDate%> to <%=Date()%>
      All Time High: ><%=ATH%> hits on ><%=ATHDateFull%>
         1 Top Maximum Hit    2 Second Maximum Hit     3 Third Maximum Hit   
4 Fourth Maximum Hit     # Minimum Hit

<% Do While NOT rs.eof 'Do While NOT rs.eof OR rsNC.eof If isNull(rs("VisitDate")) OR Len(rs("VisitDate")) = 0 Then WD = Null Else WD = Weekday(rs("VisitDate")) End If 'response.write WD Select Case WD Case 1 D = "Sun" Case 2 D = "Mon" Case 3 D = "Tue" Case 4 D = "Wed" Case 5 D = "Thu" Case 6 D = "Fri" Case 7 D = "Sat" End Select If rs("Hits") = One Then MaxHitsBanner = " 1 " Else MaxHitsBanner = "" End If If rs("Hits") = Two Then TwoHitsBanner = " 2 " Else TwoHitsBanner = "" End If If rs("Hits") = Three Then ThreeHitsBanner = " 3 " Else ThreeHitsBanner = "" End If If rs("Hits") = Four Then FourHitsBanner = " 4 " Else FourHitsBanner = "" End If If rs("Hits") = MinHits Then MinHitsBanner = " # " Else MinHitsBanner = "" End If If rs("Hits") <= 9 Then HitNum = "  " & rs("Hits") ElseIf rs("Hits") >=10 AND rs("Hits") <= 99 Then HitNum = "  " & rs("Hits") Else HitNum = rs("Hits") End If '----- If rsNC("Hits") = OneNC Then MaxHitsBannerNC = " 1 " Else MaxHitsBannerNC = "" End If If rsNC("Hits") = TwoNC Then TwoHitsBannerNC = " 2 " Else TwoHitsBannerNC = "" End If If rsNC("Hits") = ThreeNC Then ThreeHitsBannerNC = " 3 " Else ThreeHitsBannerNC = "" End If If rsNC("Hits") = FourNC Then FourHitsBannerNC = " 4 " Else FourHitsBannerNC = "" End If If rsNC("Hits") = MinHitsNC Then MinHitsBannerNC = " # " Else MinHitsBannerNC = "" End If If rsNC("Hits") <= 9 Then HitNumNC = "  " & rsNC("Hits") Else HitNumNC = rsNC("Hits") End If %> <% rsNC.movenext rs.movenext loop %>
Date  <%If Sort = "DtAsc" Then%> <%Else%> <%End If%>   <%If Sort = "DtDesc" Then%> <%Else%> <%End If%> Day Hits  <%If Sort = "hitsAsc" Then%> <%Else%> <%End If%>   <%If Sort = "hitsDesc" Then%> <%Else%> <%End If%> Hits
No Crawlers 
"><%=rs("VisitDate")%> <%=D%>       <%=HitNum%><%=MinHitsBanner%><%=MaxHitsBanner%><%=TwoHitsBanner%><%=ThreeHitsBanner%><%=FourHitsBanner%>    <%=HitNumNC%><%=MinHitsBannerNC%><%=MaxHitsBannerNC%><%=TwoHitsBannerNC%><%=ThreeHitsBannerNC%><%=FourHitsBannerNC%>






































<% TotalWeeks = Round(TotalDays/7,0) AverageVisitorCountPerWeek = Round(TotalCountOfVisitors/TotalWeeks,1) 'response.write "Average Visitor Count Per Week = " & AverageVisitorCountPerWeek %>
Hits per Weekday (<%=TotalCountOfVisitors%> Total Hits) <% If Sort = "hitsWDAsc" Then Order = "ORDER BY Hits" ElseIf Sort = "hitsWDDesc" Then Order = "ORDER BY Hits DESC" Else Order = Null End If SQLStr = "SELECT * FROM qryHitsByWeekDay " & Order 'response.write SQLStr 'response.end Set rsHitsWD = Conn.Execute(SQLStr) Do While NOT rsHitsWD.eof %> <% rsHitsWD.movenext loop %>
Weekday Total
Hits
<%If Sort = "hitsWDAsc" Then%> <%Else%> <%End If%> <%If Sort = "hitsWDDesc" Then%> <%Else%> <%End If%>
Average Hits
For <%=TotalWeeks%> Weeks
(<%=AverageVisitorCountPerWeek%> Total)
<%=rsHitsWD("WkDay")%>   <%=rsHitsWD("Hits")%>   <%=Round(rsHitsWD("Hits")/TotalWeeks,1)%>
<% SQLStr = "SELECT Count(tVisitorAddressID) AS TotalCountOfAddresses FROM tVisitorAddress" 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) TotalCountAddresses = FormatNumber(rs("TotalCountOfAddresses"),0) SQLStr = "SELECT Count(Crawler) as CountOfCrawlers FROM qryCountOfWHO WHERE Len(Crawler) > 0" 'response.write SQLStr 'response.end Set rs = Conn.Execute(SQLStr) CountOfCrawlers = FormatNumber(rs("CountOfCrawlers"),0) %>


Top Of Page
<%=CountOfCrawlers%> WEB Sites in Database
<%=TotalCountAddresses%> IP Addresses