\n";
$retval .= "\n";
$retval .= "\n\n";
return $retval;
} // end self::getLinks()
/**
* Creates a fieldset for adding a new routine, if the user has the privileges.
*
* @return string HTML code with containing the footer fieldset
*/
public static function routines()
{
return self::getLinks('CREATE_PROCEDURE', 'CREATE ROUTINE', 'ROUTINE');
}// end self::routines()
/**
* Creates a fieldset for adding a new trigger, if the user has the privileges.
*
* @return string HTML code with containing the footer fieldset
*/
public static function triggers()
{
return self::getLinks('CREATE_TRIGGER', 'TRIGGER', 'TRIGGER');
} // end self::triggers()
/**
* Creates a fieldset for adding a new event, if the user has the privileges.
*
* @return string HTML code with containing the footer fieldset
*/
public static function events()
{
global $db, $url_query;
/**
* For events, we show the usual 'Add event' form and also
* a form for toggling the state of the event scheduler
*/
// Init options for the event scheduler toggle functionality
$es_state = $GLOBALS['dbi']->fetchValue(
"SHOW GLOBAL VARIABLES LIKE 'event_scheduler'",
0,
1
);
$es_state = mb_strtolower($es_state);
$options = array(
0 => array(
'label' => __('OFF'),
'value' => "SET GLOBAL event_scheduler=\"OFF\"",
'selected' => ($es_state != 'on')
),
1 => array(
'label' => __('ON'),
'value' => "SET GLOBAL event_scheduler=\"ON\"",
'selected' => ($es_state == 'on')
)
);
// Generate output
$retval = "\n";
$retval .= "