<%@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("
 Use Default

") '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."' ') %>