tbl_move_copy.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @version $Id$
   6  * @package phpMyAdmin
   7  */
   8
   9 /**
  10  * Gets some core libraries
  11  */
  12 require_once './libraries/common.inc.php';
  13 require_once './libraries/Table.class.php';
  14
  15 // Check parameters
  16
  17 PMA_checkParameters(array('db', 'table'));
  18
  19 /**
  20  * Defines the url to return to in case of error in a sql statement
  21  */
  22 $err_url = 'tbl_sql.php?' . PMA_generate_common_url($db, $table);
  23
  24
  25 /**
  26  * Selects the database to work with
  27  */
  28 PMA_DBI_select_db($db);
  29
  30 $goto = $cfg['DefaultTabTable'];
  31
  32 /**
  33  * $_REQUEST['target_db'] could be empty in case we came from an input field
  34  * (when there are many databases, no drop-down)
  35  */
  36 if (empty($_REQUEST['target_db'])) {
  37     $_REQUEST['target_db'] = $db;
  38 }
  39
  40 /**
  41  * A target table name has been sent to this script -> do the work
  42  */
  43 if (PMA_isValid($_REQUEST['new_name'])) {
  44     if ($db == $_REQUEST['target_db'] && $table == $_REQUEST['new_name']) {
  45         if (isset($_REQUEST['submit_move'])) {
  46             $message = PMA_Message::error(__('Can\'t move table to same one!'));
  47         } else {
  48             $message = PMA_Message::error(__('Can\'t copy table to same one!'));
  49         }
  50         $goto = './tbl_operations.php';
  51     } else {
  52         PMA_Table::moveCopy($db, $table, $_REQUEST['target_db'], $_REQUEST['new_name'],
  53             $_REQUEST['what'], isset($_REQUEST['submit_move']), 'one_table');
  54
  55         if (isset($_REQUEST['submit_move'])) {
  56             $message = PMA_Message::success(__('Table %s has been moved to %s.'));
  57         } else {
  58             $message = PMA_Message::success(__('Table %s has been copied to %s.'));
  59         }
  60         $old = PMA_backquote($db) . '.' . PMA_backquote($table);
  61         $message->addParam($old);
  62         $new = PMA_backquote($_REQUEST['target_db']) . '.' . PMA_backquote($_REQUEST['new_name']);
  63         $message->addParam($new);
  64
  65         /* Check: Work on new table or on old table? */
  66         if (isset($_REQUEST['submit_move']) || PMA_isValid($_REQUEST['switch_to_new'])) {
  67             $db        = $_REQUEST['target_db'];
  68             $table     = $_REQUEST['new_name'];
  69         }
  70         $reload = 1;
  71
  72         $disp_query = $sql_query;
  73         $disp_message = $message;
  74         unset($sql_query, $message);
  75
  76         $goto = $cfg['DefaultTabTable'];
  77     }
  78 } else {
  79     /**
  80      * No new name for the table!
  81      */
  82     $message = PMA_Message::error(__('The table name is empty!'));
  83     $goto = './tbl_operations.php';
  84 }
  85
  86 /**
  87  * Back to the calling script
  88  */
  89 require $goto;
  90 ?>