#!/bin/bash

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

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

export MYSQL_HOME PATH

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

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

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

if [ "x${PASSWORD}" = "x" ]; then
    echo "SET VARIABLE agiResult 0"
    exit 0
fi

if [ "${PASSWORD}" = "${pass}" ]; then
   echo "SET VARIABLE agiResult 1"
   exit 0
fi

echo "SET VARIABLE agiResult 0"
exit 0