From 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab Mon Sep 17 00:00:00 2001
From: Charles Cabergs <me@cacharle.xyz>
Date: Mon, 27 Jul 2020 10:05:23 +0200
Subject: Removed wordpress and phpmyadmin, my server doesn't handle it well
 and it brings shame on my familly

---
 .../libraries/classes/RelationCleanup.php          | 392 ---------------------
 1 file changed, 392 deletions(-)
 delete 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
deleted file mode 100644
index ce98ee4..0000000
--- a/srcs/phpmyadmin/libraries/classes/RelationCleanup.php
+++ /dev/null
@@ -1,392 +0,0 @@
-<?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