Gecko [ www.finalhopeacademy.com ]

Name	Size	Permission
doc	[ DIR ]	drwxr-xr-x
examples	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libraries	[ DIR ]	drwxr-xr-x
locale	[ DIR ]	drwxr-xr-x
sql	[ DIR ]	drwxr-xr-x
templates	[ DIR ]	drwxr-xr-x
themes	[ DIR ]	drwxr-xr-x
vendor	[ DIR ]	drwxr-xr-x
CONTRIBUTING.md	1.69 KB	-rw-r--r--
ChangeLog	15.9 KB	-rw-r--r--
DCO	1.77 KB	-rw-r--r--
LICENSE	17.67 KB	-rw-r--r--
README	1.48 KB	-rw-r--r--
RELEASE-DATE-4.7.9	29 B	-rw-r--r--
ajax.php	913 B	-rw-r--r--
browse_foreigners.php	1.49 KB	-rw-r--r--
changelog.php	4.99 KB	-rw-r--r--
chk_rel.php	772 B	-rw-r--r--
composer.json	2.05 KB	-rw-r--r--
composer.lock	84.89 KB	-rw-r--r--
config.inc.php	4.44 KB	-rw-r--r--
db_central_columns.php	5.24 KB	-rw-r--r--
db_datadict.php	5.69 KB	-rw-r--r--
db_designer.php	5.72 KB	-rw-r--r--
db_events.php	356 B	-rw-r--r--
db_export.php	4.88 KB	-rw-r--r--
db_import.php	1.02 KB	-rw-r--r--
db_operations.php	10.37 KB	-rw-r--r--
db_qbe.php	4.32 KB	-rw-r--r--
db_routines.php	416 B	-rw-r--r--
db_search.php	2.02 KB	-rw-r--r--
db_sql.php	1.08 KB	-rw-r--r--
db_sql_autocomplete.php	749 B	-rw-r--r--
db_sql_format.php	488 B	-rw-r--r--
db_structure.php	1.05 KB	-rw-r--r--
db_tracking.php	4.34 KB	-rw-r--r--
db_triggers.php	360 B	-rw-r--r--
error_report.php	4.43 KB	-rw-r--r--
export.php	15.27 KB	-rw-r--r--
favicon.ico	21.96 KB	-rw-r--r--
gis_data_editor.php	15.48 KB	-rw-r--r--
import.php	23.29 KB	-rw-r--r--
import_status.php	3.32 KB	-rw-r--r--
index.php	19.29 KB	-rw-r--r--
license.php	897 B	-rw-r--r--
lint.php	1.38 KB	-rw-r--r--
logout.php	287 B	-rw-r--r--
navigation.php	2.14 KB	-rw-r--r--
normalization.php	3.94 KB	-rw-r--r--
phpinfo.php	510 B	-rw-r--r--
phpmyadmin.css.php	746 B	-rw-r--r--
prefs_forms.php	2.7 KB	-rw-r--r--
prefs_manage.php	14.89 KB	-rw-r--r--
print.css	1.18 KB	-rw-r--r--
robots.txt	26 B	-rw-r--r--
schema_export.php	1.64 KB	-rw-r--r--
server_binlog.php	804 B	-rw-r--r--
server_collations.php	837 B	-rw-r--r--
server_databases.php	817 B	-rw-r--r--
server_engines.php	803 B	-rw-r--r--
server_export.php	1.2 KB	-rw-r--r--
server_import.php	779 B	-rw-r--r--
server_plugins.php	808 B	-rw-r--r--
server_privileges.php	13.56 KB	-rw-r--r--
server_replication.php	2.18 KB	-rw-r--r--
server_sql.php	847 B	-rw-r--r--
server_status.php	995 B	-rw-r--r--
server_status_advisor.php	954 B	-rw-r--r--
server_status_monitor.php	2.88 KB	-rw-r--r--
server_status_processes.php	1.9 KB	-rw-r--r--
server_status_queries.php	1.36 KB	-rw-r--r--
server_status_variables.php	1.59 KB	-rw-r--r--
server_user_groups.php	1.8 KB	-rw-r--r--
server_variables.php	817 B	-rw-r--r--
show_config_errors.php	1.02 KB	-rw-r--r--
sql.php	6.17 KB	-rw-r--r--
tbl_addfield.php	3.82 KB	-rw-r--r--
tbl_change.php	6.38 KB	-rw-r--r--
tbl_chart.php	990 B	-rw-r--r--
tbl_create.php	3.12 KB	-rw-r--r--
tbl_export.php	4.38 KB	-rw-r--r--
tbl_find_replace.php	1.02 KB	-rw-r--r--
tbl_get_field.php	1.39 KB	-rw-r--r--
tbl_gis_visualization.php	1.23 KB	-rw-r--r--
tbl_import.php	873 B	-rw-r--r--
tbl_indexes.php	1.4 KB	-rw-r--r--
tbl_operations.php	13.31 KB	-rw-r--r--
tbl_recent_favorite.php	455 B	-rw-r--r--
tbl_relation.php	2.31 KB	-rw-r--r--
tbl_replace.php	16.13 KB	-rw-r--r--
tbl_row_action.php	4.94 KB	-rw-r--r--
tbl_select.php	1.15 KB	-rw-r--r--
tbl_sql.php	1.25 KB	-rw-r--r--
tbl_structure.php	1.63 KB	-rw-r--r--
tbl_tracking.php	5.76 KB	-rw-r--r--
tbl_triggers.php	141 B	-rw-r--r--
tbl_zoom_select.php	1.07 KB	-rw-r--r--
themes.php	938 B	-rw-r--r--
transformation_overview.php	1.88 KB	-rw-r--r--
transformation_wrapper.php	4.39 KB	-rw-r--r--
url.php	1.26 KB	-rw-r--r--
user_password.php	9.03 KB	-rw-r--r--
version_check.php	1.07 KB	-rw-r--r--
view_create.php	9.34 KB	-rw-r--r--
view_operations.php	3.91 KB	-rw-r--r--

Code Editor : tbl_tracking.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Table tracking page
 *
 * @package PhpMyAdmin
 */

// Run common work
use PMA\libraries\Tracker;
use PMA\libraries\Response;

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

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

//Get some js files needed for Ajax requests
$response = Response::getInstance();
$header   = $response->getHeader();
$scripts  = $header->getScripts();
$scripts->addFile('jquery/jquery.tablesorter.js');
$scripts->addFile('tbl_tracking.js');

define('TABLE_MAY_BE_ABSENT', true);
require './libraries/tbl_common.inc.php';

if (Tracker::isActive()
    && Tracker::isTracked($GLOBALS["db"], $GLOBALS["table"])
    && ! (isset($_REQUEST['toggle_activation'])
    && $_REQUEST['toggle_activation'] == 'deactivate_now')
    && ! (isset($_REQUEST['report_export'])
    && $_REQUEST['export_type'] == 'sqldumpfile')
) {
    $msg = PMA\libraries\Message::notice(
        sprintf(
            __('Tracking of %s is activated.'),
            htmlspecialchars($GLOBALS["db"] . '.' . $GLOBALS["table"])
        )
    );
    $response->addHTML($msg->getDisplay());
}

$url_query .= '&amp;goto=tbl_tracking.php&amp;back=tbl_tracking.php';
$url_params['goto'] = 'tbl_tracking.php';
$url_params['back'] = 'tbl_tracking.php';

// Init vars for tracking report
if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
    $data = 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'])) {
    $entries = PMA_getEntries($data, $filter_ts_from, $filter_ts_to, $filter_users);
}

// Export as file download
if (isset($_REQUEST['report_export'])
    && $_REQUEST['export_type'] == 'sqldumpfile'
) {
    PMA_exportAsFileDownload($entries);
}

$html = '<br />';

/**
 * Actions
 */
if (isset($_REQUEST['submit_mult'])) {
    if (! empty($_REQUEST['selected_versions'])) {
        if ($_REQUEST['submit_mult'] == 'delete_version') {
            foreach ($_REQUEST['selected_versions'] as $version) {
                PMA_deleteTrackingVersion($version);
            }
            $html .= PMA\libraries\Message::success(
                __('Tracking versions deleted successfully.')
            )->getDisplay();
        }
    } else {
        $html .= PMA\libraries\Message::notice(
            __('No versions selected.')
        )->getDisplay();
    }
}

if (isset($_REQUEST['submit_delete_version'])) {
    $html .= PMA_deleteTrackingVersion($_REQUEST['version']);
}

// Create tracking version
if (isset($_REQUEST['submit_create_version'])) {
    $html .= PMA_createTrackingVersion();
}

// Deactivate tracking
if (isset($_REQUEST['toggle_activation'])
    && $_REQUEST['toggle_activation'] == 'deactivate_now'
) {
    $html .= PMA_changeTracking('deactivate');
}

// Activate tracking
if (isset($_REQUEST['toggle_activation'])
    && $_REQUEST['toggle_activation'] == 'activate_now'
) {
    $html .= PMA_changeTracking('activate');
}

// Export as SQL execution
if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'execution') {
    $sql_result = PMA_exportAsSQLExecution($entries);
    $msg = PMA\libraries\Message::success(__('SQL statements executed.'));
    $html .= $msg->getDisplay();
}

// Export as SQL dump
if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'sqldump') {
    $html .= PMA_exportAsSQLDump($entries);
}

/*
 * Schema snapshot
 */
if (isset($_REQUEST['snapshot'])) {
    $html .= PMA_getHtmlForSchemaSnapshot($url_query);
}
// end of snapshot report

/*
 *  Tracking report
 */
if (isset($_REQUEST['report'])
    && (isset($_REQUEST['delete_ddlog']) || isset($_REQUEST['delete_dmlog']))
) {
    $html .= PMA_deleteTrackingReportRows($data);
}

if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
    $html .= PMA_getHtmlForTrackingReport(
        $url_query, $data, $url_params, $selection_schema, $selection_data,
        $selection_both, $filter_ts_to, $filter_ts_from, $filter_users
    );
} // end of report

/*
 * List selectable tables
 */
$selectable_tables_sql_result = PMA_getSQLResultForSelectableTables();
if ($GLOBALS['dbi']->numRows($selectable_tables_sql_result) > 0) {
    $html .= PMA_getHtmlForSelectableTables(
        $selectable_tables_sql_result, $url_query
    );
}
$html .= '<br />';

/*
 * List versions of current table
 */
$sql_result = PMA_getListOfVersionsOfTable();
$last_version = PMA_getTableLastVersionNumber($sql_result);
if ($last_version > 0) {
    $html .= PMA_getHtmlForTableVersionDetails(
        $sql_result, $last_version, $url_params,
        $url_query, $pmaThemeImage, $text_dir
    );
}

$type = $GLOBALS['dbi']->getTable($GLOBALS['db'], $GLOBALS['table'])
    ->isView() ? 'view' : 'table';
$html .= PMA_getHtmlForDataDefinitionAndManipulationStatements(
    'tbl_tracking.php' . $url_query,
    $last_version,
    $GLOBALS['db'],
    array($GLOBALS['table']),
    $type
);

$html .= '<br class="clearfloat"/>';

$response->addHTML($html);

${this.title}

Code Editor : tbl_tracking.php