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; } }