$result = SQL_QUERY("SELECT action, title, sort FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE (what='' OR `what` IS NULL) ORDER BY `sort`", __FILE__, __LINE__);
$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
// Read menu structure
- while (list($act, $title, $sort) = SQL_FETCHROW($result))
- {
+ while ($content = SQL_FETCHARRAY($result)) {
// Menu actions
// Menu actions
- $menus[] = $act;
+ $menus[] = $content['action'];
// Menu titles
// 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 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
// Free memory
SQL_FREERESULT($result);
// Remove double eintries
+ // @TODO This can be somehow rewritten to a function
$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`",
$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();
$menus[$value_main] = array();
$titles[$value_main] = array();
$below[$value_main] = array();
+
// Read menu structure
// Read menu structure
- while (list($act, $title, $sort) = SQL_FETCHROW($result))
- {
+ while ($content = SQL_FETCHROW($result)) {
// Menu actions
// Menu actions
- $menus[$value_main][] = $act;
+ $menus[$value_main][] = $content['action'];
// Menu titles
// 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 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
// Free memory
SQL_FREERESULT($result);
// Remove double eintries
+ // @TODO This can be somehow rewritten to a function