libraries/tbl_links.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @version $Id$
   6  * @package phpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * Check parameters
  14  */
  15 require_once './libraries/common.inc.php';
  16
  17 PMA_checkParameters(array('db', 'table'));
  18
  19 /**
  20  * Prepares links
  21  */
  22 require_once './libraries/bookmark.lib.php';
  23
  24
  25 /**
  26  * Set parameters for links
  27  */
  28 $url_params = array();
  29 $url_params['db']    = $db;
  30 $url_params['table'] = $table;
  31
  32 /**
  33  * Defines the urls to return to in case of error in a sql statement
  34  */
  35 $err_url_0 = $cfg['DefaultTabDatabase'] . PMA_generate_common_url(array('db' => $db,));
  36 $err_url   = $cfg['DefaultTabTable'] . PMA_generate_common_url($url_params);
  37
  38 /**
  39  * Displays headers
  40  */
  41 $GLOBALS['js_include'][] = 'functions.js';
  42 require_once './libraries/header.inc.php';
  43
  44 /**
  45  * Displays links
  46  */
  47 $tabs = array();
  48
  49 $tabs['browse']['icon'] = 'b_browse.png';
  50 $tabs['browse']['text'] = __('Browse');
  51 $tabs['browse']['link'] = 'sql.php';
  52 $tabs['browse']['args']['pos'] = 0;
  53
  54 $tabs['structure']['icon'] = 'b_props.png';
  55 $tabs['structure']['link'] = 'tbl_structure.php';
  56 $tabs['structure']['text'] = __('Structure');
  57
  58 $tabs['sql']['icon'] = 'b_sql.png';
  59 $tabs['sql']['link'] = 'tbl_sql.php';
  60 $tabs['sql']['text'] = __('SQL');
  61
  62 $tabs['search']['icon'] = 'b_search.png';
  63 $tabs['search']['text'] = __('Search');
  64 $tabs['search']['link'] = 'tbl_select.php';
  65
  66 if(PMA_Tracker::isActive())
  67 {
  68     $tabs['tracking']['icon'] = 'eye.png';
  69     $tabs['tracking']['text'] = __('Tracking');
  70     $tabs['tracking']['link'] = 'tbl_tracking.php';
  71 }
  72
  73 if (! (isset($db_is_information_schema) && $db_is_information_schema)) {
  74     $tabs['insert']['icon'] = 'b_insrow.png';
  75     $tabs['insert']['link'] = 'tbl_change.php';
  76     $tabs['insert']['text'] = __('Insert');
  77 }
  78
  79 $tabs['export']['icon'] = 'b_tblexport.png';
  80 $tabs['export']['link'] = 'tbl_export.php';
  81 $tabs['export']['args']['single_table'] = 'true';
  82 $tabs['export']['text'] = __('Export');
  83
  84 /**
  85  * Don't display "Import", "Operations" and "Empty"
  86  * for views and information_schema
  87  */
  88 if (! $tbl_is_view && ! (isset($db_is_information_schema) && $db_is_information_schema)) {
  89     $tabs['import']['icon'] = 'b_tblimport.png';
  90     $tabs['import']['link'] = 'tbl_import.php';
  91     $tabs['import']['text'] = __('Import');
  92
  93     $tabs['operation']['icon'] = 'b_tblops.png';
  94     $tabs['operation']['link'] = 'tbl_operations.php';
  95     $tabs['operation']['text'] = __('Operations');
  96
  97     $tabs['empty']['link']  = 'sql.php';
  98     $tabs['empty']['args']['reload']    = 1;
  99     $tabs['empty']['args']['sql_query'] = 'TRUNCATE TABLE ' . PMA_backquote($table);
 100     $tabs['empty']['args']['zero_rows'] = sprintf(__('Table %s has been emptied'), htmlspecialchars($table));
 101     $tabs['empty']['attr']  = 'onclick="return confirmLink(this, \'TRUNCATE TABLE ' . PMA_jsFormat($table) . '\')"';
 102     $tabs['empty']['args']['goto'] = 'tbl_structure.php';
 103     $tabs['empty']['class'] = 'caution';
 104     $tabs['empty']['icon'] = 'b_empty.png';
 105     $tabs['empty']['text'] = __('Empty');
 106     if ($table_info_num_rows == 0) {
 107         $tabs['empty']['warning'] = __('Table seems to be empty!');
 108     }
 109 }
 110
 111 /**
 112  * Views support a limited number of operations
 113  */
 114 if ($tbl_is_view && ! (isset($db_is_information_schema) && $db_is_information_schema)) {
 115     $tabs['operation']['icon'] = 'b_tblops.png';
 116     $tabs['operation']['link'] = 'view_operations.php';
 117     $tabs['operation']['text'] = __('Operations');
 118 }
 119
 120 /**
 121  * no drop in information_schema
 122  */
 123 if (! (isset($db_is_information_schema) && $db_is_information_schema)) {
 124     $tabs['drop']['icon'] = 'b_deltbl.png';
 125     $tabs['drop']['link'] = 'sql.php';
 126     $tabs['drop']['url_params'] = array('table' => NULL);
 127     $tabs['drop']['text'] = __('Drop');
 128     $tabs['drop']['args']['reload']     = 1;
 129     $tabs['drop']['args']['purge']      = 1;
 130     $drop_command = 'DROP ' . ($tbl_is_view ? 'VIEW' : 'TABLE');
 131     $tabs['drop']['args']['sql_query']  = $drop_command . ' ' . PMA_backquote($table);
 132     $tabs['drop']['args']['goto']       = 'db_structure.php';
 133     $tabs['drop']['args']['zero_rows']  = sprintf(($tbl_is_view ? __('View %s has been dropped') : __('Table %s has been dropped')), htmlspecialchars($table));
 134     $tabs['drop']['attr'] = 'onclick="return confirmLink(this, \'' . $drop_command . ' ' . PMA_jsFormat($table) . '\')"';
 135     unset($drop_command);
 136     $tabs['drop']['class'] = 'caution';
 137 }
 138
 139 if ($table_info_num_rows == 0 && !$tbl_is_view) {
 140     $tabs['browse']['warning'] = __('Table seems to be empty!');
 141     $tabs['search']['warning'] = __('Table seems to be empty!');
 142 }
 143
 144 echo PMA_generate_html_tabs($tabs, $url_params);
 145 unset($tabs);
 146
 147 if(PMA_Tracker::isActive() and PMA_Tracker::isTracked($GLOBALS["db"], $GLOBALS["table"]))
 148 {
 149     $msg = PMA_Message::notice('<a href="tbl_tracking.php?'.$url_query.'">'.sprintf(__('Tracking of %s.%s is activated.'), $GLOBALS["db"], $GLOBALS["table"]).'</a>');
 150     $msg->display();
 151 }
 152
 153 /**
 154  * Displays a message
 155  */
 156 if (!empty($message)) {
 157     PMA_showMessage($message);
 158     unset($message);
 159 }
 160
 161 ?>