diff options
Diffstat (limited to 'libraries/db_events.inc.php')
-rw-r--r-- | libraries/db_events.inc.php | 62 |
1 files changed, 0 insertions, 62 deletions
diff --git a/libraries/db_events.inc.php b/libraries/db_events.inc.php deleted file mode 100644 index 5f99a8b2cf..0000000000 --- a/libraries/db_events.inc.php +++ /dev/null @@ -1,62 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * - * @version $Id$ - * @package phpMyAdmin - */ -if (! defined('PHPMYADMIN')) { - exit; -} - -/** - * Append goto to ulr_query. - */ -$url_query .= '&goto=db_structure.php'; - -$events = PMA_DBI_fetch_result('SELECT EVENT_NAME, EVENT_TYPE FROM information_schema.EVENTS WHERE EVENT_SCHEMA= \'' . PMA_sqlAddslashes($db,true) . '\';'); - -if ($events) { - PMA_generate_slider_effect('events', $strEvents); - echo '<fieldset>' . "\n"; - echo ' <legend>' . $strEvents . '</legend>' . "\n"; - echo '<table border="0">'; - echo sprintf('<tr> - <th>%s</th> - <th> </th> - <th> </th> - <th>%s</th> - </tr>', - $strName, - $strType); - $ct=0; - $delimiter = '//'; - 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('<tr class="%s"> - <td><strong>%s</strong></td> - <td>%s</td> - <td>%s</td> - <td>%s</td> - </tr>', - ($ct%2 == 0) ? 'even' : 'odd', - $event['EVENT_NAME'], - ! empty($definition) ? PMA_linkOrButton('db_sql.php?' . $url_query . '&sql_query=' . urlencode($definition) . '&show_query=1&delimiter=' . urlencode($delimiter), $titles['Structure']) : ' ', - '<a href="sql.php?' . $url_query . '&sql_query=' . urlencode($sqlDrop) . '" onclick="return confirmLink(this, \'' . PMA_jsFormat($sqlDrop, false) . '\')">' . $titles['Drop'] . '</a>', - $event['EVENT_TYPE']); - $ct++; - } - echo '</table>'; - echo '</fieldset>' . "\n"; - echo '</div>' . "\n"; -} -?> |