X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Flibs%2Fpayout_functions.php;h=7dea181c693d4411d0b977de9598bd8964e1884b;hb=ccd86939ba30aba70497c73264333f2fe4d786e8;hp=088a0b4eed8503819fc61d060377735bf6bc0a49;hpb=747c49b9f46a3d7d1d881c9e1c273ecf107f8d8b;p=mailer.git
diff --git a/inc/libs/payout_functions.php b/inc/libs/payout_functions.php
index 088a0b4eed..7dea181c69 100644
--- a/inc/libs/payout_functions.php
+++ b/inc/libs/payout_functions.php
@@ -1,7 +1,7 @@
0) {
// Pay this out!
- $result = SQL_QUERY_ESC("SELECT id, type, rate, min_points
-FROM `{!MYSQL_PREFIX!}_payout_types`
-WHERE %s >= min_points
-ORDER BY type", array($points), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) > 0) {
- OUTPUT_HTML("
-
".PAYOUT_NOW.":
-
");
+ $result = SQL_QUERY_ESC("SELECT
+ `id`,`type`,`rate`,`min_points`
+FROM
+ `{?_MYSQL_PREFIX?}_payout_types`
+WHERE
+ %s >= `min_points`
+ORDER BY
+ `type` ASC",
+ array($points), __FUNCTION__, __LINE__);
+ if (!SQL_HASZERONUMS($result)) {
+ // Init output
+ $OUT = '';
+
// Now let's check
- while (list($id, $type, $rate, $mpoi) = SQL_FETCHROW($result)) {
- $type = COMPILE_CODE($type);
- if ($points >= $mpoi) {
- // Ok we found one
- $P = $points * $rate - 0.5;
- OUTPUT_HTML("- ".PAYOUT_IN.": ".$type." (".PAYOUT_MAX." ".round($P)." ".$type.")
");
- }
- }
+ while ($content = SQL_FETCHARRAY($result)) {
+ // Are these points enougth?
+ if ($points >= $content['min_points']) {
+ // Prepare content for template
+ $content['points'] = translateComma($points * $content['rate'] - 0.5);
- // Free memory
- SQL_FREERESULT($result);
- OUTPUT_HTML("
");
+ // Load row template
+ $OUT .= loadTemplate('member_payout_li', true, $content);
+ } // END - if
+ } // END - while
+
+ // Load main template
+ loadTemplate('member_payout_list', true, $OUT);
} else {
// No payout types setup so far
- LOAD_TEMPLATE("admin_settings_saved", false, "".PAYOUT_NO_PAYOUT_TYPES."
".PAYOUT_NO_POINTS_ENTERED."