Rewritten to not use anymore

[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 cf796793212c49c90d5c8c0b7ad6356ed91481a4..8100ac79d7357280ee95fb7446b10acc5d088c29 100644 (file)
--- a/inc/modules/admin/what-del_transfer.php
+++ b/inc/modules/admin/what-del_transfer.php
@@ -46,27 +46,26 @@ addMenuDescription('admin', __FILE__);
 
 if (isPostRequestElementSet('del')) {
        // Delete entries from tables
-       $SEL = countPostSelection();
-       if ($SEL > 0) {
+       if (countPostSelection() > 0) {
                // Init SQLs
                initSqls();
 
                // Delete entries...
                foreach (postRequestElement('sel') as $id => $sel) {
-                       addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE trans_id=%s LIMIT 1",
-                       array(bigintval($id)), __FILE__, __LINE__, false));
-                       addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE trans_id=%s LIMIT 1",
-                       array(bigintval($id)), __FILE__, __LINE__, false));
+                       addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE `trans_id`=%s LIMIT 1",
+                               array(bigintval($id)), __FILE__, __LINE__, false));
+                       addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE `trans_id`=%s LIMIT 1",
+                               array(bigintval($id)), __FILE__, __LINE__, false));
                } // END - foreach
 
                // Run all SQLs
                runFilterChain('run_sqls');
-       }
-}
+       } // END - if
+} // END - if
 
 // We only need outgoing transfers
-$result = SQL_QUERY("SELECT userid, to_userid, trans_id, points, reason, time_trans FROM `{?_MYSQL_PREFIX?}_user_transfers_out` ORDER BY trans_id", __FILE__, __LINE__);
-$total = 0;
+$result = SQL_QUERY("SELECT `userid`, `to_userid`, `trans_id`, `points`, `reason`, `time_trans` FROM `{?_MYSQL_PREFIX?}_user_transfers_out` ORDER BY `trans_id` ASC", __FILE__, __LINE__);
+$total = '0';
 if (SQL_NUMROWS($result) > 0) {
        // Output rows
        $OUT = ''; $SW = 2;
@@ -75,7 +74,7 @@ if (SQL_NUMROWS($result) > 0) {
                $content = array(
                        'sw'          => $SW,
                        'trans_id'    => $content['trans_id'],
-                       'stamp'       => generateDateTime($content['time_trans'], '3'),
+                       'stamp'       => generateDateTime($content['time_trans'], 3),
                        'userid_from' => generateUserProfileLink($content['userid']),
                        'userid_to'   => generateUserProfileLink($content['to_userid']),
                        'reason'      => $content['reason'],
@@ -87,7 +86,7 @@ if (SQL_NUMROWS($result) > 0) {
 
                // Sum points and switch colors
                $total += $content['points']; $SW = 3 - $SW;
-       }
+       } // END - while
 
        // Free memory
        SQL_FREERESULT($result);