All pastes #2048406 Raw Edit

Mine

public text v1 · immutable
#2048406 ·published 2011-04-19 19:57 UTC
rendered paste body
//==Disabled inactive users
    $days = 90; //==days of inactivity
          $dt= time() - ($days * 86400);
    $res = mysql_query("SELECT id, modcomment, last_access FROM users WHERE last_access < $dt AND enabled='yes' AND donor='no'") or sqlerr(__FILE__, __LINE__);
    if (mysql_num_rows($res) > 0) {
        while ($arr = mysql_fetch_assoc($res)) {
            $modcomment = sqlesc(get_date( time(), 'DATE', 1 ) . " - Auto-disabled for inactivity By System\n");
            $users_buffer[] = '(' . $arr['id'] . ', \'no\', ' . $modcomment . ')';
        }
        if (sizeof($users_buffer) > 0) {
            @mysql_query("INSERT INTO users (id, enabled, modcomment) VALUES " . implode(', ', $users_buffer) . " ON DUPLICATE key UPDATE enabled=values(enabled),
            modcomment=concat(values(modcomment),modcomment)") or sqlerr(__FILE__, __LINE__);
            $count = mysql_affected_rows();
            write_log("Cleanup:  Disabled " . $count . " Member(s) for inactivity");
        }
        unset ($users_buffer);
    }
    //==End