CiviCRM Community Forums (archive)

Hello,

I'm implementing the tokenValues() and token() hooks to allow the addition of the joomla username to emails in CiviMail. It works fine for plain-text, but it gets omitted on the html version when I send a test email. It does the token replace for both html and plain-text in the preview, so am wondering if this is a bug...

Implementation as follows:
/**
 * Hook to add username token
 */
function richmondcustom_civicrm_tokens(&$tokens) {
$tokens['joomla'] = array(
'joomla.username' => 'Joomla: username',
);
}

/**
 * Hook to populate joomla.username from database
 */
function richmondcustom_civicrm_tokenValues(&$values, $cids, $job = null, $tokens = array(), $context = null)
{
$contacts = implode(',', $cids);

$dao = &CRM_Core_DAO::executeQuery("
SELECT username, contact_id
FROM joomla_users
INNER JOIN civicrm_uf_match on uf_id=joomla_users.id
WHERE contact_id IN ($contacts);"
);

while ($dao->fetch()) {
$cid = $dao->contact_id;

$values[$cid]['joomla.username'] = $dao->username;
}
}


Not sure where I'm going wrong. Guidance gratefully received!