35 Commits

Author SHA1 Message Date
16e91cc05d show database size in admin 2025-08-26 21:37:37 +02:00
14fe8e2799 More style fixes 2024-01-25 14:50:15 +01:00
a7a40fb292 Automatic code style fixes 2024-01-25 13:06:49 +01:00
04a1c67a0e Admin: direct download of database file 2024-01-08 14:38:38 +01:00
9038f70750 Cleanup for the admin interface 2023-06-20 21:43:59 +02:00
5a212f8e61 Remove listing of the now unsupported sqlite2 databases 2023-06-20 12:57:27 +02:00
14e7409b4e fix method calls missed in refactoring operation 2023-06-13 08:54:45 +02:00
7ddaad1152 Fix import/export handling, always split multi-statements
Even though mutliple statements can be passed to $sth->execute(),
failures will only be checked in the very first statement. Failures
later on will lead to the rest of the statements to be silently ignored
rendering our rollback strategy moot.

We now always split multiline statements and run them separately
(affects import and migrations).

The export was adjusted to not include the transaction handling and
fix entry exports.
2023-06-12 10:42:14 +02:00
3a56750b42 admin interface cleanup
Query saving has been moved to its own class
2023-03-15 22:03:56 +01:00
ecc45fdcc8 admin.php uses Form class now 2023-03-13 10:54:38 +01:00
af0e76916d fix sqlite_rename functionality: use current Form class and check security token 2023-03-13 09:41:17 +01:00
cd9d7ecb20 remove sqlite_convert suppor which is no longer avaliable in current PHP versions 2023-03-13 09:30:23 +01:00
7431dc9076 change $_REQUEST to $INPUT 2023-03-13 09:23:59 +01:00
d6f421984a the commit: b03109898c has broken the plugin's admin interface. This commit fix this and still prevents the warnings. 2023-03-08 13:22:02 +01:00
f2fcfb537a fix conflict 2023-03-08 13:06:17 +01:00
b03109898c Fixed warnings 'undefined arrays' at lines 216 and 221. 2022-11-29 15:34:30 -03:00
74f97ccf10 args for named queries; bug fixes; lang support 2021-09-01 14:21:39 +02:00
09a0e52b96 store saved queries in separate database 2021-08-27 09:46:04 +02:00
271f9cae79 first version of query saver 2021-07-20 15:02:44 +02:00
0dbd1d4c3c add import/export to admin interface
Sometimes I need access to my sqlite databases on a hosting where I don't have the file-level access. This import/export feature is very helpful in this case.
2017-10-10 10:42:00 +02:00
5eb2cff176 visualize NULL values in interface 2016-08-10 11:37:18 +02:00
f57002af53 p tag must not contain block level elements
Paragraphs must not contain block level elements. Therefore, changed paragraph to division tag.
2015-05-04 23:51:39 +02:00
79288b5889 no pass by ref for objects 2014-05-14 13:20:33 +02:00
355597ac6c removed a bit of unneeded stuff 2013-01-22 15:18:53 +01:00
0542fc8e14 Changed link of headers in ToC of admin page to static url. Some code reformating. 2012-11-01 16:48:36 +01:00
a34ef33354 Added database version upgrade funtion.
Added dump and import functions. Added checks and rename and convert buttons to admin interface, that adds upgrade function when possible
2012-11-01 16:42:04 +01:00
8404199129 Adminpage: Added database version urlparameter, changed result parsing and added a timer around the query. 2012-11-01 15:38:22 +01:00
40698f67e5 PDO sqlite uses and look for database file with extension .sqlite3.
This instead of .sqlite. ie. to prevent autoupgrades. Add lookup for sqlite2 and sqlite3 dbs to admin.
2012-06-26 00:10:59 +02:00
04bccc8678 Fixes bug where we failed to use the helper function for counting results
thanks to ghoz for the spot and the fix.
2012-02-18 18:11:03 +01:00
dd79791b6f larger input field in admin backend 2012-01-31 11:07:37 +01:00
ab6c40f961 Fix XHTML output in admin interface 2010-09-21 12:05:07 +02:00
a1a04581b8 Avoid warning when no database is available 2010-04-25 13:09:52 +02:00
fd69a32c01 added ALTER TABLE support 2010-02-03 14:04:19 +01:00
7f5f9a980e added CSRF checks to admin interface 2010-01-27 15:42:52 +01:00
93d995e06c Added admin interface to access databases directly 2009-12-16 15:26:15 +01:00