Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
doc	[ DIR ]	drwxrwxrwx
examples	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxrwxrwx
libraries	[ DIR ]	drwxrwxrwx
locale	[ DIR ]	drwxrwxrwx
setup	[ DIR ]	drwxrwxrwx
sql	[ DIR ]	drwxrwxrwx
templates	[ DIR ]	drwxrwxrwx
themes	[ DIR ]	drwxrwxrwx
tmp	[ DIR ]	drwxrwxrwx
vendor	[ DIR ]	drwxrwxrwx
CONTRIBUTING.md	2.53 KB	-rw-rw-rw-
ChangeLog	32.24 KB	-rw-rw-rw-
LICENSE	17.67 KB	-rw-rw-rw-
README	1.48 KB	-rw-rw-rw-
RELEASE-DATE-5.0.4	29 B	-rw-rw-rw-
ajax.php	1.96 KB	-rw-rw-rw-
browse_foreigners.php	1.77 KB	-rw-rw-rw-
changelog.php	3.04 KB	-rw-rw-rw-
chk_rel.php	1.16 KB	-rw-rw-rw-
composer.json	3.47 KB	-rw-rw-rw-
composer.lock	170.01 KB	-rw-rw-rw-
config.inc.php	2 KB	-rw-rw-rw-
config.sample.inc.php	4.43 KB	-rw-rw-rw-
db_central_columns.php	4.5 KB	-rw-rw-rw-
db_datadict.php	730 B	-rw-rw-rw-
db_designer.php	7.6 KB	-rw-rw-rw-
db_events.php	1.96 KB	-rw-rw-rw-
db_export.php	5 KB	-rw-rw-rw-
db_import.php	1.08 KB	-rw-rw-rw-
db_multi_table_query.php	1.42 KB	-rw-rw-rw-
db_operations.php	9.64 KB	-rw-rw-rw-
db_qbe.php	5.19 KB	-rw-rw-rw-
db_routines.php	2.2 KB	-rw-rw-rw-
db_search.php	2.17 KB	-rw-rw-rw-
db_sql.php	1.18 KB	-rw-rw-rw-
db_sql_autocomplete.php	1.01 KB	-rw-rw-rw-
db_sql_format.php	613 B	-rw-rw-rw-
db_structure.php	2 KB	-rw-rw-rw-
db_tracking.php	3.58 KB	-rw-rw-rw-
db_triggers.php	1.96 KB	-rw-rw-rw-
error_report.php	4.64 KB	-rw-rw-rw-
export.php	16.93 KB	-rw-rw-rw-
favicon.ico	21.96 KB	-rw-rw-rw-
gis_data_editor.php	3.83 KB	-rw-rw-rw-
import.php	24.03 KB	-rw-rw-rw-
import_status.php	3.65 KB	-rw-rw-rw-
index.php	3.01 KB	-rw-rw-rw-
license.php	1021 B	-rw-rw-rw-
lint.php	1.52 KB	-rw-rw-rw-
logout.php	437 B	-rw-rw-rw-
navigation.php	2.58 KB	-rw-rw-rw-
normalization.php	4.48 KB	-rw-rw-rw-
package.json	1.42 KB	-rw-rw-rw-
phpinfo.php	633 B	-rw-rw-rw-
prefs_forms.php	3.02 KB	-rw-rw-rw-
prefs_manage.php	7.29 KB	-rw-rw-rw-
prefs_twofactor.php	1.93 KB	-rw-rw-rw-
print.css	1.18 KB	-rw-rw-rw-
robots.txt	26 B	-rw-rw-rw-
schema_export.php	861 B	-rw-rw-rw-
server_binlog.php	733 B	-rw-rw-rw-
server_collations.php	626 B	-rw-rw-rw-
server_databases.php	1.74 KB	-rw-rw-rw-
server_engines.php	797 B	-rw-rw-rw-
server_export.php	1.22 KB	-rw-rw-rw-
server_import.php	833 B	-rw-rw-rw-
server_plugins.php	595 B	-rw-rw-rw-
server_privileges.php	14.8 KB	-rw-rw-rw-
server_replication.php	1.57 KB	-rw-rw-rw-
server_sql.php	1.06 KB	-rw-rw-rw-
server_status.php	1.01 KB	-rw-rw-rw-
server_status_advisor.php	885 B	-rw-rw-rw-
server_status_monitor.php	3.22 KB	-rw-rw-rw-
server_status_processes.php	1.78 KB	-rw-rw-rw-
server_status_queries.php	1.34 KB	-rw-rw-rw-
server_status_variables.php	1.31 KB	-rw-rw-rw-
server_user_groups.php	2.16 KB	-rw-rw-rw-
server_variables.php	1.08 KB	-rw-rw-rw-
services.yml	3.09 KB	-rw-rw-rw-
services_controllers.yml	8.4 KB	-rw-rw-rw-
show_config_errors.php	1.23 KB	-rw-rw-rw-
sql.php	6.73 KB	-rw-rw-rw-
tbl_addfield.php	4.33 KB	-rw-rw-rw-
tbl_change.php	6.86 KB	-rw-rw-rw-
tbl_chart.php	1.13 KB	-rw-rw-rw-
tbl_create.php	3.92 KB	-rw-rw-rw-
tbl_export.php	2.9 KB	-rw-rw-rw-
tbl_find_replace.php	1.29 KB	-rw-rw-rw-
tbl_get_field.php	2.05 KB	-rw-rw-rw-
tbl_gis_visualization.php	1.64 KB	-rw-rw-rw-
tbl_import.php	895 B	-rw-rw-rw-
tbl_indexes.php	1.23 KB	-rw-rw-rw-
tbl_operations.php	15.43 KB	-rw-rw-rw-
tbl_recent_favorite.php	590 B	-rw-rw-rw-
tbl_relation.php	2.81 KB	-rw-rw-rw-
tbl_replace.php	17.51 KB	-rw-rw-rw-
tbl_row_action.php	5.48 KB	-rw-rw-rw-
tbl_select.php	1.29 KB	-rw-rw-rw-
tbl_sql.php	1.23 KB	-rw-rw-rw-
tbl_structure.php	2.31 KB	-rw-rw-rw-
tbl_tracking.php	5.33 KB	-rw-rw-rw-
tbl_triggers.php	265 B	-rw-rw-rw-
tbl_zoom_select.php	1.22 KB	-rw-rw-rw-
themes.php	894 B	-rw-rw-rw-
transformation_overview.php	846 B	-rw-rw-rw-
transformation_wrapper.php	5.26 KB	-rw-rw-rw-
url.php	1.56 KB	-rw-rw-rw-
user_password.php	2.18 KB	-rw-rw-rw-
version_check.php	1.17 KB	-rw-rw-rw-
view_create.php	7.02 KB	-rw-rw-rw-
view_operations.php	3.45 KB	-rw-rw-rw-
yarn.lock	109.31 KB	-rw-rw-rw-

Code Editor : tbl_tracking.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Table tracking page
 *
 * @package PhpMyAdmin
 */
declare(strict_types=1);

use PhpMyAdmin\Message;
use PhpMyAdmin\Response;
use PhpMyAdmin\Tracker;
use PhpMyAdmin\Tracking;

if (! defined('ROOT_PATH')) {
    define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
}

global $pmaThemeImage, $text_dir, $url_query;

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

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

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

/** @var Tracking $tracking */
$tracking = $containerBuilder->get('tracking');

if (Tracker::isActive()
    && Tracker::isTracked($GLOBALS["db"], $GLOBALS["table"])
    && ! (isset($_POST['toggle_activation'])
    && $_POST['toggle_activation'] == 'deactivate_now')
    && ! (isset($_POST['report_export'])
    && $_POST['export_type'] == 'sqldumpfile')
) {
    $msg = 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';
$data               = [];
$entries            = [];
$filter_ts_from     = '';
$filter_ts_to       = '';
$filter_users       = [];
$selection_schema   = false;
$selection_data     = false;
$selection_both     = false;

// Init vars for tracking report
if (isset($_POST['report']) || isset($_POST['report_export'])) {
    $data = Tracker::getTrackedData(
        $GLOBALS['db'],
        $GLOBALS['table'],
        $_POST['version']
    );

if (! isset($_POST['logtype'])) {
        $_POST['logtype'] = 'schema_and_data';
    }
    if ($_POST['logtype'] == 'schema') {
        $selection_schema = true;
    } elseif ($_POST['logtype'] == 'data') {
        $selection_data   = true;
    } else {
        $selection_both   = true;
    }
    if (! isset($_POST['date_from'])) {
        $_POST['date_from'] = $data['date_from'];
    }
    if (! isset($_POST['date_to'])) {
        $_POST['date_to'] = $data['date_to'];
    }
    if (! isset($_POST['users'])) {
        $_POST['users'] = '*';
    }
    $filter_ts_from = strtotime($_POST['date_from']);
    $filter_ts_to   = strtotime($_POST['date_to']);
    $filter_users   = array_map('trim', explode(',', $_POST['users']));
}

// Prepare export
if (isset($_POST['report_export'])) {
    $entries = $tracking->getEntries($data, $filter_ts_from, $filter_ts_to, $filter_users);
}

// Export as file download
if (isset($_POST['report_export'])
    && $_POST['export_type'] == 'sqldumpfile'
) {
    $tracking->exportAsFileDownload($entries);
}

$html = '<br>';

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

if (isset($_POST['submit_delete_version'])) {
    $html .= $tracking->deleteTrackingVersion($_POST['version']);
}

// Create tracking version
if (isset($_POST['submit_create_version'])) {
    $html .= $tracking->createTrackingVersion();
}

// Deactivate tracking
if (isset($_POST['toggle_activation'])
    && $_POST['toggle_activation'] == 'deactivate_now'
) {
    $html .= $tracking->changeTracking('deactivate');
}

// Activate tracking
if (isset($_POST['toggle_activation'])
    && $_POST['toggle_activation'] == 'activate_now'
) {
    $html .= $tracking->changeTracking('activate');
}

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

// Export as SQL dump
if (isset($_POST['report_export']) && $_POST['export_type'] == 'sqldump') {
    $html .= $tracking->exportAsSqlDump($entries);
}

/*
 * Schema snapshot
 */
if (isset($_POST['snapshot'])) {
    $html .= $tracking->getHtmlForSchemaSnapshot($url_query);
}
// end of snapshot report

/*
 *  Tracking report
 */
if (isset($_POST['report'])
    && (isset($_POST['delete_ddlog']) || isset($_POST['delete_dmlog']))
) {
    $html .= $tracking->deleteTrackingReportRows($data);
}

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

/*
 * Main page
 */
$html .= $tracking->getHtmlForMainPage(
    $url_query,
    $url_params,
    $pmaThemeImage,
    $text_dir
);

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

$response->addHTML($html);

${this.title}

Code Editor : tbl_tracking.php