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/RelationCleanup.php          | 392 +++++++++++++++++++++
 1 file changed, 392 insertions(+)
 create mode 100644 srcs/phpmyadmin/libraries/classes/RelationCleanup.php

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

diff --git a/srcs/phpmyadmin/libraries/classes/RelationCleanup.php b/srcs/phpmyadmin/libraries/classes/RelationCleanup.php
new file mode 100644
index 0000000..ce98ee4
--- /dev/null
+++ b/srcs/phpmyadmin/libraries/classes/RelationCleanup.php
@@ -0,0 +1,392 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Set of functions used for cleaning up phpMyAdmin tables
+ *
+ * @package PhpMyAdmin
+ */
+declare(strict_types=1);
+
+namespace PhpMyAdmin;
+
+use PhpMyAdmin\DatabaseInterface;
+use PhpMyAdmin\Relation;
+use PhpMyAdmin\Util;
+
+/**
+ * PhpMyAdmin\RelationCleanup class
+ *
+ * @package PhpMyAdmin
+ */
+class RelationCleanup
+{
+    /**
+     * @var Relation
+     */
+    public $relation;
+
+    /**
+     * @var DatabaseInterface
+     */
+    public $dbi;
+
+    /**
+     * RelationCleanup constructor.
+     *
+     * @param DatabaseInterface $dbi      DatabaseInterface object
+     * @param Relation          $relation Relation object
+     */
+    public function __construct($dbi, Relation $relation)
+    {
+        $this->dbi = $dbi;
+        $this->relation = $relation;
+    }
+
+    /**
+     * Cleanup column related relation stuff
+     *
+     * @param string $db     database name
+     * @param string $table  table name
+     * @param string $column column name
+     *
+     * @return void
+     */
+    public function column($db, $table, $column)
+    {
+        $cfgRelation = $this->relation->getRelationsParam();
+
+        if ($cfgRelation['commwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['column_info'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
+                . ' AND table_name = \'' . $this->dbi->escapeString($table)
+                . '\''
+                . ' AND column_name = \'' . $this->dbi->escapeString($column)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['displaywork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['table_info'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
+                . ' AND table_name = \'' . $this->dbi->escapeString($table)
+                . '\''
+                . ' AND display_field = \'' . $this->dbi->escapeString($column)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['relwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['relation'])
+                . ' WHERE master_db  = \'' . $this->dbi->escapeString($db)
+                . '\''
+                . ' AND master_table = \'' . $this->dbi->escapeString($table)
+                . '\''
+                . ' AND master_field = \'' . $this->dbi->escapeString($column)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['relation'])
+                . ' WHERE foreign_db  = \'' . $this->dbi->escapeString($db)
+                . '\''
+                . ' AND foreign_table = \'' . $this->dbi->escapeString($table)
+                . '\''
+                . ' AND foreign_field = \'' . $this->dbi->escapeString($column)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+    }
+
+    /**
+     * Cleanup table related relation stuff
+     *
+     * @param string $db    database name
+     * @param string $table table name
+     *
+     * @return void
+     */
+    public function table($db, $table)
+    {
+        $cfgRelation = $this->relation->getRelationsParam();
+
+        if ($cfgRelation['commwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['column_info'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
+                . ' AND table_name = \'' . $this->dbi->escapeString($table)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['displaywork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['table_info'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
+                . ' AND table_name = \'' . $this->dbi->escapeString($table)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['pdfwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['table_coords'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
+                . ' AND table_name = \'' . $this->dbi->escapeString($table)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['relwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['relation'])
+                . ' WHERE master_db  = \'' . $this->dbi->escapeString($db)
+                . '\''
+                . ' AND master_table = \'' . $this->dbi->escapeString($table)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['relation'])
+                . ' WHERE foreign_db  = \'' . $this->dbi->escapeString($db)
+                . '\''
+                . ' AND foreign_table = \'' . $this->dbi->escapeString($table)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['uiprefswork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['table_uiprefs'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
+                . ' AND table_name = \'' . $this->dbi->escapeString($table)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['navwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['navigationhiding'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
+                . ' AND (table_name = \'' . $this->dbi->escapeString($table)
+                . '\''
+                . ' OR (item_name = \'' . $this->dbi->escapeString($table)
+                . '\''
+                . ' AND item_type = \'table\'))';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+    }
+
+    /**
+     * Cleanup database related relation stuff
+     *
+     * @param string $db database name
+     *
+     * @return void
+     */
+    public function database($db)
+    {
+        $cfgRelation = $this->relation->getRelationsParam();
+
+        if ($cfgRelation['commwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['column_info'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['bookmarkwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['bookmark'])
+                . ' WHERE dbase  = \'' . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['displaywork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['table_info'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['pdfwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['pdf_pages'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['table_coords'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['relwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['relation'])
+                . ' WHERE master_db  = \''
+                . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['relation'])
+                . ' WHERE foreign_db  = \'' . $this->dbi->escapeString($db)
+                . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['uiprefswork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['table_uiprefs'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['navwork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['navigationhiding'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['savedsearcheswork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['savedsearches'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['centralcolumnswork']) {
+            $remove_query = 'DELETE FROM '
+                . Util::backquote($cfgRelation['db'])
+                . '.' . Util::backquote($cfgRelation['central_columns'])
+                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
+            $this->relation->queryAsControlUser($remove_query);
+        }
+    }
+
+    /**
+     * Cleanup user related relation stuff
+     *
+     * @param string $username username
+     *
+     * @return void
+     */
+    public function user($username)
+    {
+        $cfgRelation = $this->relation->getRelationsParam();
+
+        if ($cfgRelation['bookmarkwork']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['bookmark'])
+                . " WHERE `user`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['historywork']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['history'])
+                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['recentwork']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['recent'])
+                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['favoritework']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['favorite'])
+                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['uiprefswork']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['table_uiprefs'])
+                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['userconfigwork']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['userconfig'])
+                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['menuswork']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['users'])
+                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['navwork']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['navigationhiding'])
+                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['savedsearcheswork']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['savedsearches'])
+                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+
+        if ($cfgRelation['designersettingswork']) {
+            $remove_query = "DELETE FROM "
+                . Util::backquote($cfgRelation['db'])
+                . "." . Util::backquote($cfgRelation['designer_settings'])
+                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
+                . "'";
+            $this->relation->queryAsControlUser($remove_query);
+        }
+    }
+}
-- 
cgit