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
   9 /**
  10  * Cleanup column related relation stuff
  11  *
  12  * @param string $db     database name
  13  * @param string $table  table name
  14  * @param string $column column name
  15  *
  16  * @return void
  17  */
  18 function PMA_relationsCleanupColumn($db, $table, $column)
  19 {
  20     $cfgRelation = PMA_getRelationsParam();
  21
  22     if ($cfgRelation['commwork']) {
  23         $remove_query = 'DELETE FROM '
  24             . PMA\libraries\Util::backquote($cfgRelation['db'])
  25             . '.' . PMA\libraries\Util::backquote($cfgRelation['column_info'])
  26             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\''
  27             . ' AND table_name = \'' . $GLOBALS['dbi']->escapeString($table)
  28             . '\''
  29             . ' AND column_name = \'' . $GLOBALS['dbi']->escapeString($column)
  30             . '\'';
  31         PMA_queryAsControlUser($remove_query);
  32     }
  33
  34     if ($cfgRelation['displaywork']) {
  35         $remove_query = 'DELETE FROM '
  36             . PMA\libraries\Util::backquote($cfgRelation['db'])
  37             . '.' . PMA\libraries\Util::backquote($cfgRelation['table_info'])
  38             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\''
  39             . ' AND table_name = \'' . $GLOBALS['dbi']->escapeString($table)
  40             . '\''
  41             . ' AND display_field = \'' . $GLOBALS['dbi']->escapeString($column)
  42             . '\'';
  43         PMA_queryAsControlUser($remove_query);
  44     }
  45
  46     if ($cfgRelation['relwork']) {
  47         $remove_query = 'DELETE FROM '
  48             . PMA\libraries\Util::backquote($cfgRelation['db'])
  49             . '.' . PMA\libraries\Util::backquote($cfgRelation['relation'])
  50             . ' WHERE master_db  = \'' . $GLOBALS['dbi']->escapeString($db)
  51             . '\''
  52             . ' AND master_table = \'' . $GLOBALS['dbi']->escapeString($table)
  53             . '\''
  54             . ' AND master_field = \'' . $GLOBALS['dbi']->escapeString($column)
  55             . '\'';
  56         PMA_queryAsControlUser($remove_query);
  57
  58         $remove_query = 'DELETE FROM '
  59             . PMA\libraries\Util::backquote($cfgRelation['db'])
  60             . '.' . PMA\libraries\Util::backquote($cfgRelation['relation'])
  61             . ' WHERE foreign_db  = \'' . $GLOBALS['dbi']->escapeString($db)
  62             . '\''
  63             . ' AND foreign_table = \'' . $GLOBALS['dbi']->escapeString($table)
  64             . '\''
  65             . ' AND foreign_field = \'' . $GLOBALS['dbi']->escapeString($column)
  66             . '\'';
  67         PMA_queryAsControlUser($remove_query);
  68     }
  69 }
  70
  71 /**
  72  * Cleanup table related relation stuff
  73  *
  74  * @param string $db    database name
  75  * @param string $table table name
  76  *
  77  * @return void
  78  */
  79 function PMA_relationsCleanupTable($db, $table)
  80 {
  81     $cfgRelation = PMA_getRelationsParam();
  82
  83     if ($cfgRelation['commwork']) {
  84         $remove_query = 'DELETE FROM '
  85             . PMA\libraries\Util::backquote($cfgRelation['db'])
  86             . '.' . PMA\libraries\Util::backquote($cfgRelation['column_info'])
  87             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\''
  88             . ' AND table_name = \'' . $GLOBALS['dbi']->escapeString($table)
  89             . '\'';
  90         PMA_queryAsControlUser($remove_query);
  91     }
  92
  93     if ($cfgRelation['displaywork']) {
  94         $remove_query = 'DELETE FROM '
  95             . PMA\libraries\Util::backquote($cfgRelation['db'])
  96             . '.' . PMA\libraries\Util::backquote($cfgRelation['table_info'])
  97             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\''
  98             . ' AND table_name = \'' . $GLOBALS['dbi']->escapeString($table)
  99             . '\'';
 100         PMA_queryAsControlUser($remove_query);
 101     }
 102
 103     if ($cfgRelation['pdfwork']) {
 104         $remove_query = 'DELETE FROM '
 105             . PMA\libraries\Util::backquote($cfgRelation['db'])
 106             . '.' . PMA\libraries\Util::backquote($cfgRelation['table_coords'])
 107             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\''
 108             . ' AND table_name = \'' . $GLOBALS['dbi']->escapeString($table)
 109             . '\'';
 110         PMA_queryAsControlUser($remove_query);
 111     }
 112
 113     if ($cfgRelation['relwork']) {
 114         $remove_query = 'DELETE FROM '
 115             . PMA\libraries\Util::backquote($cfgRelation['db'])
 116             . '.' . PMA\libraries\Util::backquote($cfgRelation['relation'])
 117             . ' WHERE master_db  = \'' . $GLOBALS['dbi']->escapeString($db)
 118             . '\''
 119             . ' AND master_table = \'' . $GLOBALS['dbi']->escapeString($table)
 120             . '\'';
 121         PMA_queryAsControlUser($remove_query);
 122
 123         $remove_query = 'DELETE FROM '
 124             . PMA\libraries\Util::backquote($cfgRelation['db'])
 125             . '.' . PMA\libraries\Util::backquote($cfgRelation['relation'])
 126             . ' WHERE foreign_db  = \'' . $GLOBALS['dbi']->escapeString($db)
 127             . '\''
 128             . ' AND foreign_table = \'' . $GLOBALS['dbi']->escapeString($table)
 129             . '\'';
 130         PMA_queryAsControlUser($remove_query);
 131     }
 132
 133     if ($cfgRelation['uiprefswork']) {
 134         $remove_query = 'DELETE FROM '
 135             . PMA\libraries\Util::backquote($cfgRelation['db'])
 136             . '.' . PMA\libraries\Util::backquote($cfgRelation['table_uiprefs'])
 137             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\''
 138             . ' AND table_name = \'' . $GLOBALS['dbi']->escapeString($table)
 139             . '\'';
 140         PMA_queryAsControlUser($remove_query);
 141     }
 142
 143     if ($cfgRelation['navwork']) {
 144         $remove_query = 'DELETE FROM '
 145             . PMA\libraries\Util::backquote($cfgRelation['db'])
 146             . '.' . PMA\libraries\Util::backquote($cfgRelation['navigationhiding'])
 147             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\''
 148             . ' AND (table_name = \'' . $GLOBALS['dbi']->escapeString($table)
 149             . '\''
 150             . ' OR (item_name = \'' . $GLOBALS['dbi']->escapeString($table)
 151             . '\''
 152             . ' AND item_type = \'table\'))';
 153         PMA_queryAsControlUser($remove_query);
 154     }
 155 }
 156
 157 /**
 158  * Cleanup database related relation stuff
 159  *
 160  * @param string $db database name
 161  *
 162  * @return void
 163  */
 164 function PMA_relationsCleanupDatabase($db)
 165 {
 166     $cfgRelation = PMA_getRelationsParam();
 167
 168     if ($cfgRelation['commwork']) {
 169         $remove_query = 'DELETE FROM '
 170             . PMA\libraries\Util::backquote($cfgRelation['db'])
 171             . '.' . PMA\libraries\Util::backquote($cfgRelation['column_info'])
 172             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';
 173         PMA_queryAsControlUser($remove_query);
 174     }
 175
 176     if ($cfgRelation['bookmarkwork']) {
 177         $remove_query = 'DELETE FROM '
 178             . PMA\libraries\Util::backquote($cfgRelation['db'])
 179             . '.' . PMA\libraries\Util::backquote($cfgRelation['bookmark'])
 180             . ' WHERE dbase  = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';
 181         PMA_queryAsControlUser($remove_query);
 182     }
 183
 184     if ($cfgRelation['displaywork']) {
 185         $remove_query = 'DELETE FROM '
 186             . PMA\libraries\Util::backquote($cfgRelation['db'])
 187             . '.' . PMA\libraries\Util::backquote($cfgRelation['table_info'])
 188             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';
 189         PMA_queryAsControlUser($remove_query);
 190     }
 191
 192     if ($cfgRelation['pdfwork']) {
 193         $remove_query = 'DELETE FROM '
 194             . PMA\libraries\Util::backquote($cfgRelation['db'])
 195             . '.' . PMA\libraries\Util::backquote($cfgRelation['pdf_pages'])
 196             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';
 197         PMA_queryAsControlUser($remove_query);
 198
 199         $remove_query = 'DELETE FROM '
 200             . PMA\libraries\Util::backquote($cfgRelation['db'])
 201             . '.' . PMA\libraries\Util::backquote($cfgRelation['table_coords'])
 202             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';
 203         PMA_queryAsControlUser($remove_query);
 204     }
 205
 206     if ($cfgRelation['relwork']) {
 207         $remove_query = 'DELETE FROM '
 208             . PMA\libraries\Util::backquote($cfgRelation['db'])
 209             . '.' . PMA\libraries\Util::backquote($cfgRelation['relation'])
 210             . ' WHERE master_db  = \''
 211             . $GLOBALS['dbi']->escapeString($db) . '\'';
 212         PMA_queryAsControlUser($remove_query);
 213
 214         $remove_query = 'DELETE FROM '
 215             . PMA\libraries\Util::backquote($cfgRelation['db'])
 216             . '.' . PMA\libraries\Util::backquote($cfgRelation['relation'])
 217             . ' WHERE foreign_db  = \'' . $GLOBALS['dbi']->escapeString($db)
 218             . '\'';
 219         PMA_queryAsControlUser($remove_query);
 220     }
 221
 222     if ($cfgRelation['uiprefswork']) {
 223         $remove_query = 'DELETE FROM '
 224             . PMA\libraries\Util::backquote($cfgRelation['db'])
 225             . '.' . PMA\libraries\Util::backquote($cfgRelation['table_uiprefs'])
 226             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';
 227         PMA_queryAsControlUser($remove_query);
 228     }
 229
 230     if ($cfgRelation['navwork']) {
 231         $remove_query = 'DELETE FROM '
 232             . PMA\libraries\Util::backquote($cfgRelation['db'])
 233             . '.' . PMA\libraries\Util::backquote($cfgRelation['navigationhiding'])
 234             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';
 235         PMA_queryAsControlUser($remove_query);
 236     }
 237
 238     if ($cfgRelation['savedsearcheswork']) {
 239         $remove_query = 'DELETE FROM '
 240             . PMA\libraries\Util::backquote($cfgRelation['db'])
 241             . '.' . PMA\libraries\Util::backquote($cfgRelation['savedsearches'])
 242             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';
 243         PMA_queryAsControlUser($remove_query);
 244     }
 245
 246     if ($cfgRelation['centralcolumnswork']) {
 247         $remove_query = 'DELETE FROM '
 248             . PMA\libraries\Util::backquote($cfgRelation['db'])
 249             . '.' . PMA\libraries\Util::backquote($cfgRelation['central_columns'])
 250             . ' WHERE db_name  = \'' . $GLOBALS['dbi']->escapeString($db) . '\'';
 251         PMA_queryAsControlUser($remove_query);
 252     }
 253 }
 254
 255 /**
 256  * Cleanup user related relation stuff
 257  *
 258  * @param string $username username
 259  *
 260  * @return void
 261  */
 262 function PMA_relationsCleanupUser($username)
 263 {
 264     $cfgRelation = PMA_getRelationsParam();
 265
 266     if ($cfgRelation['bookmarkwork']) {
 267         $remove_query = "DELETE FROM "
 268             . PMA\libraries\Util::backquote($cfgRelation['db'])
 269             . "." . PMA\libraries\Util::backquote($cfgRelation['bookmark'])
 270             . " WHERE `user`  = '" . $GLOBALS['dbi']->escapeString($username)
 271             . "'";
 272         PMA_queryAsControlUser($remove_query);
 273     }
 274
 275     if ($cfgRelation['historywork']) {
 276         $remove_query = "DELETE FROM "
 277             . PMA\libraries\Util::backquote($cfgRelation['db'])
 278             . "." . PMA\libraries\Util::backquote($cfgRelation['history'])
 279             . " WHERE `username`  = '" . $GLOBALS['dbi']->escapeString($username)
 280             . "'";
 281         PMA_queryAsControlUser($remove_query);
 282     }
 283
 284     if ($cfgRelation['recentwork']) {
 285         $remove_query = "DELETE FROM "
 286             . PMA\libraries\Util::backquote($cfgRelation['db'])
 287             . "." . PMA\libraries\Util::backquote($cfgRelation['recent'])
 288             . " WHERE `username`  = '" . $GLOBALS['dbi']->escapeString($username)
 289             . "'";
 290         PMA_queryAsControlUser($remove_query);
 291     }
 292
 293     if ($cfgRelation['favoritework']) {
 294         $remove_query = "DELETE FROM "
 295             . PMA\libraries\Util::backquote($cfgRelation['db'])
 296             . "." . PMA\libraries\Util::backquote($cfgRelation['favorite'])
 297             . " WHERE `username`  = '" . $GLOBALS['dbi']->escapeString($username)
 298             . "'";
 299         PMA_queryAsControlUser($remove_query);
 300     }
 301
 302     if ($cfgRelation['uiprefswork']) {
 303         $remove_query = "DELETE FROM "
 304             . PMA\libraries\Util::backquote($cfgRelation['db'])
 305             . "." . PMA\libraries\Util::backquote($cfgRelation['table_uiprefs'])
 306             . " WHERE `username`  = '" . $GLOBALS['dbi']->escapeString($username)
 307             . "'";
 308         PMA_queryAsControlUser($remove_query);
 309     }
 310
 311     if ($cfgRelation['userconfigwork']) {
 312         $remove_query = "DELETE FROM "
 313             . PMA\libraries\Util::backquote($cfgRelation['db'])
 314             . "." . PMA\libraries\Util::backquote($cfgRelation['userconfig'])
 315             . " WHERE `username`  = '" . $GLOBALS['dbi']->escapeString($username)
 316             . "'";
 317         PMA_queryAsControlUser($remove_query);
 318     }
 319
 320     if ($cfgRelation['menuswork']) {
 321         $remove_query = "DELETE FROM "
 322             . PMA\libraries\Util::backquote($cfgRelation['db'])
 323             . "." . PMA\libraries\Util::backquote($cfgRelation['users'])
 324             . " WHERE `username`  = '" . $GLOBALS['dbi']->escapeString($username)
 325             . "'";
 326         PMA_queryAsControlUser($remove_query);
 327     }
 328
 329     if ($cfgRelation['navwork']) {
 330         $remove_query = "DELETE FROM "
 331             . PMA\libraries\Util::backquote($cfgRelation['db'])
 332             . "." . PMA\libraries\Util::backquote($cfgRelation['navigationhiding'])
 333             . " WHERE `username`  = '" . $GLOBALS['dbi']->escapeString($username)
 334             . "'";
 335         PMA_queryAsControlUser($remove_query);
 336     }
 337
 338     if ($cfgRelation['savedsearcheswork']) {
 339         $remove_query = "DELETE FROM "
 340             . PMA\libraries\Util::backquote($cfgRelation['db'])
 341             . "." . PMA\libraries\Util::backquote($cfgRelation['savedsearches'])
 342             . " WHERE `username`  = '" . $GLOBALS['dbi']->escapeString($username)
 343             . "'";
 344         PMA_queryAsControlUser($remove_query);
 345     }
 346
 347     if ($cfgRelation['designersettingswork']) {
 348         $remove_query = "DELETE FROM "
 349             . PMA\libraries\Util::backquote($cfgRelation['db'])
 350             . "." . PMA\libraries\Util::backquote($cfgRelation['designer_settings'])
 351             . " WHERE `username`  = '" . $GLOBALS['dbi']->escapeString($username)
 352             . "'";
 353         PMA_queryAsControlUser($remove_query);
 354     }
 355 }
 356