Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.

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

diff --git a/inc/modules/admin/what-list_transfer.php b/inc/modules/admin/what-list_transfer.php
index 57c9ed6d812208df9fd56413981c9722c059a1ae..035e1f04acfe36df8459588edcf3e5905f556383 100644 (file)
--- a/inc/modules/admin/what-list_transfer.php
+++ b/inc/modules/admin/what-list_transfer.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -43,8 +43,10 @@ if ((!defined('__SECURITY')) || (!isAdmin())) {
 // Add description as navigation point
 addYouAreHereLink('admin', __FILE__);
 
-// We only need outgoing transfers
-$result = SQL_QUERY('SELECT
+$total = '0';
+
+// Only out-going transfers are needed
+$result = sqlQuery('SELECT
        `userid` AS `from_userid`,
        `to_userid`,
        `trans_id`,
@@ -56,11 +58,10 @@ FROM
 ORDER BY
        `trans_id` ASC', __FILE__, __LINE__);
 
-$total = '0';
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNumRows($result)) {
        // Output rows
        $OUT = '';
-       while ($content = SQL_FETCHARRAY($result)) {
+       while ($content = sqlFetchArray($result)) {
                // Prepare data for the row template
                $content['time_trans']  = generateDateTime($content['time_trans'], 3);
 
@@ -70,7 +71,7 @@ if (!SQL_HASZERONUMS($result)) {
        } // END - while
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 } else {
        // Nothing for in and out
        $OUT = '<tr>