From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 srcs/phpmyadmin/tbl_row_action.php | 180 +++++++++++++++++++++++++++++++++++++
 1 file changed, 180 insertions(+)
 create mode 100644 srcs/phpmyadmin/tbl_row_action.php

(limited to 'srcs/phpmyadmin/tbl_row_action.php')

diff --git a/srcs/phpmyadmin/tbl_row_action.php b/srcs/phpmyadmin/tbl_row_action.php
new file mode 100644
index 0000000..b26f1ec
--- /dev/null
+++ b/srcs/phpmyadmin/tbl_row_action.php
@@ -0,0 +1,180 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * handle row specific actions like edit, delete, export
+ *
+ * @package PhpMyAdmin
+ */
+declare(strict_types=1);
+
+use PhpMyAdmin\Response;
+use PhpMyAdmin\Sql;
+use PhpMyAdmin\Url;
+
+if (! defined('ROOT_PATH')) {
+    define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
+}
+
+global $db, $pmaThemeImage, $sql_query, $table;
+
+require_once ROOT_PATH . 'libraries/common.inc.php';
+
+if (isset($_POST['submit_mult'])) {
+    $submit_mult = $_POST['submit_mult'];
+    // workaround for IE problem:
+} elseif (isset($_POST['submit_mult_delete_x'])) {
+    $submit_mult = 'row_delete';
+} elseif (isset($_POST['submit_mult_change_x'])) {
+    $submit_mult = 'row_edit';
+} elseif (isset($_POST['submit_mult_export_x'])) {
+    $submit_mult = 'row_export';
+}
+
+// If the 'Ask for confirmation' button was pressed, this can only come
+// from 'delete' mode, so we set it straight away.
+if (isset($_POST['mult_btn'])) {
+    $submit_mult = 'row_delete';
+}
+
+if (! isset($submit_mult)) {
+    $submit_mult = 'row_edit';
+}
+
+switch ($submit_mult) {
+    case 'row_delete':
+    case 'row_edit':
+    case 'row_copy':
+    case 'row_export':
+        // leave as is
+        break;
+
+    case 'export':
+        $submit_mult = 'row_export';
+        break;
+
+    case 'delete':
+        $submit_mult = 'row_delete';
+        break;
+
+    case 'copy':
+        $submit_mult = 'row_copy';
+        break;
+
+    case 'edit':
+    default:
+        $submit_mult = 'row_edit';
+        break;
+}
+
+if (! empty($submit_mult)) {
+    if (isset($_POST['goto'])
+        && (! isset($_POST['rows_to_delete'])
+        || ! is_array($_POST['rows_to_delete']))
+    ) {
+        $response = Response::getInstance();
+        $response->setRequestStatus(false);
+        $response->addJSON('message', __('No row selected.'));
+    }
+
+    switch ($submit_mult) {
+    /** @noinspection PhpMissingBreakStatementInspection */
+        case 'row_copy':
+            $_POST['default_action'] = 'insert';
+            // no break to allow for fallthough
+        case 'row_edit':
+            // As we got the rows to be edited from the
+            // 'rows_to_delete' checkbox, we use the index of it as the
+            // indicating WHERE clause. Then we build the array which is used
+            // for the tbl_change.php script.
+            $where_clause = [];
+            if (isset($_POST['rows_to_delete'])
+            && is_array($_POST['rows_to_delete'])
+            ) {
+                foreach ($_POST['rows_to_delete'] as $i => $i_where_clause) {
+                    $where_clause[] = $i_where_clause;
+                }
+            }
+            $active_page = 'tbl_change.php';
+            include ROOT_PATH . 'tbl_change.php';
+            break;
+
+        case 'row_export':
+            // Needed to allow SQL export
+            $single_table = true;
+
+            // As we got the rows to be exported from the
+            // 'rows_to_delete' checkbox, we use the index of it as the
+            // indicating WHERE clause. Then we build the array which is used
+            // for the tbl_change.php script.
+            $where_clause = [];
+            if (isset($_POST['rows_to_delete'])
+            && is_array($_POST['rows_to_delete'])
+            ) {
+                foreach ($_POST['rows_to_delete'] as $i => $i_where_clause) {
+                    $where_clause[] = $i_where_clause;
+                }
+            }
+            $active_page = 'tbl_export.php';
+            include ROOT_PATH . 'tbl_export.php';
+            break;
+
+        case 'row_delete':
+        default:
+            $action = 'tbl_row_action.php';
+            $err_url = 'tbl_row_action.php'
+            . Url::getCommon($GLOBALS['url_params']);
+            if (! isset($_POST['mult_btn'])) {
+                $original_sql_query = $sql_query;
+                if (! empty($url_query)) {
+                    $original_url_query = $url_query;
+                }
+            }
+            include ROOT_PATH . 'libraries/mult_submits.inc.php';
+            $_url_params = $GLOBALS['url_params'];
+            $_url_params['goto'] = 'tbl_sql.php';
+            $url_query = Url::getCommon($_url_params);
+
+
+            /**
+         * Show result of multi submit operation
+         */
+            // sql_query is not set when user does not confirm multi-delete
+            if ((! empty($submit_mult) || isset($_POST['mult_btn']))
+            && ! empty($sql_query)
+            ) {
+                $disp_message = __('Your SQL query has been executed successfully.');
+                $disp_query = $sql_query;
+            }
+
+            if (isset($original_sql_query)) {
+                $sql_query = $original_sql_query;
+            }
+
+            if (isset($original_url_query)) {
+                $url_query = $original_url_query;
+            }
+
+            $active_page = 'sql.php';
+            $sql = new Sql();
+            $sql->executeQueryAndSendQueryResponse(
+                null, // analyzed_sql_results
+                false, // is_gotofile
+                $db, // db
+                $table, // table
+                null, // find_real_end
+                null, // sql_query_for_bookmark
+                null, // extra_data
+                null, // message_to_show
+                null, // message
+                null, // sql_data
+                $goto, // goto
+                $pmaThemeImage, // pmaThemeImage
+                null, // disp_query
+                null, // disp_message
+                null, // query_type
+                $sql_query, // sql_query
+                null, // selectedTables
+                null // complete_query
+            );
+    }
+}
-- 
cgit