variable for Affiliate ID - not full link

[greghl]

Is there a variable we can access for just the affiliate ID - so we can pass this to external scripts and flash banners?

 

I know I can use [AffiliateLinkCode] - but I want just their ID to link to an externally managed link+banner page.

 

thx

[othellotech]

In general, no.

 

On the affiliates.php specific pages, I think so

 

What you need is a bit of php ... something like

 

extract($this->_tpl_vars);
$query = "SELECT id FROM tblaffiliates WHERE clientid=".$clientsdetails['userid'];
$result = mysql_query ($query);
$data = @mysql_fetch_array ($result);
if ($data['id'] > 0)
{
       $this->assign('affiliateid', $data['id']);
}

 

- - - Updated - - -

 

In general, no.

 

On the affiliates.php specific pages, I think so

 

What you need is a bit of php ... something like

 

extract($this->_tpl_vars);
$query = "SELECT id FROM tblaffiliates WHERE clientid=".$clientsdetails['userid'];
$result = mysql_query ($query);
$data = @mysql_fetch_array ($result);
if ($data['id'] > 0)
{
       $this->assign('affiliateid', $data['id']);
}