Commit graph

365 commits

Author SHA1 Message Date
Jakub Vrana 6353a89816 Use oninput instead of onkeyup 2018-01-12 18:46:44 +01:00
Jakub Vrana 0411495d20 Move inline event handlers to <script> 2018-01-12 17:19:47 +01:00
Jakub Vrana 3d69fbf5f7 Allow searching data in tables by Ctrl+Enter 2018-01-12 17:11:29 +01:00
Jakub Vrana e645693147 Use script() for <script> 2018-01-12 17:10:33 +01:00
Jakub Vrana d996b48cfa Move inline event handlers to <script> 2018-01-12 17:09:41 +01:00
Jakub Vrana 4be72a2a0d Allow customizing CSP 2018-01-11 18:39:49 +01:00
Jakub Vrana 552d2a6be4 Always send security headers in customization 2018-01-11 18:39:49 +01:00
Jakub Vrana 3de101dff4 Editor: Fix doubleclick on database page 2018-01-11 17:24:57 +01:00
Jakub Vrana 48dacd1e97 Fix a typo from 9cb28186 2018-01-11 17:05:37 +01:00
Jakub Vrana 14778165a8 Use @this in JavaScript (prepares for removing inline event handlers) 2018-01-11 17:01:29 +01:00
Jakub Vrana dc85ba2d86 Delete type="text/javascript" from <script> as it is the default in HTML5 2018-01-11 14:13:43 +01:00
Jakub Vrana 9cb281868f Replace getElementById by shortcut for querySelector (requires IE8) 2018-01-11 13:51:32 +01:00
Jakub Vrana 7bcba262df Editor: Display field comment's text inside [] only in edit form 2017-10-01 08:45:17 -07:00
Lukas Tribus 32f1e856ad Editor: Don't set time zone from PHP
Current implementation checks the delta between the local time and
UTC, and applies the delta as time zone for MySQL.

This assumption is wrong if the current time is DST enabled, but the
time that is converted isn't - and vice versa.

For example, Europe/Prague is "CET-1CEST,M3.5.0,M10.5.0/3", when
the MySQL connections is setup now (September, DST enabled) and
we are reading a TIMESTAMP from November, then MySQL applies +0200
instead of +0100 to that timestamp even though November is supposed
to be DST disabled.

There is no reliable and portable way in PHP to understand the
time zone, especially since PHP >= 5.4.0 ignores environment
variable and OS settings [1].

MySQL needs to be properly setup (TZ data loaded [2] and default
TZ set [3]), then everything will work just fine.

The current implementation however causes wrong data 50% of the
time, even when OS/MySQL/PHP is properly setup. As a MySQL
connection will converte timestamps from both DST enabled and
DST disabled dates, a static UTC offset must never be set at
connection level (set time_zone = ...).

This change removes the current implementation, therefor maintaining
OS/MySQL defaults, fixing the DST issue in properly configured
environments.

[1] http://php.net/manual/en/function.date-default-timezone-get.php
[2] https://dev.mysql.com/doc/refman/5.5/en/mysql-tzinfo-to-sql.html
[3] https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html
2017-09-09 11:44:42 +02:00
Jakub Vrana 40d1feec9f Update URL 2017-02-27 13:44:22 +01:00
Jakub Vrana 8a9d803137 Add jsonly class to JS checkboxes 2017-02-20 15:11:47 +01:00
Jakub Vrana a01b2efc22 Change links to HTTPS 2015-09-10 09:26:36 -07:00
Jakub Vrana 8bd53120df Fix handling of 64 bit numbers in auto_increment 2014-11-24 18:17:43 -08:00
Jakub Vrana 1c56b3b206 Editor: Define help mouse handlers 2014-09-14 14:49:39 -07:00
Jakub Vrana 06a2d87e55 Add CSS classes to navigation 2014-06-26 12:59:04 +02:00
Jakub Vrana 06f4346cfe Prevent against brute force login attempts from the same IP address 2014-03-21 22:47:57 -07:00
Jakub Vrana cd64b707bd Use noreferrer in external links 2014-03-21 22:32:31 -07:00
Jakub Vrana 4d491d704e Translate numbers in ar, bn, fa 2014-03-19 21:56:42 -07:00
Jakub Vrana 6a3ede75f6 Print elapsed time in HTML instead of SQL command comment 2014-03-07 09:33:37 -08:00
Jakub Vrana 147957cef7 Activate JUSH before loading databases 2014-01-30 09:06:58 -08:00
Jakub Vrana 2ecff21280 Don't print query in edit 2014-01-10 21:32:07 -08:00
Jakub Vrana 8c8f659028 Don't reset column when searching for an empty value with Enter 2013-12-20 17:42:43 -08:00
Jakub Vrana f41ffd9ee1 Open external links to a new window 2013-12-19 09:31:37 -08:00
Jakub Vrana f503d8130b Abstract schemas() 2013-10-24 22:16:24 -07:00
Jakub Vrana c0fe3a6ff7 Prepare for crypting passwords stored in session 2013-08-10 19:21:18 -07:00
Jakub Vrana 37c97a18ca Editor: Support permanent login in other drivers 2013-08-10 18:57:12 -07:00
Jakub Vrana 85d212c226 Use PHP 5 2013-08-08 17:20:14 -07:00
Jakub Vrana 961ec0b857 Simplify OS detection 2013-08-08 17:09:09 -07:00
Jakub Vrana e8c6ef04d2 Replace ereg*() by preg_*()
ereg() triggers deprecated error which is sent to custom error handlers.
It is also faster.
There are no more deprecated functions except mysql_connect().
2013-07-24 16:26:41 -07:00
Jakub Vrana f8453fe65c Introduce getTarget(event) 2013-07-19 10:41:06 -07:00
Jakub Vrana 9b32d638bb Use isTag() JS function 2013-07-12 14:06:44 -07:00
Jakub Vrana ffc1fa000f Move logout button 2013-07-09 00:34:25 -07:00
Jakub Vrana 13f34d1ea9 Highlight table being altered in navigation 2013-06-25 10:12:10 -07:00
Jakub Vrana 5f370927f1 Descending indexes 2013-06-25 09:42:47 -07:00
Jakub Vrana e680d22023 Avoid fatal in PostgreSQL without implemented database()
https://sourceforge.net/p/adminer/discussion/1095138/thread/5e29e380/
2013-06-13 07:46:12 +02:00
Jakub Vrana f29a7cb140 Notify user about expired master password for permanent login 2013-06-11 11:02:17 +02:00
Jakub Vrana 7dd90f56f1 MySQL: Speed up updating rows without numeric or UTF-8 primary key 2013-06-04 19:40:17 -07:00
Jakub Vrana 2c381345b4 Use variable instead of literal value 2013-05-23 18:31:48 -07:00
Jakub Vrana b7021c9c7f Highlight default submit button 2013-05-06 09:27:35 -07:00
Jakub Vrana 94a0cc8de8 Fix resetting search (bug #3612507) 2013-05-03 18:53:13 -07:00
Jakub Vrana 9c78b3bb34 Add empty lines to source code 2013-05-01 18:28:04 -07:00
Jakub Vrana e24d1fcb02 Optimize table_status() 2013-04-26 22:19:54 -07:00
Jakub Vrana bcd1e059f5 Delete Last page link from Editor 2013-04-24 21:16:54 -07:00
Jakub Vrana 285afc202a Increase default select limit to 50 2013-04-15 14:45:49 -07:00
Jakub Vrana 3093f58157 Clear column name after resetting search (bug #3601200) 2013-04-04 18:32:05 -07:00
Jakub Vrana 190812456f Move ALTER export to plugin 2013-04-04 09:42:02 -07:00
Jakub Vrana f86cb5f837 Use autocapitalize="off" 2013-01-30 23:47:53 -08:00
Jakub Vrana f6e1c589f9 Allow specifying external links (bug #3392685) 2013-01-11 12:46:44 -08:00
Jakub Vrana b5ad37ff2b Treat Meta key same as Ctrl (bug #3599405) 2013-01-09 17:38:53 -08:00
Jakub Vrana f7f553a947 Escape links 2012-12-05 15:29:57 -08:00
Jakub Vrana 2fb1ebc7f1 HTML5 input fields 2012-12-05 13:17:42 -08:00
Jakub Vrana d5400234f0 MySQL: Support geometry data types 2012-09-08 23:43:22 -07:00
Jakub Vrana 700a78b377 selectQueryBuild() method 2012-08-23 22:17:44 -07:00
Jakub Vrana 5d337fe04c Reveal menu items only if mouse is over wide links 2012-08-20 22:20:22 -07:00
Jakub Vrana beafccb8c3 Separate printing databases in customization 2012-08-20 22:03:39 -07:00
Jakub Vrana ef0cb38aa1 Support Editor 2012-08-19 23:31:46 -07:00
Jakub Vrana 65a8c7dde4 Style logout button as link in Editor 2012-08-11 23:02:56 -07:00
Jakub Vrana 3a381564e5 Use VALUES() in INSERT+UPDATE export 2012-08-11 22:59:20 -07:00
Jakub Vrana 4b4fa16a37 Autodisplay long table names in tables filter plugin 2012-08-09 09:11:55 -07:00
Jakub Vrana 99343701ab Autodisplay long logins in saved logins list 2012-08-08 08:27:50 -07:00
Jakub Vrana 1dd6dbcce2 Support one click search in Editor 2012-08-04 22:52:50 -07:00
Jakub Vrana 6a486181dd Autodisplay long table names in tables list 2012-07-29 16:05:37 -07:00
Jakub Vrana b78b0cd109 Plugin for including date in export filename 2012-06-29 14:41:47 -07:00
Jakub Vrana 5b57706890 Customizable export filename 2012-06-29 12:25:05 -07:00
Jakub Vrana 739bcb0979 Warn about selecting data without index 2012-05-17 00:13:13 -07:00
Jakub Vrana f498219f29 Remove eventStop() used by AJAXification in past 2012-05-14 02:22:44 -07:00
Jakub Vrana f595f9313e Use namespace in login form 2012-05-14 01:11:08 -07:00
Jakub Vrana 6591d485e9 Replace isset($var) by $var !== null 2012-05-14 01:11:08 -07:00
Jakub Vrana c4a57246ac Simplify work with NULL values in select 2012-05-13 23:24:39 -07:00
Jakub Vrana 4815c7d020 Don't use AJAX links and forms 2012-04-15 22:22:47 -07:00
Jakub Vrana 24c51fe11f Print current time next to executed SQL queries 2012-03-26 23:21:38 -07:00
Jakub Vrana c7f1a6322e Extensible list of databases 2012-02-23 22:58:41 -08:00
Jakub Vrana de056d41c2 Add search condition after inputting value 2011-08-26 13:04:29 +02:00
Jakub Vrana ce0d001e8b Boolean search 2011-08-24 16:50:44 +02:00
Jakub Vrana 3a333e92ff Display search fields in order 2011-08-24 16:49:54 +02:00
Jakub Vrana 023b62a39c Highlight checked rows 2011-08-11 13:48:27 +02:00
Jakub Vrana b92fe58553 Titles of links in navigation 2011-08-09 13:25:20 +02:00
Jakub Vrana 628a43156d Hide search for hidden enums (thanks to hever) 2011-07-25 17:20:32 +02:00
Jakub Vrana a9b2ac915d Display searched columns 2011-07-01 17:15:45 +02:00
Jakub Vrana 08e70e6309 Edit foreign plugin 2011-06-23 22:11:08 +02:00
Jakub Vrana f8ae1d6360 Prefer NULL to empty string in foreign keys (bug #3323800) 2011-06-23 22:11:08 +02:00
Jakub Vrana 0f00277b82 Easier sending of default headers (customization) 2011-05-31 08:01:48 +02:00
Jakub Vrana e641e5ceba Limit commands and import in customization (bug #3194432) 2011-05-24 17:16:13 +02:00
Jakub Vrana 20a65465c6 PostgreSQL uses 'character varying' (thanks to Lubor Bilek) 2011-05-20 17:52:32 +02:00
Jakub Vrana dd39e3aa3f Save bytes 2011-05-10 14:54:10 +02:00
Jakub Vrana 24e66c2812 Respect numbers in autocomplete 2011-05-05 07:46:36 +02:00
Jakub Vrana 6b4ee48ae8 Autocomplete for big foreign keys 2011-05-04 17:19:54 +02:00
Jakub Vrana daf85306a5 Send e-mail by Ctrl+Enter (Editor) 2011-05-04 17:19:54 +02:00
Jakub Vrana 91aae7332f Simplify foreign key discovery 2011-04-08 00:50:33 -06:00
Jakub Vrana 3ebfdd30c1 Simpler customization of name() link 2011-04-03 08:27:34 -07:00
Jakub Vrana 2dbc73833b PostgreSQL bool in Editor 2011-03-24 11:37:05 +01:00
Jakub Vrana fa832055c8 Fix AJAX history after reload 2011-03-24 08:24:57 +01:00
Jakub Vrana 5ee14079b8 Avoid double escaping 2011-03-24 02:19:21 +01:00
Jakub Vrana e89f42d466 Set MySQL time zone by PHP setting only in Editor 2011-03-23 13:35:35 +01:00
Jakub Vrana d8cba0eb5d Allow own code in <head> (thanks to Nikolaj Vasilcuk) 2011-03-23 11:57:35 +01:00