public static function getMessageRecipients($types, $type_id)
{
if (!is_array($types)) {
$types = array($types);
}
$types_list = DB_Helper::buildList($types);
$sql = "SELECT\n maq_recipient\n FROM\n {{%mail_queue}}\n WHERE\n maq_type IN ({$types_list}) AND\n maq_type_id = ?";
$params = $types;
$params[] = $type_id;
try {
$res = DB_Helper::getInstance()->getColumn($sql, $params);
} catch (DbException $e) {
return false;
}
foreach ($res as &$row) {
// FIXME: what does quote stripping fix here
$row = Mime_Helper::decodeAddress(str_replace('"', '', $row));
}
return $res;
}
function getMessageRecipients($type, $type_id)
{
$sql = "SELECT\n maq_recipient\n FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "mail_queue\n WHERE\n maq_type = '" . Misc::escapeString($type) . "' AND\n maq_type_id = " . Misc::escapeInteger($type_id);
$res = $GLOBALS["db_api"]->dbh->getCol($sql);
if (PEAR::isError($res)) {
Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__);
return false;
} else {
for ($i = 0; $i < count($res); $i++) {
$res[$i] = Mime_Helper::decodeAddress(str_replace('"', '', $res[$i]));
}
return $res;
}
}
