<% ' Start of Code ' Form Fields Names 'Required ' "FORMGOTOPAGE" ' "FORMEMAILTO" 'Optional ' "FORMREQUESTOR" ' "NAME" ' "FIRST" ' "LAST" ' "EMAIL" ' "PHONE" ' "COMPANY" ' "ADDRESS1" ' "ADDRESS2" ' "CITY" ' "STATE" ' "ZIP" ' "COMMENT" ' Server Variables Captured ' XHTTP_REFERER (from pager) ' XREMOTE_ADDR (user ip address) ' XREMOTE_HOST (user ip host) ' XHTTP_USER_AGENT (user browser) ' XSERVER_NAME (website name) dim HTMLBodyX,HTMLBodyX2,HTMLBodyX3,xSubject,xh,XBODY,XFORMSTRING dim XHTTP_REFERER,XREMOTE_ADDR,XREMOTE_HOST,XHTTP_USER_AGENT,XSERVER_NAME dim xname,xfirst,xlast,xcompany,xaddress1,xaddress2,xcity,xstate,xzip,xemail,xcomment,xphone,xformrequestor,xFORMGOTOPAGE,XFORMEMAILTO for each x in Request.Querystring XFORMSTRING = XFORMSTRING & trim(x) & trim((Request.Querystring(x))) & "~" if ucase(trim(x)) = "FORMEMAILTO" then xFORMEMAILTO = trim((Request.Querystring(x))) end if HTMLBody = HTMLBody & "" & trim(x) & "" HTMLBody = HTMLBody & trim((Request.Querystring(x))) HTMLBody = HTMLBody & "" & vbCrLf if ucase(trim(x)) = "FORMREQUESTOR" then xFORMREQUESTOR = trim((Request.Querystring(x))) xh =xh & "" & "FORMREQUESTOR" & "" & _ xFORMREQUESTOR & "" & vbCrLf elseif ucase(trim(x)) = "NAME" then xname = trim((Request.Querystring(x))) xh = xh & "" & "NAME" & "" & _ xname & "" & vbCrLf elseif ucase(trim(x)) = "FIRST" then xFIRST = trim((Request.Querystring(x))) xh = xh & "" & "FIRST" & "" & _ xFIRST & "" & vbCrLf elseif ucase(trim(x)) = "LAST" then xLAST = trim((Request.Querystring(x))) xh = xh & "" & "LAST" & "" & _ xLAST & "" & vbCrLf elseif ucase(trim(x)) = "EMAIL" then xemail = trim((Request.Querystring(x))) xh = xh & "" & "EMAIL" & "" & _ xEMAIL & "" & vbCrLf elseif ucase(trim(x)) = "PHONE" then xPHONE = trim((Request.Querystring(x))) xh = xh & "" & "PHONE" & "" & _ xPHONE & "" & vbCrLf elseif ucase(trim(x)) = "COMPANY" then xCOMPANY = trim((Request.Querystring(x))) xh = xh & "" & "COMPANY" & "" & _ xCOMPANY & "" & vbCrLf elseif ucase(trim(x)) = "ADDRESS1" then xADDRESS1 = trim((Request.Querystring(x))) xh = xh & "" & "ADDRESS1" & "" & _ xADDRESS1 & "" & vbCrLf elseif ucase(trim(x)) = "ADDRESS2" then xADDRESS2 = trim((Request.Querystring(x))) xh = xh & "" & "ADDRESS2" & "" & _ xADDRESS2 & "" & vbCrLf elseif ucase(trim(x)) = "CITY" then xCITY = trim((Request.Querystring(x))) xh = xh & "" & "CITY" & "" & _ xCITY & "" & vbCrLf elseif ucase(trim(x)) = "STATE" then xSTATE = trim((Request.Querystring(x))) xh = xh & "" & "STATE" & "" & _ xSTATE & "" & vbCrLf elseif ucase(trim(x)) = "ZIP" then xZIP = trim((Request.Querystring(x))) xh = xh & "" & "ZIP" & "" & _ xZIP & "" & vbCrLf elseif ucase(trim(x)) = "COMMENT" then xCOMMENT = trim((Request.Querystring(x))) xh = xh & "" & "COMMENT" & "" & _ xCOMMENT & "" & vbCrLf elseif ucase(trim(x)) = "FORMGOTOPAGE" then xFORMGOTOPAGE = trim((Request.Querystring(x))) xh = xh & "" & "FORMGOTOPAGE" & "" & _ xFORMGOTOPAGE & "" & vbCrLf End If next XHTTP_REFERER = (Request.ServerVariables("HTTP_REFERER")) XREMOTE_ADDR = (Request.ServerVariables("REMOTE_ADDR")) XREMOTE_HOST = (Request.ServerVariables("REMOTE_HOST")) XHTTP_USER_AGENT =(Request.ServerVariables("HTTP_USER_AGENT")) XSERVER_NAME =(Request.ServerVariables("SERVER_NAME")) HTMLBody3 = HTMLBody3 & "" & "HTTP_REFERER (From Page)" & "" & xHTTP_REFERER & "" & vbCrLf HTMLBody3 = HTMLBody3 & "" & "REMOTE_ADDR (User IP Address)" & "" & xREMOTE_ADDR & "" & vbCrLf HTMLBody3 = HTMLBody3 & "" & "REMOTE_HOST (User IP Host)" & "" & xREMOTE_HOST & "" & vbCrLf HTMLBody3 = HTMLBody3 & "" & "HTTP_USER_AGENT (User Browser)" & "" & xHTTP_USER_AGENT & "" & vbCrLf HTMLBody3 = HTMLBody3 & "" & "SERVER_NAME (Website name)" & "" & xSERVER_NAME & "" & vbCrLf HTMLBody2 = "" & "" _ & xh & "" _ & HTMLBody3 & "" & HTMLBody HTMLBody2 = HTMLBody2 & "
Parsed Fields Stored in Database
Server Fields
All Form Fields
" HTMLBody2 = HTMLBody2 & "" xSubject = "A Web User On " & xSERVER_NAME & " made a request from IP " & xREMOTE_ADDR XBODY = HTMLBody2 Set objEmail = CreateObject("CDO.Message") objEmail.From ="donald@fulltech.net" objEmail.To = XFORMEMAILTO 'objEmail.Bcc ="donald@fulltech.net" objEmail.Subject = xSubject 'objEmail.Textbody = HTMLBody2 objEmail.HTMLBody = HTMLBody2 objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "90.0.1.101" 'objEmail.Configuration.Fields.Item _ ' ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 'objEmail.Configuration.Fields.Item _ ' ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 2 objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendusername") = "donald@fulltech.net" 'objEmail.Configuration.Fields.Item _ ' ("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = false objEmail.Configuration.Fields.Item _ ("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "donald" objEmail.Configuration.Fields.Update ' objemail.AddAttachment "C:\" & Trim(objRecordset.Fields.Item("Key")) & "FaxCover.DOC" ' For Each FileName In a ' if FileName <> "zxzxzx" then ' objemail.AddAttachment FileName ' end if ' Next objEmail.Send Set objEmail = Nothing ' Connect to a MS SQL Server database with OLE DB: Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "Provider=SQLOLEDB; Data Source=90.0.1.10; Initial Catalog=WEBGLOBAL; User ID=administrator; Password=admin" strSQL = "INSERT into WEBREQUEST (xname, xfirst, xlast, xcompany, xaddress1, xaddress2, xcity, xstate, xzip, xemail, xphone, xcomment," _ & "xformrequestor, xFORMGOTOPAGE, XHTTP_REFERER, XREMOTE_ADDR,XREMOTE_HOST, XHTTP_USER_AGENT, XSERVER_NAME, XSUBJECT, XBODY, XFORMEMAILTO, XFORMSTRING) VALUES ('" _ & SQLFixup(xname) & "', '" _ & SQLFixup(xfirst) & "', '" _ & SQLFixup(xlast) & "', '" _ & SQLFixup(xcompany) & "', '" _ & SQLFixup(xaddress1) & "', '" _ & SQLFixup(xaddress2) & "', '" _ & SQLFixup(xcity) & "', '" _ & SQLFixup(xstate) & "', '" _ & SQLFixup(xzip) & "', '" _ & SQLFixup(xemail) & "', '" _ & SQLFixup(xphone) & "', '" _ & SQLFixup(xcomment) & "', '" _ & SQLFixup(xformrequestor) & "', '" _ & SQLFixup(xFORMGOTOPAGE) & "', '" _ & SQLFixup(XHTTP_REFERER) & "', '" _ & SQLFixup(XREMOTE_ADDR) & "', '" _ & SQLFixup(XREMOTE_HOST) & "', '" _ & SQLFixup(XHTTP_USER_AGENT) & "', '" _ & SQLFixup(XSERVER_NAME) & "', '" _ & SQLFixup(XSUBJECT) & "', '" _ & SQLFixup(XBODY) & "', '" _ & SQLFixup(XFORMEMAILTO) & "', '" _ & SQLFixup(XFORMSTRING) & "')" objConn.Execute (strSQL) objConn.Close Set objConn = Nothing Response.Redirect Request.Querystring("FORMGOTOPAGE") Function SQLFixup(TextIn) SQLFixup = Replace(TextIn, "'", "''") End Function ' SQL Fixup Functions 'Function ReplaceStr (TextIn, ByVal SearchStr As String, _ ' ByVal Replacement As String, _ ' ByVal CompMode As Integer) ' Dim WorkText As String, Pointer As Integer ' If IsNull(TextIn) Then ' ReplaceStr = Null ' Else ' WorkText = TextIn ' Pointer = InStr(1, WorkText, SearchStr, CompMode) ' Do While Pointer > 0 ' WorkText = Left(WorkText, Pointer - 1) & Replacement & _ ' Mid(WorkText, Pointer + Len(SearchStr)) ' Pointer = InStr(Pointer + Len(Replacement), WorkText, _ ' SearchStr, CompMode) ' Loop ' ReplaceStr = WorkText ' End If ' End Function ' ' ' Function JetSQLFixup(TextIn) ' Dim Temp ' Temp = ReplaceStr(TextIn, "'", "''", 0) ' JetSQLFixup = ReplaceStr(Temp, "|", "' & chr(124) & '", 0) ' End Function ' Function FindFirstFixup(TextIn) ' Dim Temp ' Temp = ReplaceStr(TextIn, "'", "' & chr(39) & '", 0) ' FindFirstFixup = ReplaceStr(Temp, "|", "' & chr(124) & '", 0) ' End Function ' ' name2 = Request.Querystring("NAME") cant get this to work with post ' for each x in Request.ServerVariables ' HTMLBody = HTMLBody & "" & x & "" ' HTMLBody = HTMLBody & (Request.ServerVariables(x)) ' HTMLBody = HTMLBody & "" & vbCrLf ' next 'strSQL = "UPDATE WEBREQUEST " & _ ' " SET PINNO = " & CheckString(strCompanyName, ",") & _ ' " ContactName = " & CheckString(strContactName, ",") & _ ' " ContactTitle = " & CheckString(strContactTitle, ",") & _ ' " Address = " & CheckString(strAddress, ",") & _ ' " City = " & CheckString(strCity, ",") & _ ' " Region = " & CheckString(strRegion, ",") & _ ' " PostalCode = " & CheckString(strPostalCode, ",") & _ ' " Country = " & CheckString(strCountry, ",") & _ ' " Phone = " & CheckString(strPhone, ",") & _ ' " Fax = " & CheckString(strFax, " ") & _ ' " WHERE CustomerId = '" & strID & "' " ' Dim dcndb 'ADODB.connection ' Dim strDatabaseLocation ' Dim rscat 'ADODB.Recordset ' Dim strSQL ' strDatabaseLocation = _ ' "D:\INETPUB\ALACAR~1\ALCLOGIN.MDB" ' Set dbcDB = Server.CreateObject("ADODB.Connection") ' dcnDB.ConnectionString = _ ' "Provider=Microsoft.Jet.OLEDB.3.51;" _ ' & "Persist Security Info=False;Data Source=" _ ' & strDatabaseLocation ' dcnDB.Open ' ' UPDATE #application.suppressionTableName# ' %>