Blame view

pma/view_operations.php 2.74 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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
  <?php
  /* vim: set expandtab sw=4 ts=4 sts=4: */
  /**
   *
   * @package PhpMyAdmin
   */
  
  /**
   *
   */
  require_once './libraries/common.inc.php';
  
  $pma_table = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
  
  /**
   * Runs common work
   */
  require './libraries/tbl_common.php';
  $url_query .= '&amp;goto=view_operations.php&amp;back=view_operations.php';
  $url_params['goto'] = $url_params['back'] = 'view_operations.php';
  
  /**
   * Gets tables informations
   */
  
  require './libraries/tbl_info.inc.php';
  $reread_info = false;
  
  /**
   * Updates if required
   */
  if (isset($_REQUEST['submitoptions'])) {
      $_message = '';
      $warning_messages = array();
  
      if (isset($_REQUEST['new_name'])) {
          if ($pma_table->rename($_REQUEST['new_name'], null, $is_view = true)) {
              $_message .= $pma_table->getLastMessage();
              $result = true;
              $GLOBALS['table'] = $pma_table->getName();
              $reread_info = true;
              $reload = true;
          } else {
              $_message .= $pma_table->getLastError();
              $result = false;
          }
      }
  }
  
  /**
   * Displays top menu links
   */
  require_once './libraries/tbl_links.inc.php';
  
  if (isset($result)) {
      // set to success by default, because result set could be empty
      // (for example, a table rename)
      $_type = 'success';
      if (empty($_message)) {
          $_message = $result ? __('Your SQL query has been executed successfully') : __('Error');
          // $result should exist, regardless of $_message
          $_type = $result ? 'success' : 'error';
      }
      if (! empty($warning_messages)) {
          $_message = new PMA_Message;
          $_message->addMessages($warning_messages);
          $_message->isError(true);
          unset($warning_messages);
      }
      PMA_showMessage($_message, $sql_query, $_type, $is_view = true);
      unset($_message, $_type);
  }
  
  $url_params['goto'] = 'view_operations.php';
  $url_params['back'] = 'view_operations.php';
  
  /**
   * Displays the page
   */
  ?>
  <!-- Table operations -->
  <div class="operations_half_width">
  <form method="post" action="view_operations.php">
  <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
  <input type="hidden" name="reload" value="1" />
  <fieldset>
      <legend><?php echo __('Operations'); ?></legend>
  
      <table>
      <!-- Change view name -->
      <tr><td><?php echo __('Rename view to'); ?></td>
          <td><input type="text" size="20" name="new_name" onfocus="this.select()"
                  value="<?php echo htmlspecialchars($GLOBALS['table']); ?>" />
          </td>
      </tr>
      </table>
  </fieldset>
  <fieldset class="tblFooters">
          <input type="submit" name="submitoptions" value="<?php echo __('Go'); ?>" />
  </fieldset>
  </form>
  </div>
  
  <?php
  /**
   * Displays the footer
   */
  require './libraries/footer.inc.php';
  ?>