<% Dim objConn, objConnAdmin, strDBPath, strAdminDBPath, strDomain, smtpServer, mailObj, cdoMessage, cdoConfig, addrList Dim fromAddr, mailComp, strSiteTitle, strFooter, rsNews, recipients, strCount, strEmailMsg, subject, strEmail, rsNAdmin Dim rsAdmin, strSQL, strNwnm, strNwpwd, strCKSDPWD, strHFooter, strTFooter, MM_authorizedUsers, MM_authFailedURL Dim MM_grantAccess, MM_Cookies, MM_qsChar, MM_referrer, Addrss, Addr, msg, strConfirm, strDir, MM_LoginAction, rsAdd Dim MM_valUsername, MM_fldUserAuthorization, MM_redirectLoginSuccess, MM_redirectLoginFailed, MM_flag, MM_rsUser, strASPUpload Dim strSplitEmail, strItem, strFolder, strSaveFile, Upload, FName, objFSO, UploadProgress, PID, barref, File, strAConnString Dim strPathInfo, objFolder, objFolderContents, Bgcolor, counter, intCounter, objFileItem, strVersion, strConnString 'Change to the title of your site IE: HTMLJunction strSiteTitle = "Outclick Media" 'The address to your website WITHOUT "http://" strDomain = "dev96.scandirectory.com" 'Your mail server smtpServer = "mail.scandirectory.com" 'your email address on the mail server fromAddr = "support@scandirectory.com" 'Select your email component mailComp = "CDOSYS" 'mailComp = "CDONTS" 'mailComp = "JMail" 'mailComp = "ASPMail" 'mailComp = "AspEmail" ' Do you have ASPUpload installed for the Image feature? ' change this to "yes" or "no" - default is "no" strASPUpload = "no" ' folder where the script is - default is "/newsletter/" ' change this if you rename the "newsletter" folder and/or put it in another folder. strDir = "/newsletter/" ' one more time but with the slash reversed *NOTE* - no begining slash strFolder = "newsletter\" ' database paths - the path to your databases, must be a "machine" path IE: starts with - X:\ Where X is the drive letter ' where the script is. If you dont know what it is ask you web hosting provider. If you are on a "Unix" server then stop right ' now and delete this script because it will only work on a "Windows" server! strDBPath = "C:\Websites\dev96.scandirectory.com\newsletter\datastores\newsletter.mdb" strAdminDBPath = "C:\Websites\dev96.scandirectory.com\newsletter\datastores\admin.mdb" 'Customize the footer that gets inserted at the bottom of the newsletter - please be careful when editing ' HTML strHFooter = "

If you would like to be removed from this mailing list - Click on the link below." & _ "
Or Copy and Paste to your browsers address bar" & _ "

" & _ "Unsubscribe

" & _ "Thanks
" & strSiteTitle '"

" & _ ' TEXT strTFooter = vbcrlf&vbcrlf& "If you would like to be removed from this mailing list - Click on the link below." & vbcrlf & _ "Or Copy and Paste to your browsers address bar." & vbcrlf & _ "/newsletter/common/process.asp?cancel=now" '"http://"&strDomain&strDir&"common/process.asp?cancel=now" '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''' DO NOT TOUCH ANYTHING BELOW ''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' strVersion = "2_5" strSaveFile = Request.ServerVariables("APPL_PHYSICAL_PATH")&strFolder&"images" strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = "&strDBPath&";User Id=Admin;Password=" strAConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = "&strAdminDBPath&";User Id=Admin;Password=" 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/newsletter/datastores/newsletter.mdb") 'strAConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/newsletter/datastores/admin.mdb") Sub objConnOpen Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open strConnString End Sub Sub objConnClose objConn.Close Set objConn = Nothing End Sub Sub objConnAdminOpen Set objConnAdmin = Server.CreateObject("ADODB.Connection") objConnAdmin.Open strAConnString End Sub Sub objConnAdminClose objConnAdmin.Close Set objConnAdmin = Nothing End Sub Sub Newsletter_1 %>
Newsletter

<% End Sub Sub selectEmailAddy Set rsNews = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM newsLetter WHERE confirm = 'yes';" rsNews.Open strSQL, objConn, 0, 3, &H0001 If Not rsNews.EOF Then Response.Write "" Else Response.Write "" End If rsNews.Close Set rsNews = nothing End Sub Sub htmljunctionnews %> <% End Sub Sub MainContent Set rsNews = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM newsLetter WHERE confirm = 'yes'" rsNews.Open strSQL, objConn, 0, 3, &H0001 strCount = 0 If Not rsNews.EOF Then Do While Not rsNews.EOF recipients = recipients & rsNews("email") & ";" strCount = strCount + 1 rsNews.MoveNext Loop recipients = Left(recipients,Len(recipients)-1) End If rsNews.Close Set rsNews = Nothing %>

There are <%= strCount %> members in your mailing list.



Subject:  
  HTML    TEXT
<% End Sub Sub sendMail 'strEmail = Request.Form("recipients") subject = Request.Form("nwsubject") 'send email so subscriber can confirm strEmailMsg = Request.Form("msg") If Request.Form("version") = "html" Then strEmailMsg = strEmailMsg & strHFooter Else strEmailMsg = strEmailMsg & strTFooter End If Set rsNews = Server.CreateObject("ADODB.Recordset") rsNews.Open "newsLetter", objConn, 0, 3, &H0002 rsNews.Filter = "confirm = 'yes'" If Not rsNews.EOF Then Do While Not rsNews.EOF strEmail = rsNews("email") 'Send email based on mail component. 'Send email (CDONTS version). Note: CDONTS doesn't support a reply-to 'address and has no error checking. If mailComp = "CDONTS" then Set mailObj = Server.CreateObject("CDONTS.NewMail") If Request.Form("version") = "html" Then mailObj.BodyFormat = 0 mailObj.MailFormat = 0 Else mailObj.BodyFormat = 1 End If mailObj.From = fromAddr mailObj.To = strEmail mailObj.Subject = subject mailObj.Body = strEmailMsg mailObj.Send Set mailObj = Nothing End If 'Send email (CDOSYS version). If mailComp = "CDOSYS" Then Set cdoMessage = Server.CreateObject("CDO.Message") Set cdoConfig = Server.CreateObject("CDO.Configuration") cdoConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 cdoConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = smtpServer cdoConfig.Fields.Update Set cdoMessage.Configuration = cdoConfig cdoMessage.From = "" & strSiteTitle & " <" & fromAddr & ">" cdoMessage.To = strEmail cdoMessage.Subject = subject If Request.Form("version") = "html" Then cdoMessage.HtmlBody = strEmailMsg Else cdoMessage.TextBody = strEmailMsg End If On Error Resume Next cdoMessage.Send If Err.Number <> 0 Then Response.Write = "Email send failed: " & Err.Description & "." Set cdoMessage = Nothing Set cdoConfig = Nothing End If 'Send email (JMail version). If mailComp = "JMail" Then set mailObj = Server.CreateObject("JMail.SMTPMail") mailObj.Silent = True mailObj.ServerAddress = smtpServer mailObj.Sender = fromAddr mailObj.SenderName = strSiteTitle mailObj.ReplyTo = fromAddr mailObj.Subject = subject mailObj.AddRecipient strEmail If Request.Form("version") = "html" Then mailObj.ContentType = "text/html" mailObj.Body = strEmailMsg If not mailObj.Execute Then Response.Write = "Email send failed: " & mailObj.ErrorMessage & "." End If 'Send email (ASPMail version). If mailComp = "ASPMail" Then Set mailObj = Server.CreateObject("SMTPsvg.Mailer") mailObj.FromAddress = fromAddr mailObj.FromName = strSiteTitle mailObj.RemoteHost = smtpServer mailObj.ReplyTo = fromAddr mailObj.AddRecipient "", strEmail mailObj.Subject = subject If Request.Form("version") = "html" Then mailObj.ContentType = "text/html" mailObj.BodyText = strEmailMsg If Not mailObj.SendMail Then Response.Write "Email send failed: " & mailObj.Response & "." End If If mailComp = "AspEmail" Then Set mailObj = Server.CreateObject("Persits.MailSender") mailObj.Host = smtpServer mailObj.From = fromAddr mailObj.FromName = strSiteTitle mailObj.AddAddress strEmail mailObj.Subject = subject mailObj.Body = strEmailMsg If Request.Form("version") = "html" Then mailObj.IsHTML = True On Error Resume Next mailObj.Send If Err <> 0 Then Response.Write Err.Description Set mailObj = Nothing End If If Err.Number <> 0 Then Response.Write SendMail rsNews.MoveNext If rsNews.EOF Then Exit Do Loop End If rsNews.Close Set rsNews = Nothing Response.Write "


" & _ "" & _ "Success! Your newsletter has been sent via "&mailComp&"!
" End Sub Sub showNewAdmin %>
Admin Name:
Admin Password:
<% Set rsNAdmin = Server.CreateObject("ADODB.Recordset") rsNAdmin.Open "admin", objConnAdmin, 0, 3, &H0002 If Not rsNAdmin.EOF Then Do While Not rsNADmin.EOF %> <% rsNAdmin.MoveNext Loop End If rsNAdmin.Close Set rsNAdmin = Nothing %>
<%= " "&msg&"

" %> List of Admins
<%= rsNAdmin("name") %> ">Delete
<% End Sub Sub addAdmin strNwnm = Trim(Request.Form("nwnm")) strNwpwd = Trim(Request.Form("nwpwd")) Set rsAdmin = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM admin WHERE name= '"&strNwnm&"'" rsAdmin.Open strSQL, objConnAdmin, 0, 3, &H0001 If Not rsAdmin.EOF Then Response.Write "There is already an Admin with this name: "&rsAdmin("name")&"" Else strSQL = "INSERT INTO admin ([name],[pwd]) VALUES ('"&strNwnm&"','"&strNwpwd&"')" objConnAdmin.Execute strSQL Response.Write ""&strNwnm&" Has been added." End If rsAdmin.Close Set rsAdmin = Nothing End Sub Sub showAdminPwd %>
Login Name: 
Password: 
<% End Sub Sub changePwd Set rsAdmin = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT * FROM admin WHERE pwd = '"&Request.Cookies("Admin")("pwd")&"'" rsAdmin.Open strSQL, objConnAdmin, 3, 3, &H0001 If NOT rsAdmin.EOF Then rsAdmin("name") = Request.Form("cname") rsAdmin("pwd") = Request.Form("cpwd") rsAdmin.Update Response.Cookies("Admin")("name") = rsAdmin("name") Response.Cookies("Admin")("pwd") = rsAdmin("pwd") Response.Redirect "mail.asp" End If rsAdmin.Close Set rsAdmin = Nothing End Sub Sub showDelete %> Select an address/es to delete *WARNING* This cannot be undone...This is your only warning
<% selectEmailAddy %>
<% End Sub Sub deleteAddy strEmail = Trim(Request.Form("email")) strSplitEmail = Split(strEmail,",") For Each strItem in strSplitEmail Response.Write Trim(strItem) strSQL = "DELETE * FROM newsLetter WHERE email = '"&Trim(strItem)&"'" objConn.Execute strSQL Next End Sub Sub showAddress %>
Email Address:
<% End Sub Sub addAddress Set rsAdd = objConn.Execute("SELECT * FROM newsLetter WHERE email = '"&Trim(Request.Form("email"))&"'") If Not rsAdd.EOF Then Response.Write "The Email Address: "&Trim(Request.Form("email"))&" is already in the database!" Else strSQL = "INSERT INTO newsLetter ([email],[Date],[confirm]) Values('"&Trim(Request.Form("email"))&"','"&Date&"','yes')" objConn.Execute strSQL Response.Write "
"&vbcrlf Response.Write " "&vbcrlf Response.Write " You have successfully added "&Trim(Request.Form("email"))&" to the database!"&vbcrlf Response.Write " "&vbcrlf Response.Write "
"&vbcrlf End If rsAdd.Close Set rsAdd = Nothing End Sub Sub showImage %>

<% Set UploadProgress = Server.CreateObject("Persits.UploadProgress") PID = "PID=" & UploadProgress.CreateProgressID() barref = "framebar.asp?to=10&" & PID %> <% Set objFSO = CreateObject("Scripting.FileSystemObject") If Not objFSO.FolderExists(strSaveFile) Then objFSO.CreateFolder(strSaveFile) End If strPathInfo = strSaveFile Set objFolder = objFSO.GetFolder(strPathInfo) Set objFolderContents = objFolder.Files Bgcolor = "#ffffff" counter = 0 intCounter = 0 %>
<% For each objFileItem In objFolderContents If objFileItem.Name <> "Thumbs.db" Then counter = counter + 1 If Bgcolor = "lightblue" Then Bgcolor = "white" Else Bgcolor = "lightblue" End if %> <% End If Next %>
<%= counter %>. <%= objFileItem.Name %> <%= ConvBytes(objFileItem.Size) %>
http://<%= strDomain&strDir %>images/<%= Replace(objFileItem.Name," ","%20") %>


<% Response.Write "" & Request.QueryString("msg") & ""%>

File 1:
File 2:
File 3:
File 4:
File 5:
<% End Sub Function fileExt(s) fileExt = Right(s,Len(s)-(inStrRev(s,"\",-1,1))) End Function Function ConvBytes(TBytes) Dim inSize, isType Const lnBYTE = 1 Const lnKILO = 1024 ' 2^10 Const lnMEGA = 1048576 ' 2^20 Const lnGIGA = 1073741824 ' 2^30 Const lnTERA = 1099511627776 If TBytes < 0 Then Exit Function If TBytes < lnKILO Then ' ByteConversion inSize = TBytes isType = "bytes" Else If TBytes < lnMEGA Then ' KiloByte Conversion inSize = (TBytes / lnKILO) isType = "kb" ElseIf TBytes < lnGIGA Then ' MegaByte Conversion inSize = (TBytes / lnMEGA) isType = "mb" ElseIf TBytes < lnTERA Then ' GigaByte Conversion inSize = (TBytes / lnGIGA) isType = "gb" Else ' TeraByte Conversion inSize = (TBytes / lnTERA) isType = "tb" End If End If ' format number to 2 decimal places inSize = FormatNumber(inSize,2) ' Return the results ConvBytes = inSize & " " & isType End Function %>