\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']); } } // SQL string to check for accounts $result_main = SQL_QUERY_ESC("SELECT userid, email, beg_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... $UIDs = ""; while(list($uid, $email, $points) = SQL_FETCHROW($result_main)) { // Add points to user's account directly ADD_POINTS_REFSYSTEM($uid, $points, false, "0", false, "direct"); // Load email template and email it away $msg = LOAD_EMAIL_TEMPLATE("member_beg", $points, bigintval($uid)); SEND_EMAIL($email, BEG_MONTHLY_RALLYE, $msg); } // Remove first commata $UIDs = substr($UIDs, 1); // Get current month $curr = date("m", time()); if (strlen($curr) == 1) $curr = "0".$curr; if ($curr == "00") $curr = "12"; // Reset accounts $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data SET beg_points=0.00000 WHERE beg_points > 0", __FILE__, __LINE__); } // Free memory SQL_FREERESULT($result_main); } // ?>