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