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}';"