A lot while() conditions rewritten to SQL_FETCHARRAY(), see bug #107, @TODO tags...

[mailer.git] / inc / libs / payout_functions.php

diff --git a/inc/libs/payout_functions.php b/inc/libs/payout_functions.php
index 9ab7329ec72f39bdf6b3bcce7ca92983758f03dd..df8b39e84078580fd3e799dca4370db51e518a49 100644 (file)
--- a/inc/libs/payout_functions.php
+++ b/inc/libs/payout_functions.php
@@ -40,7 +40,9 @@ if (!defined('__SECURITY')) {
 //
 function PAYOUT_OUTPUT_PAYOUT_LIST ($points) {
        // Replace german decimal comma with CPU's decimal dot
-       $points = strval(REVERT_COMMA($points));
+       $points = REVERT_COMMA($points);
+
+       // Enougth points?
        if ($points > 0) {
                // Pay this out!
                $result = SQL_QUERY_ESC("SELECT id, type, rate, min_points
@@ -52,14 +54,17 @@ ORDER BY type", array($points), __FUNCTION__, __LINE__);
 <div align=\"center\"><strong>{--PAYOUT_NOW--}:</strong></div><br />
 <ul>");
                        // Now let's check
-                       while (list($id, $type, $rate, $mpoi) = SQL_FETCHROW($result)) {
-                               $type = COMPILE_CODE($type);
-                               if ($points >= $mpoi) {
+                       while ($content = SQL_FETCHARRAY($result)) {
+                               // Compile the type
+                               $content['type'] = COMPILE_CODE($content['type']);
+
+                               // Are these points enougth?
+                               if ($points >= $content['min_points']) {
                                        // Ok we found one
-                                       $P = $points * $rate - 0.5;
-                                       OUTPUT_HTML("<li>{--PAYOUT_IN--}: <strong><a href=\"{!URL!}/modules.php?module=login&amp;what=payout&amp;payout=".$id."\">".$type." ({--PAYOUT_MAX--} ".round($P)." ".$type.")</a></strong></li>");
-                               }
-                       }
+                                       $P = $points * $content['rate'] - 0.5;
+                                       OUTPUT_HTML("<li>{--PAYOUT_IN--}: <strong><a href=\"{!URL!}/modules.php?module=login&amp;what=payout&amp;payout=".$content['id']."\">".$content['type']." ({--PAYOUT_MAX--} ".round($P)." ".$content['type'].")</a></strong></li>");
+                               } // END - if
+                       } // END - while
 
                        OUTPUT_HTML("</ul></div>");
                } else {