X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fpayout_functions.php;h=d22a2864c6a32317026eef6b0db78a9d88202046;hb=fd4bf800943a932696a2d2c25f702a771c2c3cf9;hp=84357a9f77d19751c07683abd07a9a1cf30504bc;hpb=a84b517e5ce0d1601ca09082aad89f9b673bc202;p=mailer.git
diff --git a/inc/libs/payout_functions.php b/inc/libs/payout_functions.php
index 84357a9f77..d22a2864c6 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), __FUNCTION__, __LINE__);
+ $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_NUMROWS($result) > 0) {
- OUTPUT_HTML("
-
{--PAYOUT_NOW--}:
-
");
// Now let's check
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 * $content['rate'] - 0.5;
- OUTPUT_HTML("- {--PAYOUT_IN--}: ".$content['type']." ({--PAYOUT_MAX--} ".round($P)." ".$content['type'].")
");
+ // Prepare content for template
+ $content['points'] = translateComma($points * $content['rate'] - 0.5);
+
+ // Load row template
+ $OUT .= loadTemplate('member_payout_li', true, $content);
} // END - if
} // END - while
- OUTPUT_HTML("
");
+ // 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_PAYOUT_TYPES--}');
}
// Free memory
SQL_FREERESULT($result);
} else {
// Points is empty
- LOAD_TEMPLATE('admin_settings_saved', false, "{--PAYOUT_NO_POINTS_ENTERED--}
{--PAYOUT_NO_POINTS_ENTERED--}');
}
}