show affiliate link only if already affiliate

[Malware]

Hi!
Is there any way, currently, to make the affiliates link on the homepage to show up only if the customer is already an affiliate?

thanks

[skshost]

You can accomplish this by modifying homepage.tpl. I can only see this being useful if you only wish to enable an affiliate from admin. I'd assume you'll need to connect to your DB and pass a few things to smarty. I'll take a crack at it..

Otherwise only showing the affiliate link when someone is logged in is quite easy.

[Malware]

Yes, affiliates are being activated by me only.

You think I'll have to query the DB for that right?

Thanks

[skshost]

do something like: SELECT id FROM tblaffiliates WHERE clientid='$clientdetails.id'
then pass it to smarty and do some kind of if statement..