Server IP : 85.214.239.14 / Your IP : 18.191.192.113 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/wordpress/phpMyAdmin/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Tracking configuration for database * * @package PhpMyAdmin */ declare(strict_types=1); use PhpMyAdmin\Display\CreateTable; use PhpMyAdmin\Message; use PhpMyAdmin\Relation; use PhpMyAdmin\Response; use PhpMyAdmin\Tracker; use PhpMyAdmin\Tracking; use PhpMyAdmin\Util; if (! defined('ROOT_PATH')) { define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR); } global $db, $pmaThemeImage, $text_dir, $url_query; require_once ROOT_PATH . 'libraries/common.inc.php'; //Get some js files needed for Ajax requests $response = Response::getInstance(); $header = $response->getHeader(); $scripts = $header->getScripts(); $scripts->addFile('vendor/jquery/jquery.tablesorter.js'); $scripts->addFile('database/tracking.js'); /** @var Tracking $tracking */ $tracking = $containerBuilder->get('tracking'); /** * If we are not in an Ajax request, then do the common work and show the links etc. */ require ROOT_PATH . 'libraries/db_common.inc.php'; $url_query .= '&goto=tbl_tracking.php&back=db_tracking.php'; $url_params['goto'] = 'tbl_tracking.php'; $url_params['back'] = 'db_tracking.php'; // Get the database structure $sub_part = '_structure'; list( $tables, $num_tables, $total_num_tables, $sub_part, $is_show_stats, $db_is_system_schema, $tooltip_truename, $tooltip_aliasname, $pos ) = Util::getDbInfo($db, $sub_part === null ? '' : $sub_part); if (isset($_POST['delete_tracking']) && isset($_POST['table'])) { Tracker::deleteTracking($db, $_POST['table']); Message::success( __('Tracking data deleted successfully.') )->display(); } elseif (isset($_POST['submit_create_version'])) { $tracking->createTrackingForMultipleTables($_POST['selected']); Message::success( sprintf( __( 'Version %1$s was created for selected tables,' . ' tracking is active for them.' ), htmlspecialchars($_POST['version']) ) )->display(); } elseif (isset($_POST['submit_mult'])) { if (! empty($_POST['selected_tbl'])) { if ($_POST['submit_mult'] == 'delete_tracking') { foreach ($_POST['selected_tbl'] as $table) { Tracker::deleteTracking($db, $table); } Message::success( __('Tracking data deleted successfully.') )->display(); } elseif ($_POST['submit_mult'] == 'track') { echo $tracking->getHtmlForDataDefinitionAndManipulationStatements( 'db_tracking.php' . $url_query, 0, $db, $_POST['selected_tbl'] ); exit; } } else { Message::notice( __('No tables selected.') )->display(); } } // Get tracked data about the database $data = Tracker::getTrackedData($db, '', '1'); // No tables present and no log exist if ($num_tables == 0 && count($data['ddlog']) === 0) { echo '<p>' , __('No tables found in database.') , '</p>' , "\n"; if (empty($db_is_system_schema)) { echo CreateTable::getHtml($db); } exit; } // --------------------------------------------------------------------------- echo $tracking->getHtmlForDbTrackingTables( $db, $url_query, $pmaThemeImage, $text_dir ); // If available print out database log if (count($data['ddlog']) > 0) { $log = ''; foreach ($data['ddlog'] as $entry) { $log .= '# ' . $entry['date'] . ' ' . $entry['username'] . "\n" . $entry['statement'] . "\n"; } echo Util::getMessage(__('Database Log'), $log); }