Subversion Repositories SmartDukaan

Rev

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

Rev 2195 Rev 2196
Line 8... Line 8...
8
 
8
 
9
MASTER_AFF_NAME=$1
9
MASTER_AFF_NAME=$1
10
AFF_NAME=$1
10
AFF_NAME=$1
11
AFF_URL=$1
11
AFF_URL=$1
12
 
12
 
13
mysql -uroot -pshop2020 user -e "CALL add_affiliate('${MASTER_AFF_NAME}', '${AFF_NAME}', '${AFF_URL}');" 
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}';"