Shell Programming and Scripting

#! /bin/ksh
SENDER=person@some.com
CHECKER=$mysql_code_to_get_check_statement
SPAM="$spam_message"

CNT=0
for GRP in $mysql_code_to_create_GRP_list
do
    echo $CHECKER | grep $GRP > /dev/null 2>&1
    if [ $? -eq 0 ]
    then
          CNT=$(($CNT + 1))
          MESSAGE="$mysql_code_to_get_GRP_message"
          SUBJECT="$mysql_code_to_get_GRP_subject"
          ADDLIST="$mysql_code_to_get_GRP_address_list"
          for EMAIL in $ADDLIST
          do
                echo "$MESSAGE" | mailx -s "$SUBJECT" -a From:$SENDER $EMAIL
          done
          echo "email sent to $GRP contacts"
          break
     fi
done

if [ $CNT -eq 0 ]
then
      $SPAM
fi

VALIDATION="$(mysql --skip-column-names -u root --password=123456 smsd -e "SELECT sms_keyword FROM kontak_group" > sms_keyword001.txt)"
SENDER="$( mysql -u root --password=123456 smsd -N -s -r -e "SELECT address FROM sender WHERE id='1'")"
KRITERIA="$(mysql -u root --password=123456 smsd -e "select concat_ws ( '', group_concat(sms_keyword separator '|') ) from kontak_group")"
CHECKER="$(mysql -u root --password=123456 smsd -e "SELECT ID, SenderNumber, TextDecoded FROM inbox ORDER BY ReceivingDateTime DESC LIMIT 1  \G" |egrep -w '$KRITERIA' 2> /dev/null)"
SPAM="$(mysql -u root --password=123456 smsd -e "INSERT INTO inbox_spam SELECT * FROM inbox WHERE TextDecoded NOT regexp ( select concat_ws ( '', '^(', group_concat(sms_keyword separator '|'), ').*' ) from kontak_group)")"
SUBJECT="$( mysql -u root --password=123456 smsd -N -s -r -e "SELECT subject FROM email_subject WHERE id='1'")"
MESSAGE="$( mysql -u root --password=123456 smsd -e "SELECT ID, SenderNumber, TextDecoded FROM inbox ORDER BY ReceivingDateTime DESC LIMIT 1")"
ADDLIST="$( mysql -u root --password=123456 smsd -e "SELECT email_group FROM kontak_group")"

CNT=0
for GRP in $VALIDATION
do
    echo $CHECKER | grep $GRP > /dev/null 2>&1
    if [ $? -eq 0 ]
    then
          CNT=$(($CNT + 1))
          MESSAGE=$MESSAGE
          SUBJECT=$SUBJECT
          ADDLIST=$ADDLIST
          for EMAIL in $ADDLIST
          do
                echo "$MESSAGE" | mailx -s "$SUBJECT" -a From:$SENDER $EMAIL
          done
          echo "email sent to $GRP contacts"
          break
     fi
done

if [ $CNT -eq 0 ]
then
      $SPAM
fi