Viewing file:  db_events.inc.php (2.26 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
' . "\n";
echo ' ' . "\n";
echo '';
echo sprintf('
| %s |
|
|
%s |
',
__('Name'),
__('Type'));
$ct=0;
$delimiter = '//';
if ($GLOBALS['cfg']['AjaxEnable']) {
$conditional_class = 'class="drop_event_anchor"';
} else {
$conditional_class = '';
}
foreach ($events as $event) {
// information_schema (at least in MySQL 5.1.22) does not return
// the full CREATE EVENT statement in a way that could be useful for us
// so we rely on PMA_DBI_get_definition() which uses SHOW CREATE EVENT
$definition = 'DROP EVENT ' . PMA_backquote($event['EVENT_NAME']) . $delimiter . "\n"
. PMA_DBI_get_definition($db, 'EVENT', $event['EVENT_NAME'])
. "\n";
$sqlDrop = 'DROP EVENT ' . PMA_backquote($event['EVENT_NAME']);
echo sprintf('
| %s |
%s |
%s |
%s |
',
($ct%2 == 0) ? 'even' : 'odd',
$event['EVENT_NAME'],
! empty($definition) ? PMA_linkOrButton('db_sql.php?' . $url_query . '&sql_query=' . urlencode($definition) . '&show_query=1&db_query_force=1&delimiter=' . urlencode($delimiter), $titles['Structure']) : ' ',
'' . $titles['Drop'] . '',
$event['EVENT_TYPE']);
$ct++;
}
echo ' ';
echo '' . "\n";
echo '' . "\n";
}
?>
|