X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-repair_mmnu.php;h=ac688c979667c5fd52a2d813a6869a3350cdbcdc;hp=c471fe5e96508102603d8564f9b376c75c2d7f6f;hb=0f3a135204757cc8750262871c8e62c42300acb4;hpb=e2148142f8b1a8f40fd6e7ca32185569c5a9083e diff --git a/inc/modules/admin/what-repair_mmnu.php b/inc/modules/admin/what-repair_mmnu.php index c471fe5e96..ac688c9796 100644 --- a/inc/modules/admin/what-repair_mmnu.php +++ b/inc/modules/admin/what-repair_mmnu.php @@ -14,10 +14,9 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -39,57 +38,57 @@ // Some security stuff... if ((!defined('__SECURITY')) || (!isAdmin())) { die(); -} +} // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); -$ACTIONS = array(); +$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'; $REP = '0'; +$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__); +$count = '0'; $repairedWeights = '0'; while ($content = SQL_FETCHARRAY($result_fix)) { // Store action value for later usage in sorting sub menus - $ACTIONS[] = $content['action']; + $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__); - $REP += SQL_AFFECTEDROWS(); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `sort`=%s WHERE `id`=%s LIMIT 1", + array($count, $content['id']), __FILE__, __LINE__); + $repairedWeights += SQL_AFFECTEDROWS(); // Count one up - $cnt++; -} + $count++; +} // END - while // Set logout weight to 999 SQL_QUERY("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET sort='999' WHERE `action`='logout' AND (`what`='' OR `what` IS NULL) LIMIT 1", __FILE__, __LINE__); // Now sort every each menu -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`", +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__); - $REP += SQL_AFFECTEDROWS(); + array($count, $content['id']), __FILE__, __LINE__); + $repairedWeights += SQL_AFFECTEDROWS(); // Count one up - $cnt++; - } -} + $count++; + } // END - while +} // END - foreach // Repair finished -if ($REP > 0) { - $message = sprintf(getMessage('ADMIN_REPAIR_ENTRIES_FIXED'), $REP); +if ($repairedWeights > 0) { + $message = '{%message,ADMIN_REPAIR_ENTRIES_FIXED=' . $repairedWeights . '%}'; } else { - $message = getMessage('ADMIN_REPAIR_NOTHING_FIXED'); + $message = '{--ADMIN_REPAIR_NOTHING_FIXED--}'; } // Output message -loadTemplate('admin_settings_saved', false, $message); +displayMessage($message); -// +// [EOF] ?>