From 6d7606b2fd53a1d71f59eff5678daafe58d92a5b Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Mon, 26 Oct 2020 15:14:58 +0100
Subject: [serversetup-bwlp-ipxe] Empty menu item title = use bootentry title

We now leave the input box for the menu item title empty, which shows
the matching bootentry's title as the placeholder. This will then also
be what's displayed in the actual menu. This way, updating the boot
entry's title will update the displayed menu item, if it wasn't
overridden previously.

Closes #3690
---
 modules-available/serversetup-bwlp-ipxe/page.inc.php | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 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 9bf0afe4..122c3791 100644
--- a/modules-available/serversetup-bwlp-ipxe/page.inc.php
+++ b/modules-available/serversetup-bwlp-ipxe/page.inc.php
@@ -379,7 +379,8 @@ class Page_ServerSetup extends Page
 		// if = edit, else = add new
 		if ($id !== 0) {
 			$menu = Database::queryFirst("SELECT menuid, timeoutms, title, defaultentryid, isdefault
-			FROM serversetup_menu WHERE menuid = :id", compact('id'));
+				FROM serversetup_menu m
+				WHERE menuid = :id", compact('id'));
 		} else {
 			$menu = [];
 			$menu['menuid'] = 0;
@@ -405,8 +406,12 @@ class Page_ServerSetup extends Page
 
 		$menu['timeout'] = round($menu['timeoutms'] / 1000);
 		$menu['entries'] = [];
-		$res = Database::simpleQuery("SELECT menuentryid, entryid, refmenuid, hotkey, title, hidden, sortval, plainpass FROM
-			serversetup_menuentry WHERE menuid = :id ORDER BY sortval ASC", compact('id'));
+		$res = Database::simpleQuery("SELECT me.menuentryid, me.entryid, me.refmenuid, me.hotkey, me.title,
+       		me.hidden, me.sortval, me.plainpass, be.title AS parenttitle
+			FROM serversetup_menuentry me
+			LEFT JOIN serversetup_bootentry be USING (entryid)
+			WHERE menuid = :id
+			ORDER BY sortval ASC", compact('id'));
 		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
 			if ($row['entryid'] === null && $row['refmenuid'] !== null) {
 				$row['entryid'] = 'menu:' . $row['refmenuid'];
-- 
cgit v1.2.3-55-g7522