Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
2195 vikas 1 
#!/bin/bash
2 
 
3 
if [ $# -ne 3 ]
4 
then
5 
	echo "Usage: $0 <master_affiliate_name> <affiliate_name> <affiliate_url>"
6 
	exit  1
7 
fi
8 
 
9 
MASTER_AFF_NAME=$1
2398 rajveer 10 
AFF_NAME=$2
11 
AFF_URL=$3
2195 vikas 12 
 
2196 vikas 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());"
2195 vikas 14 
mysql -uroot -pshop2020 user -e "SELECT * FROM affiliate where name = '${AFF_NAME}';"