%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
'#############################
'DWStats 1.0 - ASP
'(c) 2004 N G Rohler & Elkfoot.com software
'All Rights Reserved.
'
'This File: send.asp
'Purpose: collects data
'#############################
Response.Buffer = True
Dim strFilePath, strFileName
strFilePath = Server.MapPath("blank.gif")
strFileName = "blank.gif"
Response.Clear
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Open
objStream.Type = 1
objStream.LoadFromFile strFilePath
Response.AddHeader "Content-Disposition", "attachment; filename=" & strFileName
Response.ContentType = "image/gif"
Response.BinaryWrite objStream.Read
Response.Flush
objStream.Close
Set objStream = Nothing
'-----------------
Dim Conn, pagename, ip, trimref, ref, platform, browser, language, country, javascript, java, screenres, screencolor, searchengine, searchquery
Conn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/dwstats.mdb") & ";"
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = Conn
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Dim callcount
callcount = 1
Function doQuery(sql)
'Response.Write("command called #" & callcount & " - SQL: " & sql & "
")
Command1.CommandText = sql
Command1.Execute()
callcount = callcount + 1
End Function
function eregi(strPattern, strOriginalString, global_returnarray)', varIgnoreCase)
' Function matches pattern, returns true or false
' varIgnoreCase must be TRUE (match is case insensitive) or FALSE (match is case sensitive)
dim objRegExp : set objRegExp = new RegExp
with objRegExp
.Pattern = strPattern
.IgnoreCase = True'varIgnoreCase
.Global = global_returnarray
end with
if (global_returnarray=false) then
'objRegExp.Global = false
eregi = objRegExp.test(strOriginalString)
else
'objRegExp.Global = true
dim matches
set matches = objRegExp.Execute(strOriginalString)
eregi = matches
end if
set objRegExp = nothing
end function
function ereg_replace(strPattern, strReplacement, strOriginalString)', varIgnoreCase)
' Function replaces pattern with replacement
' varIgnoreCase must be TRUE (match is case insensitive) or FALSE (match is case sensitive)
dim objRegExp : set objRegExp = new RegExp
with objRegExp
.Pattern = strPattern
.IgnoreCase = False'varIgnoreCase
.Global = True
end with
ereg_replace = objRegExp.replace(strOriginalString, strReplacement)
set objRegExp = nothing
end function
function str_replace(search, strreplace, subject)
str_replace = Replace(subject, search, strreplace)
end function
function explode(separator, string)
explode = split(string, separator)
end function
function stristr(haystack, needle)
dim occurrence, substr
occurrence = instr(ucase(haystack), ucase(needle))
if (occurrence = 0) then
substr = false
else
substr = mid(haystack, occurrence)
end if
stristr = substr
end function
'function writeArray(thearray)
' dim item
' for each item in thearray
' Response.Write(item & "
")
' next
'end function
'writeArray(explode("e", "me@mydomain.com"))
Function getBrowserInfo
Dim InfoArray(4)
Dim objRegExpr, colMatches
dim subval
Dim platform, name, version, agent, aol, val
plaform = "Unknown"
name = "Unknown"
version = "Unknown"
agent = "Not reported"
aol = false
'if (request("agent")<>"") then
' agent = Request("agent")
'else
agent = Request.ServerVariables("HTTP_USER_AGENT")
'end if
'Response.Write("
")
'find operating system
if (eregi("win", agent, false)) then
platform = "Windows"
elseif (eregi("mac", agent, false)) then
platform = "Macintosh"
elseif (eregi("linux", agent, false)) then
platform = "Linux"
elseif (eregi("OS/2", agent, false)) then
platform = "OS/2"
elseif (eregi("BeOS", agent, false)) then
platform = "BeOS"
end if
' test for Opera
if (eregi("opera",agent, false)) then
val = stristr(agent, "opera")
if (eregi("/", val, false)) then
val = explode("/",val)
name = val(0)
subval = explode(" ", val(1))
version = subval(0)
else
val = explode(" ",stristr(val,"opera"))
name = val(0)
version = val(1)
end if
' test for WebTV
elseif(eregi("webtv",agent, false)) then
val = explode("/",stristr(agent,"webtv"))
name = val(0)
subval = explode(" ",val(1))
version = subval(0)
' test for MS Internet Explorer version 1
elseif(eregi("microsoft internet explorer", agent, false)) then
name = "MSIE"
version = "1.0"
var = stristr(agent, "/")
if (eregi("308|425|426|474|0b1", var, false)) then
version = "1.5"
end if
' test for NetPositive
elseif(eregi("NetPositive", agent, false)) then
val = explode("/",stristr(agent,"NetPositive"))
platform = "BeOS"
name = val(0)
version = ereg_replace("[();][\w\W]*", "", val(1))
' test for MS Internet Explorer
elseif(eregi("msie",agent, false) and eregi("opera",agent, false)=false) then
val = explode(" ",stristr(agent,"msie"))
name = val(0)
version = val(1)
' test for MS Pocket Internet Explorer
elseif(eregi("mspie",agent, false) or eregi("pocket", agent, false)) then
val = explode(" ",stristr(agent,"mspie"))
name = "MSPIE"
platform = "WindowsCE"
if (eregi("mspie", agent, false)) then
version = val(1)
else
val = explode("/",agent)
version = val(1)
end if
' test for Galeon
elseif(eregi("galeon",agent, false)) then
val = explode(" ",stristr(agent,"galeon"))
subval = explode("/",val(0))
name = subval(0)
version = subval(1)
' test for Konqueror
elseif(eregi("Konqueror",agent, false)) then
val = explode(" ",stristr(agent,"Konqueror"))
subval = explode("/",val(0))
name = subval(0)
version = subval(1)
' test for iCab
elseif(eregi("icab",agent, false)) then
val = explode(" ",stristr(agent,"icab"))
name = val(0)
version = val(1)
' test for OmniWeb
elseif(eregi("omniweb",agent, false)) then
val = explode("/",stristr(agent,"omniweb"))
name = val(0)
version = val(1)
version = ereg_replace("-v[\w\W]*", "", version)
version = ereg_replace(";[\w\W]*", "", version)
' test for Phoenix
elseif(eregi("Phoenix", agent, false)) then
name = "Phoenix"
val = explode("/", stristr(agent,"Phoenix/"))
version = val(1)
' test for Firebird
elseif(eregi("firebird", agent, false)) then
name="Firebird"
val = stristr(agent, "Firebird")
val = explode("/",val)
version = val(1)
' test for Firefox
elseif(eregi("Firefox", agent, false)) then
name="Firefox"
val = stristr(agent, "Firefox")
val = explode("/",val)
version = val(1)
' test for Mozilla Alpha/Beta Versions
elseif(eregi("mozilla",agent, false) and eregi("rv:[0-9].[0-9][a-b]",agent, false) and eregi("netscape",agent, false)=false) then
name = "Mozilla"
'val = explode(" ",stristr(agent,"rv:"))
'val = eregi("rv:[0-9].[0-9][a-b]", agent, true)
Set objRegExpr = New regexp
objRegExpr.Pattern = "rv:[0-9].[0-9][a-b]"
objRegExpr.Global = True
objRegExpr.IgnoreCase = True
Set colMatches = objRegExpr.Execute(agent)
version = str_replace("rv:","",colMatches(0))
' test for Mozilla Stable Versions
elseif(eregi("mozilla",agent, false) and eregi("rv:[0-9]\.[0-9]",agent, false) and eregi("netscape",agent, false)=false) then
name = "Mozilla"
'val = explode(" ",stristr(agent,"rv:"))
'val = eregi("rv:[0-9]\.[0-9]\.[0-9]",agent,true)
'Extrace rv:...
Set objRegExpr = New regexp
objRegExpr.Pattern = "rv:[0-9]\.[0-9]"
objRegExpr.Global = True
objRegExpr.IgnoreCase = True
Set colMatches = objRegExpr.Execute(agent)
version = str_replace("rv:","",colMatches(0))
' test for Lynx & Amaya
elseif(eregi("libwww", agent, false)) then
if (eregi("amaya", agent, false)) then
val = explode("/",stristr(agent,"amaya"))
name = "Amaya"
subval = explode(" ", val(1))
version = subval(0)
else
val = explode("/",agent)
name = "Lynx"
version = val(1)
version = ereg_replace(" [\w\W]*", "", version)
end if
' test for Safari
elseif(eregi("safari", agent, false)) then
name = "Safari"
version = ""
' two tests for Netscape
elseif(eregi("netscape",agent, false)) then
dim netscapeval
netscapeval = Split(stristr(agent,"netscape"), " ") 'explode(" ",stristr(agent,"netscape"))
dim netscapeval2
netscapeval2 = Split(netscapeval(0), "/") 'explode("/",val(0))
name = netscapeval2(0)
version = netscapeval2(1)
elseif(eregi("mozilla",agent, false) and eregi("rv:[0-9]\.[0-9]\.[0-9]",agent, false)=false) then
val = explode(" ",stristr(agent,"mozilla"))
subval = explode("/",val(0))
name = "Netscape"
version = subval(1)
' googlebot
elseif(eregi("googlebot", agent, false)) then
val = explode(" ",stristr(agent,"googlebot"))
subval = explode("/",val(0))
name = subval(0)
version = subval(1)
end if
' clean up extraneous garbage that may be in the name
name = ereg_replace("[^a-z,A-Z]", "", name)
' clean up extraneous garbage that may be in the version
version = ereg_replace("[^0-9,.,a-z,A-Z]", "", version)
' check for AOL
if (eregi("AOL", agent, false)) then
var = stristr(agent, "AOL")
var = explode(" ", var)
aol = ereg_replace("[^0-9,.,a-z,A-Z]", "", var(1))
end if
InfoArray(0) = platform
InfoArray(1) = name
InfoArray(2) = version
InfoArray(3) = aol
getBrowserInfo = InfoArray
End Function
'------------------
If (Request.QueryString("nojs") = "true") Then
'############################
If (Request.QueryString("pnm") <> "") Then
pagename = Request.QueryString("pnm")
Else
pagename = "(No page name specified)"
End If
ip = Request.ServerVariables("REMOTE_ADDR")
trimref = "Bookmark/Entered URL or blocked"
platform = "Unknown"
browser = "Unknown"
language = "Unknown"
country = "Unknown"
javascript = "Disabled"
java = "Unknown"
screenres = "Unknown"
screencolor = "Unknown"
searchengine = "None"
searchquery = "None"
'################################
Else
'################################
ip = Request.ServerVariables("REMOTE_ADDR")
If (Request.QueryString("pnm") <> "") Then
pagename = Request.QueryString("pnm")
Else
pagename = "(No page name specified)"
End If
If (Request.QueryString("ref") <> "") Then
ref = LCase(Request.QueryString("ref"))
if (InStr(ref, "?") <> 0) Then
trimref = Mid(ref, 1, InStr(ref, "?")-1)
End If
Else
ref = "Bookmark/Entered URL or blocked"
End If
If (Request.QueryString("plat") <> "") Then
platform = LCase(Request.QueryString("plat"))
If (platform = "win32") Then
platform = "Windows"
ElseIf (platform = "macppc") Then
platform = "Macintosh"
Else
platform = "Other"
End If
Else
ref = "Other"
End If
If (Request.QueryString("brw") <> "" And Request.QueryString("ver") <> "") Then
browser = LCase(Request.QueryString("brw"))
If (InStr(browser, "msie") <> 0) Then
browser = "Microsoft Internet Explorer "
ElseIf (InStr(browser, "firefox") <> 0) Then
browser = "FireFox "
ElseIf (InStr(browser, "netscape") <> 0) Then
browser = "Netscape "
ElseIf (InStr(browser, "safari") <> 0) Then
browser = "Safari "
ElseIf (InStr(browser, "opera") <> 0) Then
browser = "Opera "
ElseIf (InStr(browser, "konqueror") <> 0) Then
browser = "Konqueror"
ElseIf (InStr(browser, "googlebot") <> 0) Then
browser = "(GoogleBot)"
ElseIf (InStr(browser, "spider") <> 0 Or InStr(browser, "bot") <> 0) Then
browser = "(Spider/Bot)"
ElseIf (InStr(browser, "gecko") <> 0) Then
browser = "Mozilla "
Else
browser = "Other "
End If
If (InStr(Request.QueryString("ver"), " ") <> 0) Then
browser = browser & Mid(Request.QueryString("ver"), 1, InStr(Request.QueryString("ver"), " "))
Else
browser = browser & Request.QueryString("ver")
End If
Else
browser = "Unknown"
End If
If (Request.QueryString("lang") <> "" And Len(Request.QueryString("lang"))=5 And InStr(Request.QueryString("lang"), "-") = 3) Then
language = Left(Request.QueryString("lang"), 2)
country = Right(Request.QueryString("lang"), 2)
'REGEXPS
'\$HTTP_GET_VARS\[\"([^"]*)"]
'case "([^"]{2})":\s*\$([^\s]*) = "([^"]*)";\s*break;
'Elseif ($2 = "$1") Then
'Set $2 = "$3"
If (language = "en") Then
language = "English"
Elseif (language = "zh") Then
language = "Chinese"
Elseif (language = "es") Then
language = "Spanish"
Elseif (language = "de") Then
language = "German"
Elseif (language = "fr") Then
language = "French"
Elseif (language = "af") Then
language = "Afrikaans"
Elseif (language = "sq") Then
language = "Albanian"
Elseif (language = "ar") Then
language = "Arabic"
Elseif (language = "eu") Then
language = "Basque"
Elseif (language = "bg") Then
language = "Bulgarian"
Elseif (language = "be") Then
language = "Belarusian"
Elseif (language = "ca") Then
language = "Catalan"
Elseif (language = "hr") Then
language = "Croatian"
Elseif (language = "cs") Then
language = "Czech"
Elseif (language = "da") Then
language = "Danish"
Elseif (language = "nl") Then
language = "Dutch"
Elseif (language = "et") Then
language = "Estonian"
Elseif (language = "fo") Then
language = "Faeroese"
Elseif (language = "fa") Then
language = "Farsi"
Elseif (language = "fi") Then
language = "Finnish"
Elseif (language = "gd") Then
language = "Gaelic"
Elseif (language = "el") Then
language = "Greek"
Elseif (language = "he") Then
language = "Hebrew"
Elseif (language = "hi") Then
language = "Hindi"
Elseif (language = "hu") Then
language = "Hungarian"
Elseif (language = "is") Then
language = "Icelandic"
Elseif (language = "id") Then
language = "Indonesian"
Elseif (language = "it") Then
language = "Italian"
Elseif (language = "ja") Then
language = "Japanese"
Elseif (language = "ko") Then
language = "Korean"
Elseif (language = "lv") Then
language = "Latvian"
Elseif (language = "lt") Then
language = "Lithuanian"
Elseif (language = "mk") Then
language = "Macedonian"
Elseif (language = "ms") Then
language = "Malaysian"
Elseif (language = "mt") Then
language = "Maltese"
Elseif (language = "no") Then
language = "Norwegian"
Elseif (language = "pl") Then
language = "Polish"
Elseif (language = "pt") Then
language = "Portuguese"
Elseif (language = "rm") Then
language = "Rhaeto-Romanic"
Elseif (language = "ro") Then
language = "Romanian"
Elseif (language = "ru") Then
language = "Russian"
Elseif (language = "sz") Then
language = "Sami"
Elseif (language = "sr") Then
language = "Serbian Cyrillic"
Elseif (language = "sk") Then
language = "Slovak"
Elseif (language = "sl") Then
language = "Slovenian"
Elseif (language = "sb") Then
language = "Sorbian"
Elseif (language = "sx") Then
language = "Sutu"
Elseif (language = "sv") Then
language = "Swedish"
Elseif (language = "th") Then
language = "Thai"
Elseif (language = "ts") Then
language = "Tsonga"
Elseif (language = "tn") Then
language = "Tswana"
Elseif (language = "tr") Then
language = "Turkish"
Elseif (language = "uk") Then
language = "Ukrainian"
Elseif (language = "ur") Then
language = "Urdu"
Elseif (language = "ve") Then
language = "Venda"
Elseif (language = "vi") Then
language = "Vietnamese"
Elseif (language = "xh") Then
language = "Xhosa"
Elseif (language = "ji") Then
language = "Yiddish"
Elseif (language = "zu") Then
language = "Zulu"
Else
language = "Other"
End If
'---------------------------
If (country = "us") Then
country = "United States"
Elseif (country = "gb") Then
country = "United Kingdom"
Elseif (country = "ca") Then
country = "Canada"
Elseif (country = "de") Then
country = "Germany"
Elseif (country = "sa") Then
country = "Saudi Arabia"
Elseif (country = "be") Then
country = "Belgium"
Elseif (country = "au") Then
country = "Australia"
Elseif (country = "iq") Then
country = "Iraq"
Elseif (country = "eg") Then
country = "Egypt"
Elseif (country = "ly") Then
country = "Libya"
Elseif (country = "dz") Then
country = "Algeria"
Elseif (country = "ma") Then
country = "Morocco"
Elseif (country = "tn") Then
country = "Tunisia"
Elseif (country = "om") Then
country = "Oman"
Elseif (country = "ye") Then
country = "Yemen"
Elseif (country = "sy") Then
country = "Syria"
Elseif (country = "jo") Then
country = "Jordan"
Elseif (country = "lb") Then
country = "Lebanon"
Elseif (country = "kw") Then
country = "Kuwait"
Elseif (country = "ae") Then
country = "United Arab Emirates"
Elseif (country = "bh") Then
country = "Bahrain"
Elseif (country = "qa") Then
country = "Qatar"
Elseif (country = "tw") Then
country = "Taiwan"
Elseif (country = "cn") Then
country = "PRC"
Elseif (country = "hk") Then
country = "Hong Kong SAR"
Elseif (country = "sg") Then
country = "Singapore"
Elseif (country = "nz") Then
country = "New Zealand"
Elseif (country = "ie") Then
country = "Ireland"
Elseif (country = "za") Then
country = "South Africa"
Elseif (country = "jm") Then
country = "Jamaica"
Elseif (country = "bz") Then
country = "Belize"
Elseif (country = "tt") Then
country = "Trinidad"
Elseif (country = "ch") Then
country = "Switzerland"
Elseif (country = "lu") Then
country = "Luxembourg"
Elseif (country = "ie") Then
country = "Ireland"
Elseif (country = "ch") Then
country = "Switzerland"
Elseif (country = "at") Then
country = "Austria"
Elseif (country = "lu") Then
country = "Luxembourg"
Elseif (country = "li") Then
country = "Liechtenstein"
Elseif (country = "ch") Then
country = "Switzerland"
Elseif (country = "br") Then
country = "Brazil"
Elseif (country = "pt") Then
country = "Portugal"
Elseif (country = "mo") Then
country = "Moldavia"
Elseif (country = "mx") Then
country = "Mexico"
Elseif (country = "gt") Then
country = "Guatemala"
Elseif (country = "cr") Then
country = "Costa Rica"
Elseif (country = "pa") Then
country = "Panama"
Elseif (country = "do") Then
country = "Dominican Republic"
Elseif (country = "ve") Then
country = "Venezuela"
Elseif (country = "co") Then
country = "Colombia"
Elseif (country = "pe") Then
country = "Peru"
Elseif (country = "ar") Then
country = "Argentina"
Elseif (country = "ec") Then
country = "Ecuador"
Elseif (country = "cl") Then
country = "Chile"
Elseif (country = "uy") Then
country = "Uruguay"
Elseif (country = "py") Then
country = "Paraguay"
Elseif (country = "bo") Then
country = "Bolivia"
Elseif (country = "sv") Then
country = "El Salvador"
Elseif (country = "hn") Then
country = "Honduras"
Elseif (country = "ni") Then
country = "Nicaragua"
Elseif (country = "pr") Then
country = "Puerto Rico"
Elseif (country = "fi") Then
country = "Finland"
Else
country = "Other"
End If
Else
language = "Unknown"
country = "Unknown"
End If
javascript = "Enabled"
If (Request.QueryString("jav") <> "") Then
If (Request.QueryString("jav") = "true") Then
java = "Enabled"
Else
java = "Disabled"
End If
Else
java = "Unknown"
End If
If (Request.QueryString("scrw") <> "" And Request.QueryString("scrh") <> "") Then
screenres = Request.QueryString("scrw") & " x " & Request.QueryString("scrh")
Else
screenres = "Unknown"
End If
If (Request.QueryString("clr") <> "") Then
screencolor = Request.QueryString("clr") & " bit"
Else
screencolor = "Unknown"
End If
'search engines
'REGEXP
'If \(strpos\(\$ref, "([^"]*)"\)!=false\) Then\s*\$searchengine = "([^"]*)";\s*if \(ereg\("([^=]*)=[^"]*", \$ref, \$regs\)\) \{\s*\$searchquery = \$regs\[1\];\s*\} else \{\s*\$searchquery = "None";\s*\}
'If (InStr(ref, "$1") <> 0) Then
'searchengine = "$2"
'If (InStr(ref, "$3=")) Then
' tempsearchstr = "$3="
' querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
' If (InStr(querystart, ref, "&") <> 0) Then
' searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
' Else
' searchquery = Mid(ref, querystart, 1000000)
' End If
'Else
' searchquery = "None"
'End If
Dim querystart, tempsearchstr
If (InStr(ref, "google.com/search") <> 0) Then
searchengine = "Google"
If (InStr(ref, "q=")) Then
tempsearchstr = "q="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "altavista.com/web") <> 0) Then
searchengine = "AltaVista"
If (InStr(ref, "q=")) Then
tempsearchstr = "q="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "ask.com/web") <> 0) Then
searchengine = "Ask Jeeves"
If (InStr(ref, "q=")) Then
tempsearchstr = "q="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "search.msn.com") <> 0) Then
searchengine = "MSN Search"
If (InStr(ref, "q=")) Then
tempsearchstr = "q="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "alltheweb.com/search") <> 0) Then
searchengine = "AllTheWeb"
If (InStr(ref, "q=")) Then
tempsearchstr = "q="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "s.teoma.com/search") <> 0) Then
searchengine = "Teoma"
If (InStr(ref, "q=")) Then
tempsearchstr = "q="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "search.yahoo.com") <> 0) Then
searchengine = "Yahoo"
If (InStr(ref, "p=")) Then
tempsearchstr = "p="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "search.aol.com") <> 0) Then
searchengine = "AOL Search"
If (InStr(ref, "query=")) Then
tempsearchstr = "query="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "hotbot.com") <> 0) Then
searchengine = "HotBot"
If (InStr(ref, "query=")) Then
tempsearchstr = "query="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "mamma.com/mamma") <> 0) Then
searchengine = "Mamma"
If (InStr(ref, "query=")) Then
tempsearchstr = "query="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "search.netscape.com") <> 0) Then
searchengine = "Netscape Search"
If (InStr(ref, "query=")) Then
tempsearchstr = "query="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "websearch.com") <> 0) Then
searchengine = "WebSearch"
If (InStr(ref, "qkw=")) Then
tempsearchstr = "qkw="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
ElseIf (InStr(ref, "voila.com/s") <> 0) Then
searchengine = "Voila"
If (InStr(ref, "rdata=")) Then
tempsearchstr = "rdata="
querystart = InStr(ref, tempsearchstr) + Len(tempsearchstr)
If (InStr(querystart, ref, "&") <> 0) Then
searchquery = Mid(ref, querystart, (InStr(querystart, ref, "&")-querystart))
Else
searchquery = Mid(ref, querystart, 1000000)
End If
Else
searchquery = "None"
End If
Else
searchengine = "Other/None"
searchquery = "None/Unknown Engine"
End If
searchquery = URLDecode(searchquery)
If (trimref = "") Then
trimref = ref
End If
'##################################
End If
'################ FIX BROWSER AND PLATFORM ###################
Dim br
br = getBrowserInfo
'Response.Write("
" & Request.ServerVariables("HTTP_USER_AGENT") & "
")
'Response.Write("Platform: " & br(0) & "
")
'Response.Write("Browser: " & br(1) & "
")
'Response.Write("Browser Version: " & br(2) & "
")
'Response.Write("AOL: " & br(3) & "
")
platform = br(0)
browser = br(1) & " " & br(2)
'########################################
ip = Replace(ip, "'", "''")
trimref = Replace(trimref, "'", "''")
platform = Replace(platform, "'", "''")
browser = Replace(browser, "'", "''")
country = Replace(country, "'", "''")
language = Replace(language, "'", "''")
javascript = Replace(javascript, "'", "''")
java = Replace(java, "'", "''")
screenres = Replace(screenres, "'", "''")
screencolor = Replace(screencolor, "'", "''")
searchengine = Replace(searchengine, "'", "''")
searchquery = Replace(searchquery, "'", "''")
'######################################################
'##################### BEGIN DB #######################
'######################################################
'doQuery("DELETE FROM dwstats_activeip WHERE cPageName='" & pagename & "' AND cDate < #" & Date() & "#")
Command1.CommandText = "DELETE FROM dwstats_activeip WHERE cPageName='" & pagename & "' AND cDate < #" & Date() & "#"
Command1.Execute()
Set isActiveIP = Server.CreateObject("ADODB.Recordset")
isActiveIP.ActiveConnection = Conn
isActiveIP.Source = "SELECT ID FROM dwstats_activeip WHERE cPageName='" & pagename & "' AND cIP='" & ip & "' AND cDate = #" & Date() & "#"
isActiveIP.CursorType = 0
isActiveIP.CursorLocation = 3
isActiveIP.LockType = 1
isActiveIP.Open()
Dim isNew
If (isActiveIP.RecordCount = 0) Then
isNew = True
doQuery("INSERT INTO dwstats_activeip (cPageName, cDate, cIP) VALUES ('" & pagename & "', #" & Date() & "#, '" & ip & "')")
'Response.Write("insert activeip")
Else
isNew = False
End If
isActiveIP.Close()
Set isActiveIP = Nothing
Set dateHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
dateHasBeenRecorded.ActiveConnection = Conn
dateHasBeenRecorded.Source = "SELECT ID FROM dwstats_visitors WHERE cPageName='" & pagename & "' AND cDate=#" & Date() & "#"
dateHasBeenRecorded.CursorType = 0
dateHasBeenRecorded.CursorLocation = 3
dateHasBeenRecorded.LockType = 1
dateHasBeenRecorded.Open()
If (dateHasBeenRecorded.RecordCount <> 0) Then
If (isNew = true) Then
'update visitor & hit
doQuery("UPDATE dwstats_visitors SET cVisitors=cVisitors+1, cHits=cHits+1 WHERE cPageName='" & pagename & "' AND cDate=#" & Date() & "#")
Else
'just update hit
doQuery("UPDATE dwstats_visitors SET cHits=cHits+1 WHERE cPageName='" & pagename & "' AND cDate=#" & Date() & "#")
End If
Else
doQuery("INSERT INTO dwstats_visitors (cPageName, cDate, cVisitors, cHits) VALUES ('" & pagename & "', #" & Date() & "#, 1, 1)")
End If
dateHasBeenRecorded.Close()
Set dateHasBeenRecorded = Nothing
Set refHasBeenRecorded2 = Server.CreateObject("ADODB.Recordset")
refHasBeenRecorded2.ActiveConnection = Conn
refHasBeenRecorded2.Source = "SELECT ID FROM dwstats_ref WHERE cPageName='" & pagename & "' AND cRef='" & trimref & "'"
refHasBeenRecorded2.CursorType = 0
refHasBeenRecorded2.CursorLocation = 3
refHasBeenRecorded2.LockType = 1
refHasBeenRecorded2.Open()
If (refHasBeenRecorded2.RecordCount <> 0) Then
doQuery("UPDATE dwstats_ref SET cRefCount=cRefCount+1 WHERE cPageName='" & pagename & "' AND cRef='" & trimref & "'")
Else
doQuery("INSERT INTO dwstats_ref (cPageName, cRef, cRefCount) VALUES ('" & pagename & "', '" & trimref & "', 1)")
End If
refHasBeenRecorded2.Close()
Set refHasBeenRecorded2 = Nothing
Set refHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
refHasBeenRecorded.ActiveConnection = Conn
refHasBeenRecorded.Source = "SELECT ID FROM dwstats_ref WHERE cPageName='" & pagename & "' ORDER BY cRefCount ASC"
refHasBeenRecorded.CursorType = 0
refHasBeenRecorded.CursorLocation = 3
refHasBeenRecorded.LockType = 1
refHasBeenRecorded.Open()
Dim maxrefcount, i
maxrefcount = 500
If (refHasBeenRecorded.RecordCount > maxrefcount) Then
For i=1 To (refHasBeenRecorded.RecordCount-maxrefcount)
doQuery("DELETE FROM dwstats_ref WHERE ID=" & refHasBeenRecorded("ID"))
refHasBeenRecorded.MoveNext
Next
End If
refHasBeenRecorded.Close()
Set refHasBeenRecorded = Nothing
'--------------------------------------------
If (IsNew = True) Then
Set osHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
osHasBeenRecorded.ActiveConnection = Conn
osHasBeenRecorded.Source = "SELECT ID FROM dwstats_os WHERE cPageName='" & pagename & "' AND cOs='" & platform & "'"
osHasBeenRecorded.CursorType = 0
osHasBeenRecorded.CursorLocation = 3
osHasBeenRecorded.LockType = 1
osHasBeenRecorded.Open()
If (osHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE dwstats_os SET cOSCount=cOSCount+1 WHERE cPageName='" & pagename & "' AND cOS='" & platform & "'")
Else
doQuery("INSERT INTO dwstats_os (cPageName, cOS, cOSCount) VALUES ('" & pagename & "', '" & platform & "', 1)")
End If
osHasBeenRecorded.Close()
Set osHasBeenRecorded = Nothing
End If
'--------------------------------------------
Dim updateVal, updateTbl, updateCol
If (IsNew = True) Then
'### BROWSER ###
updateVal = browser
updateTbl = "dwstats_browser"
updateCol = "cBrowser"
Set itemHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
itemHasBeenRecorded.ActiveConnection = Conn
itemHasBeenRecorded.Source = "SELECT ID FROM " & updateTbl & " WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'"
itemHasBeenRecorded.CursorType = 0
itemHasBeenRecorded.CursorLocation = 3
itemHasBeenRecorded.LockType = 1
itemHasBeenRecorded.Open()
If (itemHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE " & updateTbl & " SET " & updateCol & "Count=" & updateCol & "Count+1 WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'")
Else
doQuery("INSERT INTO " & updateTbl & " (cPageName, " & updateCol & ", " & updateCol & "Count) VALUES ('" & pagename & "', '" & updateVal & "', 1)")
End If
itemHasBeenRecorded.Close()
Set itemHasBeenRecorded = Nothing
End If
'--------------------------------------------
If (IsNew = True) Then
'### COUNTRY ###
updateVal = country
updateTbl = "dwstats_country"
updateCol = "cCountry"
Set itemHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
itemHasBeenRecorded.ActiveConnection = Conn
itemHasBeenRecorded.Source = "SELECT ID FROM " & updateTbl & " WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'"
itemHasBeenRecorded.CursorType = 0
itemHasBeenRecorded.CursorLocation = 3
itemHasBeenRecorded.LockType = 1
itemHasBeenRecorded.Open()
If (itemHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE " & updateTbl & " SET " & updateCol & "Count=" & updateCol & "Count+1 WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'")
Else
doQuery("INSERT INTO " & updateTbl & " (cPageName, " & updateCol & ", " & updateCol & "Count) VALUES ('" & pagename & "', '" & updateVal & "', 1)")
End If
itemHasBeenRecorded.Close()
Set itemHasBeenRecorded = Nothing
End If
'--------------------------------------------
If (IsNew = True) Then
'### LANGUAGE ###
updateVal = language
updateTbl = "dwstats_language"
updateCol = "cLanguage"
Set itemHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
itemHasBeenRecorded.ActiveConnection = Conn
itemHasBeenRecorded.Source = "SELECT ID FROM " & updateTbl & " WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'"
itemHasBeenRecorded.CursorType = 0
itemHasBeenRecorded.CursorLocation = 3
itemHasBeenRecorded.LockType = 1
itemHasBeenRecorded.Open()
If (itemHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE " & updateTbl & " SET " & updateCol & "Count=" & updateCol & "Count+1 WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'")
Else
doQuery("INSERT INTO " & updateTbl & " (cPageName, " & updateCol & ", " & updateCol & "Count) VALUES ('" & pagename & "', '" & updateVal & "', 1)")
End If
itemHasBeenRecorded.Close()
Set itemHasBeenRecorded = Nothing
End If
'--------------------------------------------
If (IsNew = True) Then
'### Javascript ###
updateVal = javascript
updateTbl = "dwstats_javascript"
updateCol = "cJavascript"
Set itemHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
itemHasBeenRecorded.ActiveConnection = Conn
itemHasBeenRecorded.Source = "SELECT ID FROM " & updateTbl & " WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'"
itemHasBeenRecorded.CursorType = 0
itemHasBeenRecorded.CursorLocation = 3
itemHasBeenRecorded.LockType = 1
itemHasBeenRecorded.Open()
If (itemHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE " & updateTbl & " SET " & updateCol & "Count=" & updateCol & "Count+1 WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'")
Else
doQuery("INSERT INTO " & updateTbl & " (cPageName, " & updateCol & ", " & updateCol & "Count) VALUES ('" & pagename & "', '" & updateVal & "', 1)")
End If
itemHasBeenRecorded.Close()
Set itemHasBeenRecorded = Nothing
End If
'--------------------------------------------
If (IsNew = True) Then
'### Java ###
updateVal = java
updateTbl = "dwstats_java"
updateCol = "cJava"
Set itemHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
itemHasBeenRecorded.ActiveConnection = Conn
itemHasBeenRecorded.Source = "SELECT ID FROM " & updateTbl & " WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'"
itemHasBeenRecorded.CursorType = 0
itemHasBeenRecorded.CursorLocation = 3
itemHasBeenRecorded.LockType = 1
itemHasBeenRecorded.Open()
If (itemHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE " & updateTbl & " SET " & updateCol & "Count=" & updateCol & "Count+1 WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'")
Else
doQuery("INSERT INTO " & updateTbl & " (cPageName, " & updateCol & ", " & updateCol & "Count) VALUES ('" & pagename & "', '" & updateVal & "', 1)")
End If
itemHasBeenRecorded.Close()
Set itemHasBeenRecorded = Nothing
End If
'--------------------------------------------
If (IsNew = True) Then
'### ScreenRes ###
updateVal = screenres
updateTbl = "dwstats_screenres"
updateCol = "cScreenRes"
Set itemHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
itemHasBeenRecorded.ActiveConnection = Conn
itemHasBeenRecorded.Source = "SELECT ID FROM " & updateTbl & " WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'"
itemHasBeenRecorded.CursorType = 0
itemHasBeenRecorded.CursorLocation = 3
itemHasBeenRecorded.LockType = 1
itemHasBeenRecorded.Open()
If (itemHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE " & updateTbl & " SET " & updateCol & "Count=" & updateCol & "Count+1 WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'")
Else
doQuery("INSERT INTO " & updateTbl & " (cPageName, " & updateCol & ", " & updateCol & "Count) VALUES ('" & pagename & "', '" & updateVal & "', 1)")
End If
itemHasBeenRecorded.Close()
Set itemHasBeenRecorded = Nothing
End If
'--------------------------------------------
If (IsNew = True) Then
'### ScreenColor ###
updateVal = screencolor
updateTbl = "dwstats_screencolor"
updateCol = "cScreenColor"
Set itemHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
itemHasBeenRecorded.ActiveConnection = Conn
itemHasBeenRecorded.Source = "SELECT ID FROM " & updateTbl & " WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'"
itemHasBeenRecorded.CursorType = 0
itemHasBeenRecorded.CursorLocation = 3
itemHasBeenRecorded.LockType = 1
itemHasBeenRecorded.Open()
If (itemHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE " & updateTbl & " SET " & updateCol & "Count=" & updateCol & "Count+1 WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'")
Else
doQuery("INSERT INTO " & updateTbl & " (cPageName, " & updateCol & ", " & updateCol & "Count) VALUES ('" & pagename & "', '" & updateVal & "', 1)")
End If
itemHasBeenRecorded.Close()
Set itemHasBeenRecorded = Nothing
End If
'--------------------------------------------
'### SearchEngine ###
updateVal = searchengine
updateTbl = "dwstats_searchengine"
updateCol = "cSearchEngine"
Set itemHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
itemHasBeenRecorded.ActiveConnection = Conn
itemHasBeenRecorded.Source = "SELECT ID FROM " & updateTbl & " WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'"
itemHasBeenRecorded.CursorType = 0
itemHasBeenRecorded.CursorLocation = 3
itemHasBeenRecorded.LockType = 1
itemHasBeenRecorded.Open()
If (itemHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE " & updateTbl & " SET " & updateCol & "Count=" & updateCol & "Count+1 WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'")
Else
doQuery("INSERT INTO " & updateTbl & " (cPageName, " & updateCol & ", " & updateCol & "Count) VALUES ('" & pagename & "', '" & updateVal & "', 1)")
End If
itemHasBeenRecorded.Close()
Set itemHasBeenRecorded = Nothing
'--------------------------------------------
'### SearchQuery ###
updateVal = searchquery
updateTbl = "dwstats_searchquery"
updateCol = "cSearchQuery"
Set itemHasBeenRecorded = Server.CreateObject("ADODB.Recordset")
itemHasBeenRecorded.ActiveConnection = Conn
itemHasBeenRecorded.Source = "SELECT ID FROM " & updateTbl & " WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'"
itemHasBeenRecorded.CursorType = 0
itemHasBeenRecorded.CursorLocation = 3
itemHasBeenRecorded.LockType = 1
itemHasBeenRecorded.Open()
If (itemHasBeenRecorded.RecordCount <> 0) Then
doQuery("UPDATE " & updateTbl & " SET " & updateCol & "Count=" & updateCol & "Count+1 WHERE cPageName='" & pagename & "' AND " & updateCol & "='" & updateVal & "'")
Else
doQuery("INSERT INTO " & updateTbl & " (cPageName, " & updateCol & ", " & updateCol & "Count) VALUES ('" & pagename & "', '" & updateVal & "', 1)")
End If
itemHasBeenRecorded.Close()
Set itemHasBeenRecorded = Nothing
Set searchQueryCount = Server.CreateObject("ADODB.Recordset")
searchQueryCount.ActiveConnection = Conn
searchQueryCount.Source = "SELECT ID FROM dwstats_searchquery WHERE cPageName='" & pagename & "' ORDER BY cSearchQueryCount ASC"
searchQueryCount.CursorType = 0
searchQueryCount.CursorLocation = 3
searchQueryCount.LockType = 1
searchQueryCount.Open()
maxrefcount = 500
If (searchQueryCount.RecordCount > maxrefcount) Then
For i=1 To searchQueryCount.RecordCount-maxrefcount
doQuery("DELETE FROM dwstats_searchquery WHERE ID=" & searchQueryCount("ID"))
searchQueryCount.MoveNext
Next
End If
searchQueryCount.Close()
Set searchQueryCount = Nothing
'----------------------------------------------
'Response.Write("ip = " & ip & "
")
'Response.Write("trimref = " & trimref & "
")
'Response.Write("platform = " & platform & "
")
'Response.Write("browser = " & browser & "
")
'Response.Write("country = " & country & "
")
'Response.Write("language = " & language & "
")
'Response.Write("javascript = " & javascript & "
")
'Response.Write("java = " & java & "
")
'Response.Write("screenres = " & screenres & "
")
'Response.Write("screencolor = " & screencolor & "
")
'Response.Write("searchengine = " & searchengine & "
")
'Response.Write("searchquery = " & searchquery & "
")
'INSERT INTO dwstats_stats (pagename, date, ip, ref, os, browser, country, language, javascript, java, screenres, screencolor, searchengine, searchquery)
'VALUES ('".$pagename."',
'NOW(),
'".$ip."',
'".$trimref."',
'".$platform."',
'".$browser."',
'".$country."',
'".$language."',
'".$javascript."',
'".$java."',
'".$screenres."',
'".$screencolor."',
'".$searchengine."',
'".$searchquery."'
')
%>