\n"; // Get current month (2 digits) $curr = date("m", time()); // Check if month is done if (($curr != getConfig('last_month')) && (getConfig('last_month') > 0) && (getConfig('beg_ranks') > 0) && ($CSS != 1)) { // Extension "autopurge" is inactive or purging of inactive accounts is deactivated $whereStatement1 = ""; $whereStatement2 = bigintval(getConfig('beg_ranks')); // Shall we exclude webmaster's own userid? if ((getConfig('beg_include_own') == "N") && (getConfig('beg_uid') > 0)) { // Exclude it $whereStatement1 = sprintf(" AND userid != %s", bigintval(getConfig('beg_uid'))); } // END - if // 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 ((getConfig('ap_inactive_since') > 0) && (getConfig('beg_active') == "Y")) { // Okay, include last online timestamp $whereStatement1 .= sprintf(" AND last_online >= (UNIX_TIMESTAMP() - %s)", bigintval(getConfig('ap_inactive_since')));; } // 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("monthly_beg", $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 // ?>