notrack 导致mysql_tbl_tracking.php

/* vim: set expandtab sw=4 ts=4 sts=4: */

/**

*

* @author Alexander Rutkowski

* @version $Id$

* @package phpMyAdmin

*/

// Run common work

require_once './libraries/common.inc.php';

require_once './libraries/Table.class.php';

define('TABLE_MAY_BE_ABSENT', true);

require './libraries/tbl_common.php';

$url_query .= '&goto=tbl_tracking.php&back=tbl_tracking.php';

$url_params['goto'] = 'tbl_tracking.php';;

$url_params['back'] = 'tbl_tracking.php';

// Get relation settings

require_once './libraries/relation.lib.php';

// Init vars for tracking report

if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {

$data = PMA_Tracker::getTrackedData($_REQUEST['db'], $_REQUEST['table'], $_REQUEST['version']);

$selection_schema = false;

$selection_data = false;

$selection_both = false;

if (! isset($_REQUEST['logtype'])) {

$_REQUEST['logtype'] = 'schema_and_data';

}

if ($_REQUEST['logtype'] == 'schema') {

$selection_schema = true;

} elseif($_REQUEST['logtype'] == 'data') {

$selection_data = true;

} else {

$selection_both = true;

}

if (! isset($_REQUEST['date_from'])) {

$_REQUEST['date_from'] = $data['date_from'];

}

if (! isset($_REQUEST['date_to'])) {

$_REQUEST['date_to'] = $data['date_to'];

}

if (! isset($_REQUEST['users'])) {

$_REQUEST['users'] = '*';

}

$filter_ts_from = strtotime($_REQUEST['date_from']);

$filter_ts_to = strtotime($_REQUEST['date_to']);

$filter_users = array_map('trim', explode(',', $_REQUEST['users']));

}

// Prepare export

if (isset($_REQUEST['report_export'])) {

/**

* Filters tracking entries

*

* @param array the entries to filter

* @param string "from" date

* @param string "to" date

* @param string users

*

* @return array filtered entries

*

*/

function PMA_filter_tracking($data, $filter_ts_from, $filter_ts_to, $filter_users) {

$tmp_entries = array();

$id = 0;

foreach( $data as $entry ) {

$timestamp = strtotime($entry['date']);

if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to &&

( in_array('*', $filter_users) || in_array($entry['username'], $filter_users) ) ) {

$tmp_entries[] = array( 'id' => $id,

'timestamp' => $timestamp,

'username' => $entry['username'],

'statement' => $entry['statement']

);

}

$id++;

}

return($tmp_entries);

}

$entries = array();

// Filtering data definition statements

if ($_REQUEST['logtype'] == 'schema' || $_REQUEST['logtype'] == 'schema_and_data') {

$entries = array_merge($entries, PMA_filter_tracking($data['ddlog'], $filter_ts_from, $filter_ts_to, $filter_users));

}

// Filtering data manipulation statements

if ($_REQUEST['logtype'] == 'data' || $_REQUEST['logtype'] == 'schema_and_data') {

$entries = array_merge($entries, PMA_filter_tracking($data['dmlog'], $filter_ts_from, $filter_ts_to, $filter_users));

}

// Sort it

foreach ($entries as $key => $row) {

$ids[$key] = $row['id'];

$timestamps[$key] = $row['timestamp'];

$usernames[$key] = $row['username'];

$statements[$key] = $row['statement'];

}

array_multisort($timestamps, SORT_ASC, $ids, SORT_ASC, $usernames, SORT_ASC, $statements, SORT_ASC, $entries);

}

// Export as file download

if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'sqldumpfile') {

@ini_set('url_rewriter.tags','');

$dump = "# " . sprintf($strTrackingReportForTable, htmlspecialchars($_REQUEST['table'])) . "\n" .

"# " . date('Y-m-d H:i:s') . "\n";

foreach($entries as $entry) {

$dump .= $entry['statement'];

}

$filename = 'log_' . htmlspecialchars($_REQUEST['table']) . '.sql';

header('Content-Type: text/x-sql');

header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

header('Content-Disposition: attachment; filename="' . $filename . '"');

if (PMA_USR_BROWSER_AGENT == 'IE') {

header('Cache-Control: must-revalidate, post-check=0, pre-check=0');

header('Pragma: public');

} else {

header('Pragma: no-cache');

header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');

}

echo $dump;

exit();

}

/**

* Gets tables informations

*/

/**

* Displays top menu links

*/

require_once './libraries/tbl_links.inc.php';

echo '
';

/**

* Actions

*/

// Create tracking version

if (isset($_REQUEST['submit_create_version'])) {

$tracking_set = '';

if ($_REQUEST['alter_table'] == true) {

$tracking_set .= 'ALTER TABLE,';

}

if ($_REQUEST['rename_table'] == true) {

$tracking_set .= 'RENAME TABLE,';

}

if ($_REQUEST['create_table'] == true) {

$tracking_set .= 'CREATE TABLE,';

}

if ($_REQUEST['drop_table'] == true) {

$tracking_set .= 'DROP TABLE,';

}

if ($_REQUEST['create_index'] == true) {

$tracking_set .= 'CREATE INDEX,';

}

if ($_REQUEST['drop_index'] == true) {

$tracking_set .= 'DROP INDEX,';

}

if ($_REQUEST['insert'] == true) {

$tracking_set .= 'INSERT,';

}

if ($_REQUEST['update'] == true) {

$tracking_set .= 'UPDATE,';

}

if ($_REQUEST['delete'] == true) {

$tracking_set .= 'DELETE,';

}

if ($_REQUEST['truncate'] == true) {

$tracking_set .= 'TRUNCATE,';

}

$tracking_set = rtrim($tracking_set, ',');

if (PMA_Tracker::createVersion($GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version'], $tracking_set )) {

$msg = PMA_Message::success(sprintf($strTrackingVersionCreated, $_REQUEST['version'], $GLOBALS['db'], $GLOBALS['table']));

$msg->display();

}

}

// Deactivate tracking

if (isset($_REQUEST['submit_deactivate_now'])) {

if (PMA_Tracker::deactivateTracking($GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version'])) {

$msg = PMA_Message::success(sprintf($strTrackingVersionDeactivated, $GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version']));

$msg->display();

}

}

// Activate tracking

if (isset($_REQUEST['submit_activate_now'])) {

if (PMA_Tracker::activateTracking($GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version'])) {

$msg = PMA_Message::success(sprintf($strTrackingVersionActivated, $GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version']));

$msg->display();

}

}

// Export as SQL execution

if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'execution') {

foreach($entries as $entry) {

$sql_result = PMA_DBI_query( "/*NOTRACK*/\n" . $entry['statement'] );

}

$msg = PMA_Message::success($strTrackingSQLExecuted);

$msg->display();

}

// Export as SQL dump

if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'sqldump')

{

$new_query = "# " . $strTrackingYouCanExecute . "\n" .

"# " . $strTrackingCommentOut . "\n" .

"\n" .

"CREATE database IF NOT EXISTS pma_temp_db; \n" .

"USE pma_temp_db; \n" .

"\n";

foreach($entries as $entry) {

$new_query .= $entry['statement'];

}

$msg = PMA_Message::success($strTrackingSQLExported);

$msg->display();

$db_temp = $db;

$table_temp = $table;

$db = $table = '';

$GLOBALS['js_include'][] = 'functions.js';

require_once './libraries/sql_query_form.lib.php';

PMA_sqlQueryForm($new_query, 'sql');

$db = $db_temp;

$table = $table_temp;

}

/*

* Schema snapshot

*/

if (isset($_REQUEST['snapshot'])) {

?>

<?php echo $strTrackingStructureSnapshot;?> [<?php echo $strTrackingReportClose;?>]

$data = PMA_Tracker::getTrackedData($_REQUEST['db'], $_REQUEST['table'], $_REQUEST['version']);

// Get first DROP TABLE and CREATE TABLE statements

$drop_create_statements = $data['ddlog'][0]['statement'];

if (strstr($data['ddlog'][0]['statement'], 'DROP TABLE')) {

$drop_create_statements .= $data['ddlog'][1]['statement'];

}

// Print SQL code

PMA_showMessage(sprintf($strTrackingVersionSnapshotSQL, $_REQUEST['version']), $drop_create_statements);

// Unserialize snapshot

$temp = unserialize($data['schema_snapshot']);

$columns = $temp['COLUMNS'];

$indexes = $temp['INDEXES'];

?>

<?php echo $strStructure;?>

$style = 'odd';

foreach($columns as $field_index => $field) {

?>

if ($field['Key'] == 'PRI') {

echo '

' . $field['Field'] . '' . "\n";

} else {

echo '

' . $field['Field'] . '' . "\n";

}

?>

<?php echo $field['Type'];?><?php echo $field['Collation'];?><?php echo $field['Null'];?><?php echo $field['Default'];?><?php echo $field['Extra'];?><?php echo $field['Comment'];?>

if ($style == 'even') {

$style = 'odd';

} else {

$style = 'even';

}

}

?>

if (count($indexes) > 0) {

?>

<?php echo $strIndexes;?>

$style = 'odd';

foreach ($indexes as $indexes_index => $index) {

if ($index['Non_unique'] == 0) {

$str_unique = $strYes;

} else {

$str_unique = $strNo;

}

if ($index['Packed'] != '') {

$str_packed = $strYes;

} else {

$str_packed = $strNo;

}

?>

<?php echo $index['Key_name'];?><?php echo $index['Index_type'];?><?php echo $str_unique;?><?php echo $str_packed;?><?php echo $index['Column_name'];?><?php echo $index['Cardinality'];?><?php echo $index['Collation'];?><?php echo $index['Null'];?><?php echo $index['Comment'];?>

if ($style == 'even') {

$style = 'odd';

} else {

$style = 'even';

}

}

?>

} // endif

?>

---

}

// end of snapshot report

/*

* Tracking report

*/

if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {

?>

<?php echo $strTrackingReport;?> [<?php echo $strTrackingReportClose;?>]

$str1 = '' .

'' . $strStrucOnly . '' .

'' . $strDataOnly . '' .

'' . $strStrucData . '' .

'';

$str2 = '';

$str3 = '';

$str4 = '';

$str5 = '';

printf($strTrackingShowLogDateUsers, $str1, $str2, $str3, $str4, $str5);

/*

* First, list tracked data definition statements

*/

$i = 1;

if ($selection_schema || $selection_both ) {

?>

#<?php echo $strTrackingDate;?><?php echo $strTrackingUsername;?><?php echo $strTrackingDataDefinitionStatement;?>

$style = 'odd';

foreach ($data['ddlog'] as $entry) {

if (strlen($entry['statement']) > $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) {

$statement = substr($entry['statement'], 0, $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) . '[...]';

} else {

$statement = PMA_formatSql(PMA_SQP_parse($entry['statement']));

}

$timestamp = strtotime($entry['date']);

if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to &&

( in_array('*', $filter_users) || in_array($entry['username'], $filter_users) ) ) {

?>

<?php echo $i;?> <?php echo $entry['date'];?> <?php echo $entry['username']; ?><?php echo $statement; ?>

if ($style == 'even') {

$style = 'odd';

} else {

$style = 'even';

}

$i++;

}

}

?>

} //endif

/*

* Secondly, list tracked data manipulation statements

*/

if (($selection_data || $selection_both) && count($data['dmlog']) > 0) {

?>

#<?php echo $strTrackingDate;?><?php echo $strTrackingUsername;?><?php echo $strTrackingDataManipulationStatement;?>

$style = 'odd';

foreach ($data['dmlog'] as $entry) {

if (strlen($entry['statement']) > $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) {

$statement = substr($entry['statement'], 0, $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) . '[...]';

} else {

$statement = PMA_formatSql(PMA_SQP_parse($entry['statement']));

}

$timestamp = strtotime($entry['date']);

if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to &&

( in_array('*', $filter_users) || in_array($entry['username'], $filter_users) ) ) {

?>

<?php echo $i; ?> <?php echo $entry['date']; ?> <?php echo $entry['username']; ?><?php echo $statement; ?>

if ($style == 'even') {

$style = 'odd';

} else {

$style = 'even';

}

$i++;

}

}

?>

}

?>

printf($strTrackingShowLogDateUsers, $str1, $str2, $str3, $str4, $str5);

$str_export1 = '' .

'' . $strTrackingSQLDumpFile . '' .

'' . $strTrackingSQLDump . '' .

'' . $strTrackingSQLExecution . '' .

'';

$str_export2 = '';

?>

echo "
" . sprintf($strTrackingExportAs, $str_export1) . $str_export2 . "
";

?>

echo "

---

\n";

} // end of report

/*

* List selectable tables

*/

$sql_query = " SELECT DISTINCT db_name, table_name FROM " .

PMA_backquote($GLOBALS['cfg']['Server']['pmadb']) . "." .

PMA_backquote($GLOBALS['cfg']['Server']['tracking']) .

" WHERE " . PMA_backquote('db_name') . " = '" . PMA_sqlAddslashes($GLOBALS['db']) . "' " .

" ORDER BY ". PMA_backquote('db_name') . ", " . PMA_backquote('table_name');

$sql_result = PMA_query_as_controluser($sql_query);

if (PMA_DBI_num_rows($sql_result) > 0) {

?>

while ($entries = PMA_DBI_fetch_array($sql_result)) {

if (PMA_Tracker::isTracked($entries['db_name'], $entries['table_name'])) {

$status = ' (' . $strTrackingStatusActive . ')';

} else {

$status = ' (' . $strTrackingStatusNotActive . ')';

}

if ($entries['table_name'] == $_REQUEST['table']) {

$s = ' selected="selected"';

} else {

$s = '';

}

echo '' . htmlspecialchars($entries['db_name']) . ' . ' . htmlspecialchars($entries['table_name']) . $status . '' . "\n";

}

?>

}

?>

/*

* List versions of current table

*/

$sql_query = " SELECT * FROM " .

PMA_backquote($GLOBALS['cfg']['Server']['pmadb']) . "." .

PMA_backquote($GLOBALS['cfg']['Server']['tracking']) .

" WHERE " . PMA_backquote('db_name') . " = '" . PMA_sqlAddslashes($_REQUEST['db']) . "' ".

" AND " . PMA_backquote('table_name') . " = '" . PMA_sqlAddslashes($_REQUEST['table']) ."' ".

" ORDER BY ". PMA_backquote('version') . " DESC ";

$sql_result = PMA_query_as_controluser($sql_query);

$last_version = 0;

$maxversion = PMA_DBI_fetch_array($sql_result);

$last_version = $maxversion['version'];

if ($last_version > 0) {

?>

$style = 'odd';

PMA_DBI_data_seek($sql_result, 0);

while($version = PMA_DBI_fetch_array($sql_result)) {

if ($version['tracking_active'] == 1) {

$version_status = $strTrackingStatusActive;

} else {

$version_status = $strTrackingStatusNotActive;

}

if (($version['version'] == $last_version) && ($version_status == $strTrackingStatusNotActive)) {

$tracking_active = false;

}

if (($version['version'] == $last_version) && ($version_status == $strTrackingStatusActive)) {

$tracking_active = true;

}

?>

<?php echo htmlspecialchars($version['db_name']);?><?php echo htmlspecialchars($version['table_name']);?><?php echo $version['version'];?><?php echo $version['date_created'];?><?php echo $version['date_updated'];?><?php echo $version_status;?> <?php echo $strTrackingReport;?> | <?php echo $strTrackingStructureSnapshot;?>

if ($style == 'even') {

$style = 'odd';

} else {

$style = 'even';

}

}

?>

}

?>

}

}

?>

ALTER TABLE

RENAME TABLE

CREATE TABLE

DROP TABLE

CREATE INDEX

DROP INDEX

INSERT

UPDATE

DELETE

TRUNCATE

/**

* Displays the footer

*/

require_once './libraries/footer.inc.php';

?>

一键复制

编辑

Web IDE

原始数据

按行查看

历史