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

[mailer.git] / inc / modules / member / what-transfer.php

diff --git a/inc/modules/member/what-transfer.php b/inc/modules/member/what-transfer.php
index 6f334187822f2e4488d55ce02ddce06388f041b6..884e31b08df41383e8980ef408d08033f931768d 100644 (file)
--- a/inc/modules/member/what-transfer.php
+++ b/inc/modules/member/what-transfer.php
@@ -216,7 +216,7 @@ switch ($mode) {
                        $result = sqlQueryEscaped("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED'" . runFilterChain('user_exclusion_sql', ' ') . " AND `opt_in`='Y' AND `userid` != '%s' ORDER BY `userid` ASC",
                                array(getMemberId()), __FILE__, __LINE__);
 
-                       if (!ifSqlHasZeroNums($result)) {
+                       if (!ifSqlHasZeroNumRows($result)) {
                                // Load list
                                $OUT  = '<select name="to_userid" size="1" class="form_select">
        <option value="0">{--SELECT_NONE--}</option>';
@@ -300,7 +300,7 @@ switch ($mode) {
                $result = sqlQueryEscaped($sql, array(getMemberId()), __FILE__, __LINE__);
 
                // Are there entries?
-               if (!ifSqlHasZeroNums($result)) {
+               if (!ifSqlHasZeroNumRows($result)) {
                        $OUT = '';
                        while ($content = sqlFetchArray($result)) {
                                // Rewrite points, out is subtracted
@@ -386,7 +386,7 @@ INDEX (`party_userid`)
                        array(getMemberId()), __FILE__, __LINE__);
 
                $total = '0';
-               if (!ifSqlHasZeroNums($result)) {
+               if (!ifSqlHasZeroNumRows($result)) {
                        // Output rows
                        $OUT = '';
                        while ($content = sqlFetchArray($result)) {