Subversion Repositories SmartDukaan

Rev

Rev 2196 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2196 Rev 2398
Line 5... Line 5...
5 
	echo "Usage: $0 <master_affiliate_name> <affiliate_name> <affiliate_url>"
 5 
	echo "Usage: $0 <master_affiliate_name> <affiliate_name> <affiliate_url>"
6 
	exit  1
 6 
	exit  1
7 
fi
 7 
fi
8 
 
 8 
 
9 
MASTER_AFF_NAME=$1
 9 
MASTER_AFF_NAME=$1
10 
AFF_NAME=$1
 10 
AFF_NAME=$2
11 
AFF_URL=$1
 11 
AFF_URL=$3
12 
 
 12 
 
13 
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());"
13 
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());"
14 
mysql -uroot -pshop2020 user -e "SELECT * FROM affiliate where name = '${AFF_NAME}';"
14 
mysql -uroot -pshop2020 user -e "SELECT * FROM affiliate where name = '${AFF_NAME}';"