You'll need to add a "require" statement for the nph-mail.cgi script (you may have to rename it to .pl -- I'm not sure about this kind of stuff).
Add a new "admin-only" link:
<a href="$db_script_link_url&mailer=1">Mailer</a>
In db.cgi, sub main, add a new command:
elsif ($in{'mailer'}) { if ($per_admin) { &mail_form; } else { &html_unauth; } }
In nph-email.cfg, take out the check password lines.
Then do a routine to determine the date that you want to start checking for. If you need some help with that, there's info here on the forum, or I can help you out.
You'll want to end up with a variable like $in{'Date-gt'} = [the day before you want to start looking];
Then get the record information:
my ($status, @hits) = &query("view");
You'll probably want to do some error-checking to be sure that you got results.
(One thing. I think there's a bug in the db.cgi script. Look in sub query for
if ($in{"$column-gt"} !~ /^\s*$/) { ($db_sort{$column} eq 'date') and (&date_to_unix($in{$column
-gt}) or return "Invalid date format: '$in{$column}'");
push(@search_gt_fields, $i); }
if ($in{"$column-lt"} !~ /^\s*$/) { ($db_sort{$column} eq 'date') and (&date_to_unix($in{$column
-lt}) or return "Invalid date format: '$in{$column}'");
push(@search_lt_fields, $i);
}
and make the changes I've indicated in bold.
Next you'll need to have a routine to format your records for the mailing. It will be much like the routiine in html_view_success:
for (0 .. $numhits - 1) {
[etc]
but as you go through the records, build up the text in a variable. For our purposes here, I'll call it $new_records.
Finally, you insert the information into the textarea--
<textarea name=body cols=60 rows=40>$new_records</textarea>
I hope this was clear. Please don't hesitate to ask if you don't understand.
------------------
JPD
