spam_history table
If checked, then Tcl evaluator will be run at the time the message is actually sent on message subject and body, substituting variables or procedure calls wherever \$ and \[\] chars are found. This is specially useful for creating automatically generated templates, such as a daily report which runs a tcl procedure to query the database or create some other summary message.
Note: if you have the Template? option selected, make sure you use backslash to quote any $ or '[]' characters in your message, if you do not want them to undergo evaluation by the Tcl parser.
The following variables are guaranteed to be set in the environment, for use by your template.
db2 a database handle for any subqueries you want to make
user_id the user_id of the current target user
email the email address of the current target user
first_names
last_name
The param is an association-list, with SQL patterns on the left, and
pseudo-mime types on the right. Supported types right now are text/html,
text/html, and text/aol-html.
EmailTypes={%@hotmail.com text/html} {%@aol.com text/aol-html}
Below is an example of the periodic spam admin form, showing the options for configuring periodic messages which get their content from named files the drop-zone directory:
Daily Spam File LocationsYour Workspace : Admin Home : Spam : List Daily Spam FilesSpam files to look for in drop-zone directory "/web/arsdigita/spam/". To delete an entry, just enter an empty string for the filename and subject, and press the Modify button. 'From address' is optional; if left blank, the default spam system from-address will be used. |
You can enter the following information for an automatic spam daily message:
template? option is
selected, then the named file will be used as a Tcl template.
If you are supplying
"static" content by uploading new files to the dropzone with the date conventions described
in the next section, then leave the default setting of Daily for the period.
DailySpamDirectory:
Example:
DailySpamDirectory=/web/eplay/spamFor each spam defined in the Daily Spam list, the system will look for the following files:
file_prefix-MM-DD-YYYY file_prefixNote: Be sure to always use two-digits for Month and Day fields, i.e., 03-06-1999. Don't forget the leading zeros.
If a file whose name matches with the specified prefix and the current day's date is found, the contents are queued up to be sent as spam to the designated target user class.
The spam system will only send a dated spam once. It keeps a history of all spams sent, and will be robust across server restarts. If the server is restarted in the middle of sending a spam, the spam daemon will resume sending where it left off in the list of users.
select user_id from users where trunc(registration_date)=trunc(sysdate-1)which is carefully constructed to always select a mutually exclusive set of users each day, and never repeat the same user twice.
file_prefix-html-MM-DD-YYYY file_prefix-aol-MM-DD-YYYYThen content from these files will be sent preferentially to users who have their email types preferences set in the database.
# insert a new spam message into the spam queue, returns the spam_id of the new message
spam_post_new_spam_message {{
-db 0
-template_p "f"
-from_address ""
-title ""
-body_plain ""
-body_html ""
-body_aol ""
-target_users_description ""
-target_users_query ""
-send_date "sysdate"
-creation_user ""
}}
The target_users_description should be an English description of
who the designated target users are, for administrative documentation purposes.
The target_users_query should be a SQL query which returns the user_id
for each user you want to send email to. Example
select user_id from users where last_name = 'Kennedy'
user_id.
The spam system will automatically join this with the users_spammable view,
which is a view that filters out users who have elected not to receive
email from the system.
So don't worry about pre-filtering your query via the users_spammable view. Just
supply SQL which coughs up a list of user_ids.
A simple plain text spam to members of a specific user_group:select u.user_id from users u, user_group_map ugm where ugm.group_id = 12345 and ugm.user_id = u.user_idA query which gets all users with an email address at aol.com.
select user_id from users where email like '%@aol.com'
[ns/server/yourserver/acs/spam]
; Pairs of {email_addr_pattern pseudo-mime-type}
EmailTypes={%@hotmail.com text/html} {%@aol.com text/aol-html}
DailySpamDirectory=/web/yourserver/spam
SpamRobotFromAddress=email-robot@yourdomain.com
For more info on the configuration of bulkmail and qmail, see bulkmail and qmail configuration
send_email_attachment_from_file allows you to send a file via ns_sendmail as a MIME encoded email attachment. The file
can have binary content such as a JPEG image or PDF document.