query($query);
// Ergebnisse lesen und an den Client ausgeben
while ($row = $result->fetch_array()) {
$value2 = '';
unset($inner1);
$query2 = "SELECT meid
, headline
, link
, mhid
, fontawesome
, sup
FROM jumi_menu_entries
WHERE mhid=$row[mhid]
AND sup = meid
AND meid IN (SELECT DISTINCT meid
FROM jumi_admin_rollen_rechte_zuord a, jumi_admin_rollen_user_zuord b
WHERE a.rid = b.rid
AND b.uid = $uid)
ORDER BY meid ASC
";
#echo "
----------------------------------------$query2";
$result2 = $db->query($query2) or die("Cannot execute query2");
$ln2 = 0;
while ($row2 = $result2->fetch_array()) {
$inner1[$ln2]['headline'] = $row2['headline'];
$inner1[$ln2]['link'] = $row2['link'];
$inner1[$ln2]['fontawesome'] = $row2['fontawesome'];
$value3 = '';
unset($inner2);
if ($row2['link'] == '#') {
$query3 = "SELECT meid
, headline
, link
, mhid
, fontawesome
, sup
FROM jumi_menu_entries
WHERE mhid=$row2[mhid]
AND sup != meid
AND sup = $row2[sup]
AND meid IN (SELECT DISTINCT meid
FROM jumi_admin_rollen_rechte_zuord a, jumi_admin_rollen_user_zuord b
WHERE a.rid = b.rid
AND b.uid = $uid)
ORDER BY meid ASC
";
#echo "
----------------------------------------$query3
";
$result3 = $db->query($query3) or die("Cannot execute query3");
$ln3 = 0;
while ($row3 = $result3->fetch_array()) {
$inner2[$ln3]['headline'] = $row3['headline'];
$inner2[$ln3]['link'] = $row3['link'];
$inner2[$ln3]['fontawesome'] = $row3['fontawesome'];
$value3 = $inner2;
$ln3++;
}
$inner1[$ln2]['inner2'] = $value3;
}
$value2 = $inner1;
$ln2++;
}
$row['inner'] = $value2;
$table_data[] = $row;
}
$smarty->assign('table_data', $table_data);
#echo "";
#print_r($table_data);
#echo "
";
###############################################################################
$result_name = $db->query("SELECT vorname, nachname, mail FROM jumi_admin WHERE uid='$uid'");
$row_name = $result_name->fetch_array();
$smarty->assign('nav_name', "$row_name[vorname] $row_name[nachname]");
$smarty->assign('action', "$action");
$smarty->display("modern/dashboard/$templatename");
?>