#!/bin/sh
SQLBIN_PATH="/usr/local/bin"
MYSQLUSER="pdns_temp"
MYSQLPASS="pdns123"
username=$1
domain=$2

# Remove first character from userid. (First character is A-Z)
username_1=`echo $username | sed 's/.\(.*\)/\1/'`

# Connect to database and set the userid on the domainname
echo "use pdns_temp;UPDATE domains SET cust_id='$username_1' WHERE name='$domain'" | $SQLBIN_PATH/mysql -u$MYSQLUSER -p$MYSQLPASS

temp_domain_id=`echo "use pdns_temp;SELECT id FROM domains WHERE name='$domain'" | $SQLBIN_PATH/mysql -u$MYSQLUSER -p$MYSQLPASS`

domain_id=`echo $temp_domain_id |  sed 's/..\(..*\)/\1/'`

echo "use pdns_temp;INSERT INTO pdns_temp.domain_owners (domain_id,user_id) VALUES ('$domain_id','103')" | $SQLBIN_PATH/mysql -u$MYSQLUSER -p$MYSQLPASS

exit 0;