#!/bin/bash
#

MYSQL_HOME="/opt/mysql-4.1.10"
PATH="${PATH}:${MYSQL_HOME}/bin"

export MYSQL_HOME PATH

DBHOST="localhost"
DATABASE="asterisk"
USERNAME="asterisk"
PASSWORD="asterisk"

function _ltrim() {
    echo $( echo "${1}" | sed -e 's/^\s+//' )
    return 0
}

function _checkBlank() {
    if [ "${1}x" = "x" ]; then
        echo "SET VARIABLE agiResult 0"
        exit 0
    fi
}

context=$( _ltrim "${1}" )
exten=$( _ltrim "${2}" )

_checkBlank "${context}"
_checkBlank "${exten}"

RETVAL=1

ringtype=$( mysql -N -B -q \
    -h ${DBHOST} -u ${USERNAME} \
    --password="${PASSWORD}" ${DATABASE} \
    -e "select ringtype from forward 
	    where extension = '${exten}' and 
	    context = '${context}'" 2> /dev/null )
    RETVAL=$?
    
number=$( mysql -N -B -q \
    -h ${DBHOST} -u ${USERNAME} \
    --password="${PASSWORD}" ${DATABASE} \
    -e "select number from forward 
	    where extension = '${exten}' and 
	    context = '${context}'" 2> /dev/null )
    RETVAL=$?

# check our return result
if ! [ "${RETVAL}" = "0" ]; then
    echo "SET VARIABLE agiResult 0"
    exit 0    
fi

_checkBlank "${ringtype}"
_checkBlank "${number}"

echo "SET VARIABLE agiResult 1"
echo "SET VARIABLE forwardType ${ringtype}"
echo "SET VARIABLE forwardNumber ${number}"

exit 0