public function exportRoutines($db, $aliases = array())
{
global $crlf;
$db_alias = $db;
$this->initAlias($aliases, $db_alias);
$text = '';
$delimiter = '$$';
$procedure_names = $GLOBALS['dbi']->getProceduresOrFunctions($db, 'PROCEDURE');
$function_names = $GLOBALS['dbi']->getProceduresOrFunctions($db, 'FUNCTION');
if ($procedure_names || $function_names) {
$text .= $crlf . 'DELIMITER ' . $delimiter . $crlf;
if ($procedure_names) {
$text .= $this->_exportRoutineSQL($db, $aliases, 'PROCEDURE', __('Procedures'), $procedure_names, $delimiter);
}
if ($function_names) {
$text .= $this->_exportRoutineSQL($db, $aliases, 'FUNCTION', __('Functions'), $function_names, $delimiter);
}
$text .= 'DELIMITER ;' . $crlf;
}
if (!empty($text)) {
return PMA_exportOutputHandler($text);
} else {
return false;
}
}