Subversion Repositories SmartDukaan

Rev

Rev 2195 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

#!/bin/bash

if [ $# -ne 3 ]
then
        echo "Usage: $0 <master_affiliate_name> <affiliate_name> <affiliate_url>"
        exit  1
fi

MASTER_AFF_NAME=$1
AFF_NAME=$1
AFF_URL=$1

mysql -uroot -pshop2020 user -e "insert into affiliate(master_affiliate_id, name, url, added_on) values((select id from masteraffiliate where name = '${MASTER_AFF_NAME}'), '${AFF_NAME}', '${AFF_URL}', now());" 
mysql -uroot -pshop2020 user -e "SELECT * FROM affiliate where name = '${AFF_NAME}';"