\n"; // Get current month (2 digits) $curr = date("m", time()); // Check if month is done if (($curr != $_CONFIG['last_month']) && ($_CONFIG['last_month'] > 0) && ($_CONFIG['beg_ranks'] > 0) && ($CSS != 1)) { // Extension "autopurge" is inactive or purging of inactive accounts is deactivated $whereStatement1 = ""; $whereStatement2 = 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_inactive_since'] > 0) && ($_CONFIG['beg_active'] == "Y")) { // Okay, include last online timestamp $whereStatement1 = sprintf(" AND last_online >= (UNIX_TIMESTAMP() - %s)", bigintval($_CONFIG['ap_inactive_since']));; $whereStatement2 = bigintval($_CONFIG['beg_ranks']); } // END - if } // END - if // SQL string to check for accounts $result_main = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, beg_points AS points FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED'".$whereStatement1." AND beg_points > 0 ORDER BY beg_points DESC, userid LIMIT %s", array($whereStatement2), __FILE__, __LINE__); if (SQL_NUMROWS($result_main) > 0) { // Load our winners... while ($content = SQL_FETCHARRAY($result_main)) { // Add points to user's account directly ADD_POINTS_REFSYSTEM($content['userid'], $content['points'], false, "0", false, "direct"); // Translate gender/points $content['gender'] = TRANSLATE_GENDER($content['gender']); $content['points'] = TRANSLATE_COMMA($content['points']); // Load email template and email it away $msg = LOAD_EMAIL_TEMPLATE("member_beg", $content, bigintval($content['userid'])); SEND_EMAIL($content['email'], BEG_MONTHLY_RALLYE, $msg); } // END - while // Reset accounts $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data SET beg_points=0.00000 WHERE beg_points > 0", __FILE__, __LINE__); } // END - if // Free memory SQL_FREERESULT($result_main); } // END - if // ?>