{
// Extension "autopurge" is inactive or purging of inactive accounts is deactivated
$whereStatement1 = "";
- $whereStatement2 = 0;
- $whereStatement3 = bigintval($_CONFIG['beg_ranks']);
+ $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_in_since'] > 0) && ($_CONFIG['beg_active'] == "Y"))
+ if (($_CONFIG['ap_inactive_since'] > 0) && ($_CONFIG['beg_active'] == "Y"))
{
// Okay, include last online timestamp
- $whereStatement1 = "AND last_online >=";
- $whereStatement2 = bigintval(time() - $_CONFIG['ap_in_since']);
- $whereStatement3 = bigintval($_CONFIG['beg_ranks']);
+ $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." %s AND beg_points > 0 ORDER BY beg_points DESC, userid LIMIT %s",
- array($whereStatement2, $whereStatement3), __FILE__, __LINE__);
+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)
- {
+ if (SQL_NUMROWS($result_main) > 0) {
// Load our winners...
$UIDs = "";
- while(list($uid, $email, $points) = SQL_FETCHROW($result_main))
- {
+ while(list($uid, $email, $points) = SQL_FETCHROW($result_main)) {
// 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=%s LIMIT 1",
array($points, bigintval($uid)), __FILE__, __LINE__);
// Update mediadata as well
- if (GET_EXT_VERSION("mediadata") >= "0.0.4")
- {
+ if (GET_EXT_VERSION("mediadata") >= "0.0.4") {
// Update database
MEDIA_UPDATE_ENTRY(array("total_points"), "add", $points);
}
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__);
+ $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data SET beg_points=0.00000 WHERE beg_points > 0", __FILE__, __LINE__);
}
// Free memory