diff options
| author | Steffen Ritter | 2019-12-17 14:18:45 +0100 |
|---|---|---|
| committer | Steffen Ritter | 2019-12-17 14:18:45 +0100 |
| commit | 1ecbc53f54ff0ddf9be4fb7689e9d4336019616d (patch) | |
| tree | 14fbaf646b092ecd0788cc529155fc37e038c5e8 /modules-available/serversetup-bwlp-ipxe/page.inc.php | |
| parent | [statistics] Add filter for runtime and lastboot (diff) | |
| download | slx-admin-1ecbc53f54ff0ddf9be4fb7689e9d4336019616d.tar.gz slx-admin-1ecbc53f54ff0ddf9be4fb7689e9d4336019616d.tar.xz slx-admin-1ecbc53f54ff0ddf9be4fb7689e9d4336019616d.zip | |
[serversetup-bwlp-ipxe] Show title of referenced menus in entry list
Diffstat (limited to 'modules-available/serversetup-bwlp-ipxe/page.inc.php')
| -rw-r--r-- | modules-available/serversetup-bwlp-ipxe/page.inc.php | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/modules-available/serversetup-bwlp-ipxe/page.inc.php b/modules-available/serversetup-bwlp-ipxe/page.inc.php index a636665e..b3c9917c 100644 --- a/modules-available/serversetup-bwlp-ipxe/page.inc.php +++ b/modules-available/serversetup-bwlp-ipxe/page.inc.php @@ -298,9 +298,11 @@ class Page_ServerSetup extends Page { $allowEdit = User::hasPermission('ipxe.bootentry.edit'); - $bootentryTable = Database::queryAll("SELECT be.entryid, be.hotkey, be.title, be.builtin, be.module, Count(sm.menuid) AS refs + $bootentryTable = Database::queryAll("SELECT be.entryid, be.hotkey, be.title, be.builtin, be.module, Count(sme.menuid) AS refs, + GROUP_CONCAT(sm.title SEPARATOR ', ') as menuname FROM serversetup_bootentry be - LEFT JOIN serversetup_menuentry sm USING (entryid) + LEFT JOIN serversetup_menuentry sme USING (entryid) + LEFT JOIN serversetup_menu sm USING (menuid) GROUP BY be.entryid, be.title ORDER BY be.title ASC"); |