Blame view

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