/** * Given a queue event ID, find the corresponding email address. * * @param int $queue_id The queue event ID * @return string The email address * @access public * @static */ function getEmailAddress($queue_id) { $email = CRM_Core_BAO_Email::getTableName(); $eq = CRM_Mailing_Event_BAO_Queue::getTableName(); $query = " SELECT {$email}.email as email \n FROM {$email} \n INNER JOIN {$eq} \n ON {$eq}.email_id = {$email}.id \n WHERE {$eq}.id = " . CRM_Utils_Type::rule($queue_id, 'Integer'); $q =& new CRM_Mailing_Event_BAO_Queue(); $q->query($query); if (!$q->fetch()) { return null; } return $q->email; }