aboutsummaryrefslogtreecommitdiff
path: root/srcs/phpmyadmin/libraries/classes/RelationCleanup.php
diff options
context:
space:
mode:
Diffstat (limited to 'srcs/phpmyadmin/libraries/classes/RelationCleanup.php')
-rw-r--r--srcs/phpmyadmin/libraries/classes/RelationCleanup.php392
1 files changed, 392 insertions, 0 deletions
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);
+ }
+ }
+}
generated by cgit (git 2.34.1) at 2026-05-16 01:11:40 +0000