openslx-ng/slx-admin.git/modules-available/statistics/install.inc.php, branch master Web Interface zum Verwalten der Hochschul-/UniSpezifischen Einstellungen der Linux-Umgebung https://git.openslx.org/openslx-ng/slx-admin.git/atom/modules-available/statistics/install.inc.php?h=master 2025-03-18T16:41:24+00:00 [statistics] Make sure 'notes' and 'id44mb' columns get initialized 2025-03-18T16:41:24+00:00 Simon Rettberg 2025-03-18T16:41:24+00:00 urn:sha1:36a3d4f39b182f19b2ad2a09891db4019826551b [statistics] Track firmware used by clients and display in machine details 2024-12-16T15:06:38+00:00 Simon Rettberg 2024-12-16T15:06:38+00:00 urn:sha1:8e706622c388c16d25c21048c35b3a08a9096449 [statistics] Fix mysql regex to delete non-ASCII values 2023-10-30T09:04:51+00:00 Simon Rettberg 2023-10-30T09:04:51+00:00 urn:sha1:cf4d3241e2a987baf14d7f4a298ac99dc7ffdb75 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 count 2022-12-02T14:24:08+00:00 Simon Rettberg 2022-12-02T14:21:26+00:00 urn:sha1:200d92c8491d5060af5dd839aa82d1e51b058dd6 [statistics] install: Remove bogus SCREEN entries on update 2022-05-12T15:30:29+00:00 Simon Rettberg 2022-05-12T15:30:29+00:00 urn:sha1:4845167135bd6184646281dd0eb39d1d065e7b79 [statistics] Adapt hw-data parsing to new json format for display 2022-03-09T14:06:54+00:00 Simon Rettberg 2021-09-30T15:44:30+00:00 urn:sha1:d736e75ade7a4472aefb72af9036f86016adcb42 [passthrough] New module for managing hardware passthrough for QEMU 2022-03-09T14:06:54+00:00 Simon Rettberg 2021-09-21T14:52:06+00:00 urn:sha1:67e6b6c9981207d7d658f2ad2bf1c39b75c099c7 [statistics] Support new json-format of hardware info from client 2022-03-09T14:06:25+00:00 Simon Rettberg 2021-08-24T14:31:13+00:00 urn:sha1:291837061ba13647f49cc32092fd0a3ec89d51ed 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 handling 2021-05-11T12:51:13+00:00 Simon Rettberg 2021-05-06T08:26:09+00:00 urn:sha1:8dc2b92d667f1401ab9f1315a36add61658f899c * 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 exists 2021-03-04T14:39:18+00:00 Simon Rettberg 2021-03-04T14:39:18+00:00 urn:sha1:d2e9f25c02f800138c3fcc571ec4e611847a8b3d