Email details and bonus mails in admin swapped out to template

[mailer.git] / inc / modules / admin / what-repair_amnu.php

diff --git a/inc/modules/admin/what-repair_amnu.php b/inc/modules/admin/what-repair_amnu.php
index 35f926b828e8b51ed2e69102e6daf58c9fbc8bdc..75872b180c63a5bbdd5f95d0c6c353af8e76143a 100644 (file)
--- a/inc/modules/admin/what-repair_amnu.php
+++ b/inc/modules/admin/what-repair_amnu.php
@@ -40,7 +40,6 @@ if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!IS_ADMIN()))
 // Add description as navigation point
 ADD_DESCR("admin", basename(__FILE__));
 
-global $link;
 $ACTIONs = array();
 // First fix all main menus (what="")...
 $result_fix = SQL_QUERY("SELECT id, action FROM "._MYSQL_PREFIX."_admin_menu WHERE (what='' OR what IS NULL) AND action != 'logout' ORDER BY sort ASC", __FILE__, __LINE__);
@@ -51,7 +50,7 @@ while(list($id, $act) = SQL_FETCHROW($result_fix))
        $ACTIONs[] = $act;
 
        // Fix weight
-       $result_sort = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admin_menu SET sort='%s' WHERE id=%d LIMIT 1",
+       $result_sort = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admin_menu SET sort='%s' WHERE id=%s LIMIT 1",
         array($cnt, bigintval($id)), __FILE__, __LINE__);
        $REP += SQL_AFFECTEDROWS();
 
@@ -74,7 +73,7 @@ foreach ($ACTIONs as $act)
        while (list($id) = SQL_FETCHROW($result_fix))
        {
                // Fix weight
-               $result_sort = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admin_menu SET sort='%s' WHERE id=%d LIMIT 1",
+               $result_sort = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admin_menu SET sort='%s' WHERE id=%s LIMIT 1",
                 array($cnt, bigintval($id)), __FILE__, __LINE__);
                $REP += SQL_AFFECTEDROWS();