Show only if user is Affiliate

[AdminIEH]

Greetings,

 

There are some menus and sections that I only want to display if the user is activated as an affiliate, but I cannot find how to do this. Any help is greatly appreciated!

[omnigenus]

Well, try something like this:

 

{php}
// take the user's id
$userID = $_SESSION["uid"];

// try to find that user amon affiliates	
$sql = "SELECT id FROM tblaffiliates WHERE clientid = ".$userID;
$result = mysql_query($sql);
$rows = mysql_num_rows($result);

// if found
if ($rows > 0)
{
	$this->assign('isAffiliate',"Y");
}
// if not
else
{
	$this->assign('isAffiliate',"N");
}
{/php}

{if $isAffiliate eq "Y"}
show the menu
{/if}

 

Check for errors as this was done quickly

[AdminIEH]

Perfect! thank you very much.