acctmod-rt.sh
#!/bin/sh
if [ "$1" = "" ]; then exit 1 ; fi
if [ "$2" = "" ]; then exit 1 ; fi
n1=`expr index $1 "@"`
if [ $n1 = 0 ]; then exit 1 ; fi
n2=`expr index $2 "@"`
if [ $n2 = 0 ]; then exit 1 ; fi
cou0=`mysql -u root -p*** -e "use rt3; select count(*) from Users where Users.EmailAddress = '$1'" | sed -n '2p';`
if [ "$cou0" -eq "0" ]; then exit 1 ; fi
cou1=`mysql -u root -p*** -e "use rt3; select count(*) from Users where Users.Name = '$2'" | sed -n '2p';`
if [ "$cou1" -eq "0" ]
then
cou2=`mysql -u root -p*** -e "use rt3; select count(*) from Users where Users.EmailAddress = '$2'" | sed -n '2p';`
if [ "$cou2" -eq "0" ]
then
mysql -u root -p*** -e "use rt3; update Users set Users.Name = '$2',Users.EmailAddress = '$2' where Users.EmailAddress = '$1';"
echo "login_name: $1 -> $2"
fi
fi