#!/bin/sh

usage () {                             
        echo "Usage: $0 <domain> <hostname> <v6 IP> [zone serial]"
        echo "Usage: $0 foobar.gr www 2001:db8:1001::1"
        exit 1
}

if [ $# -lt 3 ]; then
        usage
fi
DOMAIN=$1
HOSTNAME=$2
v6IP=$3
INPUT_SERIAL=${4:-10}
FULLHOST="$2.$1."

ADMIN_PASS=`cat /etc/psa/.psa.shadow`
MYSQL_BIN_D=`grep MYSQL_BIN_D /etc/psa/psa.conf | awk '{print $2}'`
PRODUCT_ROOT_D=`grep PRODUCT_ROOT_D /etc/psa/psa.conf | awk '{print $2}'`
SERIAL=`date +%Y%m%d${INPUT_SERIAL}`
mysql="${MYSQL_BIN_D}/mysql -N -uadmin -p${ADMIN_PASS} psa"

query1="SELECT dns_zone_id FROM dns_recs where host like \"$DOMAIN%\" LIMIT 0,1"
ZONE_ID=`echo "$query1" | $mysql`
echo "ZONE_ID=$ZONE_ID"
query2="INSERT INTO dns_recs (displayHost, host, displayVal, val, type, dns_zone_id) VALUES ('$FULLHOST', '$FULLHOST', '$v6IP', '$v6IP', 'AAAA',$ZONE_ID)"
echo "$query2" | $mysql

query3="UPDATE dns_zone SET serial=\"$SERIAL\" WHERE id=$ZONE_ID LIMIT 1;"
echo "$query3" | $mysql

echo "REBUILDING zone file for $DOMAIN"
$PRODUCT_ROOT_D/admin/sbin/dnsmng update $DOMAIN