summaryrefslogtreecommitdiffstats
path: root/inc/database.inc.php
Commit message (Collapse)AuthorAgeFilesLines
* Fix more type errors, stricter typingSimon Rettberg2023-11-151-1/+3
|
* Add function param/return types, fix a lot more phpstorm complaintsSimon Rettberg2023-11-141-6/+7
|
* Fix a few deprecation warnings on PHP 8.2Simon Rettberg2023-10-061-2/+2
|
* [inc/Database] Fix return typeSimon Rettberg2023-10-021-1/+2
|
* [inc/Database] Force utf8mb4 explicitly via SET NAMESSimon Rettberg2022-10-261-0/+1
| | | | | Apparently, putting &charset=utf7mb4 in the connect string is not enough for reasons unknown to me.
* Fix typosSimon Rettberg2022-07-041-1/+1
|
* [inc/Util] Add types, move error printing functions to their own classSimon Rettberg2022-05-021-6/+6
|
* [inc/Database] Add type informationSimon Rettberg2022-04-131-19/+20
|
* [inc/Database] Force more sql_mode options in debug modeSimon Rettberg2022-04-131-1/+2
|
* [statistics] Support new json-format of hardware info from clientSimon Rettberg2022-03-091-2/+2
| | | | | | We now try to use JSON output mode from any tool on the client to supply information, for easier parsability and hopefully, a more stable format.
* [eventlog] Add event filtering and notification systemSimon Rettberg2021-06-251-0/+35
|
* Moderize Database handlingSimon Rettberg2021-05-111-20/+12Star
| | | | | | | * Auto-convert to utf8mb4_unicode_520_ci * Use foreach instead of while to loop over results * Drop useless statement caching * Keep emulated prepares, as we sometimes loop over nested queries
* Fix deprecated curly braces string indexing (PHP 7.4)Simon Rettberg2021-03-251-1/+1
|
* [locations/rebootcontrol] Inherit openingtimes for WOL/shutdownSimon Rettberg2021-03-191-0/+13
| | | | | | | | | | The opening times schedule is now inherited to child locations, so it's easy to toggle WOL or shutdown for individual rooms in a building, where you only have to set the opening times once for the entire building. As of now, WOL and shutdown settings are *not* inherited to child locations, as I'm not sure if you always want to inherit those by default. Closes #3710
* [inc/Database] Force strict mode with CONFIG_DEBUGSimon Rettberg2020-04-271-0/+1
|
* [inc/Database] Convert bool params to 1 or 0Simon Rettberg2020-02-271-0/+9
| | | | | PDO unfortunately only does (string)<bool> for boolean params, which converts false to '' instead of '0'. This breaks MariaDB in strict mode.
* [inc/Database] Method to return single-column queries as arraySimon Rettberg2018-06-121-0/+13
|
* [inc/*] Suppress warning, don't close statementsSimon Rettberg2018-03-211-1/+1
|
* [inc/Database] Add profiling info (timing, query count)Simon Rettberg2018-01-041-6/+48
|
* [inc/Database] Support nested arrays in querySimon Rettberg2017-12-211-1/+10
|
* [inc/Database] Do EXPLAIN SELECT at shutdown so we don't interfere with ↵Simon Rettberg2017-11-291-2/+15
| | | | SQL_CAL_FOUND_ROWS
* [inc/Database] Only fall back to global ignoreError setting if param was omittedSimon Rettberg2017-06-231-9/+9
|
* [inc/Database] Add slow query debugging outputSimon Rettberg2017-05-101-0/+48
|
* [inc/Database] Add ::queryAll()Simon Rettberg2017-04-241-0/+14
|
* [inc/Database] Support expanding nested arraysSimon Rettberg2017-04-191-0/+42
| | | | | | | In parametrized queries, you can now pass an array as an argument. This will result in the arguments being expanded to :a1,:a2,:a3 which is suitable for "IN (:slist)" constructs.
* [inc/Database] Add helper function to run INSERT and retrieve keysSimon Rettberg2017-04-071-0/+94
|
* [install] Implement install scripts for most modulesSimon Rettberg2016-06-081-7/+22
|
* PhpStorm stuffSimon Rettberg2016-06-061-23/+14Star
|
* Still working in modularization cleanup and refinementSimon Rettberg2016-05-111-0/+1
|
* [locations] New module for managing locationsSimon Rettberg2016-02-191-1/+1
|
* [database] Fix typo in prepare method (self::init()was missing a colon)Simon Rettberg2016-01-181-1/+1
|
* [statistics] Add table definition, bump db versionSimon Rettberg2015-12-211-1/+1
|
* Support statictics slxlog messages (Starting with '.'), those go to a ↵Simon Rettberg2015-05-211-1/+1
| | | | special table
* config module structure completed. Many other fixes. Hidden pw field support.Simon Rettberg2015-01-201-2/+4
|
* Rework config module class structure. Still some TODOs though....Simon Rettberg2014-12-121-1/+5
|
* Store processed and unprocessed values of settings; add option to download ↵Simon Rettberg2014-12-101-1/+1
| | | | minilinux components that seem up to date; add setting to show/hide password fields
* Big load of changesSimon Rettberg2014-10-091-1/+1
| | | | | | | | | | | - Added callback functionality for taskmanager tasks. You can launch a task and define a callback function to be run when the task finished. This requires activating the cronjob - Added cron functionality: Add cronjob that calls the cron api every 5 minutes to use it. (See cron.inc.php) - Added eventlog - Added missing translations - Merged main-menu-login and main-menu-logout
* Implement force utf8 option for mysql dbSimon Rettberg2014-10-061-1/+4
|
* Added eventlog class, improved db-update machanism.Simon Rettberg2014-09-151-0/+14
| | | | A warning will be shown in the main menu bar if the database schema needs to be updated.
* Fixed some bugs from Sateserver v05Simon Rettberg2014-05-281-11/+23
|
* Stuff (WIP)Simon Rettberg2014-05-231-0/+1
|
* Working on config.tgz composition through config modulesSimon Rettberg2014-05-151-0/+92
generated by cgit v1.2.3-55-g7522 (git 2.39.0) at 2024-05-09 22:52:18 +0200