X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fpayout_functions.php;h=d22a2864c6a32317026eef6b0db78a9d88202046;hb=4b9a37b0cb430ee8b1f71f837b2f9b2e5dd568f5;hp=f524c2ae252ff42c55a2f4f2774e2b3244e10827;hpb=ac04130f9ccbaba51d7d7992d8a10c38db776eee;p=mailer.git diff --git a/inc/libs/payout_functions.php b/inc/libs/payout_functions.php index f524c2ae25..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), __FILE__, __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.":

-
"); + // 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_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--}
'); } }