X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmonthly%2Fmonthly_bonus.php;h=e425c8f1ac13216546df38cbb03bcb52fee7c6e9;hp=d877e5e6f9f50bf9818b108ea9f6f6f14d551047;hb=52e8a0635bd0b7c653845685c55e4e5f251375fe;hpb=4d6226782aa4ba157dca8c3891412ba50159481f diff --git a/inc/monthly/monthly_bonus.php b/inc/monthly/monthly_bonus.php index d877e5e6f9..e425c8f1ac 100644 --- a/inc/monthly/monthly_bonus.php +++ b/inc/monthly/monthly_bonus.php @@ -49,41 +49,41 @@ if (($CSS == 1) || (!defined('__DAILY_RESET'))) return; // Get current month (2 digits) $curr = date("m", time()); -if (($curr != $CONFIG['bonus_month']) && ($CONFIG['bonus_ranks'] > 0) && ($CSS != 1)) +if (($curr != $_CONFIG['bonus_month']) && ($_CONFIG['bonus_ranks'] > 0) && ($CSS != 1)) { // Extension "autopurge" is inactive or purging of inactive accounts is deactivated - $WHERE1 = "WHERE status='CONFIRMED'"; - $WHERE2 = 0; - $WHERE3 = bigintval($CONFIG['bonus_ranks']); + $whereStatement1 = "WHERE status='CONFIRMED'"; + $whereStatement2 = 0; + $whereStatement3 = bigintval($_CONFIG['bonus_ranks']); // Shall I keep inactive members away from here? (mostly wanted in an "active-rallye" ...) if (EXT_IS_ACTIVE("autopurge")) { // Use last online stamp only when autopurge for inactive members is activated - if ($CONFIG['ap_in_since'] > 0) + if ($_CONFIG['ap_in_since'] > 0) { // Okay, include last online timestamp - $WHERE1 = "WHERE status='CONFIRMED' AND last_online >="; - $WHERE2 = bigintval(time() - $CONFIG['ap_in_since']); - $WHERE3 = bigintval($CONFIG['bonus_ranks']); + $whereStatement1 = "WHERE status='CONFIRMED' AND last_online >="; + $whereStatement2 = bigintval(time() - $_CONFIG['ap_in_since']); + $whereStatement3 = bigintval($_CONFIG['bonus_ranks']); } } // Add more bonus points here $ADD = " AND (0"; - if ($CONFIG['bonus_click_yn'] == 'Y') $ADD .= " + turbo_bonus"; - if ($CONFIG['bonus_login_yn'] == 'Y') $ADD .= " + login_bonus"; - if ($CONFIG['bonus_order_yn'] == 'Y') $ADD .= " + bonus_order"; - if ($CONFIG['bonus_stats_yn'] == 'Y') $ADD .= " + bonus_stats"; - if ($CONFIG['bonus_ref_yn'] == 'Y') $ADD .= " + bonus_ref"; + if ($_CONFIG['bonus_click_yn'] == 'Y') $ADD .= " + turbo_bonus"; + if ($_CONFIG['bonus_login_yn'] == 'Y') $ADD .= " + login_bonus"; + if ($_CONFIG['bonus_order_yn'] == 'Y') $ADD .= " + bonus_order"; + if ($_CONFIG['bonus_stats_yn'] == 'Y') $ADD .= " + bonus_stats"; + if ($_CONFIG['bonus_ref_yn'] == 'Y') $ADD .= " + bonus_ref"; $ADD .= ") > 0"; // SQL string to check for accounts $result_main = SQL_QUERY_ESC("SELECT userid, email, (turbo_bonus + login_bonus + bonus_order + bonus_stats + bonus_ref) AS active_bonus FROM "._MYSQL_PREFIX."_user_data -".$WHERE1." %s".$ADD." +".$whereStatement1." %s".$ADD." ORDER BY active_bonus DESC, userid LIMIT %s", - array($WHERE2, $WHERE3), __FILE__, __LINE__); + array($whereStatement2, $whereStatement3), __FILE__, __LINE__); if (SQL_NUMROWS($result_main) > 0) { @@ -128,8 +128,8 @@ SET turbo_bonus=0, login_bonus=0, bonus_order=0, bonus_stats=0, bonus_ref=0", __ SQL_FREERESULT($result_main); // Finally update database and config array - $CONFIG['bonus_month'] = $curr; - $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET last_bonus_month='%s' WHERE config='0' LIMIT 1", + $_CONFIG['bonus_month'] = $curr; + $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET last_bonus_month='%s' WHERE config=0 LIMIT 1", array($curr), __FILE__, __LINE__); // Destroy cache