X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-repair_mmnu.php;h=42dd10ac4cfc57a4a55baab533c39511d2ac5803;hp=17b2f931c05501bbccb2f1f9495ab28340c76de7;hb=682edce003a1a91f66fb8e2212d7fdb591379843;hpb=e523b69ecd6c7f37ae1cb36872537073b40c0e27 diff --git a/inc/modules/admin/what-repair_mmnu.php b/inc/modules/admin/what-repair_mmnu.php index 17b2f931c0..42dd10ac4c 100644 --- a/inc/modules/admin/what-repair_mmnu.php +++ b/inc/modules/admin/what-repair_mmnu.php @@ -47,18 +47,18 @@ $actions = array(); // First fix all main menus (what = '')... $result_fix = SQL_QUERY("SELECT `id`, `action` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE (`what`='' OR `what` IS NULL) AND `action` != 'logout' ORDER BY `sort` ASC", __FILE__, __LINE__); -$cnt = '0'; $repairedWeights = '0'; +$count = '0'; $repairedWeights = '0'; while ($content = SQL_FETCHARRAY($result_fix)) { // Store action value for later usage in sorting sub menus $actions[] = $content['action']; // Fix weight SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `sort`=%s WHERE `id`=%s LIMIT 1", - array($cnt, $content['id']), __FILE__, __LINE__); + array($count, $content['id']), __FILE__, __LINE__); $repairedWeights += SQL_AFFECTEDROWS(); // Count one up - $cnt++; + $count++; } // END - while // Set logout weight to 999 @@ -68,15 +68,15 @@ SQL_QUERY("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET sort='999' WHERE `action`= foreach ($actions as $action) { $result_fix = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC", array($action), __FILE__, __LINE__); - $cnt = 1; + $count = 1; while ($content = SQL_FETCHARRAY($result_fix)) { // Fix weight SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET sort=%s WHERE `id`=%s LIMIT 1", - array($cnt, $content['id']), __FILE__, __LINE__); + array($count, $content['id']), __FILE__, __LINE__); $repairedWeights += SQL_AFFECTEDROWS(); // Count one up - $cnt++; + $count++; } // END - while } // END - foreach