UNIX for Dummies Questions & Answers

cd $UPLOAD_DIRECTORY
find . -type f -newer timestamp -name "*.pdf" -print | 
   awk -F- { print $1 } | 
   while read id ; do 
        email_user_by_id $id
   done

touch timestamp

  /usr/sbin/sendmail -t  <<EOF
From: "The system" <otheus@xxxx.com>
To: $email
Subject: Your PDF file was received

blah blah blah
EOF

#!/bin/bash

UPLOAD_DIR="/home/xyz/test"
REPORT_DIR="/home/xyz"
UNAME="xyz"
PASS="xyz"
DB="xyz"
URL="http://www.xyz.com/pdf/"

cd $UPLOAD_DIR

for FILENAME in *.pdf
do
	USER_ID=`echo $FILENAME | cut -d "-" -f1`	
	EMAIL_TO=`echo $(mysql -u $UNAME -p$PASS $DB -e "select email from <tablename> where user_id=$USER_ID") | cut -d " " -f2`
	#echo "Send email to $EMAIL_TO"
	BODY="blah blah blah"
	#echo $BODY
	mv $FILENAME $REPORT_DIR
	/usr/sbin/sendmail -t  <<EOF
	From: a@b.com
	To: $EMAIL_TO
	Subject: <subject>
	Content-Type: text/html; charset=us-ascii
	$BODY
	EOF
done

1 * * * * /home/xyz/script.sh

* * * * * /home/xyz/script.sh

*/5 * * * * /home/xyz/script.sh