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