pmd_general.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * @package PhpMyAdmin-Designer
   5  */
   6
   7 /**
   8  *
   9  */
  10 require_once './libraries/common.inc.php';
  11 require_once 'libraries/pmd_common.php';
  12 require 'libraries/db_common.inc.php';
  13 require 'libraries/db_info.inc.php';
  14
  15 /**
  16  * Sets globals from $_GET
  17  */
  18 $get_params = array(
  19     'db',
  20     'table',
  21     'token'
  22 );
  23 foreach ($get_params as $one_get_param) {
  24     if (isset($_GET[$one_get_param])) {
  25         $GLOBALS[$one_get_param] = $_GET[$one_get_param];
  26     }
  27 }
  28
  29 $tab_column       = get_tab_info();
  30 $script_tabs      = get_script_tabs();
  31 $script_contr     = get_script_contr();
  32 $tab_pos          = get_tab_pos();
  33 $tables_pk_or_unique_keys = get_pk_or_unique_keys();
  34 $tables_all_keys  = get_all_keys();
  35
  36 $params = array('lang' => $GLOBALS['lang']);
  37 if (isset($GLOBALS['db'])) {
  38     $params['db'] = $GLOBALS['db'];
  39 }
  40 require_once 'libraries/header_scripts.inc.php';
  41 ?>
  42     <script type="text/javascript">
  43     // <![CDATA[
  44 <?php
  45 echo '
  46     var server = "' . PMA_escapeJsString($server) . '";
  47     var db = "' . PMA_escapeJsString($db) . '";
  48     var token = "' . PMA_escapeJsString($token) . '";';
  49     echo "\n";
  50     if (isset($_REQUEST['query'])) {
  51     echo '
  52      $(function() {
  53         $(".trigger").click(function() {
  54         $(".panel").toggle("fast");
  55         $(this).toggleClass("active");
  56         return false;
  57         });
  58     });';
  59     }
  60 ?>
  61     // ]]>
  62     </script>
  63     <script src="js/pmd/ajax.js" type="text/javascript"></script>
  64     <script src="js/pmd/history.js" type="text/javascript"></script>
  65     <script src="js/pmd/move.js" type="text/javascript"></script>
  66     <!--[if IE]>
  67     <script src="js/pmd/iecanvas.js" type="text/javascript"></script>
  68     <![endif]-->
  69 <?php
  70 echo $script_tabs . $script_contr . $script_display_field;
  71 ?>
  72
  73 </head>
  74 <body onload="Main()" class="general_body" id="pmd_body">
  75
  76 <div class="pmd_header" id="top_menu">
  77         <a href="#"
  78             onclick="Show_left_menu(document.getElementById('key_Show_left_menu')); return false" class="M_butt first" target="_self">
  79             <img id='key_Show_left_menu' title="<?php echo __('Show/Hide left menu'); ?>"
  80                 alt="v" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/downarrow2_m.png" /></a>
  81         <a href="#" onclick="Save2(); return false"
  82             class="M_butt" target="_self"
  83         ><img title="<?php echo __('Save position') ?>" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/save.png" alt=""
  84         /></a><a href="#" onclick="Start_table_new(); return false"
  85             class="M_butt" target="_self"
  86         ><img title="<?php echo __('Create table')?>" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/table.png" alt=""
  87         /></a><a href="#" onclick="Start_relation(); return false"
  88             class="M_butt" id="rel_button" target="_self"
  89         ><img title="<?php echo __('Create relation') ?>" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/relation.png" alt=""
  90         /></a><a href="#" onclick="Start_display_field(); return false"
  91             class="M_butt" id="display_field_button" target="_self"
  92         ><img title="<?php echo __('Choose column to display') ?>" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/display_field.png" alt=""
  93         /></a><a href="#" onclick="location.reload(); return false"
  94             class="M_butt" target="_self"
  95         ><img title="<?php echo __('Reload'); ?>" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/reload.png" alt=""
  96         /></a><a href="Documentation.html#faq6_31" target="documentation"
  97             class="M_butt" target="_self"
  98         ><img title="<?php echo __('Help'); ?>" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/help.png" alt=""
  99         /></a><img class="M_bord" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/bord.png" alt=""
 100         /><a href="#" onclick="Angular_direct(); return false"
 101             class="M_butt" id="angular_direct_button" target="_self"
 102         ><img title="<?php echo __('Angular links') . ' / ' . __('Direct links'); ?>"
 103                 src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/ang_direct.png" alt=""
 104         /></a><a href="#" onclick="Grid(); return false"
 105             class="M_butt" id="grid_button" target="_self"
 106         ><img title="<?php echo __('Snap to grid') ?>" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/grid.png" alt=""
 107         /></a><img class="M_bord" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/bord.png" alt=""
 108         /><a href="#"
 109             onclick="Small_tab_all(document.getElementById('key_SB_all')); return false" class="M_butt" target="_self"
 110         ><img id='key_SB_all' title="<?php echo __('Small/Big All'); ?>" alt="v"
 111                 src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/downarrow1.png"
 112         /></a>
 113 <a href="#" onclick="Small_tab_invert(); return false" class="M_butt" target="_self" ><img title="<?php echo __('Toggle small/big'); ?>" alt="key" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/bottom.png" /></a>
 114 <a href="#" onclick="Relation_lines_invert(); return false" class="M_butt" target="_self" ><img title="<?php echo __('Toggle relation lines'); ?>" alt="key" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/toggle_lines.png" /></a>
 115 <img class="M_bord" src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/bord.png" alt="" />
 116 <a href="#" onclick="PDF_save(); return false"
 117             class="M_butt" target="_self"
 118         ><img src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/pdf.png" alt="key" width="20" height="20"
 119                 title="<?php echo __('Import/Export coordinates for PDF schema'); ?>" /></a
 120          >
 121         <?php if (isset($_REQUEST['query'])) {
 122             echo '<a href="#" onclick="build_query(\'SQL Query on Database\', 0)" onmousedown="return false;"
 123             class="M_butt" target="_self">';
 124             echo '<img src="'. $GLOBALS['pmaThemeImage'] . 'pmd/query_builder.png" alt="key" width="20" height="20" title="';
 125             echo __('Build Query');
 126             echo '"/></a>'; }?>
 127          <a href="#"
 128             onclick="Top_menu_right(document.getElementById('key_Left_Right')); return false" class="M_butt last" target="_self">
 129             <img src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/2rightarrow_m.png" id="key_Left_Right" alt=">"
 130                 title="<?php echo __('Move Menu'); ?>" /></a>
 131 </div>
 132
 133 <form action="" method="post" name="form1">
 134 <div id="osn_tab">
 135   <canvas class="pmd" id="canvas" width="100" height="100" onclick="Canvas_click(this)"></canvas>
 136 </div>
 137 <div id="layer_menu" style="display:none;">
 138 <div class="center" style="padding-top:5px;">
 139     <a href="#"
 140         onclick="Hide_tab_all(document.getElementById('key_HS_all')); return false" class="M_butt" target="_self">
 141     <img title="<?php echo __('Hide/Show all'); ?>" alt="v"
 142         src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/downarrow1.png" id='key_HS_all' /></a>
 143     <a href="#"
 144         onclick="No_have_constr(document.getElementById('key_HS')); return false" class="M_butt" target="_self">
 145     <img title="<?php echo __('Hide/Show Tables with no relation'); ?>" alt="v"
 146         src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/downarrow2.png" id='key_HS' /></a>
 147 </div>
 148
 149 <div id="id_scroll_tab" class="scroll_tab">
 150     <table width="100%" style="padding-left: 3px;">
 151 <?php
 152 $name_cnt = count($GLOBALS['PMD']['TABLE_NAME']);
 153 for ($i = 0; $i < $name_cnt; $i++) {
 154     ?>
 155     <tr><td title="<?php echo __('Structure'); ?>" width="1px"
 156             onmouseover="this.className='L_butt2_2'"
 157             onmouseout="this.className='L_butt2_1'">
 158             <img onclick="Start_tab_upd('<?php echo $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i]; ?>');"
 159                 src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/exec.png" alt="" /></td>
 160         <td width="1px">
 161             <input onclick="VisibleTab(this,'<?php echo $GLOBALS['PMD_URL']["TABLE_NAME"][$i]; ?>')"
 162                 title="<?php echo __('Hide'); ?>"
 163                 id="check_vis_<?php echo $GLOBALS['PMD_URL']["TABLE_NAME"][$i]; ?>"
 164                 style="margin:0px;" type="checkbox"
 165                 value="<?php echo $GLOBALS['PMD_URL']["TABLE_NAME"][$i]; ?>"
 166                 <?php
 167                 if (isset($tab_pos[$GLOBALS['PMD']["TABLE_NAME"][$i]])) {
 168                     echo $tab_pos[$GLOBALS['PMD']["TABLE_NAME"][$i]]["H"] ? 'checked="checked"' : '';
 169                 } else {
 170                     echo 'checked="checked"';
 171                 }
 172                 ?> /></td>
 173         <td class="pmd_Tabs" onmouseover="this.className='pmd_Tabs2'"
 174             onmouseout="this.className='pmd_Tabs'"
 175             onclick="Select_tab('<?php echo $GLOBALS['PMD_URL']["TABLE_NAME"][$i]; ?>');">
 176             <?php echo $GLOBALS['PMD_OUT']["TABLE_NAME"][$i]; ?></td>
 177     </tr>
 178     <?php
 179 }
 180 ?>
 181     </table>
 182 </div>
 183
 184 <div class="center">
 185     <?php echo __('Number of tables') . ': ' . $name_cnt; ?>
 186 </div>
 187 <div class="right">
 188     <div id="layer_menu_sizer" onmousedown="layer_menu_cur_click=1">
 189     </div>
 190 </div>
 191 </div>
 192
 193
 194 <?php
 195 for ($i = 0; $i < count($GLOBALS['PMD']["TABLE_NAME"]); $i++) {
 196     $t_n = $GLOBALS['PMD']["TABLE_NAME"][$i];
 197     $t_n_url = $GLOBALS['PMD_URL']["TABLE_NAME"][$i];
 198
 199     ?>
 200 <input name="t_x[<?php echo $t_n_url ?>]" type="hidden" id="t_x_<?php echo $t_n_url ?>_" />
 201 <input name="t_y[<?php echo $t_n_url ?>]" type="hidden" id="t_y_<?php echo $t_n_url ?>_" />
 202 <input name="t_v[<?php echo $t_n_url ?>]" type="hidden" id="t_v_<?php echo $t_n_url ?>_" />
 203 <input name="t_h[<?php echo $t_n_url ?>]" type="hidden" id="t_h_<?php echo $t_n_url ?>_" />
 204
 205 <table id="<?php echo $t_n_url ?>" cellpadding="0" cellspacing="0" class="pmd_tab"
 206    style="position: absolute;
 207           left: <?php if (isset($tab_pos[$t_n])) echo $tab_pos[$t_n]["X"]; else echo rand(180, 800); ?>px;
 208           top: <?php if (isset($tab_pos[$t_n])) echo $tab_pos[$t_n]["Y"]; else echo rand(30, 500); ?>px;
 209           visibility: <?php if (isset($tab_pos[$t_n])) echo $tab_pos[$t_n]["H"] ? "visible" : "hidden"; ?>;
 210          ">
 211 <thead>
 212 <tr>
 213     <?php
 214     if (isset($_REQUEST['query'])) {
 215         echo '<td class="select_all">';
 216         echo '<input type="checkbox" value="select_all_'.htmlspecialchars($t_n_url).'" style="margin: 0px;" ';
 217         echo 'id="select_all_'.htmlspecialchars($t_n_url).'" title="select all" ';
 218         echo 'onclick="Select_all(\''. htmlspecialchars($t_n_url) .'\',\''.htmlspecialchars($GLOBALS['PMD_OUT']["OWNER"][$i]).'\')"></td>';
 219     }?>
 220     <td class="small_tab" onmouseover="this.className='small_tab2';"
 221         onmouseout="this.className='small_tab';"
 222         id="id_hide_tbody_<?php echo $t_n_url ?>"
 223         onclick="Small_tab('<?php echo $t_n_url ?>', 1)"><?php
 224         // no space alloawd here, between tags and content !!!
 225         // JavaScript function does require this
 226         if (! isset($tab_pos[$t_n]) || ! empty($tab_pos[$t_n]["V"])) {
 227             echo 'v';
 228         } else {
 229             echo '&gt;';
 230         }
 231         ?></td>
 232     <td class="small_tab_pref" onmouseover="this.className='small_tab_pref2';"
 233         onmouseout="this.className='small_tab_pref';"
 234         onclick="Start_tab_upd('<?php echo $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i]; ?>');">
 235         <img src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/exec_small.png" alt="" /></td>
 236     <td id="id_zag_<?php echo $t_n_url ?>" class="tab_zag nowrap"
 237         onmousedown="cur_click=document.getElementById('<?php echo $t_n_url ?>');"/
 238         onmouseover="Table_onover('<?php echo $t_n_url ?>',0,<?php echo (isset($_REQUEST['query'])? 1 : 0 )?> )"
 239         onmouseout="Table_onover('<?php echo $t_n_url ?>',1,<?php echo (isset($_REQUEST['query']) ? 1 : 0 )?>)">
 240         <span class='owner'>
 241         <?php
 242         echo $GLOBALS['PMD_OUT']["OWNER"][$i];
 243         echo '.</span>';
 244         echo $GLOBALS['PMD_OUT']["TABLE_NAME_SMALL"][$i];
 245         ?></td>
 246     <?php
 247     if (isset($_REQUEST['query'])) {
 248         echo '<td class="tab_zag"  onmouseover="Table_onover(\''.htmlspecialchars($t_n_url).'\',0,1)"  id="id_zag_'.htmlspecialchars($t_n_url).'_2"';
 249         echo 'onmousedown="cur_click=document.getElementById(\''.htmlspecialchars($t_n_url).'\');"';
 250         echo 'onmouseout="Table_onover(\''.htmlspecialchars($t_n_url).'\',1,1)">';
 251     }?>
 252 </tr>
 253 </thead>
 254 <tbody id="id_tbody_<?php echo $t_n_url ?>"
 255     <?php
 256     if (isset($tab_pos[$t_n]) && empty($tab_pos[$t_n]["V"])) {
 257         echo 'style="display: none;"';
 258     }?>>
 259     <?php
 260     $display_field = PMA_getDisplayField($db, $GLOBALS['PMD']["TABLE_NAME_SMALL"][$i]);
 261     for ($j = 0, $id_cnt = count($tab_column[$t_n]["COLUMN_ID"]); $j < $id_cnt; $j++) {
 262         ?>
 263 <tr id="id_tr_<?php
 264         echo $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i] . '.'
 265             . urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]) ?>"
 266         <?php
 267         if ($display_field == $tab_column[$t_n]["COLUMN_NAME"][$j]) {
 268             echo ' class="tab_field_3" ';
 269         } else {
 270             echo ' class="tab_field" ';
 271         }
 272         ?>
 273     onmouseover="old_class = this.className; this.className = 'tab_field_2';"
 274     onmouseout="this.className = old_class;"
 275     onmousedown="Click_field('<?php
 276         echo $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i]."','".urlencode($tab_column[$t_n]["COLUMN_NAME"][$j])."',";
 277         if (! PMA_foreignkey_supported($GLOBALS['PMD']['TABLE_TYPE'][$i])) {
 278             echo (isset($tables_pk_or_unique_keys[$t_n . "." . $tab_column[$t_n]["COLUMN_NAME"][$j]]) ? 1 : 0);
 279         } else {
 280             // if foreign keys are supported, it's not necessary that the
 281             // index is a primary key
 282             echo (isset($tables_all_keys[$t_n.".".$tab_column[$t_n]["COLUMN_NAME"][$j]]) ? 1 : 0);
 283         }
 284         ?>)">
 285     <?php
 286     if (isset($_REQUEST['query'])) {
 287         echo '<td class="select_all">';
 288         echo '<input value="'.htmlspecialchars($t_n_url).urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]).'"';
 289         echo 'type="checkbox" id="select_'.htmlspecialchars($t_n_url).'._'.urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]).'" ';
 290         echo 'style="margin: 0px;" title="select_'.urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]).'" ';
 291         echo 'onclick="store_column(\''.urlencode($GLOBALS['PMD_OUT']["TABLE_NAME_SMALL"][$i]).'\',\''.htmlspecialchars($GLOBALS['PMD_OUT']["OWNER"][$i]).'\',\''.urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]).'\')"></td>';
 292     }?>
 293     <td width="10px" colspan="3"
 294         id="<?php echo $t_n_url.".".urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]) ?>">
 295         <div class="nowrap">
 296         <?php
 297         if (isset($tables_pk_or_unique_keys[$t_n.".".$tab_column[$t_n]["COLUMN_NAME"][$j]])) {
 298             ?>
 299                 <img src="<?php echo $_SESSION['PMA_Theme']->getImgPath(); ?>pmd/FieldKey_small.png"
 300                     alt="*" />
 301             <?php
 302         } else {
 303             ?>
 304                     <img src="<?php echo $_SESSION['PMA_Theme']->getImgPath(); ?>pmd/Field_small<?php
 305             if (strstr($tab_column[$t_n]["TYPE"][$j], 'char')
 306                 || strstr($tab_column[$t_n]["TYPE"][$j], 'text')
 307             ) {
 308                 echo '_char';
 309             } elseif (strstr($tab_column[$t_n]["TYPE"][$j], 'int')
 310                 || strstr($tab_column[$t_n]["TYPE"][$j], 'float')
 311                 || strstr($tab_column[$t_n]["TYPE"][$j], 'double')
 312                 || strstr($tab_column[$t_n]["TYPE"][$j], 'decimal')
 313             ) {
 314                 echo '_int';
 315             } elseif (strstr($tab_column[$t_n]["TYPE"][$j], 'date')
 316                 || strstr($tab_column[$t_n]["TYPE"][$j], 'time')
 317                 || strstr($tab_column[$t_n]["TYPE"][$j], 'year')
 318             ) {
 319                 echo '_date';
 320             }
 321             ?>.png" alt="*" />
 322             <?php
 323         }
 324         echo htmlspecialchars(
 325             $tab_column[$t_n]["COLUMN_NAME"][$j] . " : " . $tab_column[$t_n]["TYPE"][$j],
 326             ENT_QUOTES
 327         );
 328         ?>
 329         </div>
 330    </td>
 331    <?php
 332    if (isset($_REQUEST['query'])) {
 333        //$temp = $GLOBALS['PMD_OUT']["OWNER"][$i].'.'.$GLOBALS['PMD_OUT']["TABLE_NAME_SMALL"][$i];
 334        echo '<td class="small_tab_pref" onmouseover="this.className=\'small_tab_pref2\';"';
 335        echo 'onmouseout="this.className=\'small_tab_pref\';"';
 336        echo 'onclick="Click_option(\'pmd_optionse\',\''.urlencode($tab_column[$t_n]["COLUMN_NAME"][$j]).'\',\''.$GLOBALS['PMD_OUT']["TABLE_NAME_SMALL"][$i].'\')" >';
 337        echo  '<img src="' . $GLOBALS['pmaThemeImage'] . 'pmd/exec_small.png" title="options" alt="" /></td> ';
 338     } ?>
 339 </tr>
 340         <?php
 341     }
 342     ?>
 343 </tbody>
 344 </table>
 345     <?php
 346 }
 347 ?>
 348 </form>
 349 <div id="pmd_hint"></div>
 350
 351 <table id="layer_new_relation" style="display:none;"
 352     width="5%" cellpadding="0" cellspacing="0">
 353 <tbody>
 354 <tr>
 355     <td class="frams1" width="10px"></td>
 356     <td class="frams5" width="99%" ></td>
 357     <td class="frams2" width="10px"><div class="bor"></div></td>
 358 </tr>
 359 <tr>
 360     <td class="frams8"></td>
 361     <td class="input_tab">
 362         <table width="168" class="center" cellpadding="2" cellspacing="0">
 363         <thead>
 364         <tr>
 365             <td colspan="2" class="center nowrap"><strong><?php echo __('Create relation'); ?></strong></td>
 366         </tr>
 367         </thead>
 368         <tbody id="foreign_relation">
 369         <tr>
 370         <td colspan="2" class="center nowrap"><strong>FOREIGN KEY</strong></td>
 371         </tr>
 372         <tr>
 373             <td width="58" class="nowrap">on delete</td>
 374             <td width="102"><select name="on_delete" id="on_delete">
 375                     <option value="nix" selected="selected">--</option>
 376                     <option value="CASCADE">CASCADE</option>
 377                     <option value="SET NULL">SET NULL</option>
 378                     <option value="NO ACTION">NO ACTION</option>
 379                     <option value="RESTRICT">RESTRICT</option>
 380                 </select>
 381             </td>
 382         </tr>
 383         <tr>
 384             <td class="nowrap">on update</td>
 385             <td><select name="on_update" id="on_update">
 386                     <option value="nix" selected="selected">--</option>
 387                     <option value="CASCADE">CASCADE</option>
 388                     <option value="SET NULL">SET NULL</option>
 389                     <option value="NO ACTION">NO ACTION</option>
 390                     <option value="RESTRICT">RESTRICT</option>
 391                 </select>
 392             </td>
 393         </tr>
 394         </tbody>
 395         <tbody>
 396         <tr>
 397             <td colspan="2" class="center nowrap">
 398                 <input type="button" class="butt" name="Button"
 399                     value="<?php echo __('OK'); ?>" onclick="New_relation()" />
 400                 <input type="button" class="butt" name="Button"
 401                     value="<?php echo __('Cancel'); ?>"
 402                     onclick="document.getElementById('layer_new_relation').style.display = 'none';" />
 403             </td>
 404         </tr>
 405         </tbody>
 406         </table>
 407     </td>
 408     <td class="frams6"></td>
 409 </tr>
 410 <tr>
 411     <td class="frams4"><div class="bor"></div></td>
 412     <td class="frams7"></td>
 413     <td class="frams3"></td>
 414 </tr>
 415 </tbody>
 416 </table>
 417
 418 <table id="layer_upd_relation" style="display:none;"
 419     width="5%" cellpadding="0" cellspacing="0">
 420 <tbody>
 421 <tr>
 422     <td class="frams1" width="10px"></td>
 423     <td class="frams5" width="99%"></td>
 424     <td class="frams2" width="10px"><div class="bor"></div></td>
 425 </tr>
 426 <tr>
 427     <td class="frams8"></td>
 428     <td class="input_tab">
 429         <table width="100%" class="center" cellpadding="2" cellspacing="0">
 430         <tr>
 431             <td colspan="3" class="center nowrap"><strong><?php echo __('Delete relation'); ?></strong></td>
 432         </tr>
 433         <tr>
 434             <td colspan="3" class="center nowrap">
 435                 <input name="Button" type="button" class="butt"
 436                     onclick="Upd_relation()" value="<?php echo __('Delete'); ?>" />
 437                 <input type="button" class="butt" name="Button"
 438                     value="<?php echo __('Cancel'); ?>"
 439                     onclick="document.getElementById('layer_upd_relation').style.display = 'none'; Re_load();" />
 440             </td>
 441         </tr>
 442     </table></td>
 443     <td class="frams6"></td>
 444 </tr>
 445 <tr>
 446     <td class="frams4"><div class="bor"></div></td>
 447     <td class="frams7"></td>
 448     <td class="frams3"></td>
 449 </tr>
 450 </tbody>
 451 </table>
 452
 453 <table id="pmd_optionse" style="display:none;"
 454     width="5%" cellpadding="0" cellspacing="0">
 455 <tbody>
 456 <tr>
 457     <td class="frams1" width="10px"></td>
 458     <td class="frams5" width="99%" ></td>
 459     <td class="frams2" width="10px"><div class="bor"></div></td>
 460 </tr>
 461 <tr>
 462     <td class="frams8"></td>
 463     <td class="input_tab">
 464         <table width="168" class="center" cellpadding="2" cellspacing="0">
 465        <thead>
 466         <tr>
 467             <td colspan="2" rowspan="2" id="option_col_name" class="center nowrap"></td>
 468         </tr>
 469         </thead>
 470         <tbody id="where">
 471         <tr><td class="center nowrap"><b>WHERE</b></td></tr>
 472         <tr>
 473         <td width="58" class="nowrap"><?php echo __('Relation operator'); ?></td>
 474             <td width="102"><select name="rel_opt" id="rel_opt">
 475                     <option value="--" selected="selected"> -- </option>
 476                     <option value="="> = </option>
 477                     <option value="&gt;"> &gt; </option>
 478                     <option value="&lt;"> &lt; </option>
 479                     <option value="&gt;="> &gt;= </option>
 480                     <option value="&lt;="> &lt;= </option>
 481                     <option value="NOT"> NOT </option>
 482                     <option value="IN"> IN </option>
 483                     <option value="EXCEPT"> <?php echo __('Except'); ?> </option>
 484                     <option value="NOT IN"> NOT IN </option>
 485                 </select>
 486             </td>
 487         </tr>
 488         <tr>
 489         <td class="nowrap"><?php echo __('Value'); ?>/<br /><?php echo __('subquery'); ?></td>
 490             <td><textarea id="Query" value="" cols="18"></textarea>
 491             </td>
 492         </tr>
 493         <tr><td class="center nowrap"><b><?php echo __('Rename to'); ?></b></td></tr>
 494         <tr>
 495         <td width="58" class="nowrap"><?php echo __('New name'); ?></td>
 496             <td width="102"><input type="text" value="" id="new_name"/></td>
 497         </tr>
 498         <tr><td class="center nowrap"><b><?php echo __('Aggregate'); ?></b></td></tr>
 499          <tr>
 500          <td width="58" class="nowrap"><?php echo __('Operator'); ?></td>
 501             <td width="102"><select name="operator" id="operator">
 502                     <option value="---" selected="selected">---</option>
 503                     <option value="sum" > SUM </option>
 504                     <option value="min"> MIN </option>
 505                     <option value="max"> MAX </option>
 506                     <option value="avg"> AVG </option>
 507                     <option value="count"> COUNT </option>
 508                     </select>
 509            </td></tr>
 510            <tr>
 511                 <td width="58" class="center nowrap"><b>GROUP BY</b></td>
 512                 <td><input type="checkbox" value="groupby" id="groupby"/></td>
 513            </tr>
 514            <tr>
 515                 <td width="58" class="center nowrap"><b>ORDER BY</b></td>
 516                 <td><input type="checkbox" value="orderby" id="orderby"/></td>
 517            </tr>
 518           <tr><td class="center nowrap"><b>HAVING</b></td></tr>
 519           <tr>
 520           <td width="58" class="nowrap"><?php echo __('Operator'); ?></td>
 521             <td width="102"><select name="h_operator" id="h_operator">
 522                     <option value="---" selected="selected">---</option>
 523                     <option value="None" > <?php echo __('None'); ?> </option>
 524                     <option value="sum" > SUM </option>
 525                     <option value="min"> MIN </option>
 526                     <option value="max"> MAX </option>
 527                     <option value="avg"> AVG </option>
 528                     <option value="count"> COUNT </option>
 529                     </select>
 530                </td></tr>
 531             <tr>
 532             <td width="58" class="nowrap"><?php echo __('Relation operator'); ?></td>
 533             <td width="102"><select name="h_rel_opt" id="h_rel_opt">
 534                     <option value="--" selected="selected"> -- </option>
 535                     <option value="="> = </option>
 536                     <option value="&gt;"> &gt; </option>
 537                     <option value="&lt;"> &lt; </option>
 538                     <option value="&gt;="> &gt;= </option>
 539                     <option value="&lt;="> &lt;= </option>
 540                     <option value="NOT"> NOT </option>
 541                     <option value="IN"> IN </option>
 542                     <option value="EXCEPT"> <?php echo __('Except'); ?> </option>
 543                     <option value="NOT IN"> NOT IN </option>
 544                 </select>
 545             </td>
 546             </tr>
 547             <tr>
 548             <td width="58" class="nowrap"><?php echo __('Value'); ?>/<br/><?php echo __('subquery'); ?></td>
 549                 <td width="102"><textarea id="having" value="" cols="18"></textarea></td>
 550             </tr>
 551         </tbody>
 552         <tbody>
 553         <tr>
 554             <td colspan="2" class="center nowrap">
 555                 <input type="button" class="butt" name="Button"
 556                     value="<?php echo __('OK'); ?>" onclick="add_object()" />
 557                 <input type="button" class="butt" name="Button"
 558                     value="<?php echo __('Cancel'); ?>"
 559                     onclick="Close_option()" />
 560             </td>
 561         </tr>
 562         </tbody>
 563         </table>
 564     </td>
 565     <td class="frams6"></td>
 566 </tr>
 567 <tr>
 568     <td class="frams4"><div class="bor"></div></td>
 569     <td class="frams7"></td>
 570     <td class="frams3"></td>
 571 </tr>
 572 </tbody>
 573 </table>
 574
 575 <table id="query_rename_to" style="display:none;"
 576     width="5%" cellpadding="0" cellspacing="0">
 577 <tbody>
 578 <tr>
 579     <td class="frams1" width="10px"></td>
 580     <td class="frams5" width="99%" ></td>
 581     <td class="frams2" width="10px"><div class="bor"></div></td>
 582 </tr>
 583 <tr>
 584     <td class="frams8"></td>
 585     <td class="input_tab">
 586         <table width="168" class="center" cellpadding="2" cellspacing="0">
 587         <thead>
 588         <tr>
 589         <td colspan="2" class="center nowrap"><strong><?php echo __('Rename to'); ?></strong></td>
 590         </tr>
 591         </thead>
 592         <tbody id="rename_to">
 593         <tr>
 594         <td width="58" class="nowrap"><?php echo __('New name'); ?></td>
 595             <td width="102">
 596                 <input type="text" value="" id="e_rename"/>
 597             </td>
 598         </tr>
 599         </tbody>
 600         <tbody>
 601         <tr>
 602             <td colspan="2" class="center nowrap">
 603                 <input type="button" class="butt" name="Button"
 604                     value="<?php echo __('OK'); ?>" onclick="edit('Rename')" />
 605                 <input type="button" class="butt" name="Button"
 606                     value="<?php echo __('Cancel'); ?>"
 607                     onclick="document.getElementById('query_rename_to').style.display = 'none';" />
 608             </td>
 609         </tr>
 610         </tbody>
 611         </table>
 612     </td>
 613     <td class="frams6"></td>
 614 </tr>
 615 <tr>
 616     <td class="frams4"><div class="bor"></div></td>
 617     <td class="frams7"></td>
 618     <td class="frams3"></td>
 619 </tr>
 620 </tbody>
 621 </table>
 622
 623 <table id="query_having" style="display:none;"
 624     width="5%" cellpadding="0" cellspacing="0">
 625 <tbody>
 626     <tr>
 627         <td class="frams1" width="10px"></td>
 628         <td class="frams5" width="99%" ></td>
 629         <td class="frams2" width="10px"><div class="bor"></div></td>
 630     </tr>
 631 <tr>
 632     <td class="frams8"></td>
 633     <td class="input_tab">
 634     <table width="168" class="center" cellpadding="2" cellspacing="0">
 635        <thead>
 636         <tr>
 637           <td colspan="2" class="center nowrap"><strong>HAVING</strong></td>
 638         </tr>
 639         </thead>
 640         <tbody id="rename_to">
 641         <tr>
 642         <td width="58" class="nowrap"><?php echo __('Operator'); ?></td>
 643             <td width="102"><select name="hoperator" id="hoperator">
 644                     <option value="---" selected="selected">---</option>
 645                     <option value="None" > None </option>
 646                     <option value="sum" > SUM </option>
 647                     <option value="min"> MIN </option>
 648                     <option value="max"> MAX </option>
 649                     <option value="avg"> AVG </option>
 650                     <option value="count"> COUNT </option>
 651                     </select>
 652            </td></tr>
 653         <tr>
 654         <tr>
 655         <td width="58" class="nowrap"><?php echo __('Operator'); ?></td>
 656             <td width="102"><select name="hrel_opt" id="hrel_opt">
 657                 <option value="--" selected="selected"> -- </option>
 658                     <option value="="> = </option>
 659                     <option value="&gt;"> &gt; </option>
 660                     <option value="&lt;"> &lt; </option>
 661                     <option value="&gt;="> &gt;= </option>
 662                     <option value="&lt;="> &lt;= </option>
 663                     <option value="NOT"> NOT </option>
 664                     <option value="IN"> IN </option>
 665                     <option value="EXCEPT"> <?php echo __('Except'); ?> </option>
 666                     <option value="NOT IN"> NOT IN </option>
 667                 </select>
 668             </td>
 669         </tr>
 670         <tr>
 671         <td class="nowrap"><?php echo __('Value'); ?>/<br /><?php echo __('subquery'); ?></td>
 672             <td><textarea id="hQuery" value="" cols="18"></textarea>
 673             </td>
 674             </tr>
 675          </tbody>
 676         <tbody>
 677         <tr>
 678             <td colspan="2" class="center nowrap">
 679                 <input type="button" class="butt" name="Button"
 680                     value="<?php echo __('OK'); ?>" onclick="edit('Having')" />
 681                 <input type="button" class="butt" name="Button"
 682                     value="<?php echo __('Cancel'); ?>"
 683                     onclick="document.getElementById('query_having').style.display = 'none';" />
 684             </td>
 685         </tr>
 686         </tbody>
 687         </table>
 688     </td>
 689     <td class="frams6"></td>
 690 </tr>
 691 <tr>
 692     <td class="frams4"><div class="bor"></div></td>
 693     <td class="frams7"></td>
 694     <td class="frams3"></td>
 695 </tr>
 696 </tbody>
 697 </table>
 698
 699 <table id="query_Aggregate" style="display:none;"
 700     width="5%" cellpadding="0" cellspacing="0">
 701 <tbody>
 702 <tr>
 703     <td class="frams1" width="10px"></td>
 704     <td class="frams5" width="99%" ></td>
 705     <td class="frams2" width="10px"><div class="bor"></div></td>
 706 </tr>
 707 <tr>
 708     <td class="frams8"></td>
 709     <td class="input_tab">
 710         <table width="168" class="center" cellpadding="2" cellspacing="0">
 711         <thead>
 712         <tr>
 713         <td colspan="2" class="center nowrap"><strong><?php echo __('Aggregate'); ?></strong></td>
 714         </tr>
 715         </thead>
 716         <tbody>
 717         <tr>
 718         <td width="58" class="nowrap"><?php echo __('Operator'); ?></td>
 719             <td width="102">
 720                 <select name="operator" id="e_operator">
 721                     <option value="---" selected="selected">---</option>
 722                     <option value="sum" > SUM </option>
 723                     <option value="min"> MIN </option>
 724                     <option value="max"> MAX </option>
 725                        <option value="avg"> AVG </option>
 726                     <option value="avg"> COUNT </option>
 727                 </select>
 728            </td></tr>
 729         </tbody>
 730         <tbody>
 731         <tr>
 732             <td colspan="2" class="center nowrap">
 733                 <input type="button" class="butt" name="Button"
 734                     value="<?php echo __('OK'); ?>" onclick="edit('Aggregate')" />
 735                 <input type="button" class="butt" name="Button"
 736                     value="<?php echo __('Cancel'); ?>"
 737                     onclick="document.getElementById('query_Aggregate').style.display = 'none';" />
 738             </td>
 739         </tr>
 740         </tbody>
 741         </table>
 742     </td>
 743     <td class="frams6"></td>
 744 </tr>
 745 <tr>
 746     <td class="frams4"><div class="bor"></div></td>
 747     <td class="frams7"></td>
 748     <td class="frams3"></td>
 749 </tr>
 750 </tbody>
 751 </table>
 752
 753 <table id="query_where" style="display:none;"
 754     width="5%" cellpadding="0" cellspacing="0">
 755 <tbody>
 756     <tr>
 757         <td class="frams1" width="10px"></td>
 758         <td class="frams5" width="99%" ></td>
 759         <td class="frams2" width="10px"><div class="bor"></div></td>
 760     </tr>
 761 <tr>
 762     <td class="frams8"></td>
 763     <td class="input_tab">
 764     <table width="168" class="center" cellpadding="2" cellspacing="0">
 765        <thead>
 766         <tr>
 767           <td colspan="2" class="center nowrap"><strong>WHERE</strong></td>
 768         </tr>
 769         </thead>
 770         <tbody id="rename_to">
 771         <tr>
 772         <td width="58" class="nowrap"><?php echo __('Operator'); ?></td>
 773             <td width="102"><select name="erel_opt" id="erel_opt">
 774                 <option value="--" selected="selected"> -- </option>
 775                     <option value="=" > = </option>
 776                     <option value="&gt;"> &gt; </option>
 777                     <option value="&lt;"> &lt; </option>
 778                     <option value="&gt;="> &gt;= </option>
 779                     <option value="&lt;="> &lt;= </option>
 780                     <option value="NOT"> NOT </option>
 781                     <option value="IN"> IN </option>
 782                     <option value="EXCEPT"> <?php echo __('Except'); ?> </option>
 783                     <option value="NOT IN"> NOT IN </option>
 784                 </select>
 785             </td>
 786         </tr>
 787         <tr>
 788         <td class="nowrap"><?php echo __('Value'); ?>/<br /><?php echo __('subquery'); ?></td>
 789             <td><textarea id="eQuery" value="" cols="18"></textarea>
 790             </td>
 791             </tr>
 792          </tbody>
 793         <tbody>
 794         <tr>
 795             <td colspan="2" class="center nowrap">
 796                 <input type="button" class="butt" name="Button"
 797                     value="<?php echo __('OK'); ?>" onclick="edit('Where')" />
 798                 <input type="button" class="butt" name="Button"
 799                     value="<?php echo __('Cancel'); ?>"
 800                     onclick="document.getElementById('query_where').style.display = 'none';" />
 801             </td>
 802         </tr>
 803         </tbody>
 804         </table>
 805     </td>
 806     <td class="frams6"></td>
 807 </tr>
 808 <tr>
 809     <td class="frams4"><div class="bor"></div></td>
 810     <td class="frams7"></td>
 811     <td class="frams3"></td>
 812 </tr>
 813 </tbody>
 814 </table>
 815
 816 <?php
 817 if (! empty($_REQUEST['query'])) {
 818     echo '<div class="panel">';
 819     echo '<div style="clear:both;"></div>';
 820     echo '<div id="ab"></div>';
 821     echo '<div style="clear:both;"></div>';
 822     echo '</div>';
 823     echo '<a class="trigger" href="#">' . __('Active options') . '</a>';
 824     echo '<div id="filter"></div>';
 825     echo '<div id="box">';
 826     echo '<span id="boxtitle"></span>';
 827     echo '<form method="post" action="db_qbe.php">';
 828     echo '<textarea cols="80" name="sql_query" id="textSqlquery" rows="15"></textarea><div id="tblfooter">';
 829     echo '  <input type="submit" name="submit_sql" class="btn" />';
 830     echo '  <input type="button" name="cancel" value="' . __('Cancel') . '" onclick="closebox()" class="btn" />';
 831     echo PMA_generate_common_hidden_inputs($GLOBALS['db']);
 832     echo '</div></p>';
 833     echo '</form></div>';
 834
 835 } ?>
 836
 837
 838 <!-- cache images -->
 839 <img src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/2leftarrow_m.png" width="0" height="0" alt="" />
 840 <img src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/rightarrow1.png" width="0" height="0" alt="" />
 841 <img src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/rightarrow2.png" width="0" height="0" alt="" />
 842 <img src="<?php echo $GLOBALS['pmaThemeImage'] ?>pmd/uparrow2_m.png" width="0" height="0" alt="" />
 843 <div id="PMA_disable_floating_menubar"></div>
 844 </body>
 845 </html>