Reset rewritten, SQL fixed, zeros are now numeric

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

diff --git a/inc/modules/admin/what-del_transfer.php b/inc/modules/admin/what-del_transfer.php
index 27ace76a17cb7358e9ba9132f45761b1487e6be1..0f1b92788eda977fccf5ced8472938535f1bf3c0 100644 (file)
--- a/inc/modules/admin/what-del_transfer.php
+++ b/inc/modules/admin/what-del_transfer.php
@@ -48,11 +48,11 @@ if (isset($_POST['del']))
        if ($SEL > 0)
        {
                // Delete entries...
        if ($SEL > 0)
        {
                // Delete entries...

-               foreach ($_POST['sel'] as $id=>$sel)
+               foreach ($_POST['sel'] as $id => $sel)

                {
                {

-                       $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_in WHERE trans_id=%d LIMIT 1",
+                       $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_in WHERE trans_id=%s LIMIT 1",

                         array(bigintval($id)), __FILE__, __LINE__);
                         array(bigintval($id)), __FILE__, __LINE__);

-                       $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_out WHERE trans_id=%d LIMIT 1",
+                       $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_out WHERE trans_id=%s LIMIT 1",

                         array(bigintval($id)), __FILE__, __LINE__);
                }
        }
                         array(bigintval($id)), __FILE__, __LINE__);
                }
        }


@@ -60,7 +60,7 @@ if (isset($_POST['del']))
 
 // We only need outgoing transfers
 $result = SQL_QUERY("SELECT userid, to_uid, trans_id, points, reason, time_trans FROM "._MYSQL_PREFIX."_user_transfers_out ORDER BY trans_id", __FILE__, __LINE__);
 
 // We only need outgoing transfers
 $result = SQL_QUERY("SELECT userid, to_uid, trans_id, points, reason, time_trans FROM "._MYSQL_PREFIX."_user_transfers_out ORDER BY trans_id", __FILE__, __LINE__);

-$total = "0";
+$total = 0;

 if (SQL_NUMROWS($result) > 0)
 {
        // Output rows
 if (SQL_NUMROWS($result) > 0)
 {
        // Output rows