X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmonthly%2Fmonthly_beg.php;h=ed17e83ac9743ecb202570a6af2c4b4b33ba0fae;hb=a2c2e0711e61b8ba5f3ee1fd4b3958d9014669a6;hp=c944d040425933ba4b24c50725fa21d4d96aef2b;hpb=e0408cc79990e2a8d2b2a2476a3f2be346df48cd;p=mailer.git diff --git a/inc/monthly/monthly_beg.php b/inc/monthly/monthly_beg.php index c944d04042..ed17e83ac9 100644 --- a/inc/monthly/monthly_beg.php +++ b/inc/monthly/monthly_beg.php @@ -50,30 +50,30 @@ if (($CSS == 1) || (!defined('__DAILY_RESET'))) return; $curr = date("m", time()); // Check if month is done -if (($curr != $CONFIG['beg_month']) && ($CONFIG['beg_month'] > 0) && ($CONFIG['beg_ranks'] > 0) && ($CSS != 1)) +if (($curr != $_CONFIG['beg_month']) && ($_CONFIG['beg_month'] > 0) && ($_CONFIG['beg_ranks'] > 0) && ($CSS != 1)) { // Extension "autopurge" is inactive or purging of inactive accounts is deactivated - $WHERE1 = ""; - $WHERE2 = 0; - $WHERE3 = bigintval($CONFIG['beg_ranks']); + $whereStatement1 = ""; + $whereStatement2 = 0; + $whereStatement3 = bigintval($_CONFIG['beg_ranks']); // Let's check if there are some points left we can "pay"... if (EXT_IS_ACTIVE("autopurge")) { // Use last online stamp only when autopurge for inactive members is activated - if (($CONFIG['ap_in_since'] > 0) && ($CONFIG['beg_active'] == 'Y')) + if (($_CONFIG['ap_in_since'] > 0) && ($_CONFIG['beg_active'] == 'Y')) { // Okay, include last online timestamp - $WHERE1 = "AND last_online >="; - $WHERE2 = bigintval(time() - $CONFIG['ap_in_since']); - $WHERE3 = bigintval($CONFIG['beg_ranks']); + $whereStatement1 = "AND last_online >="; + $whereStatement2 = bigintval(time() - $_CONFIG['ap_in_since']); + $whereStatement3 = bigintval($_CONFIG['beg_ranks']); } } // SQL string to check for accounts $result_main = SQL_QUERY_ESC("SELECT userid, email, beg_points -FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' ".$WHERE1." %s AND beg_points > 0 ORDER BY beg_points DESC, userid LIMIT %s", - array($WHERE2, $WHERE3), __FILE__, __LINE__); +FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' ".$whereStatement1." %s AND beg_points > 0 ORDER BY beg_points DESC, userid LIMIT %s", + array($whereStatement2, $whereStatement3), __FILE__, __LINE__); if (SQL_NUMROWS($result_main) > 0) { @@ -83,7 +83,7 @@ FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' ".$WHERE1." %s AND beg { // Add points to user's account directly $result_data = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points -SET points=points+%s WHERE ref_depth='0' AND userid=%d LIMIT 1", +SET points=points+%s WHERE ref_depth=0 AND userid=%d LIMIT 1", array($points, bigintval($uid)), __FILE__, __LINE__); // Update mediadata as well @@ -115,8 +115,8 @@ SET points=points+%s WHERE ref_depth='0' AND userid=%d LIMIT 1", SQL_FREERESULT($result_main); // Finally update database and config array - $CONFIG['beg_month'] = $curr; - $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET beg_month='%s' WHERE config='0' LIMIT 1", + $_CONFIG['beg_month'] = $curr; + $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET beg_month='%s' WHERE config=0 LIMIT 1", array($curr), __FILE__, __LINE__); // Destroy cache