From 5fb820a9549b51d5ee34dc2fe0fb041cd0e941c6 Mon Sep 17 00:00:00 2001
From: Steffen Ritter
Date: Tue, 27 Aug 2019 11:37:29 +0200
Subject: [serversetup-bwlp-ipxe] Show title of referenced menus in entry list

---
 modules-available/serversetup-bwlp-ipxe/page.inc.php | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'modules-available/serversetup-bwlp-ipxe/page.inc.php')

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 = [];
-- 
cgit v1.2.3-55-g7522