getHeader(); $scripts = $header->getScripts(); $scripts->addFile('jquery/jquery.tablesorter.js'); $scripts->addFile('db_tracking.js'); /** * If we are not in an Ajax request, then do the common work and show the links etc. */ require 'libraries/db_common.inc.php'; $url_query .= '&goto=tbl_tracking.php&back=db_tracking.php'; // Get the database structure $sub_part = '_structure'; require 'libraries/db_info.inc.php'; // Work to do? // (here, do not use $_REQUEST['db] as it can be crafted) if (isset($_REQUEST['delete_tracking']) && isset($_REQUEST['table'])) { PMA_Tracker::deleteTracking($GLOBALS['db'], $_REQUEST['table']); PMA_Message::success( __('Tracking data deleted successfully.') )->display(); } elseif (isset($_REQUEST['submit_create_version'])) { PMA_createTrackingForMultipleTables($_REQUEST['selected']); PMA_Message::success( sprintf( __( 'Version %1$s was created for selected tables,' . ' tracking is active for them.' ), htmlspecialchars($_REQUEST['version']) ) )->display(); } elseif (isset($_REQUEST['submit_mult'])) { if (! empty($_REQUEST['selected_tbl'])) { if ($_REQUEST['submit_mult'] == 'delete_tracking') { foreach ($_REQUEST['selected_tbl'] as $table) { PMA_Tracker::deleteTracking($GLOBALS['db'], $table); } PMA_Message::success( __('Tracking data deleted successfully.') )->display(); } elseif ($_REQUEST['submit_mult'] == 'track') { echo PMA_getHtmlForDataDefinitionAndManipulationStatements( 'db_tracking.php' . $url_query, 0, $GLOBALS['db'], $_REQUEST['selected_tbl'] ); exit; } } else { PMA_Message::notice( __('No tables selected.') )->display(); } } // Get tracked data about the database $data = PMA_Tracker::getTrackedData($_REQUEST['db'], '', '1'); // No tables present and no log exist if ($num_tables == 0 && count($data['ddlog']) == 0) { echo '

' . __('No tables found in database.') . '

' . "\n"; if (empty($db_is_system_schema)) { include 'libraries/display_create_table.lib.php'; } exit; } // --------------------------------------------------------------------------- $cfgRelation = PMA_getRelationsParam(); // Prepare statement to get HEAD version $all_tables_query = ' SELECT table_name, MAX(version) as version FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['tracking']) . ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($_REQUEST['db']) . '\' ' . ' GROUP BY table_name' . ' ORDER BY table_name ASC'; $all_tables_result = PMA_queryAsControlUser($all_tables_query); // If a HEAD version exists if ($GLOBALS['dbi']->numRows($all_tables_result) > 0) { ?>

fetchArray($all_tables_result)) { list($table_name, $version_number) = $one_result; $table_query = ' SELECT * FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['tracking']) . ' WHERE `db_name` = \'' . PMA_Util::sqlAddSlashes($_REQUEST['db']) . '\' AND `table_name` = \'' . PMA_Util::sqlAddSlashes($table_name) . '\' AND `version` = \'' . $version_number . '\''; $table_result = PMA_queryAsControlUser($table_query); $version_data = $GLOBALS['dbi']->fetchArray($table_result); $tmp_link = 'tbl_tracking.php' . $url_query . '&table=' . htmlspecialchars($version_data['table_name']); $delete_link = 'db_tracking.php' . $url_query . '&table=' . htmlspecialchars($version_data['table_name']) . '&delete_tracking=true&'; $checkbox_id = "selected_tbl_" . htmlspecialchars($version_data['table_name']); ?> ' . ''; if ($style == 'even') { $style = 'odd'; } else { $style = 'even'; } } unset($tmp_link); ?>
array( 'label' => __('not active'), 'value' => 'deactivate_now', 'selected' => ($state != 'active') ), 1 => array( 'label' => __('active'), 'value' => 'activate_now', 'selected' => ($state == 'active') ) ); echo PMA_Util::toggleButton( $tmp_link . '&version=' . $version_data['version'], 'toggle_activation', $options, null ); ?> ' . '' . '' . $versions . '' . '  ' . '' . $report . '' . '  ' . '' . $structure . '' . '
$value) { // If $value is a table group. if (array_key_exists(('is' . $sep . 'group'), $value) && $value['is' . $sep . 'group'] ) { foreach ($value as $temp_table) { // If $temp_table is a table with the value for 'Name' is set, // rather than a property of the table group. if (is_array($temp_table) && array_key_exists('Name', $temp_table) ) { $tracking_version = PMA_Tracker::getVersion( $GLOBALS['db'], $temp_table['Name'] ); if ($tracking_version == -1) { $my_tables[] = $temp_table['Name']; } } } } else { // If $value is a table. if (PMA_Tracker::getVersion($GLOBALS['db'], $value['Name']) == -1) { $my_tables[] = $value['Name']; } } } // If untracked tables exist if (count($my_tables) > 0) { ?>

$tablename) { $checkbox_id = "selected_tbl_" . htmlspecialchars($tablename); if (PMA_Tracker::getVersion($GLOBALS['db'], $tablename) == -1) { $my_link = ''; $my_link .= PMA_Util::getIcon('eye.png', __('Track table')); $my_link .= ''; ?>
0) { $log = ''; foreach ($data['ddlog'] as $entry) { $log .= '# ' . $entry['date'] . ' ' . $entry['username'] . "\n" . $entry['statement'] . "\n"; } echo PMA_Util::getMessage(__('Database Log'), $log); }