Hi,

My client needs to be able to send emails in the format "Hi !firstname, ...", which means I need access to the proflie values.

I also need to be able to send them a link to their affiliate manager page, which lives at /user/x/affiliates, which depends on the userid meaning I can't hardcode it.

The token module allows anyone to substitute in tokens, which is really handy ... it also provides a nice token replacement helper to show all of the available tokens.

I also provide some additional tokens for other emails the system generates:

<?php

/**
 * Implements hook_token_list().
 */
function x_token_list($type = 'site') {
  $tokens = array();
 
  if ($type === 'profile') {
    $tokens['affiliate']['affiliate_balance']        = t('The affiliates current balance.');
    $tokens['affiliate']['affiliate_ap_earnings']    = t('The affiliates earnings for the current accounting period.');
    $tokens['affiliate']['affiliate_total_earnings'] = t('The affiliates total earnings.');
  }
 
  return $tokens;
}

/**
 * Implements hook_token_values().
 */
function x_token_values($type, $object = NULL, $options = array()) {
  $tokens = array();
 
  if ($type === 'profile') {
    $account =& $object;     
    $since = variable_get('radar_affiliates_notifications_lastsent', 0);
    $tokens['affiliate_balance']        = number_format($account->af_balance, 2);
    $tokens['affiliate_ap_earnings']    = number_format(db_result(db_query('SELECT SUM(amount) FROM {ms_affiliates_history} WHERE date > %d AND amount > 0 AND uid = %d', $since, $account->uid)), 2);
    $tokens['affiliate_total_earnings'] = number_format(db_result(db_query('SELECT SUM(amount) FROM {ms_affiliates_history} WHERE amount > 0 AND uid = %d', $account->uid)), 2);
  }
 
  return $tokens;
}

?>