Adminer plugin that replaces UNIX timestamps with human-readable dates.

readable-dates.php

<?php

/** This plugin replaces UNIX timestamps with human-readable dates in your local format.
* Mouse click on the date field reveals timestamp back.
*
* @link https://www.adminer.org/plugins/#use
* @author Anonymous
* @license http://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
* @license http://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
*/
class AdminerReadableDates {
	/** @access protected */
	var $prepend;

	function __construct() {
		$this->prepend = <<<EOT

document.addEventListener('DOMContentLoaded', function(event) {
	var date = new Date();
	var tds = document.querySelectorAll('td[id^="val"]');
	for (var i = 0; i < tds.length; i++) {
		var text = tds[i].innerHTML.trim();
		if (text.match(/^\d{10}$/)) {
			date.setTime(parseInt(text) * 1000);
			tds[i].oldDate = text;

			// tds[i].newDate = date.toUTCString().substr(5); // UTC format
			tds[i].newDate = date.toLocaleString();	// Local format
			// tds[i].newDate = date.toLocaleFormat('%e %b %Y %H:%M:%S'); // Custom format - works in Firefox only

			tds[i].newDate = '<span style="color: #009900">' + tds[i].newDate + '</span>';
			tds[i].innerHTML = tds[i].newDate;
			tds[i].dateIsNew = true;

			tds[i].addEventListener('click', function(event) {
				this.innerHTML = (this.dateIsNew ? this.oldDate : this.newDate);
				this.dateIsNew = !this.dateIsNew;
			});
		}
	}
});

EOT;
	}

	function head() {
		echo script($this->prepend);
	}
}

Hi, im trying to find out why this php script doesnt work in Adminer anymore..

Hi, im trying to find out why this php script doesnt work in Adminer anymore..

I can confirm this, doesn't work in 4.8.1 anymore.
However, the javascript itself still works when pasted in the console, so i suspect this is only an issue with the way plugins are loaded now.

Hello, did it stop working for you after upgrading Adminer from 4.8.0 to 4.8.1?
I just upgraded to 4.8.1 and it works fine for me.
What PHP version do you use?
You can maybe also paste your adminer.php file here (censored if you have any keys inside, of course).
You can also try to disable other plugins to find out if some other plugin doesn't break this one.

I did not use Adminer several months, but now its working fine. I am on version 4.8.1