root/feedmelinks/bin/drip-feed-mailer.sh

#!/bin/sh

. env.sh

# change to accomodate different urls, e.g. admin/disable-user?op=re_enable, admin/disable-user?op=disable, etc.
op_flag="notify_expiring_soon"

root=`get_webserver_root`
lynx=`get_http_downloader`

bot_operator=`bot_operator`
bot_operator_password=`bot_operator_password`
# FIXME: put these in servers.xml config FIXME: currently they just hardcode over the above calls
bot_operator="klaus_kinski"
bot_operator_password="fuzzlebuzzle"

# db auth: (from env)
db_u=`get_database_user`
db=`get_database_name`
db_p=`get_database_password`

# FIXME: put these into servers.xml
time_to_wait_between_lists=3600 # in seconds
emails_per_time_unit=225 # ISP limit is 250/ hour

cd "$root/_mail"
echo in `pwd`

echo dumping list of users to notify:
mysql -u $db_u -p$db_p $db -s -e 'SELECT userid FROM users WHERE snuffed IS NULL AND DISABLED = 1' > recipients.txt

echo -n "splitting up the file into sub-lists to be mailed one per hour: "
split -d -l $emails_per_hour recipients.txt recipient-batch-
echo -n `ls -1 recipient-batch-* | wc -l`
echo " sub-lists created"

for sub_list in recipient-batch-*
do
        echo processing sub-list $sub_list at `date`

                for user in `cat $sub_list`
                do
                        $lynx --dump --auth="$bot_operator:$bot_operator_password" "http://feedmelinks.com/admin/disable-user?op=$op_flag&user=$user" > /dev/null
                        sleep 1
                done

                mv $sub_list "SENT-$sub_list"

        sleep $time_to_wait_between_lists
done