X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-bonus.php;h=6b655305faca120b977ce9e1b8caca0f84993522;hb=83475fa12b58b4be5f91c21c1afff87ae49c11e4;hp=8b13ded196e1674a96c90653740c5857c954093e;hpb=2f0357c7ac9da6c17d361b8e7cb0b1ad09eb85f6;p=mailer.git diff --git a/inc/modules/member/what-bonus.php b/inc/modules/member/what-bonus.php index 8b13ded196..6b655305fa 100644 --- a/inc/modules/member/what-bonus.php +++ b/inc/modules/member/what-bonus.php @@ -1,7 +1,7 @@ = '0.6.9') { +if (getExtensionVersion('bonus') >= '0.6.9') { // Add more bonus points here // @TODO Rewrite this to a filter - $USE = "(0"; - if (getConfig('bonus_click_yn') == 'Y') $USE .= " + turbo_bonus"; - if (getConfig('bonus_login_yn') == 'Y') $USE .= " + login_bonus"; - if (getConfig('bonus_order_yn') == 'Y') $USE .= " + bonus_order"; - if (getConfig('bonus_stats_yn') == 'Y') $USE .= " + bonus_stats"; - if (getConfig('bonus_ref_yn') == 'Y') $USE .= " + bonus_ref"; - $USE .= ")"; + $USE = '(0'; + if (getConfig('bonus_click_yn') == 'Y') $USE .= ' + `turbo_bonus`'; + if (getConfig('bonus_login_yn') == 'Y') $USE .= ' + `login_bonus`'; + if (getConfig('bonus_order_yn') == 'Y') $USE .= ' + `bonus_order`'; + if (getConfig('bonus_stats_yn') == 'Y') $USE .= ' + `bonus_stats`'; + if (getConfig('bonus_ref_yn') == 'Y') $USE .= ' + `bonus_ref`'; + $USE .= ')'; } else { // Old version ??? - $USE = "turbo_bonus"; + $USE = '`turbo_bonus`'; } // Autopurge installed? $lastOnline = "%s"; $ONLINE = ''; -if (EXT_IS_ACTIVE('autopurge')) { +if (isExtensionActive('autopurge')) { // Use last online timestamp to keep inactive members away from here - $lastOnline = " AND last_online >= (UNIX_TIMESTAMP() - %s)"; + $lastOnline = " AND `last_online` >= (UNIX_TIMESTAMP() - %s)"; $ONLINE = getConfig('ap_inactive_since'); } -// Let's check if there are some points left we can "pay"... -$result = SQL_QUERY_ESC("SELECT userid, ".$USE." AS points, last_online FROM `{!_MYSQL_PREFIX!}_user_data` -WHERE ".$USE." > 0 AND `status`='CONFIRMED'".$lastOnline." -ORDER BY points DESC, last_online DESC, userid +// Let's check if there are some points left we can 'pay'... +$result = SQL_QUERY_ESC("SELECT + `userid`, ".$USE." AS points, `last_online` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + ".$USE." > 0 AND `status`='CONFIRMED'".$lastOnline." +ORDER BY + `points` DESC, + last_online DESC, + userid ASC LIMIT %s", - array($ONLINE, getConfig('bonus_ranks')), __FILE__, __LINE__); + array( + $ONLINE, + getConfig('bonus_ranks') + ), __FILE__, __LINE__); // Reset temporary variable and check for users $OUT = ''; @@ -88,31 +99,32 @@ if (SQL_NUMROWS($result) > 0) { while ($content = SQL_FETCHARRAY($result)) { // Prepare data for the template $content = array( - $content['sw'] = $SW; - $content['cnt'] = $cnt; - $content['uid'] = bigintval($content['uid']); - $content['points'] = TRANSLATE_COMMA($content['points']); - $content['last'] = MAKE_DATETIME($content['last'], "2"); + 'sw' => $SW, + 'cnt' => $cnt, + 'userid' => bigintval($content['userid']), + 'points' => translateComma($content['points']), + 'last_online' => generateDateTime($content['last_online'], 2) + ); // Load row template - $OUT .= LOAD_TEMPLATE("member_bonus_row", true, $content); + $OUT .= loadTemplate('member_bonus_row', true, $content); // Count one up and switch colors - $cnt++;$SW = 3 - $SW; + $cnt++; $SW = 3 - $SW; } } else { // No one is interested in our "active rallye" ! :-( - $OUT = LOAD_TEMPLATE("member_bonus_404", true); + $OUT = loadTemplate('member_bonus_404', true); } // Free memory SQL_FREERESULT($result); -// Remeber row(s) for the template -define('__BONUS_ROWS', $OUT); +// Prepare content array +$content['rows'] = $OUT; // Load final template -LOAD_TEMPLATE("member_bonus"); +loadTemplate('member_bonus', false, $content); -// +// [EOF] ?>