libraries/footer.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * finishes HTML output
   5  *
   6  * updates javascript variables in index.php for correct working with querywindow
   7  * and navigation frame refreshing
   8  *
   9  * send buffered data if buffered
  10  *
  11  * WARNING: This script has to be included at the very end of your code because
  12  *          it will stop the script execution!
  13  *
  14  * always use $GLOBALS, as this script is also included by functions
  15  *
  16  * @uses    $_REQUEST['no_history']
  17  * @uses    $GLOBALS['lang']
  18  * @uses    $GLOBALS['collation_connection']
  19  * @uses    $GLOBALS['server']
  20  * @uses    $GLOBALS['db']
  21  * @uses    $GLOBALS['table']
  22  * @uses    $GLOBALS['error_message']
  23  * @uses    $GLOBALS['reload']
  24  * @uses    $GLOBALS['sql_query']
  25  * @uses    $GLOBALS['focus_querywindow']
  26  * @uses    $GLOBALS['checked_special']
  27  * @uses    $GLOBALS['pmaThemeImage']
  28  * @uses    $GLOBALS['controllink'] to close it
  29  * @uses    $GLOBALS['userlink'] to close it
  30  * @uses    $cfg['Server']['user']
  31  * @uses    $cfg['NavigationBarIconic']
  32  * @uses    $cfg['MaxCharactersInDisplayedSQL']
  33  * @uses    PMA_isValid()
  34  * @uses    PMA_setHistory()
  35  * @uses    PMA_ifSetOr()
  36  * @uses    PMA_escapeJsString()
  37  * @uses    PMA_getenv()
  38  * @uses    PMA_generate_common_url()
  39  * @uses    basename()
  40  * @uses    file_exists()
  41  * @package phpMyAdmin
  42  */
  43 if (! defined('PHPMYADMIN')) {
  44     exit;
  45 }
  46
  47 /**
  48  * for PMA_setHistory()
  49  */
  50 if (! PMA_isValid($_REQUEST['no_history']) && empty($GLOBALS['error_message'])
  51  && ! empty($GLOBALS['sql_query'])) {
  52     PMA_setHistory(PMA_ifSetOr($GLOBALS['db'], ''),
  53         PMA_ifSetOr($GLOBALS['table'], ''),
  54         $GLOBALS['cfg']['Server']['user'],
  55         $GLOBALS['sql_query']);
  56 }
  57
  58 if ($GLOBALS['error_handler']->hasDisplayErrors()) {
  59     echo '<div>';
  60     $GLOBALS['error_handler']->dispErrors();
  61     echo '</div>';
  62 }
  63
  64 if (count($GLOBALS['footnotes'])) {
  65     echo '<div class="footnotes">';
  66     foreach ($GLOBALS['footnotes'] as $footnote) {
  67         echo '<span id="footnote_' . $footnote['nr'] . '"><sup>'
  68             . $footnote['nr'] . '</sup> ' . $footnote['note'] . '</span><br />';
  69     }
  70     echo '</div>';
  71 }
  72
  73 if (! empty($_SESSION['debug'])) {
  74     $sum_time = 0;
  75     $sum_exec = 0;
  76     foreach ($_SESSION['debug']['queries'] as $query) {
  77         $sum_time += $query['count'] * $query['time'];
  78         $sum_exec += $query['count'];
  79     }
  80
  81     echo '<div>';
  82     echo count($_SESSION['debug']['queries']) . ' queries executed '
  83         . $sum_exec . ' times in ' . $sum_time . ' seconds';
  84     echo '<pre>';
  85     print_r($_SESSION['debug']);
  86     echo '</pre>';
  87     echo '</div>';
  88     $_SESSION['debug'] = array();
  89 }
  90
  91 if (!$GLOBALS['is_ajax_request']) {
  92 ?>
  93 <script type="text/javascript">
  94 //<![CDATA[
  95 <?php
  96 if (empty($GLOBALS['error_message'])) {
  97     ?>
  98 $(document).ready(function(){
  99 // updates current settings
 100 if (window.parent.setAll) {
 101     window.parent.setAll('<?php
 102         echo PMA_escapeJsString($GLOBALS['lang']) . "', '";
 103         echo PMA_escapeJsString($GLOBALS['collation_connection']) . "', '";
 104         echo PMA_escapeJsString($GLOBALS['server']) . "', '";
 105         echo PMA_escapeJsString(PMA_ifSetOr($GLOBALS['db'], '')) . "', '";
 106         echo PMA_escapeJsString(PMA_ifSetOr($GLOBALS['table'], '')) . "', '";
 107         echo PMA_escapeJsString($_SESSION[' PMA_token ']);?>');
 108 }
 109     <?php
 110     if (! empty($GLOBALS['reload'])) {
 111         ?>
 112 // refresh navigation frame content
 113 if (window.parent.refreshNavigation) {
 114     window.parent.refreshNavigation();
 115 }
 116         <?php
 117     } else if (isset($_GET['reload_left_frame']) && $_GET['reload_left_frame'] == '1') {
 118         // reload left frame (used by user preferences)
 119         ?>
 120         if (window.parent && window.parent.frame_navigation) {
 121             window.parent.frame_navigation.location.reload();
 122         }
 123         <?php
 124     }
 125
 126     ?>
 127 // set current db, table and sql query in the querywindow
 128 if (window.parent.reload_querywindow) {
 129     window.parent.reload_querywindow(
 130         '<?php echo PMA_escapeJsString(PMA_ifSetOr($GLOBALS['db'], '')) ?>',
 131         '<?php echo PMA_escapeJsString(PMA_ifSetOr($GLOBALS['table'], '')) ?>',
 132         '<?php echo strlen($GLOBALS['sql_query']) > $GLOBALS['cfg']['MaxCharactersInDisplayedSQL'] ? PMA_escapeJsString($GLOBALS['sql_query']) : ''; ?>');
 133 }
 134     <?php
 135 }
 136
 137 if (! empty($GLOBALS['focus_querywindow'])) {
 138     ?>
 139 // set focus to the querywindow
 140 if (parent.querywindow && !parent.querywindow.closed && parent.querywindow.location) {
 141     self.focus();
 142 }
 143     <?php
 144 }
 145 ?>
 146
 147 if (window.parent.frame_content) {
 148     // reset content frame name, as querywindow needs to set a unique name
 149     // before submitting form data, and navigation frame needs the original name
 150     if (typeof(window.parent.frame_content.name) != 'undefined'
 151      && window.parent.frame_content.name != 'frame_content') {
 152         window.parent.frame_content.name = 'frame_content';
 153     }
 154     if (typeof(window.parent.frame_content.id) != 'undefined'
 155      && window.parent.frame_content.id != 'frame_content') {
 156         window.parent.frame_content.id = 'frame_content';
 157     }
 158     //window.parent.frame_content.setAttribute('name', 'frame_content');
 159     //window.parent.frame_content.setAttribute('id', 'frame_content');
 160 }
 161 });
 162
 163 //]]>
 164 </script>
 165 <?php
 166 }
 167
 168 // Link to itself to replicate windows including frameset
 169 if (!isset($GLOBALS['checked_special'])) {
 170     $GLOBALS['checked_special'] = false;
 171 }
 172
 173 if (PMA_getenv('SCRIPT_NAME') && empty($_POST) && !$GLOBALS['checked_special'] && ! $GLOBALS['is_ajax_request']) {
 174     echo '<div id="selflink" class="print_ignore">' . "\n";
 175     $url_params['target'] = basename(PMA_getenv('SCRIPT_NAME'));
 176     ?>
 177 <script type="text/javascript">
 178 //<![CDATA[
 179
 180 /* Store current location in hash part of URL to allow direct bookmarking */
 181 setURLHash("<?php echo PMA_generate_common_url($url_params, 'text', ''); ?>");
 182
 183 //]]>
 184 </script>
 185 <?php
 186
 187     echo '<a href="index.php' . PMA_generate_common_url($url_params) . '"'
 188         . ' title="' . __('Open new phpMyAdmin window') . '" target="_blank">';
 189     if ($GLOBALS['cfg']['NavigationBarIconic']) {
 190         echo '<img class="icon" src="'. $GLOBALS['pmaThemeImage'] . 'window-new.png"'
 191             . ' alt="' . __('Open new phpMyAdmin window') . '" />';
 192     }
 193     if ($GLOBALS['cfg']['NavigationBarIconic'] !== true) {
 194         echo __('Open new phpMyAdmin window');
 195     }
 196     echo '</a>' . "\n";
 197     echo '</div>' . "\n";
 198 }
 199
 200 // Include possible custom footers
 201 if (! $GLOBALS['is_ajax_request'] && file_exists(CUSTOM_FOOTER_FILE)) {
 202     require CUSTOM_FOOTER_FILE;
 203 }
 204
 205 /**
 206  * If we are in an AJAX request, we do not need to generate the closing tags for
 207  * body and html.
 208  */
 209 if (! $GLOBALS['is_ajax_request']) {
 210 ?>
 211 </body>
 212 </html>
 213 <?php
 214 }
 215 /**
 216  * Stops the script execution
 217  */
 218 exit;
 219 ?>