X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-repair_gmnu.php;h=030fb911ce64d468f18194675decaf50251228de;hp=71c833ce725589487b2e503d053e830b8f4cec01;hb=682edce003a1a91f66fb8e2212d7fdb591379843;hpb=e523b69ecd6c7f37ae1cb36872537073b40c0e27 diff --git a/inc/modules/admin/what-repair_gmnu.php b/inc/modules/admin/what-repair_gmnu.php index 71c833ce72..030fb911ce 100644 --- a/inc/modules/admin/what-repair_gmnu.php +++ b/inc/modules/admin/what-repair_gmnu.php @@ -47,20 +47,20 @@ $actions = array(); // First fix all main menus (what = '')... $result_fix = SQL_QUERY("SELECT `id`, `action` FROM `{?_MYSQL_PREFIX?}_guest_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 act value for later usage in sorting sub menus $actions[] = $content['action']; // Fix weight $result_sort = SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `sort`=%s WHERE `id`=%s LIMIT 1", - array($cnt, $content['id']), __FILE__, __LINE__); + array($count, $content['id']), __FILE__, __LINE__); // Get updated rows $repairedWeights += SQL_AFFECTEDROWS(); // Count one up - $cnt++; + $count++; } // END - while // Set logout weight to 999 @@ -70,15 +70,15 @@ $result_sort = SQL_QUERY("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET sort='999' W foreach ($actions as $action) { $result_fix = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_guest_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?}_guest_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