tbl_tracking.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @version $Id$
   6  * @package phpMyAdmin
   7  */
   8
   9 // Run common work
  10 require_once './libraries/common.inc.php';
  11 require_once './libraries/Table.class.php';
  12
  13 define('TABLE_MAY_BE_ABSENT', true);
  14 require './libraries/tbl_common.php';
  15 $url_query .= '&amp;goto=tbl_tracking.php&amp;back=tbl_tracking.php';
  16 $url_params['goto'] = 'tbl_tracking.php';;
  17 $url_params['back'] = 'tbl_tracking.php';
  18
  19 // Get relation settings
  20 require_once './libraries/relation.lib.php';
  21
  22 // Init vars for tracking report
  23 if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
  24     $data = PMA_Tracker::getTrackedData($_REQUEST['db'], $_REQUEST['table'], $_REQUEST['version']);
  25
  26     $selection_schema = false;
  27     $selection_data   = false;
  28     $selection_both  = false;
  29
  30     if (! isset($_REQUEST['logtype'])) {
  31         $_REQUEST['logtype'] = 'schema_and_data';
  32     }
  33     if ($_REQUEST['logtype'] == 'schema') {
  34         $selection_schema = true;
  35     } elseif($_REQUEST['logtype'] == 'data') {
  36         $selection_data   = true;
  37     } else {
  38         $selection_both   = true;
  39     }
  40     if (! isset($_REQUEST['date_from'])) {
  41         $_REQUEST['date_from'] = $data['date_from'];
  42     }
  43     if (! isset($_REQUEST['date_to'])) {
  44         $_REQUEST['date_to'] = $data['date_to'];
  45     }
  46     if (! isset($_REQUEST['users'])) {
  47         $_REQUEST['users'] = '*';
  48     }
  49     $filter_ts_from = strtotime($_REQUEST['date_from']);
  50     $filter_ts_to   = strtotime($_REQUEST['date_to']);
  51     $filter_users   = array_map('trim', explode(',', $_REQUEST['users']));
  52 }
  53
  54 // Prepare export
  55 if (isset($_REQUEST['report_export'])) {
  56
  57 /**
  58  * Filters tracking entries
  59  *
  60  * @param   array   the entries to filter
  61  * @param   string  "from" date
  62  * @param   string  "to" date
  63  * @param   string  users
  64  *
  65  * @return  array   filtered entries
  66  *
  67  */
  68     function PMA_filter_tracking($data, $filter_ts_from, $filter_ts_to, $filter_users) {
  69         $tmp_entries = array();
  70         $id = 0;
  71         foreach( $data as $entry ) {
  72             $timestamp = strtotime($entry['date']);
  73
  74             if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to &&
  75               ( in_array('*', $filter_users) || in_array($entry['username'], $filter_users) ) ) {
  76                 $tmp_entries[] = array( 'id' => $id,
  77                                     'timestamp' => $timestamp,
  78                                     'username'  => $entry['username'],
  79                                     'statement' => $entry['statement']
  80                              );
  81             }
  82             $id++;
  83         }
  84         return($tmp_entries);
  85     }
  86
  87     $entries = array();
  88     // Filtering data definition statements
  89     if ($_REQUEST['logtype'] == 'schema' || $_REQUEST['logtype'] == 'schema_and_data') {
  90         $entries = array_merge($entries, PMA_filter_tracking($data['ddlog'], $filter_ts_from, $filter_ts_to, $filter_users));
  91     }
  92
  93     // Filtering data manipulation statements
  94     if ($_REQUEST['logtype'] == 'data' || $_REQUEST['logtype'] == 'schema_and_data') {
  95         $entries = array_merge($entries, PMA_filter_tracking($data['dmlog'], $filter_ts_from, $filter_ts_to, $filter_users));
  96     }
  97
  98     // Sort it
  99     foreach ($entries as $key => $row) {
 100         $ids[$key]        = $row['id'];
 101         $timestamps[$key] = $row['timestamp'];
 102         $usernames[$key]  = $row['username'];
 103         $statements[$key] = $row['statement'];
 104     }
 105
 106     array_multisort($timestamps, SORT_ASC, $ids, SORT_ASC, $usernames, SORT_ASC, $statements, SORT_ASC, $entries);
 107
 108 }
 109
 110 // Export as file download
 111 if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'sqldumpfile') {
 112     @ini_set('url_rewriter.tags','');
 113
 114     $dump = "# " . sprintf($strTrackingReportForTable, htmlspecialchars($_REQUEST['table'])) . "\n" .
 115             "# " . date('Y-m-d H:i:s') . "\n";
 116     foreach($entries as $entry) {
 117         $dump .= $entry['statement'];
 118     }
 119     $filename = 'log_' . htmlspecialchars($_REQUEST['table']) . '.sql';
 120     header('Content-Type: text/x-sql');
 121     header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
 122     header('Content-Disposition: attachment; filename="' . $filename . '"');
 123     if (PMA_USR_BROWSER_AGENT == 'IE') {
 124         header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
 125         header('Pragma: public');
 126     } else {
 127         header('Pragma: no-cache');
 128         header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
 129     }
 130
 131     echo $dump;
 132     exit();
 133 }
 134
 135
 136 /**
 137  * Gets tables informations
 138  */
 139
 140 /**
 141  * Displays top menu links
 142  */
 143 require_once './libraries/tbl_links.inc.php';
 144 echo '<br />';
 145
 146 /**
 147  * Actions
 148  */
 149
 150 // Create tracking version
 151 if (isset($_REQUEST['submit_create_version'])) {
 152     $tracking_set = '';
 153
 154     if ($_REQUEST['alter_table'] == true) {
 155         $tracking_set .= 'ALTER TABLE,';
 156     }
 157     if ($_REQUEST['rename_table'] == true) {
 158         $tracking_set .= 'RENAME TABLE,';
 159     }
 160     if ($_REQUEST['create_table'] == true) {
 161         $tracking_set .= 'CREATE TABLE,';
 162     }
 163     if ($_REQUEST['drop_table'] == true) {
 164         $tracking_set .= 'DROP TABLE,';
 165     }
 166     if ($_REQUEST['create_index'] == true) {
 167         $tracking_set .= 'CREATE INDEX,';
 168     }
 169     if ($_REQUEST['drop_index'] == true) {
 170         $tracking_set .= 'DROP INDEX,';
 171     }
 172     if ($_REQUEST['insert'] == true) {
 173         $tracking_set .= 'INSERT,';
 174     }
 175     if ($_REQUEST['update'] == true) {
 176         $tracking_set .= 'UPDATE,';
 177     }
 178     if ($_REQUEST['delete'] == true) {
 179         $tracking_set .= 'DELETE,';
 180     }
 181     if ($_REQUEST['truncate'] == true) {
 182         $tracking_set .= 'TRUNCATE,';
 183     }
 184     $tracking_set = rtrim($tracking_set, ',');
 185
 186     if (PMA_Tracker::createVersion($GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version'], $tracking_set )) {
 187         $msg = PMA_Message::success(sprintf($strTrackingVersionCreated, $_REQUEST['version'], $GLOBALS['db'], $GLOBALS['table']));
 188         $msg->display();
 189     }
 190 }
 191
 192 // Deactivate tracking
 193 if (isset($_REQUEST['submit_deactivate_now'])) {
 194     if (PMA_Tracker::deactivateTracking($GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version'])) {
 195         $msg = PMA_Message::success(sprintf($strTrackingVersionDeactivated, $GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version']));
 196         $msg->display();
 197     }
 198 }
 199
 200 // Activate tracking
 201 if (isset($_REQUEST['submit_activate_now'])) {
 202     if (PMA_Tracker::activateTracking($GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version'])) {
 203         $msg = PMA_Message::success(sprintf($strTrackingVersionActivated, $GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version']));
 204         $msg->display();
 205     }
 206 }
 207
 208 // Export as SQL execution
 209 if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'execution') {
 210     foreach($entries as $entry) {
 211         $sql_result = PMA_DBI_query( "/*NOTRACK*/\n" . $entry['statement'] );
 212     }
 213     $msg = PMA_Message::success($strTrackingSQLExecuted);
 214     $msg->display();
 215 }
 216
 217 // Export as SQL dump
 218 if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'sqldump')
 219 {
 220     $new_query =    "# " . $strTrackingYouCanExecute . "\n" .
 221                     "# " . $strTrackingCommentOut . "\n" .
 222                     "\n" .
 223                     "CREATE database IF NOT EXISTS pma_temp_db; \n" .
 224                     "USE pma_temp_db; \n" .
 225                     "\n";
 226
 227     foreach($entries as $entry) {
 228         $new_query .= $entry['statement'];
 229     }
 230     $msg = PMA_Message::success($strTrackingSQLExported);
 231     $msg->display();
 232
 233     $db_temp = $db;
 234     $table_temp = $table;
 235
 236     $db = $table = '';
 237     $GLOBALS['js_include'][] = 'functions.js';
 238     require_once './libraries/sql_query_form.lib.php';
 239
 240     PMA_sqlQueryForm($new_query, 'sql');
 241
 242     $db = $db_temp;
 243     $table = $table_temp;
 244 }
 245
 246 /*
 247  * Schema snapshot
 248  */
 249 if (isset($_REQUEST['snapshot'])) {
 250 ?>
 251     <h3><?php echo $strTrackingStructureSnapshot;?>  [<a href="tbl_tracking.php?<?php echo $url_query;?>"><?php echo $strTrackingReportClose;?></a>]</h3>
 252 <?php
 253     $data = PMA_Tracker::getTrackedData($_REQUEST['db'], $_REQUEST['table'], $_REQUEST['version']);
 254
 255     // Get first DROP TABLE and CREATE TABLE statements
 256     $drop_create_statements = $data['ddlog'][0]['statement'];
 257
 258     if (strstr($data['ddlog'][0]['statement'], 'DROP TABLE')) {
 259         $drop_create_statements .= $data['ddlog'][1]['statement'];
 260     }
 261     // Print SQL code
 262     PMA_showMessage(sprintf($strTrackingVersionSnapshotSQL, $_REQUEST['version']), $drop_create_statements);
 263
 264     // Unserialize snapshot
 265     $temp = unserialize($data['schema_snapshot']);
 266     $columns = $temp['COLUMNS'];
 267     $indexes = $temp['INDEXES'];
 268 ?>
 269     <h3><?php echo $strStructure;?></h3>
 270     <table id="tablestructure" class="data">
 271     <thead>
 272     <tr>
 273         <th><?php echo $strField; ?></th>
 274         <th><?php echo $strType; ?></th>
 275         <th><?php echo $strCollation; ?></th>
 276         <th><?php echo $strNull; ?></th>
 277         <th><?php echo $strDefault; ?></th>
 278         <th><?php echo $strExtra; ?></th>
 279         <th><?php echo $strComment; ?></th>
 280     </tr>
 281     </thead>
 282     <tbody>
 283 <?php
 284     $style = 'odd';
 285     foreach($columns as $field_index => $field) {
 286 ?>
 287         <tr class="<?php echo $style; ?>">
 288             <?php
 289             if ($field['Key'] == 'PRI') {
 290                 echo '<td><b><u>' . $field['Field'] . '</u></b></td>' . "\n";
 291             } else {
 292                 echo '<td><b>' . $field['Field'] . '</b></td>' . "\n";
 293             }
 294             ?>
 295             <td><?php echo $field['Type'];?></td>
 296             <td><?php echo $field['Collation'];?></td>
 297             <td><?php echo $field['Null'];?></td>
 298             <td><?php echo $field['Default'];?></td>
 299             <td><?php echo $field['Extra'];?></td>
 300             <td><?php echo $field['Comment'];?></td>
 301         </tr>
 302 <?php
 303             if ($style == 'even') {
 304                 $style = 'odd';
 305             } else {
 306                 $style = 'even';
 307             }
 308     }
 309 ?>
 310     </tbody>
 311     </table>
 312
 313 <?php
 314     if (count($indexes) > 0) {
 315 ?>
 316         <h3><?php echo $strIndexes;?></h3>
 317         <table id="tablestructure_indexes" class="data">
 318         <thead>
 319         <tr>
 320             <th><?php echo $strKeyname;?></th>
 321             <th><?php echo $strType;?></th>
 322             <th><?php echo $strUnique;?></th>
 323             <th><?php echo $strPacked;?></th>
 324             <th><?php echo $strField;?></th>
 325             <th><?php echo $strCardinality;?></th>
 326             <th><?php echo $strCollation;?></th>
 327             <th><?php echo $strNull;?></th>
 328             <th><?php echo $strComment;?></th>
 329         </tr>
 330         <tbody>
 331 <?php
 332         $style = 'odd';
 333         foreach ($indexes as $indexes_index => $index) {
 334             if ($index['Non_unique'] == 0) {
 335                 $str_unique = $strYes;
 336             } else {
 337                 $str_unique = $strNo;
 338             }
 339             if ($index['Packed'] != '') {
 340                 $str_packed = $strYes;
 341             } else {
 342                 $str_packed = $strNo;
 343             }
 344 ?>
 345             <tr class="<?php echo $style; ?>">
 346                 <td><b><?php echo $index['Key_name'];?></b></td>
 347                 <td><?php echo $index['Index_type'];?></td>
 348                 <td><?php echo $str_unique;?></td>
 349                 <td><?php echo $str_packed;?></td>
 350                 <td><?php echo $index['Column_name'];?></td>
 351                 <td><?php echo $index['Cardinality'];?></td>
 352                 <td><?php echo $index['Collation'];?></td>
 353                 <td><?php echo $index['Null'];?></td>
 354                 <td><?php echo $index['Comment'];?></td>
 355             </tr>
 356 <?php
 357             if ($style == 'even') {
 358                 $style = 'odd';
 359             } else {
 360                 $style = 'even';
 361             }
 362         }
 363 ?>
 364     </tbody>
 365     </table>
 366 <?php
 367     } // endif
 368 ?>
 369     <br /><hr /><br />
 370 <?php
 371 }
 372 // end of snapshot report
 373
 374 /*
 375  *  Tracking report
 376  */
 377 if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
 378     ?>
 379     <h3><?php echo $strTrackingReport;?>  [<a href="tbl_tracking.php?<?php echo $url_query;?>"><?php echo $strTrackingReportClose;?></a>]</h3>
 380
 381     <small><?php echo $strTrackingStatements . ' ' . $data['tracking']; ?></small><br/>
 382     <br/>
 383
 384     <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>&amp;report=true&amp;version=<?php echo $_REQUEST['version'];?>">
 385     <?php
 386
 387     $str1 = '<select name="logtype">' .
 388             '<option value="schema"' . ($selection_schema ? ' selected="selected"' : '') . '>' . $strStrucOnly . '</option>' .
 389             '<option value="data"' . ($selection_data ? ' selected="selected"' : ''). '>' . $strDataOnly . '</option>' .
 390             '<option value="schema_and_data"' . ($selection_both ? ' selected="selected"' : '') . '>' . $strStrucData . '</option>' .
 391             '</select>';
 392     $str2 = '<input type="text" name="date_from" value="' . $_REQUEST['date_from'] . '" size="19" />';
 393     $str3 = '<input type="text" name="date_to" value="' . $_REQUEST['date_to'] . '" size="19" />';
 394     $str4 = '<input type="text" name="users" value="' . $_REQUEST['users'] . '" />';
 395     $str5 = '<input type="submit" name="list_report" value="' . $strGo . '" />';
 396
 397     printf($strTrackingShowLogDateUsers, $str1, $str2, $str3, $str4, $str5);
 398
 399
 400     /*
 401      *  First, list tracked data definition statements
 402      */
 403     $i = 1;
 404     if ($selection_schema || $selection_both ) {
 405     ?>
 406         <table id="ddl_versions" class="data" width="100%">
 407         <thead>
 408         <tr>
 409             <th width="18">#</th>
 410             <th width="100"><?php echo $strTrackingDate;?></th>
 411             <th width="60"><?php echo $strTrackingUsername;?></th>
 412             <th><?php echo $strTrackingDataDefinitionStatement;?></th>
 413         </tr>
 414         </thead>
 415         <tbody>
 416         <?php
 417         $style = 'odd';
 418         foreach ($data['ddlog'] as $entry) {
 419             $parsed_sql = PMA_SQP_parse($entry['statement']);
 420             $statement  = PMA_formatSql($parsed_sql);
 421             $timestamp = strtotime($entry['date']);
 422
 423             if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to &&
 424               ( in_array('*', $filter_users) || in_array($entry['username'], $filter_users) ) ) {
 425         ?>
 426                 <tr class="<?php echo $style; ?>">
 427                     <td><small><?php echo $i;?></small></td>
 428                     <td><small><?php echo $entry['date'];?></small></td>
 429                     <td><small><?php echo $entry['username']; ?></small></td>
 430                     <td><?php echo $statement; ?></td>
 431                 </tr>
 432         <?php
 433                 if ($style == 'even') {
 434                     $style = 'odd';
 435                 } else {
 436                     $style = 'even';
 437                 }
 438                 $i++;
 439             }
 440         }
 441         ?>
 442         </tbody>
 443         </table>
 444     <?php
 445
 446     } //endif
 447
 448     /*
 449      *  Secondly, list tracked data manipulation statements
 450      */
 451
 452     if (($selection_data || $selection_both) && count($data['dmlog']) > 0) {
 453     ?>
 454         <table id="dml_versions" class="data" width="100%">
 455         <thead>
 456         <tr>
 457             <th width="18">#</th>
 458             <th width="100"><?php echo $strTrackingDate;?></th>
 459             <th width="60"><?php echo $strTrackingUsername;?></th>
 460             <th><?php echo $strTrackingDataManipulationStatement;?></th>
 461         </tr>
 462         </thead>
 463         <tbody>
 464         <?php
 465         $style = 'odd';
 466         foreach ($data['dmlog'] as $entry) {
 467             $parsed_sql = PMA_SQP_parse($entry['statement']);
 468             $statement  = PMA_formatSql($parsed_sql);
 469             $timestamp = strtotime($entry['date']);
 470
 471             if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to &&
 472               ( in_array('*', $filter_users) || in_array($entry['username'], $filter_users) ) ) {
 473         ?>
 474                 <tr class="<?php echo $style; ?>">
 475                     <td><small><?php echo $i; ?></small></td>
 476                     <td><small><?php echo $entry['date']; ?></small></td>
 477                     <td><small><?php echo $entry['username']; ?></small></td>
 478                     <td><?php echo $statement; ?></td>
 479                 </tr>
 480         <?php
 481                 if ($style == 'even') {
 482                     $style = 'odd';
 483                 } else {
 484                     $style = 'even';
 485                 }
 486                 $i++;
 487             }
 488         }
 489     ?>
 490         </tbody>
 491         </table>
 492     <?php
 493     }
 494     ?>
 495     </form>
 496     <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>&amp;report=true&amp;version=<?php echo $_REQUEST['version'];?>">
 497     <?php
 498     printf($strTrackingShowLogDateUsers, $str1, $str2, $str3, $str4, $str5);
 499
 500     $str_export1 =  '<select name="export_type">' .
 501                     '<option value="sqldumpfile">' . $strTrackingSQLDumpFile . '</option>' .
 502                     '<option value="sqldump">' . $strTrackingSQLDump . '</option>' .
 503                     '<option value="execution" onclick="alert(\'' . $strTrackingSQLExecutionAlert .'\')">' . $strTrackingSQLExecution . '</option>' .
 504                     '</select>';
 505
 506     $str_export2 = '<input type="submit" name="report_export" value="' . $strGo .'" />';
 507     ?>
 508     </form>
 509     <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>&amp;report=true&amp;version=<?php echo $_REQUEST['version'];?>">
 510     <input type="hidden" name="logtype" value="<?php echo $_REQUEST['logtype'];?>" />
 511     <input type="hidden" name="date_from" value="<?php echo $_REQUEST['date_from'];?>" />
 512     <input type="hidden" name="date_to" value="<?php echo $_REQUEST['date_to'];?>" />
 513     <input type="hidden" name="users" value="<?php echo $_REQUEST['users'];?>" />
 514     <?php
 515     echo "<br/>" . sprintf($strTrackingExportAs, $str_export1) . $str_export2 . "<br/>";
 516     ?>
 517     </form>
 518     <?php
 519     echo "<br/><br/><hr/><br/>\n";
 520 } // end of report
 521
 522
 523 /*
 524  * List selectable tables
 525  */
 526
 527 $sql_query = " SELECT DISTINCT db_name, table_name FROM " .
 528              PMA_backquote($GLOBALS['cfg']['Server']['pmadb']) . "." .
 529              PMA_backquote($GLOBALS['cfg']['Server']['tracking']) .
 530              " WHERE " . PMA_backquote('db_name') . " = '" . PMA_sqlAddslashes($GLOBALS['db']) . "' " .
 531              " ORDER BY ". PMA_backquote('db_name') . ", " . PMA_backquote('table_name');
 532
 533 $sql_result = PMA_query_as_controluser($sql_query);
 534
 535 if (PMA_DBI_num_rows($sql_result) > 0) {
 536 ?>
 537     <form method="post" action="tbl_tracking.php?<?php echo $url_query;?>">
 538     <select name="table">
 539     <?php
 540     while ($entries = PMA_DBI_fetch_array($sql_result)) {
 541         if (PMA_Tracker::isTracked($entries['db_name'], $entries['table_name'])) {
 542             $status = ' (' . $strTrackingStatusActive . ')';
 543         } else {
 544             $status = ' (' . $strTrackingStatusNotActive . ')';
 545         }
 546         if ($entries['table_name'] == $_REQUEST['table']) {
 547             $s = ' selected="selected"';
 548         } else {
 549             $s = '';
 550         }
 551         echo '<option value="' . htmlspecialchars($entries['table_name']) . '"' . $s . '>' . htmlspecialchars($entries['db_name']) . ' . ' . htmlspecialchars($entries['table_name']) . $status . '</option>' . "\n";
 552     }
 553     ?>
 554     </select>
 555     <input type="submit" name="show_versions_submit" value="<?php echo $strTrackingShowVersions;?>" />
 556     </form>
 557 <?php
 558 }
 559 ?>
 560 <br />
 561 <?php
 562
 563 /*
 564  * List versions of current table
 565  */
 566
 567 $sql_query = " SELECT * FROM " .
 568              PMA_backquote($GLOBALS['cfg']['Server']['pmadb']) . "." .
 569              PMA_backquote($GLOBALS['cfg']['Server']['tracking']) .
 570              " WHERE " . PMA_backquote('db_name')    . " = '" . PMA_sqlAddslashes($_REQUEST['db']) . "' ".
 571              " AND "   . PMA_backquote('table_name') . " = '" . PMA_sqlAddslashes($_REQUEST['table']) ."' ".
 572              " ORDER BY ". PMA_backquote('version') . " DESC ";
 573
 574 $sql_result = PMA_query_as_controluser($sql_query);
 575
 576 $last_version = 0;
 577 $maxversion = PMA_DBI_fetch_array($sql_result);
 578 $last_version = $maxversion['version'];
 579
 580 if ($last_version > 0) {
 581 ?>
 582     <table id="versions" class="data">
 583     <thead>
 584     <tr>
 585         <th><?php echo $strDatabase;?></th>
 586         <th><?php echo $strTable;?></th>
 587         <th><?php echo $strTrackingThVersion;?></th>
 588         <th><?php echo $strTrackingThCreated;?></th>
 589         <th><?php echo $strTrackingThUpdated;?></th>
 590         <th><?php echo $strStatus;?></th>
 591         <th><?php echo $strShow;?></th>
 592     </tr>
 593     </thead>
 594     <tbody>
 595     <?php
 596     $style = 'odd';
 597     PMA_DBI_data_seek($sql_result, 0);
 598     while($version = PMA_DBI_fetch_array($sql_result)) {
 599         if ($version['tracking_active'] == 1) {
 600             $version_status = $strTrackingStatusActive;
 601         } else {
 602             $version_status = $strTrackingStatusNotActive;
 603         }
 604         if (($version['version'] == $last_version) && ($version_status == $strTrackingStatusNotActive)) {
 605             $tracking_active = false;
 606         }
 607         if (($version['version'] == $last_version) && ($version_status == $strTrackingStatusActive)) {
 608             $tracking_active = true;
 609         }
 610     ?>
 611         <tr class="<?php echo $style;?>">
 612             <td><?php echo htmlspecialchars($version['db_name']);?></td>
 613             <td><?php echo htmlspecialchars($version['table_name']);?></td>
 614             <td><?php echo $version['version'];?></td>
 615             <td><?php echo $version['date_created'];?></td>
 616             <td><?php echo $version['date_updated'];?></td>
 617             <td><?php echo $version_status;?></td>
 618             <td> <a href="tbl_tracking.php?<?php echo $url_query;?>&amp;report=true&amp;version=<?php echo $version['version'];?>"><?php echo $strTrackingReport;?></a> | <a href="tbl_tracking.php?<?php echo $url_query;?>&amp;snapshot=true&amp;version=<?php echo $version['version'];?>"><?php echo $strTrackingStructureSnapshot;?></a></td>
 619         </tr>
 620     <?php
 621         if ($style == 'even') {
 622             $style = 'odd';
 623         } else {
 624             $style = 'even';
 625         }
 626     }
 627     ?>
 628     </tbody>
 629     </table>
 630     <?php if ($tracking_active == true) {?>
 631         <div id="div_deactivate_tracking">
 632         <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>">
 633         <fieldset>
 634             <legend><?php printf($strTrackingDeactivateTrackingFor, $GLOBALS['db'], $GLOBALS['table']); ?></legend>
 635             <input type="hidden" name="version" value="<?php echo $last_version; ?>" />
 636             <input type="submit" name="submit_deactivate_now" value="<?php echo $strTrackingDeactivateNow; ?>" />
 637         </fieldset>
 638         </form>
 639         </div>
 640     <?php
 641     }
 642     ?>
 643     <?php if ($tracking_active == false) {?>
 644         <div id="div_activate_tracking">
 645         <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>">
 646         <fieldset>
 647             <legend><?php printf($strTrackingActivateTrackingFor, $GLOBALS['db'], $GLOBALS['table']); ?></legend>
 648             <input type="hidden" name="version" value="<?php echo $last_version; ?>" />
 649             <input type="submit" name="submit_activate_now" value="<?php echo $strTrackingActivateNow; ?>" />
 650         </fieldset>
 651         </form>
 652         </div>
 653     <?php
 654     }
 655 }
 656 ?>
 657
 658 <div id="div_create_version">
 659 <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>">
 660 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
 661 <fieldset>
 662     <legend><?php printf($strTrackingCreateVersionOf, ($last_version + 1), $GLOBALS['db'], $GLOBALS['table']); ?></legend>
 663
 664     <input type="hidden" name="version" value="<?php echo ($last_version + 1); ?>" />
 665
 666     <p><?php echo $strTrackingTrackDDStatements;?></p>
 667     <input type="checkbox" name="alter_table" value="true" checked="checked" /> ALTER TABLE<br/>
 668     <input type="checkbox" name="rename_table" value="true" checked="checked" /> RENAME TABLE<br/>
 669     <input type="checkbox" name="create_table" value="true" checked="checked" /> CREATE TABLE<br/>
 670     <input type="checkbox" name="drop_table" value="true" checked="checked" /> DROP TABLE<br/>
 671     <br/>
 672     <input type="checkbox" name="create_index" value="true" checked="checked" /> CREATE INDEX<br/>
 673     <input type="checkbox" name="drop_index" value="true" checked="checked" /> DROP INDEX<br/>
 674     <p><?php echo $strTrackingTrackDMStatements;?></p>
 675     <input type="checkbox" name="insert" value="true" checked="checked" /> INSERT<br/>
 676     <input type="checkbox" name="update" value="true" checked="checked" /> UPDATE<br/>
 677     <input type="checkbox" name="delete" value="true" checked="checked" /> DELETE<br/>
 678     <input type="checkbox" name="truncate" value="true" checked="checked" /> TRUNCATE<br/>
 679
 680 </fieldset>
 681 <fieldset class="tblFooters">
 682     <input type="submit" name="submit_create_version" value="<?php echo $strTrackingCreateVersion; ?>" />
 683 </fieldset>
 684 </form>
 685 </div>
 686
 687 <br class="clearfloat"/>
 688
 689 <?php
 690 /**
 691  * Displays the footer
 692  */
 693 require_once './libraries/footer.inc.php';
 694 ?>