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

---
 .../libraries/classes/VersionInformation.php       | 239 +++++++++++++++++++++
 1 file changed, 239 insertions(+)
 create mode 100644 srcs/phpmyadmin/libraries/classes/VersionInformation.php

(limited to 'srcs/phpmyadmin/libraries/classes/VersionInformation.php')

diff --git a/srcs/phpmyadmin/libraries/classes/VersionInformation.php b/srcs/phpmyadmin/libraries/classes/VersionInformation.php
new file mode 100644
index 0000000..e6f42db
--- /dev/null
+++ b/srcs/phpmyadmin/libraries/classes/VersionInformation.php
@@ -0,0 +1,239 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Responsible for retrieving version information and notifiying about latest version
+ *
+ * @package PhpMyAdmin
+ */
+declare(strict_types=1);
+
+namespace PhpMyAdmin;
+
+use PhpMyAdmin\Utils\HttpRequest;
+use \stdClass;
+
+/**
+ * Responsible for retrieving version information and notifiying about latest version
+ *
+ * @package PhpMyAdmin
+ *
+ */
+class VersionInformation
+{
+    /**
+     * Returns information with latest version from phpmyadmin.net
+     *
+     * @return stdClass|null JSON decoded object with the data
+     */
+    public function getLatestVersion(): ?stdClass
+    {
+        if (! $GLOBALS['cfg']['VersionCheck']) {
+            return null;
+        }
+
+        // Get response text from phpmyadmin.net or from the session
+        // Update cache every 6 hours
+        if (isset($_SESSION['cache']['version_check'])
+            && time() < $_SESSION['cache']['version_check']['timestamp'] + 3600 * 6
+        ) {
+            $save = false;
+            $response = $_SESSION['cache']['version_check']['response'];
+        } else {
+            $save = true;
+            $file = 'https://www.phpmyadmin.net/home_page/version.json';
+            $httpRequest = new HttpRequest();
+            $response = $httpRequest->create($file, 'GET');
+        }
+        $response = $response ?: '{}';
+        /* Parse response */
+        $data = json_decode($response);
+
+        /* Basic sanity checking */
+        if (! is_object($data)
+            || empty($data->version)
+            || empty($data->releases)
+            || empty($data->date)
+        ) {
+            return null;
+        }
+
+        if ($save) {
+            $_SESSION['cache']['version_check'] = [
+                'response' => $response,
+                'timestamp' => time(),
+            ];
+        }
+        return $data;
+    }
+
+    /**
+     * Calculates numerical equivalent of phpMyAdmin version string
+     *
+     * @param string $version version
+     *
+     * @return mixed false on failure, integer on success
+     */
+    public function versionToInt($version)
+    {
+        $parts = explode('-', $version);
+        if (count($parts) > 1) {
+            $suffix = $parts[1];
+        } else {
+            $suffix = '';
+        }
+        $parts = explode('.', $parts[0]);
+
+        $result = 0;
+
+        if (count($parts) >= 1 && is_numeric($parts[0])) {
+            $result += 1000000 * (int) $parts[0];
+        }
+
+        if (count($parts) >= 2 && is_numeric($parts[1])) {
+            $result += 10000 * (int) $parts[1];
+        }
+
+        if (count($parts) >= 3 && is_numeric($parts[2])) {
+            $result += 100 * (int) $parts[2];
+        }
+
+        if (count($parts) >= 4 && is_numeric($parts[3])) {
+            $result += 1 * (int) $parts[3];
+        }
+
+        if (! empty($suffix)) {
+            $matches = [];
+            if (preg_match('/^(\D+)(\d+)$/', $suffix, $matches)) {
+                $suffix = $matches[1];
+                $result += intval($matches[2]);
+            }
+            switch ($suffix) {
+                case 'pl':
+                    $result += 60;
+                    break;
+                case 'rc':
+                    $result += 30;
+                    break;
+                case 'beta':
+                    $result += 20;
+                    break;
+                case 'alpha':
+                    $result += 10;
+                    break;
+                case 'dev':
+                    $result += 0;
+                    break;
+            }
+        } else {
+            $result += 50; // for final
+        }
+
+        return $result;
+    }
+
+    /**
+     * Returns the version and date of the latest phpMyAdmin version compatible
+     * with the available PHP and MySQL versions
+     *
+     * @param array $releases array of information related to each version
+     *
+     * @return array|null containing the version and date of latest compatible version
+     */
+    public function getLatestCompatibleVersion(array $releases)
+    {
+        foreach ($releases as $release) {
+            $phpVersions = $release->php_versions;
+            $phpConditions = explode(",", $phpVersions);
+            foreach ($phpConditions as $phpCondition) {
+                if (! $this->evaluateVersionCondition('PHP', $phpCondition)) {
+                    continue 2;
+                }
+            }
+
+            // We evalute MySQL version constraint if there are only
+            // one server configured.
+            if (count($GLOBALS['cfg']['Servers']) === 1) {
+                $mysqlVersions = $release->mysql_versions;
+                $mysqlConditions = explode(",", $mysqlVersions);
+                foreach ($mysqlConditions as $mysqlCondition) {
+                    if (! $this->evaluateVersionCondition('MySQL', $mysqlCondition)) {
+                        continue 2;
+                    }
+                }
+            }
+
+            return [
+                'version' => $release->version,
+                'date' => $release->date,
+            ];
+        }
+
+        // no compatible version
+        return null;
+    }
+
+    /**
+     * Checks whether PHP or MySQL version meets supplied version condition
+     *
+     * @param string $type      PHP or MySQL
+     * @param string $condition version condition
+     *
+     * @return boolean whether the condition is met
+     */
+    public function evaluateVersionCondition(string $type, string $condition)
+    {
+        $operator = null;
+        $version = null;
+        $operators = [
+            "<=",
+            ">=",
+            "!=",
+            "<>",
+            "<",
+            ">",
+            "=",
+        ]; // preserve order
+        foreach ($operators as $oneOperator) {
+            if (strpos($condition, $oneOperator) === 0) {
+                $operator = $oneOperator;
+                $version = substr($condition, strlen($oneOperator));
+                break;
+            }
+        }
+
+        $myVersion = null;
+        if ($type == 'PHP') {
+            $myVersion = $this->getPHPVersion();
+        } elseif ($type == 'MySQL') {
+            $myVersion = $this->getMySQLVersion();
+        }
+
+        if ($myVersion !== null && $operator !== null) {
+            return version_compare($myVersion, $version, $operator);
+        }
+        return false;
+    }
+
+    /**
+     * Returns the PHP version
+     *
+     * @return string PHP version
+     */
+    protected function getPHPVersion()
+    {
+        return PHP_VERSION;
+    }
+
+    /**
+     * Returns the MySQL version if connected to a database
+     *
+     * @return string|null MySQL version
+     */
+    protected function getMySQLVersion()
+    {
+        if (isset($GLOBALS['dbi'])) {
+            return $GLOBALS['dbi']->getVersionString();
+        }
+        return null;
+    }
+}
-- 
cgit