#!/bin/sh
# WARNING: This file was auto-generated. Do not edit!
# $Log: vcaliasrev.in,v $
# Revision 2.1  2008-06-04 21:45:29+05:30  Cprogrammer
# added auto-generated warning
# use automake to configure directories
#
# Revision 1.1  2002-03-27 15:19:42+05:30  Cprogrammer
# Initial revision
#
#
# $Id: vcaliasrev.in,v 2.1 2008-06-04 21:45:29+05:30 Cprogrammer Stab mbhangui $
#
MYSQL=/mysql
VDOMINFO=/usr/bin/vdominfo
USER=indimail
PASS=ssh-1.5-

if [ ! $# -eq 1 ] ; then
	echo "USAGE: $0 domain"
	exit 1
fi
domain=$1

get_alias_entry()
{
$MYSQL -u $USER -p$PASS indimail -s << !
select * from valias where domain='$domain';
!
}

delete_line()
{
$MYSQL -u $USER -p$PASS indimail -s << !
delete from valias where alias='$1' and domain='$2' and valias_line='$3';
!
}

DIR=`$VDOMINFO -d $domain`
if [ " $DIR" = " " ] ; then
	echo "$domain: Invalid Domain"
	exit 1
fi
echo "Converting from MYSQL To Filesystem"
get_alias_entry | while read line
do
	set $line
	printf "Converting %-20s -> %s\n" $1 $3
	echo $3 >> $DIR/.qmail-"$1"
	chown indimail:indimail $DIR/.qmail-"$1"
	chmod 600 $DIR/.qmail-"$1"
	delete_line $1 $2 $3
done
