<?php
Kod
$menuMatch = array();
$i = 0;
$menu_data = array();
$query = dbquery("SELECT * FROM ".DB_PREFIX."menu WHERE menu_main='1' ORDER BY menu_order ASC");
while($data = dbarray($query)) {
$menu_data[$i] = array(
'id' => $data['menu_id'],
'title' => $data['menu_title'],
);
$menuMatch[$data['menu_id']] = $i;
$i++;
}
$i = 0;
$submenu_data = array();
$sub_query = dbquery("SELECT * FROM ".DB_PREFIX."menu WHERE menu_main='0' ORDER BY menu_order ASC");
while($sub_data = dbarray($sub_query)) {
$submenu_data[$menuMatch[$sub_data['menu_sub']]][] = array(
'id' => $sub_data['menu_id'],
'title' => $sub_data['menu_title'],
);
$subMenuMatch[$sub_data['menu_id']] = $i;
$d[$sub_data['menu_id']] = $menuMatch[$sub_data['menu_sub']];
$i++;
}
$submenu2_data = array();
$sub_query = dbquery("SELECT * FROM ".DB_PREFIX."menu WHERE menu_main='3' ORDER BY menu_order ASC");
while($sub2_data = dbarray($sub_query)) {
$submenu2_data[$d[$sub2_data['menu_sub']]][$subMenuMatch[$sub2_data['menu_sub']]][] = array(
'id' => $sub2_data['menu_id'],
'title' => $sub2_data['menu_title'],
);
}
$tpl -> assign('menu_data', $menu_data);
$tpl -> assign('submenu_data', $submenu_data);
$tpl -> assign('submenu2_data', $submenu2_data);
$i = 0;
$menu_data = array();
$query = dbquery("SELECT * FROM ".DB_PREFIX."menu WHERE menu_main='1' ORDER BY menu_order ASC");
while($data = dbarray($query)) {
$menu_data[$i] = array(
'id' => $data['menu_id'],
'title' => $data['menu_title'],
);
$menuMatch[$data['menu_id']] = $i;
$i++;
}
$i = 0;
$submenu_data = array();
$sub_query = dbquery("SELECT * FROM ".DB_PREFIX."menu WHERE menu_main='0' ORDER BY menu_order ASC");
while($sub_data = dbarray($sub_query)) {
$submenu_data[$menuMatch[$sub_data['menu_sub']]][] = array(
'id' => $sub_data['menu_id'],
'title' => $sub_data['menu_title'],
);
$subMenuMatch[$sub_data['menu_id']] = $i;
$d[$sub_data['menu_id']] = $menuMatch[$sub_data['menu_sub']];
$i++;
}
$submenu2_data = array();
$sub_query = dbquery("SELECT * FROM ".DB_PREFIX."menu WHERE menu_main='3' ORDER BY menu_order ASC");
while($sub2_data = dbarray($sub_query)) {
$submenu2_data[$d[$sub2_data['menu_sub']]][$subMenuMatch[$sub2_data['menu_sub']]][] = array(
'id' => $sub2_data['menu_id'],
'title' => $sub2_data['menu_title'],
);
}
$tpl -> assign('menu_data', $menu_data);
$tpl -> assign('submenu_data', $submenu_data);
$tpl -> assign('submenu2_data', $submenu2_data);
Jakieś pomysły?
