Reset rewritten, SQL fixed, zeros are now numeric

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

diff --git a/inc/modules/admin/what-admins_mails.php b/inc/modules/admin/what-admins_mails.php
index d10136d258657076558bb1cd3ac41284b7320623..08c14b722df7a4c592dcca4b26c195ef823ac0ad 100644 (file)
--- a/inc/modules/admin/what-admins_mails.php
+++ b/inc/modules/admin/what-admins_mails.php
@@ -49,12 +49,12 @@ if (isset($_POST['edit']))
                // Add option for userlog
                $cacheArray['admins'] = ADD_OPTION_LINES("admins", "id", "login", "", "email");
                $SW = 2; $rowNameS = "";
-               foreach ($_POST['sel'] as $template=>$sel)
+               foreach ($_POST['sel'] as $template => $sel)
                {
                        // First of all load data from DB
                        $result = SQL_QUERY_ESC("SELECT admin_id, id FROM "._MYSQL_PREFIX."_admins_mails WHERE mail_template='%s' ORDER BY id",
                         array($template), __FILE__, __LINE__);
-                       $OUT = ""; $aid = "0"; $aid2 = "0";
+                       $OUT = ""; $aid = 0; $aid2 = 0;
                        while (list($aid, $id) = SQL_FETCHROW($result))
                        {
                                $OUT .= "<SELECT name=\"admin_id[".$id."]\" size=\"1\" class=\"admin_select\">
@@ -122,14 +122,14 @@ ORDER BY m.admin_id, m.mail_template", __FILE__, __LINE__);
                if (isset($_POST['change']))
                {
                        // Ok, update database
-                       foreach ($_POST['admin_id'] as $id=>$aid)
+                       foreach ($_POST['admin_id'] as $id => $aid)
                        {
                                // Secure IDs
                                $id  = bigintval($id);
                                $aid = bigintval($aid);
 
                                // Update entry
-                               $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admins_mails SET admin_id=%d WHERE id=%d ORDER BY id LIMIT 1",
+                               $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_admins_mails SET admin_id=%s WHERE id=%s ORDER BY id LIMIT 1",
                                 array($aid, $id), __FILE__, __LINE__);
 
                                if (($aid < 1) && (!empty($_POST['template'][$id])))