#!/bin/bash
subdomain=${SSH_REMOTE_FINGERPRINT//:/}
ip_address=${SSH_CLIENT%% *}
lan_address="$SSH_ORIGINAL_COMMAND"

domain=ssh.cryptonomic.net 

sqlescape()
{
	printf '%s' "'${1/\'/\'\'}'"
}

add()
{
	local newdomain="$(sqlescape "$1.$domain")" ip_address="$(sqlescape "$2")" domain="$(sqlescape "$domain")"

	sqlite3 /etc/powerdns/powerdns.sqlite3 <<END
BEGIN;
	delete from records where type='A' and name=$newdomain;

	insert into records

		(domain_id,
		name,
		type,
		content,
		ttl,
		prio)

		select
			id,
			$newdomain,
			'A',
			$ip_address,
			3600,
			0
		from domains
		where name=$domain;
COMMIT;
END
	if [ $? = 0 ]; then
		printf '%s\n' "$1 $2"
	fi
}

add "$subdomain" "$ip_address"

set -- $lan_address
while [ $# -ge 2 ]; do
	d=$1
	ip=$2
	shift 2
	
	case "$d" in
		*.*) continue;;
	esac
	
	add "$d.$subdomain" "$ip"
done