%@ 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)
%>