phpmyadmin/libraries/relation_cleanup.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Set of functions used for cleaning up phpMyAdmin tables
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * Cleanup column related relation stuff
  14  *
  15  * @param string $db     database name
  16  * @param string $table  table name
  17  * @param string $column column name
  18  *
  19  * @return void
  20  */
  21 function PMA_relationsCleanupColumn($db, $table, $column)
  22 {
  23     $cfgRelation = PMA_getRelationsParam();
  24
  25     if ($cfgRelation['commwork']) {
  26         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['column_info'])
  27                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
  28                     . ' AND table_name = \'' . PMA_Util::sqlAddSlashes($table) . '\''
  29                     . ' AND column_name = \'' . PMA_Util::sqlAddSlashes($column) . '\'';
  30         PMA_queryAsControlUser($remove_query);
  31     }
  32
  33     if ($cfgRelation['displaywork']) {
  34         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['table_info'])
  35                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
  36                     . ' AND table_name = \'' . PMA_Util::sqlAddSlashes($table) . '\''
  37                     . ' AND display_field = \'' . PMA_Util::sqlAddSlashes($column) . '\'';
  38         PMA_queryAsControlUser($remove_query);
  39     }
  40
  41     if ($cfgRelation['relwork']) {
  42         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['relation'])
  43                     . ' WHERE master_db  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
  44                     . ' AND master_table = \'' . PMA_Util::sqlAddSlashes($table) . '\''
  45                     . ' AND master_field = \'' . PMA_Util::sqlAddSlashes($column) . '\'';
  46         PMA_queryAsControlUser($remove_query);
  47
  48         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['relation'])
  49                     . ' WHERE foreign_db  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
  50                     . ' AND foreign_table = \'' . PMA_Util::sqlAddSlashes($table) . '\''
  51                     . ' AND foreign_field = \'' . PMA_Util::sqlAddSlashes($column) . '\'';
  52         PMA_queryAsControlUser($remove_query);
  53     }
  54 }
  55
  56 /**
  57  * Cleanup table related relation stuff
  58  *
  59  * @param string $db    database name
  60  * @param string $table table name
  61  *
  62  * @return void
  63  */
  64 function PMA_relationsCleanupTable($db, $table)
  65 {
  66     $cfgRelation = PMA_getRelationsParam();
  67
  68     if ($cfgRelation['commwork']) {
  69         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['column_info'])
  70                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
  71                     . ' AND table_name = \'' . PMA_Util::sqlAddSlashes($table) . '\'';
  72         PMA_queryAsControlUser($remove_query);
  73     }
  74
  75     if ($cfgRelation['displaywork']) {
  76         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['table_info'])
  77                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
  78                     . ' AND table_name = \'' . PMA_Util::sqlAddSlashes($table) . '\'';
  79         PMA_queryAsControlUser($remove_query);
  80     }
  81
  82     if ($cfgRelation['pdfwork']) {
  83         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['table_coords'])
  84                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
  85                     . ' AND table_name = \'' . PMA_Util::sqlAddSlashes($table) . '\'';
  86         PMA_queryAsControlUser($remove_query);
  87     }
  88
  89     if ($cfgRelation['designerwork']) {
  90         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['designer_coords'])
  91                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
  92                     . ' AND table_name = \'' . PMA_Util::sqlAddSlashes($table) . '\'';
  93         PMA_queryAsControlUser($remove_query);
  94     }
  95
  96     if ($cfgRelation['relwork']) {
  97         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['relation'])
  98                     . ' WHERE master_db  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
  99                     . ' AND master_table = \'' . PMA_Util::sqlAddSlashes($table) . '\'';
 100         PMA_queryAsControlUser($remove_query);
 101
 102         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['relation'])
 103                     . ' WHERE foreign_db  = \'' . PMA_Util::sqlAddSlashes($db) . '\''
 104                     . ' AND foreign_table = \'' . PMA_Util::sqlAddSlashes($table) . '\'';
 105         PMA_queryAsControlUser($remove_query);
 106     }
 107 }
 108
 109 /**
 110  * Cleanup database related relation stuff
 111  *
 112  * @param string $db database name
 113  *
 114  * @return void
 115  */
 116 function PMA_relationsCleanupDatabase($db)
 117 {
 118     $cfgRelation = PMA_getRelationsParam();
 119
 120     if ($cfgRelation['commwork']) {
 121         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['column_info'])
 122                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\'';
 123         PMA_queryAsControlUser($remove_query);
 124     }
 125
 126     if ($cfgRelation['bookmarkwork']) {
 127         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['bookmark'])
 128                     . ' WHERE dbase  = \'' . PMA_Util::sqlAddSlashes($db) . '\'';
 129         PMA_queryAsControlUser($remove_query);
 130     }
 131
 132     if ($cfgRelation['displaywork']) {
 133         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['table_info'])
 134                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\'';
 135         PMA_queryAsControlUser($remove_query);
 136     }
 137
 138     if ($cfgRelation['pdfwork']) {
 139         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['pdf_pages'])
 140                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\'';
 141         PMA_queryAsControlUser($remove_query);
 142
 143         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['table_coords'])
 144                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\'';
 145         PMA_queryAsControlUser($remove_query);
 146     }
 147
 148     if ($cfgRelation['designerwork']) {
 149         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['designer_coords'])
 150                     . ' WHERE db_name  = \'' . PMA_Util::sqlAddSlashes($db) . '\'';
 151         PMA_queryAsControlUser($remove_query);
 152     }
 153
 154     if ($cfgRelation['relwork']) {
 155         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['relation'])
 156                     . ' WHERE master_db  = \'' . PMA_Util::sqlAddSlashes($db) . '\'';
 157         PMA_queryAsControlUser($remove_query);
 158
 159         $remove_query = 'DELETE FROM ' . PMA_Util::backquote($cfgRelation['db']) . '.' . PMA_Util::backquote($cfgRelation['relation'])
 160                     . ' WHERE foreign_db  = \'' . PMA_Util::sqlAddSlashes($db) . '\'';
 161         PMA_queryAsControlUser($remove_query);
 162     }
 163 }
 164
 165 ?>