// Get all available main menus
$result = SQL_QUERY("SELECT action, title, sort FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (what='' OR `what` IS NULL) ORDER BY `sort`", __FILE__, __LINE__);
- if (SQL_NUMROWS($result) > 0)
- {
+ if (SQL_NUMROWS($result) > 0) {
// Read menu structure
- while (list($act, $title, $sort) = SQL_FETCHROW($result))
- {
+ while ($content = SQL_FETCHARRAY($result)) {
// Menu actions
- $menus[] = $act;
+ $menus[] = $content['action'];
// Menu titles
- $titles[] = $title;
+ $titles[] = $content['title'];
// Below this menu point should the new be added so we simply increase the sort value by 1 :-)
- $below[] = $sort + 1;
- }
+ $below[] = $content['sort'] + 1;
+ } // END - while
// Free memory
SQL_FREERESULT($result);
// Remove double eintries
+ // @TODO This can be somehow rewritten to a function
$prev = ""; $dmy = $menus; $dmy2 = $titles; $dmy3 = $below;
foreach ($menus as $key => $value)
{
}
$menus = $dmy; $titles = $dmy2; $below = $dmy3;
// Load sub menus :)
- foreach ($menus as $key_main => $value_main)
- {
+ foreach ($menus as $key_main => $value_main) {
$result = SQL_QUERY_ESC("SELECT what, title, sort FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort`",
- array($value_main), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) > 0)
- {
+ array($value_main), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) > 0) {
+ // Init arrays
$menus[$value_main] = array();
$titles[$value_main] = array();
$below[$value_main] = array();
+
// Read menu structure
- while (list($act, $title, $sort) = SQL_FETCHROW($result))
- {
+ while ($content = SQL_FETCHROW($result)) {
// Menu actions
- $menus[$value_main][] = $act;
+ $menus[$value_main][] = $content['action'];
// Menu titles
- $titles[$value_main][] = $title;
+ $titles[$value_main][] = $content['title'];
// Below this menu point should the new be added so we simply increase the sort value by 1 :-)
- $below[$value_main][] = $sort + 1;
- }
+ $below[$value_main][] = $content['sort'] + 1;
+ } // END - while
// Free memory
SQL_FREERESULT($result);
// Remove double eintries
+ // @TODO This can be somehow rewritten to a function
$prev = ""; $dmy = $menus[$value_main]; $dmy2 = $titles[$value_main]; $dmy3 = $below[$value_main];
- foreach ($menus[$value_main] as $key => $value)
- {
- if ($value == $prev)
- {
+ foreach ($menus[$value_main] as $key => $value) {
+ if ($value == $prev) {
unset($dmy[$key]);
unset($dmy2[$key]);
unset($dmy3[$key]);
- }
- else
- {
+ } else {
$prev = $value;
}
}
- $menus[$value_main] = $dmy; $titles[$value_main] = $dmy2; $below[$value_main] = $dmy3;
+ $menus[$value_main] = $dmy;
+ $titles[$value_main] = $dmy2;
+ $below[$value_main] = $dmy3;
}
}
}