X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-manager.php;h=c019248ea03d23b3979f8d096028ef7fb5d29803;hb=9e1f6d2cff0bbef912d605d4ae1728f0382b83a4;hp=293578e3eb2fc636ef6d6d1d239c961f5f0c8bf0;hpb=c4ceb98e54f072c262519fc2ea31ccf6f8559049;p=mailer.git
diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index 293578e3eb..c019248ea0 100644
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -114,6 +114,12 @@ function checkModulePermissions ($mod) {
// Check if cache is latest version
if (GET_EXT_VERSION("cache") >= "0.1.2") {
+ // Is the cache there?
+ if (!isset($GLOBALS['cache_array']['modules'])) {
+ // This should normally not happen...
+ debug_report_bug("Cache 'modules' is gone.");
+ } // END - if
+
// Is the module cached?
if (isset($GLOBALS['cache_array']['modules']['locked'][$mod_chk])) {
// Check cache
@@ -306,7 +312,7 @@ function ADD_DESCR ($ACC_LVL, $FQFN, $return = false, $output = true) {
list($ret) = SQL_FETCHROW($result);
// Shall we return it?
- if ($return) {
+ if ($return === true) {
// Return title
return $ret;
} elseif (((GET_EXT_VERSION("sql_patches") >= "0.2.3") && (getConfig('youre_here') == "Y")) || ((IS_ADMIN()) && ($modCheck == "admin"))) {
@@ -357,7 +363,7 @@ function ADD_MENU ($MODE, $act, $wht) {
// Non-admin shall not see all menus
if (!IS_ADMIN()) {
$AND = " AND `visible`='Y' AND `locked`='N'";
- }
+ } // END - if
// Load SQL data and add the menu to the output stream...
$result_main = SQL_QUERY_ESC("SELECT title, action FROM `{!_MYSQL_PREFIX!}_%s_menu` WHERE (what='' OR `what` IS NULL)".$AND." ORDER BY `sort`",
@@ -366,60 +372,69 @@ function ADD_MENU ($MODE, $act, $wht) {
if (SQL_NUMROWS($result_main) > 0) {
OUTPUT_HTML("
");
// There are menus available, so we simply display them... :)
- while (list($main_title, $main_action) = SQL_FETCHROW($result_main)) {
- //* DEBUG: */ echo __LINE__."/".$main_cnt."/".$main_action."/".$sub_what.":".$GLOBALS['what']."* \n";
+ while ($content = SQL_FETCHARRAY($result_main)) {
+ //* DEBUG: */ echo __LINE__."/".$main_cnt."/".$content['action']."/".$sub_what.":".$GLOBALS['what']."* \n";
// Init variables
- $BLOCK_MODE = false; $act = $main_action;
-
- // Prepare content
- $content = array(
- 'action' => $main_action,
- 'title' => $main_title
- );
+ $GLOBALS['block_mode'] = false;
+ $act = $content['action'];
// Load menu header template
LOAD_TEMPLATE($MODE."_menu_title", false, $content);
- $result_sub = SQL_QUERY_ESC("SELECT title, what FROM `{!_MYSQL_PREFIX!}_%s_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ".$AND." ORDER BY `sort`",
- array($MODE, $main_action), __FUNCTION__, __LINE__);
+ // Sub menu
+ $result_sub = SQL_QUERY_ESC("SELECT title AS sub_title, what AS sub_what FROM `{!_MYSQL_PREFIX!}_%s_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ".$AND." ORDER BY `sort`",
+ array($MODE, $content['action']), __FUNCTION__, __LINE__);
+
+ // Get number of rows
$ctl = SQL_NUMROWS($result_sub);
+
+ // Do we have some entries?
if ($ctl > 0) {
- $cnt=0;
- while (list($sub_title, $sub_what) = SQL_FETCHROW($result_sub)) {
+ // Init counter
+ $cnt = 0;
+
+ // Load all sub menus
+ while ($content2 = SQL_FETCHARRAY($result_sub)) {
+ // Merge both arrays in one
+ $content = merge_array($content, $content2);
+
// Init content
- $content = "";
+ $OUT = "";
// Full file name for checking menu
- //* DEBUG: */ echo __LINE__.":!!!!".$sub_what."!!! \n";
- $FQFN = sprintf("%sinc/modules/%s/what-%s.php", constant('PATH'), $MODE, $sub_what);
- if (FILE_READABLE($FQFN)) {
- if ((!empty($wht)) && (($wht == $sub_what))) {
- $content = "";
+ //* DEBUG: */ echo __LINE__.":!!!!".$content['sub_what']."!!! \n";
+ $INC = sprintf("inc/modules/%s/what-%s.php", $MODE, $content['sub_what']);
+ if (INCLUDE_READABLE($INC)) {
+ if ((!empty($wht)) && (($wht == $content['sub_what']))) {
+ $OUT = "";
}
// Navigation link
- $content .= "";
+ $OUT .= "";
} else {
- $content .= "";
+ $OUT .= "";
}
// Menu title
- $content .= getConfig('menu_blur_spacer') . $sub_title;
+ $OUT .= getConfig('menu_blur_spacer') . $content['sub_title'];
- if (FILE_READABLE($FQFN)) {
- $content .= "";
+ if (INCLUDE_READABLE($INC)) {
+ $OUT .= "";
} else {
- $content .= "";
+ $OUT .= "";
}
- if ((!empty($wht)) && (($wht == $sub_what))) {
- $content .= "";
- }
- $wht = $sub_what; $cnt++;
- // Prepare array
+ if ((!empty($wht)) && (($wht == $content['sub_what']))) {
+ $OUT .= "";
+ } // END - if
+
+ // Remember 'what' for next round and count it up
+ $wht = $content['sub_what']; $cnt++;
+
+ // Rewrite array
$content = array(
- 'menu' => $content,
- 'what' => $sub_what
+ 'menu' => $OUT,
+ 'what' => $content['sub_what']
);
// Add regular menu row or bottom row?
@@ -431,31 +446,33 @@ function ADD_MENU ($MODE, $act, $wht) {
}
} else {
// This is a menu block... ;-)
- $BLOCK_MODE = true;
- $INC_BLOCK = sprintf("inc/modules/%s/action-%s.php", $MODE, $main_action);
+ $GLOBALS['block_mode'] = true;
+ $INC_BLOCK = sprintf("inc/modules/%s/action-%s.php", $MODE, $content['action']);
if (FILE_READABLE($INC_BLOCK)) {
// Load include file
- if ((!EXT_IS_ACTIVE($main_action)) || ($main_action == "online")) OUTPUT_HTML("
+ if ((!EXT_IS_ACTIVE($content['action'])) || ($content['action'] == "online")) OUTPUT_HTML("