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/setup/config.php         |  57 +++
 srcs/phpmyadmin/setup/index.php          |  71 ++++
 srcs/phpmyadmin/setup/lib/common.inc.php |  53 +++
 srcs/phpmyadmin/setup/styles.css         | 611 +++++++++++++++++++++++++++++++
 srcs/phpmyadmin/setup/validate.php       |  41 +++
 5 files changed, 833 insertions(+)
 create mode 100644 srcs/phpmyadmin/setup/config.php
 create mode 100644 srcs/phpmyadmin/setup/index.php
 create mode 100644 srcs/phpmyadmin/setup/lib/common.inc.php
 create mode 100644 srcs/phpmyadmin/setup/styles.css
 create mode 100644 srcs/phpmyadmin/setup/validate.php

(limited to 'srcs/phpmyadmin/setup')

diff --git a/srcs/phpmyadmin/setup/config.php b/srcs/phpmyadmin/setup/config.php
new file mode 100644
index 0000000..614f70f
--- /dev/null
+++ b/srcs/phpmyadmin/setup/config.php
@@ -0,0 +1,57 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Front controller for config view / download and clear
+ *
+ * @package PhpMyAdmin-Setup
+ */
+declare(strict_types=1);
+
+use PhpMyAdmin\Config\Forms\Setup\ConfigForm;
+use PhpMyAdmin\Core;
+use PhpMyAdmin\Response;
+use PhpMyAdmin\Setup\ConfigGenerator;
+use PhpMyAdmin\Url;
+
+if (! defined('ROOT_PATH')) {
+    define('ROOT_PATH', dirname(__DIR__) . DIRECTORY_SEPARATOR);
+}
+
+/**
+ * Core libraries.
+ */
+require ROOT_PATH . 'setup/lib/common.inc.php';
+
+$form_display = new ConfigForm($GLOBALS['ConfigFile']);
+$form_display->save('Config');
+
+$response = Response::getInstance();
+$response->disable();
+
+if (isset($_POST['eol'])) {
+    $_SESSION['eol'] = ($_POST['eol'] == 'unix') ? 'unix' : 'win';
+}
+
+if (Core::ifSetOr($_POST['submit_clear'], '')) {
+    //
+    // Clear current config and return to main page
+    //
+    $GLOBALS['ConfigFile']->resetConfigData();
+    // drop post data
+    $response->generateHeader303('index.php' . Url::getCommonRaw());
+    exit;
+} elseif (Core::ifSetOr($_POST['submit_download'], '')) {
+    //
+    // Output generated config file
+    //
+    Core::downloadHeader('config.inc.php', 'text/plain');
+    $response->disable();
+    echo ConfigGenerator::getConfigFile($GLOBALS['ConfigFile']);
+    exit;
+} else {
+    //
+    // Show generated config file in a <textarea>
+    //
+    $response->generateHeader303('index.php' . Url::getCommonRaw(['page' => 'config']));
+    exit;
+}
diff --git a/srcs/phpmyadmin/setup/index.php b/srcs/phpmyadmin/setup/index.php
new file mode 100644
index 0000000..8ff4bf2
--- /dev/null
+++ b/srcs/phpmyadmin/setup/index.php
@@ -0,0 +1,71 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Front controller for setup script
+ *
+ * @package PhpMyAdmin-Setup
+ * @license https://www.gnu.org/licenses/gpl.html GNU GPL 2.0
+ */
+declare(strict_types=1);
+
+use PhpMyAdmin\Controllers\Setup\ConfigController;
+use PhpMyAdmin\Controllers\Setup\FormController;
+use PhpMyAdmin\Controllers\Setup\HomeController;
+use PhpMyAdmin\Controllers\Setup\ServersController;
+use PhpMyAdmin\Core;
+use PhpMyAdmin\Template;
+use PhpMyAdmin\Url;
+
+if (! defined('ROOT_PATH')) {
+    define('ROOT_PATH', dirname(__DIR__) . DIRECTORY_SEPARATOR);
+}
+
+global $cfg;
+
+require ROOT_PATH . 'setup/lib/common.inc.php';
+
+if (@file_exists(CONFIG_FILE) && ! $cfg['DBG']['demo']) {
+    Core::fatalError(__('Configuration already exists, setup is disabled!'));
+}
+
+$page = Core::isValid($_GET['page'], 'scalar') ? (string) $_GET['page'] : null;
+$page = preg_replace('/[^a-z]/', '', $page);
+if ($page === '') {
+    $page = 'index';
+}
+
+Core::noCacheHeader();
+
+if ($page === 'form') {
+    $controller = new FormController($GLOBALS['ConfigFile'], new Template());
+    echo $controller->index([
+        'formset' => $_GET['formset'] ?? null,
+    ]);
+} elseif ($page === 'config') {
+    $controller = new ConfigController($GLOBALS['ConfigFile'], new Template());
+    echo $controller->index([
+        'formset' => $_GET['formset'] ?? null,
+        'eol' => $_GET['eol'] ?? null,
+    ]);
+} elseif ($page === 'servers') {
+    $controller = new ServersController($GLOBALS['ConfigFile'], new Template());
+    if (isset($_GET['mode']) && $_GET['mode'] === 'remove' && $_SERVER['REQUEST_METHOD'] == 'POST') {
+        $controller->destroy([
+            'id' => $_GET['id'] ?? null,
+        ]);
+        header('Location: index.php' . Url::getCommonRaw());
+    } else {
+        echo $controller->index([
+            'formset' => $_GET['formset'] ?? null,
+            'mode' => $_GET['mode'] ?? null,
+            'id' => $_GET['id'] ?? null,
+        ]);
+    }
+} else {
+    $controller = new HomeController($GLOBALS['ConfigFile'], new Template());
+    echo $controller->index([
+        'formset' => $_GET['formset'] ?? null,
+        'action_done' => $_GET['action_done'] ?? null,
+        'version_check' => $_GET['version_check'] ?? null,
+    ]);
+}
diff --git a/srcs/phpmyadmin/setup/lib/common.inc.php b/srcs/phpmyadmin/setup/lib/common.inc.php
new file mode 100644
index 0000000..a53e10a
--- /dev/null
+++ b/srcs/phpmyadmin/setup/lib/common.inc.php
@@ -0,0 +1,53 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Loads libraries/common.inc.php and preforms some additional actions
+ *
+ * @package PhpMyAdmin-Setup
+ */
+declare(strict_types=1);
+
+use PhpMyAdmin\Config\ConfigFile;
+use PhpMyAdmin\DatabaseInterface;
+
+/**
+ * Do not include full common.
+ * @ignore
+ */
+define('PMA_MINIMUM_COMMON', true);
+chdir('..');
+
+if (! file_exists(ROOT_PATH . 'libraries/common.inc.php')) {
+    die('Bad invocation!');
+}
+
+require_once ROOT_PATH . 'libraries/common.inc.php';
+
+// use default error handler
+restore_error_handler();
+
+// Save current language in a cookie, required since we use PMA_MINIMUM_COMMON
+$GLOBALS['PMA_Config']->setCookie('pma_lang', $GLOBALS['lang']);
+$GLOBALS['PMA_Config']->set('is_setup', true);
+
+$GLOBALS['ConfigFile'] = new ConfigFile();
+$GLOBALS['ConfigFile']->setPersistKeys(
+    [
+        'DefaultLang',
+        'ServerDefault',
+        'UploadDir',
+        'SaveDir',
+        'Servers/1/verbose',
+        'Servers/1/host',
+        'Servers/1/port',
+        'Servers/1/socket',
+        'Servers/1/auth_type',
+        'Servers/1/user',
+        'Servers/1/password',
+    ]
+);
+
+$GLOBALS['dbi'] = DatabaseInterface::load();
+
+// allows for redirection even after sending some data
+ob_start();
diff --git a/srcs/phpmyadmin/setup/styles.css b/srcs/phpmyadmin/setup/styles.css
new file mode 100644
index 0000000..bb96fd3
--- /dev/null
+++ b/srcs/phpmyadmin/setup/styles.css
@@ -0,0 +1,611 @@
+/* global styles */
+
+body {
+    margin-right: auto;
+    min-width: 960px;
+    padding-bottom: 1em;
+    color: #444;
+    font: .8em sans-serif;
+    background: url(../themes/pmahomme/img/left_nav_bg.png) repeat-y 80px 0 #f3f3f3;
+}
+
+input,
+button,
+select,
+textarea,
+th,
+td {
+    font: 1em sans-serif;
+}
+
+img {
+    border: 0;
+}
+
+a,
+a:link,
+a:visited,
+a:active {
+    text-decoration: none;
+    color: #235a81;
+    cursor: pointer;
+    outline: none;
+
+}
+
+a:hover {
+    text-decoration: underline;
+    color: #235a81;
+}
+
+h1 {
+    font-size: 1.5em;
+}
+
+/* language selection box */
+
+#select_lang {
+    position: absolute;
+    right: 1em;
+    top: 1em;
+}
+
+/* menu */
+
+#menu {
+    float: left;
+    width: 220px;
+    font-size: 1.1em;
+}
+
+#menu ul {
+    margin: 1em 1em 1em .5em;
+    padding: 0;
+    list-style: none;
+}
+
+#menu li a {
+    padding: .5em .6em;
+    margin-right: .6em;
+    display: block;
+    color: #333;
+    text-decoration: none;
+    zoom: 1; /* IE fix */
+}
+
+#menu li a:hover, #menu li a:active, #menu li a.active {
+    background-color: #e4e4e4;
+}
+
+/* page contents and footer layout */
+
+#page {
+    margin-left: 220px;
+    margin-right: 25px;
+}
+
+#footer {
+    margin-top: 1em;
+}
+
+#footer a {
+    margin-right: 0.5em;
+    text-decoration: none;
+    font-size: small;
+}
+
+/* phpMyAdmin logo colors */
+
+.blue {
+    color: #666699;
+}
+
+.orange {
+    color: #FF9900;
+}
+
+.red {
+    color: #C00;
+}
+
+/* main page messages */
+
+/* message boxes: error, confirmation */
+.success h4,
+.notice h4,
+div.error h4 {
+    border-bottom: 1px solid;
+    font-weight: bold;
+    margin: 0 0 .2em 0;
+}
+
+div.success,
+div.notice,
+div.error {
+    margin: .5em 0 1.3em 0;
+    border: 1px solid;
+    background: no-repeat 10px 10px;
+    padding: 10px 10px 10px 25px;
+
+    -moz-border-radius: 5px;
+    -webkit-border-radius: 5px;
+    border-radius: 5px;
+
+    -moz-box-shadow: 0 1px 1px #fff inset;
+    -webkit-box-shadow: 0 1px 1px #fff inset;
+    box-shadow: 0 1px 1px #fff inset;
+}
+
+.success a,
+.notice a,
+.error a {
+    text-decoration: underline;
+}
+
+.success {
+    color: #000;
+    background-color: #ebf8a4;
+}
+
+h1.success,
+div.success {
+    border-color: #a2d246;
+    background: url(../themes/pmahomme/img/s_success.png) no-repeat 5px 10px;
+}
+.success h4 {
+    border-color: #00FF00;
+}
+
+.notice {
+    color: #000;
+    background-color: #e8eef1;
+}
+
+h1.notice,
+div.notice {
+    border-color: #3a6c7e;
+    background: url(../themes/pmahomme/img/s_notice.png) no-repeat 5px 10px;
+}
+
+.notice h4 {
+    border-color: #ffb10a;
+}
+
+.error {
+    border: 1px solid maroon !important;
+    color: #000;
+    background: pink;
+}
+
+h1.error,
+div.error {
+    border-color: #333;
+    background: url(../themes/pmahomme/img/s_error.png) no-repeat 5px 10px;
+}
+
+div.error h4 {
+    border-color: #ff0000;
+}
+
+div.notice[id^=version_check] {
+    border-color: #002DFF;
+    background-color: #EEF;
+}
+
+div.notice[id^=version_check] h4 {
+    border-color: #002DFF;
+}
+
+
+
+/* form tabs */
+
+ul.tabs {
+    margin: 1.1em 2px 0;
+    padding: 0 0 3px 0;
+    list-style: none;
+    font-weight: bold;
+}
+
+ul.tabs li {
+    float: left;
+    margin-bottom: -1px;
+}
+
+ul.tabs li a {
+    display: block;
+    margin: 1px .2em 0;
+    white-space: nowrap;
+    text-decoration: none;
+    border: 1px solid #D5D5D5;
+    border-bottom: 1px solid #aaa;
+}
+
+ul.tabs li a {
+    padding: 7px 10px;
+    -webkit-border-radius: 5px 5px 0 0;
+    -moz-border-radius: 5px 5px 0 0;
+    border-radius: 5px 5px 0 0;
+    background: #f2f2f2;
+    color: #555;
+    text-shadow: 0 1px 0 #fff;
+}
+
+ul.tabs li a:hover,
+ul.tabs li a:active {
+    background: #e5e5e5;
+}
+
+ul.tabs li.active a {
+    background-color: #fff;
+    margin-top: 1px;
+    color: #000;
+    text-shadow: none;
+    border-color: #aaa;
+    border-bottom: 1px solid #fff;
+}
+
+.tabs_contents {
+    margin-top: 13px;
+}
+
+.tabs_contents fieldset {
+    margin-top: 0;
+}
+
+.tabs_contents legend {
+    display: none;
+}
+
+/* "restore default value" and "set value: foo" buttons */
+
+.restore-default img, .set-value img {
+    margin-bottom: -3px;
+}
+
+.userprefs-comment {
+    cursor: help;
+    float: right;
+}
+
+/* forms */
+
+fieldset {
+    margin-top: 1em;
+    border-radius: 4px 4px 0 0;
+    -moz-border-radius: 4px 4px 0 0;
+    -webkit-border-radius: 4px 4px 0 0;
+    border: #aaa solid 1px;
+    padding: 1.5em;
+    background: #eee;
+    text-shadow: 0 1px 0 #fff;
+    -moz-box-shadow: 1px 1px 2px #fff inset;
+    -webkit-box-shadow: 1px 1px 2px #fff inset;
+    box-shadow: 1px 1px 2px #fff inset;
+}
+
+fieldset.optbox {
+    padding: 0;
+}
+
+fieldset fieldset {
+    margin: .8em;
+    border: 1px solid #aaa;
+    background: #E8E8E8;
+}
+
+fieldset legend {
+    font-weight: bold;
+    color: #444;
+    padding: 5px 10px;
+    border-radius: 2px;
+    -moz-border-radius: 2px;
+    -webkit-border-radius: 2px;
+    border: 1px solid #aaa;
+    background-color: #fff;
+    -moz-box-shadow: 3px 3px 15px #bbb;
+    -webkit-box-shadow: 3px 3px 15px #bbb;
+    box-shadow: 3px 3px 15px #bbb;
+}
+
+.form {
+    border: 2px #DEE1FF solid;
+}
+
+fieldset p {
+    margin: 0;
+    padding: .5em;
+    background: #fff;
+    border-top: 0;
+}
+
+fieldset .errors { /* form error list */
+    margin: 0 -2px 1em -2px;
+    padding: 0.5em 1.5em;
+    background: #FBEAD9;
+    border: 1px #C83838 solid;
+    border-width: 1px 0;
+    list-style: none;
+    font-family: sans-serif;
+    font-size: small;
+}
+
+fieldset .inline_errors { /* field error list */
+    margin: 0.3em 0.3em 0.3em 0;
+    padding: 0;
+    list-style: none;
+    color: #9A0000;
+    font-size: small;
+}
+
+table caption, table th, table td {
+    text-shadow: 0 1px 0 #FFFFFF;
+}
+
+fieldset th {
+    width: 40%;
+    min-width: 350px;
+    padding: 0.3em 0.3em 0.3em 0.5em;
+    text-align: left;
+    font-weight: bold;
+    vertical-align: top;
+}
+
+fieldset.simple th {
+    width: auto;
+    min-width: 0;
+}
+
+fieldset .doc {
+    margin-left: 1em;
+}
+
+fieldset td {
+    padding-top: 0.3em;
+    vertical-align: top;
+}
+
+fieldset td.userprefs-allow {
+    padding: 0;
+    vertical-align: middle;
+    text-align: center;
+    width: 3em;
+}
+
+fieldset td.userprefs-allow:hover {
+    cursor: pointer;
+    background-color: #EEE;
+}
+
+fieldset th small {
+    display: block;
+    font-weight: normal;
+    font-family: sans-serif;
+    font-size: x-small;
+    color: #666;
+}
+
+fieldset th, fieldset td, .form .lastrow {
+    border-top: 1px solid #D5D5D5;
+}
+
+fieldset .group-header th {
+    background: #EAEDFF;
+    border: none;
+}
+
+fieldset .group-field-1 th, fieldset .group-header-2 th {
+    padding-left: 1em;
+}
+
+fieldset .group-field-2 th, fieldset .group-header-3 th {
+    padding-left: 2em;
+}
+
+fieldset .group-field-3 th {
+    padding-left: 3em;
+}
+
+fieldset .lastrow, .form .lastrow {
+    border-top: 1px #000 solid;
+    background: #D3DCE3;
+    padding: .5em;
+    text-align: center;
+}
+
+input[type=text],
+input[type=password],
+input[type=number] {
+    border-radius: 2px;
+    -moz-border-radius: 2px;
+    -webkit-border-radius: 2px;
+
+    box-shadow: 0 1px 2px #ddd;
+    -moz-box-shadow: 0 1px 2px #ddd;
+    -webkit-box-shadow: 0 1px 2px #ddd;
+
+    background: white;
+    border: 1px solid #aaa;
+    color: #555;
+    padding: 4px;
+    margin: 6px;
+}
+
+input[type=submit],
+button[type=submit]:not(.mult_submit) {
+    font-weight: bold !important;
+}
+
+input[type=submit],
+button[type=submit]:not(.mult_submit),
+input[type=reset],
+input[name=submit_reset],
+input.button {
+    margin-left: 14px;
+    border: 1px solid #aaa;
+    padding: 3px 7px;
+    color: #111;
+    text-decoration: none;
+    background: #ddd;
+
+    border-radius: 12px;
+    -webkit-border-radius: 12px;
+    -moz-border-radius: 12px;
+
+    text-shadow: 0 1px 0 #fff;
+
+    background-image: url(../themes/svg_gradient.php?from=ffffff&to=cccccc);
+    background-size: 100% 100%;
+    background: -webkit-linear-gradient(top, #ffffff, #cccccc);
+    background: -moz-linear-gradient(top, #ffffff, #cccccc);
+    background: -ms-linear-gradient(top, #ffffff, #cccccc);
+    background: -o-linear-gradient(top, #ffffff, #cccccc);
+}
+
+input[type=submit]:hover,
+button[type=submit]:not(.mult_submit):hover,
+input[type=reset]:hover,
+input[name=submit_reset]:hover,
+input.button:hover {
+    position: relative;
+    background-image: url(../themes/svg_gradient.php?from=cccccc&to=dddddd);
+    background-size: 100% 100%;
+    background: -webkit-linear-gradient(top, #cccccc, #dddddd);
+    background: -moz-linear-gradient(top, #cccccc, #dddddd);
+    background: -ms-linear-gradient(top, #cccccc, #dddddd);
+    background: -o-linear-gradient(top, #cccccc, #dddddd);
+    cursor: pointer;
+}
+
+input[type=submit]:active,
+button[type=submit]:not(.mult_submit):active,
+input[type=reset]:active,
+input[name=submit_reset]:active,
+input.button:active {
+    position: relative;
+    top: 1px;
+    left: 1px;
+}
+
+input[type="checkbox"],
+input[type="radio"] {
+    vertical-align: -11%;
+}
+
+
+select {
+    -moz-border-radius: 2px;
+    -webkit-border-radius: 2px;
+    border-radius: 2px;
+
+    -moz-box-shadow: 0 1px 2px #ddd;
+    -webkit-box-shadow: 0 1px 2px #ddd;
+    box-shadow: 0 1px 2px #ddd;
+
+    border: 1px solid #aaa;
+    color: #333;
+    padding: 3px;
+    background: white;
+    margin: 6px;
+}
+
+fieldset.simple th, fieldset.simple td {
+    border-top: none;
+    border-bottom: 1px #555 dotted;
+}
+
+fieldset.simple .lastrow {
+    border: 0;
+}
+
+/* form elements */
+
+span.checkbox {
+    padding: 2px;
+    display: inline-block;
+}
+
+.custom { /* customized field */
+    background: #FFC;
+}
+
+.checkbox.custom {
+    padding: 1px;
+    border: 1px #EDEC90 solid;
+}
+
+.field-error {
+    border-color: #C11 !important;
+}
+
+.field-comment {
+
+    position: relative;
+}
+
+.field-comment-mark {
+    cursor: help;
+    padding: 0 0.2em;
+    font-weight: bold;
+    font-style: italic;
+}
+
+.field-comment-warning {
+    color: #A00;
+}
+
+.green { /* default form button */
+    color: #080 !important;
+}
+
+table.datatable {
+    margin: 0.5em 0 1em;
+}
+
+table.datatable th {
+    padding: 0 1em 0 0.5em;
+    border-bottom: 1px #999 solid;
+    text-align: left;
+}
+
+table.datatable td {
+    padding: 1px 0.5em;
+    border-bottom: 1px #DEE1FF solid;
+}
+
+/* textarea with config file's contents */
+
+#textconfig {
+    width: 100%;
+    border: 0;
+}
+
+/* error list */
+
+dd {
+    margin-left: 0.5em;
+}
+
+dd:before {
+    content: "\25B8  ";
+}
+
+/* links on failed validation page, when saving a form */
+
+a.btn {
+    padding: 1px 5px;
+    text-decoration: none;
+    background: #E2E8FF;
+    border: 1px #A6C8FF solid;
+    border-top-color: #AFD0FF;
+    border-left-color: #AFD0FF;
+    font-weight: bold;
+}
+
+a.btn:hover, a.btn:active {
+    background: #E6F5FF;
+    color: #004C96;
+}
+.hide {
+    display: none;
+}
diff --git a/srcs/phpmyadmin/setup/validate.php b/srcs/phpmyadmin/setup/validate.php
new file mode 100644
index 0000000..df79a1e
--- /dev/null
+++ b/srcs/phpmyadmin/setup/validate.php
@@ -0,0 +1,41 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Validation callback.
+ *
+ * @package PhpMyAdmin-Setup
+ */
+declare(strict_types=1);
+
+use PhpMyAdmin\Config\Validator;
+use PhpMyAdmin\Core;
+
+if (! defined('ROOT_PATH')) {
+    define('ROOT_PATH', dirname(__DIR__) . DIRECTORY_SEPARATOR);
+}
+
+/**
+ * Core libraries.
+ */
+require ROOT_PATH . 'setup/lib/common.inc.php';
+
+$validators = [];
+
+Core::headerJSON();
+
+$ids = Core::isValid($_POST['id'], 'scalar') ? $_POST['id'] : null;
+$vids = explode(',', $ids);
+$vals = Core::isValid($_POST['values'], 'scalar') ? $_POST['values'] : null;
+$values = json_decode($vals);
+if (! ($values instanceof stdClass)) {
+    Core::fatalError(__('Wrong data'));
+}
+$values = (array) $values;
+$result = Validator::validate($GLOBALS['ConfigFile'], $vids, $values, true);
+if ($result === false) {
+    $result = sprintf(
+        __('Wrong data or no validation for %s'),
+        implode(',', $vids)
+    );
+}
+echo $result !== true ? json_encode($result) : '';
-- 
cgit