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