summaryrefslogtreecommitdiffstats
path: root/modules-available/statistics/install.inc.php
Commit message (Collapse)AuthorAgeFilesLines
* [statistics] Fix mysql regex to delete non-ASCII valuesSimon Rettberg2023-10-301-1/+4
| | | | | | | | | Before updating columns to ASCII only, make sure there are no entries that contain invalid characters. Unfortunately mysql took the stupid approach of treating a-z as "any alphabetic character" by default, so we'd retain Ä and ſ too. Also, stupid me for not verifying this every time I use a regex engine anywhere.
* [statistics] Per-location usage stats; include active lecture countSimon Rettberg2022-12-021-1/+12
|
* [statistics] install: Remove bogus SCREEN entries on updateSimon Rettberg2022-05-121-0/+1
|
* [statistics] Adapt hw-data parsing to new json format for displaySimon Rettberg2022-03-091-2/+2
|
* [passthrough] New module for managing hardware passthrough for QEMUSimon Rettberg2022-03-091-1/+10
|
* [statistics] Support new json-format of hardware info from clientSimon Rettberg2022-03-091-7/+51
| | | | | | 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.
* Moderize Database handlingSimon Rettberg2021-05-111-1/+1
| | | | | | | * 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
* [statistics] Better check if locationid trigger existsSimon Rettberg2021-03-041-13/+4Star
|
* [statistics] Show ID45 live statsSimon Rettberg2021-01-291-0/+11
| | | | Closes #3634
* [statistics] Keep track of client runmodeSimon Rettberg2020-07-071-0/+10
|
* [statistics] Track CPU temperature as wellSimon Rettberg2020-04-271-1/+3
|
* [statistics] Track CPU-load and standby failures of clientsSimon Rettberg2020-04-251-1/+13
|
* [statistics/baseconfig] Allow per-machine configvar overridesSimon Rettberg2019-10-311-0/+14
|
* [statistics/locations] Add locationid constraints; update on deleteSimon Rettberg2019-04-031-0/+11
| | | | | We didn't update subnetlocationid when deleting a location, leading to machines pointing to invalid locations.
* [statistics] Actually convert all old UUID fallback formatsSimon Rettberg2019-03-061-1/+1
|
* Fix UUID handling; refactor constraints for machineuuidSimon Rettberg2019-02-211-21/+18Star
|
* [statistics] Track and display memory/tmp usage of clientsSimon Rettberg2019-01-281-0/+17
|
* [statistics] Introduce state column to get rid of complicated state ↵Simon Rettberg2017-11-281-5/+15
| | | | | | determination This also adds support for the STANDBY state
* [statistics] Fix typo in install.inc.phpSimon Rettberg2017-05-101-1/+1
|
* [statistics] Better errormsg in install, link to projectors addedSimon Rettberg2017-04-071-5/+10
|
* [statistics] Handle client screens, manage projectorsSimon Rettberg2017-04-061-3/+52
|
* [statistics/locations] Update/set subnetlocationid field in DB if the DB has ↵Simon Rettberg2017-01-111-0/+8
| | | | been updated
* [statistics/locations/..] Cache calculated locationid of machine in machine ↵Simon Rettberg2016-12-061-1/+46
| | | | | | | | | | | | | | | table We now have three columns for the locationid: - subnetlocationid Updated whenever the clientip of a client changes on bootup, or when locations/subnets are edited in the locations module. - fixedlocationid Takes the role of the old locationid field - set when a machine is placed in a room via roomplanner, set to NULL otherwise. - locationid Set to fixedlocationid if it's not NULL, to subnetlocationid otherwise. The field is updated by a BEFORE UPDATE trigger.
* [statistics] Enlarge position column as json might get a little longerSimon Rettberg2016-09-011-1/+25
|
* [install] Implement install scripts for most modulesSimon Rettberg2016-06-081-0/+97