X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-guestedit.php;h=db713cff501284672a38901bb7840e20310309c1;hb=e297ccd93221dfbfd99f90ed160fb20df3524df0;hp=4587458acb697c599dcb9b80e7828d1e7c9d2f96;hpb=56931cd9321119dd37372bd16d6c552857e40066;p=mailer.git diff --git a/inc/modules/admin/what-guestedit.php b/inc/modules/admin/what-guestedit.php index 4587458acb..db713cff50 100644 --- a/inc/modules/admin/what-guestedit.php +++ b/inc/modules/admin/what-guestedit.php @@ -61,29 +61,30 @@ 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?}_guest_menu` WHERE ".$AND." AND `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `title`,`action`,`what` FROM `{?_MYSQL_PREFIX?}_guest_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); + $content = SQL_FETCHARRAY($result); // Prepapre content - $DATA = array( - 'cnt' => $count, + $content = array( + 'count' => $count, 'sel' => $sel, - 'action' => adminAddMenuSelectionBox('guest', 'action', 'sel_action[' . $sel . ']', $DATA['action']), - 'what' => adminAddMenuSelectionBox('guest', 'what' , 'sel_what[' . $sel . ']', $DATA['what']), - 'menu' => $DATA['title'], + 'action' => adminAddMenuSelectionBox('guest', 'action', 'sel_action[' . $sel . ']', $content['action']), + 'what' => adminAddMenuSelectionBox('guest', 'what' , 'sel_what[' . $sel . ']', $content['what']), + 'menu' => $content['title'], + 'sub' => $subMenu ); // Load row template - $OUT .= loadTemplate('admin_edit_guest_menu_row', true, $DATA); + $OUT .= loadTemplate('admin_edit_guest_menu_row', true, $content); } else { // Entry not found - $DATA = array( + $content = array( 'sel' => $sel ); - $OUT .= loadTemplate('admin_menu_404_row', true, $DATA); + $OUT .= loadTemplate('admin_menu_404_row', true, $content); } // Free result and switch color @@ -91,8 +92,10 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() } // END - if } // END - foreach - $content['rows'] = $OUT; - $content['cnt'] = $count; + $content['rows'] = $OUT; + $content['chk'] = countPostSelection(); + $content['sub'] = $subMenu; + $content['count'] = $count; // Load template loadTemplate('admin_edit_guest_menu_form', false, $content); @@ -111,25 +114,28 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() 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'], - 'sel' => $sel, + $content = SQL_FETCHARRAY($result); + $content = array( + 'count' => $count, + 'menu' => $content['title'], + 'sel' => $sel, ); - $OUT .= loadTemplate('admin_delete_guest_menu_row', true, $DATA); + $OUT .= loadTemplate('admin_delete_guest_menu_row', true, $content); } else { // Entry not found? - $DATA = array( + $content = array( 'sel' => $sel ); - $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['rows'] = $OUT; + $content['chk'] = countPostSelection(); + $content['sub'] = $subMenu; + $content['count'] = $count; // Load template loadTemplate('admin_delete_guest_menu', false, $content); @@ -143,34 +149,37 @@ 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?}_guest_menu` WHERE ".$AND." AND `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `title`,`visible`,`locked` FROM `{?_MYSQL_PREFIX?}_guest_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 ); - $OUT .= loadTemplate('admin_menu_404_row', true, $data); + $OUT .= loadTemplate('admin_menu_404_row', true, $content); } SQL_FREERESULT($result); } // END - if } // END - foreach - $content['cnt'] = $count; - $content['rows'] = $OUT; + + $content['rows'] = $OUT; + $content['chk'] = countPostSelection(); + $content['sub'] = $subMenu; + $content['count'] = $count; // Load template loadTemplate('admin_guest_menu_status', false, $content); @@ -184,52 +193,53 @@ if ((isFormSent('edit')) && (ifPostContainsSelections()) && (!isDemoModeActive() // By default list menus if (empty($subMenu)) { // List only main menus - $result = SQL_QUERY("SELECT `id`, `action`, `what`, `title`, `sort` FROM `{?_MYSQL_PREFIX?}_guest_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?}_guest_menu` WHERE (`what`='' OR `what` IS NULL) ORDER BY `sort` ASC", __FILE__, __LINE__); } else { // List sub menus - $result = SQL_QUERY_ESC("SELECT `id`, `action`, `what`, `title`, `sort` FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC", + $result = SQL_QUERY_ESC("SELECT `id`,`action`,`what`,`title`,`sort` FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC", array($subMenu), __FILE__, __LINE__); } // Do we have entries? if (!SQL_HASZERONUMS($result)) { - // Set sub value - $content['sub'] = $subMenu; - // Init variables $count = '0'; $OUT = ''; // Process all menu entries - while ($data = SQL_FETCHARRAY($result)) { + while ($content = SQL_FETCHARRAY($result)) { + // Set sub value + $content['sub'] = $subMenu; + $count++; - if (($data['sort'] == '0') || (($data['sort'] == 1) && (!empty($subMenu)))) { + if (($content['sort'] == '0') || (($content['sort'] == 1) && (!empty($subMenu)))) { // Is highest position - $NAVI = '{--LOWER--}'; + $NAVI = '{--LOWER--}'; } elseif ($count == SQL_NUMROWS($result)) { // Is lowest position - $NAVI = '{--HIGHER--}'; - } elseif ($data['sort'] > 0) { + $NAVI = '{--HIGHER--}'; + } elseif ($content['sort'] > 0) { // Anything else between highest and lowest - $NAVI = '{--HIGHER--}|{--LOWER--}'; + $NAVI = '{--HIGHER--}|{--LOWER--}'; } // Prepapre content - $row = array( - 'id' => $data['id'], - 'action' => $data['action'], - 'what' => $data['what'], - 'title' => $data['title'], + $content = array( + 'id' => $content['id'], + 'action' => $content['action'], + 'what' => $content['what'], + 'title' => $content['title'], 'navi' => $NAVI, 'mode' => 'guest' ); // Load row template - $OUT .= loadTemplate('admin_menu_overview_row', true, $row); + $OUT .= loadTemplate('admin_menu_overview_row', true, $content); } // END - while - // Add rows + // Add rows/sub $content['rows'] = $OUT; + $content['sub'] = $subMenu; // Free memory SQL_FREERESULT($result);