X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-memedit.php;h=34dc56c0c8d50d6c62195880eac16ffe0ba91f38;hp=68867ee6a69c0cacaafcbfedb17954bdf0b9de3b;hb=0f3a135204757cc8750262871c8e62c42300acb4;hpb=206ee1f32b11eaa38a8df0536d7f7732c6dcebc9 diff --git a/inc/modules/admin/what-memedit.php b/inc/modules/admin/what-memedit.php index 68867ee6a6..34dc56c0c8 100644 --- a/inc/modules/admin/what-memedit.php +++ b/inc/modules/admin/what-memedit.php @@ -60,29 +60,29 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() foreach (postRequestParameter('sel') as $sel => $confirm) { if ($confirm == 1) { $count++; - $result = SQL_QUERY_ESC("SELECT `title`, `action`, `what` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE ".$AND." AND `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `title`,`action`,`what` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE ".$AND." AND `id`=%s LIMIT 1", array(bigintval($sel)), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Entry found so we load the stuff... - $data = SQL_FETCHARRAY($result); - $data = array( - 'cnt' => $count, + $content = SQL_FETCHARRAY($result); + $content = array( + 'count' => $count, 'sel' => $sel, - 'menu' => $data['title'], - 'action' => adminAddMenuSelectionBox('member', 'action', 'sel_action[' . $sel . ']', $data['action']), - 'what' => adminAddMenuSelectionBox('member', 'what' , 'sel_what[' . $sel . ']', $data['what']), + 'menu' => $content['title'], + 'action' => adminAddMenuSelectionBox('member', 'action', 'sel_action[' . $sel . ']', $content['action']), + 'what' => adminAddMenuSelectionBox('member', 'what' , 'sel_what[' . $sel . ']', $content['what']), ); // Load template - $OUT .= loadTemplate('admin_edit_member_menu_row', true, $data); + $OUT .= loadTemplate('admin_edit_member_menu_row', true, $content); } else { // Entry not found? - $data = array( + $content = array( 'sel' => $sel ); // Load template - $OUT .= loadTemplate('admin_menu_404_row', true, $data); + $OUT .= loadTemplate('admin_menu_404_row', true, $content); } SQL_FREERESULT($result); } // END - if @@ -90,7 +90,7 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() // Add row content and current counter $content['rows'] = $OUT; - $content['cnt'] = $count; + $content['count'] = $count; // Load template loadTemplate('admin_edit_member_menu', false, $content); @@ -108,7 +108,7 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() // Entry found so we load the stuff... list($title) = SQL_FETCHROW($result); $content = array( - 'cnt' => $count, + 'count' => $count, 'sel' => $sel, 'title' => $title ); @@ -128,7 +128,7 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() } // END - if } // END - foreach $content['rows'] = $OUT; - $content['cnt'] = $count; + $content['count'] = $count; // Load template loadTemplate('admin_delete_member_menu', false, $content); @@ -140,35 +140,35 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() foreach (postRequestParameter('sel') as $sel => $confirm) { if ($confirm == 1) { $count++; - $result = SQL_QUERY_ESC("SELECT `title`, `visible`, `locked` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE ".$AND." AND `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `title`,`visible`,`locked` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE ".$AND." AND `id`=%s LIMIT 1", array(bigintval($sel)), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Entry found so we load the stuff... - $data = SQL_FETCHARRAY($result); - $data = array( - 'cnt' => $count, - 'menu' => $data['title'], + $content = SQL_FETCHARRAY($result); + $content = array( + 'count' => $count, + 'menu' => $content['title'], 'sel' => $sel, - 'visible' => addSelectionBox('yn', $data['visible'], 'visible', $sel), - 'locked' => addSelectionBox('yn', $data['locked'] , 'locked' , $sel), + 'visible' => addSelectionBox('yn', $content['visible'], 'visible', $sel), + 'locked' => addSelectionBox('yn', $content['locked'] , 'locked' , $sel), ); // Load template - $OUT .= loadTemplate('admin_menu_status_row', true, $data); + $OUT .= loadTemplate('admin_menu_status_row', true, $content); } else { // Entry not found? - $data = array( + $content = array( 'sel' => $sel ); // Load template - $OUT .= loadTemplate('admin_menu_404_row', true, $data); + $OUT .= loadTemplate('admin_menu_404_row', true, $content); } SQL_FREERESULT($result); } // END - if } // END - foreach $content['rows'] = $OUT; - $content['cnt'] = $count; + $content['count'] = $count; // Load template loadTemplate('admin_member_menu_status', false, $content); @@ -181,10 +181,10 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() if (!empty($subMenu)) { // Edit sub menus - $result = SQL_QUERY("SELECT `id`, `action`, `what`, `title`, `sort` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE ".$AND." AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC", __FILE__, __LINE__); + $result = SQL_QUERY("SELECT `id`,`action`,`what`,`title`,`sort` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE ".$AND." AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC", __FILE__, __LINE__); } else { // Edit main menus - $result = SQL_QUERY("SELECT `id`, `action`, `what`, `title`, `sort` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE (`what`='' OR `what` IS NULL) ORDER BY `sort` ASC", __FILE__, __LINE__); + $result = SQL_QUERY("SELECT `id`,`action`,`what`,`title`,`sort` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE (`what`='' OR `what` IS NULL) ORDER BY `sort` ASC", __FILE__, __LINE__); } // Some are there? @@ -193,31 +193,26 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() $content['sub'] = $subMenu; $count = '0'; $OUT = ''; - while ($data = SQL_FETCHARRAY($result)) { + while ($content = SQL_FETCHARRAY($result)) { // Init navigation - $data['navi'] = ''; + $content['navi'] = ''; $count++; - if (($data['sort'] == '0') || (($data['sort'] == 1) && (!empty($subMenu)))) { + if (($content['sort'] == '0') || (($content['sort'] == 1) && (!empty($subMenu)))) { // Is highest position - $data['navi'] = '{--LOWER--}'; + $content['navi'] = '{--LOWER--}'; } elseif ($count == SQL_NUMROWS($result)) { // Is lowest position - $data['navi'] = '{--HIGHER--}'; - } elseif ($data['sort'] > 0) { + $content['navi'] = '{--HIGHER--}'; + } elseif ($content['sort'] > 0) { // Anything else between highest and lowest - $data['navi'] = '{--HIGHER--}|{--LOWER--}'; + $content['navi'] = '{--HIGHER--}|{--LOWER--}'; } - // Fix empty values for Firefox - if (empty($data['action'])) $data['action'] = '---'; - if (empty($data['what'])) $data['what'] = '---'; - if (empty($data['title'])) $data['title'] = '---'; - // Add more entries - $data['mode'] = 'mem'; + $content['mode'] = 'mem'; // Load row template and switch color - $OUT .= loadTemplate('admin_menu_overview_row', true, $data); + $OUT .= loadTemplate('admin_menu_overview_row', true, $content); } // END - while // Free memory