X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fpayout_functions.php;h=65eb2937ba9e8a8290886e609a0204919078fbd5;hb=62b4ef5bb0b63f7cac5f0dccd816246a108a5d83;hp=df8b39e84078580fd3e799dca4370db51e518a49;hpb=4001187f22197f55e5a1f211fc8defcc180f7c32;p=mailer.git diff --git a/inc/libs/payout_functions.php b/inc/libs/payout_functions.php index df8b39e840..65eb2937ba 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--}:

-
"); + // 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--}{--PAYOUT_NO_POINTS_ENTERED--}{--PAYOUT_NO_POINTS_ENTERED--}