phpmyadmin/db_tracking.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Tracking configuration for database
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 /**
  10  * Run common work
  11  */
  12 require_once 'libraries/common.inc.php';
  13
  14 require_once './libraries/tracking.lib.php';
  15 require_once 'libraries/display_create_table.lib.php';
  16
  17 //Get some js files needed for Ajax requests
  18 $response = PMA_Response::getInstance();
  19 $header   = $response->getHeader();
  20 $scripts  = $header->getScripts();
  21 $scripts->addFile('jquery/jquery.tablesorter.js');
  22 $scripts->addFile('db_tracking.js');
  23
  24 /**
  25  * If we are not in an Ajax request, then do the common work and show the links etc.
  26  */
  27 require 'libraries/db_common.inc.php';
  28 $url_query .= '&amp;goto=tbl_tracking.php&amp;back=db_tracking.php';
  29
  30 // Get the database structure
  31 $sub_part = '_structure';
  32
  33 list(
  34     $tables,
  35     $num_tables,
  36     $total_num_tables,
  37     $sub_part,
  38     $is_show_stats,
  39     $db_is_system_schema,
  40     $tooltip_truename,
  41     $tooltip_aliasname,
  42     $pos
  43 ) = PMA_Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');
  44
  45 // Work to do?
  46 //  (here, do not use $_REQUEST['db] as it can be crafted)
  47 if (isset($_REQUEST['delete_tracking']) && isset($_REQUEST['table'])) {
  48
  49     PMA_Tracker::deleteTracking($GLOBALS['db'], $_REQUEST['table']);
  50     PMA_Message::success(
  51         __('Tracking data deleted successfully.')
  52     )->display();
  53
  54 } elseif (isset($_REQUEST['submit_create_version'])) {
  55
  56     PMA_createTrackingForMultipleTables($_REQUEST['selected']);
  57     PMA_Message::success(
  58         sprintf(
  59             __(
  60                 'Version %1$s was created for selected tables,'
  61                 . ' tracking is active for them.'
  62             ),
  63             htmlspecialchars($_REQUEST['version'])
  64         )
  65     )->display();
  66
  67 } elseif (isset($_REQUEST['submit_mult'])) {
  68
  69     if (! empty($_REQUEST['selected_tbl'])) {
  70         if ($_REQUEST['submit_mult'] == 'delete_tracking') {
  71
  72             foreach ($_REQUEST['selected_tbl'] as $table) {
  73                 PMA_Tracker::deleteTracking($GLOBALS['db'], $table);
  74             }
  75             PMA_Message::success(
  76                 __('Tracking data deleted successfully.')
  77             )->display();
  78
  79         } elseif ($_REQUEST['submit_mult'] == 'track') {
  80
  81             echo PMA_getHtmlForDataDefinitionAndManipulationStatements(
  82                 'db_tracking.php' . $url_query,
  83                 0,
  84                 $GLOBALS['db'],
  85                 $_REQUEST['selected_tbl']
  86             );
  87             exit;
  88         }
  89     } else {
  90         PMA_Message::notice(
  91             __('No tables selected.')
  92         )->display();
  93     }
  94 }
  95
  96 // Get tracked data about the database
  97 $data = PMA_Tracker::getTrackedData($_REQUEST['db'], '', '1');
  98
  99 // No tables present and no log exist
 100 if ($num_tables == 0 && count($data['ddlog']) == 0) {
 101     echo '<p>' . __('No tables found in database.') . '</p>' . "\n";
 102
 103     if (empty($db_is_system_schema)) {
 104         echo PMA_getHtmlForCreateTable($db);
 105     }
 106     exit;
 107 }
 108
 109 // ---------------------------------------------------------------------------
 110 $cfgRelation = PMA_getRelationsParam();
 111
 112 // Prepare statement to get HEAD version
 113 $all_tables_query = ' SELECT table_name, MAX(version) as version FROM ' .
 114      PMA_Util::backquote($cfgRelation['db']) . '.' .
 115      PMA_Util::backquote($cfgRelation['tracking']) .
 116      ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($_REQUEST['db']) . '\' ' .
 117      ' GROUP BY table_name' .
 118      ' ORDER BY table_name ASC';
 119
 120 $all_tables_result = PMA_queryAsControlUser($all_tables_query);
 121
 122 // If a HEAD version exists
 123 if (is_object($all_tables_result) && $GLOBALS['dbi']->numRows($all_tables_result) > 0) {
 124     PMA_displayTrackedTables(
 125         $GLOBALS['db'], $all_tables_result, $url_query, $pmaThemeImage,
 126         $text_dir, $cfgRelation
 127     );
 128 }
 129
 130 $untracked_tables = PMA_getUntrackedTables($GLOBALS['db']);
 131
 132 // If untracked tables exist
 133 if (count($untracked_tables) > 0) {
 134     PMA_displayUntrackedTables(
 135         $GLOBALS['db'], $untracked_tables, $url_query, $pmaThemeImage, $text_dir
 136     );
 137 }
 138 // If available print out database log
 139 if (count($data['ddlog']) > 0) {
 140     $log = '';
 141     foreach ($data['ddlog'] as $entry) {
 142         $log .= '# ' . $entry['date'] . ' ' . $entry['username'] . "\n"
 143             . $entry['statement'] . "\n";
 144     }
 145     echo PMA_Util::getMessage(__('Database Log'), $log);
 146 }