phpmyadmin working

1 files changed, 129 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/db_tracking.php b/srcs/phpmyadmin/db_tracking.php
new file mode 100644
index 0000000..fb508b5
--- /dev/null
+++ b/srcs/phpmyadmin/db_tracking.php
@@ -0,0 +1,129 @@
+<?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 .= '&amp;goto=tbl_tracking.php&amp;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);
+}