diff options
author | Steffen Ritter | 2019-08-27 11:37:29 +0200 |
---|---|---|
committer | Steffen Ritter | 2019-08-27 11:37:29 +0200 |
commit | 5fb820a9549b51d5ee34dc2fe0fb041cd0e941c6 (patch) | |
tree | 211fb605bf38b4c4aa837b4381a93011145312f1 /modules-available/serversetup-bwlp-ipxe/page.inc.php | |
parent | [roomplanner] Make client tooltip more readable (diff) | |
download | slx-admin-5fb820a9549b51d5ee34dc2fe0fb041cd0e941c6.tar.gz slx-admin-5fb820a9549b51d5ee34dc2fe0fb041cd0e941c6.tar.xz slx-admin-5fb820a9549b51d5ee34dc2fe0fb041cd0e941c6.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 | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/modules-available/serversetup-bwlp-ipxe/page.inc.php b/modules-available/serversetup-bwlp-ipxe/page.inc.php index 6a874775..56b41d4e 100644 --- a/modules-available/serversetup-bwlp-ipxe/page.inc.php +++ b/modules-available/serversetup-bwlp-ipxe/page.inc.php @@ -298,8 +298,11 @@ class Page_ServerSetup extends Page { $allowEdit = User::hasPermission('ipxe.bootentry.edit'); - $res = Database::simpleQuery("SELECT be.entryid, be.hotkey, be.title, be.builtin, Count(sm.menuid) AS refs FROM serversetup_bootentry be - LEFT JOIN serversetup_menuentry sm USING (entryid) + $res = Database::simpleQuery("SELECT be.entryid, be.hotkey, be.title, be.builtin, Count(sme.menuid) AS refs, + GROUP_CONCAT(sm.title SEPARATOR ', ') as menuname + FROM serversetup_bootentry be + LEFT JOIN serversetup_menuentry sme USING (entryid) + LEFT JOIN serversetup_menu sm USING (menuid) GROUP BY be.entryid ORDER BY be.title ASC"); $bootentryTable = []; |