public function execute() { global $wgUser, $wgExternalSharedDB; // Currently, inverted searches (using a column other than up_user) may not // be supported for preferences in the future. However this feature may be // supported for user "flags" if we need to do reverse lookups like these. // See https://wikia-inc.atlassian.net/browse/SERVICES-469. // --drsnyder echo "*******************************************************"; echo "Warning, inverted searches on 'user_properties' may be deprecated soon. Contact the services team."; echo "*******************************************************"; $closeAccountHelper = new CloseMyAccountHelper(); $dbr = wfGetDB(DB_SLAVE, [], $wgExternalSharedDB); // Only get users who self-requested account closure $subQuery = $dbr->selectSQLText('user_properties', ['up_user'], ['up_property' => 'requested-closure-date'], __METHOD__); $res = $dbr->select('user_properties', ['up_user'], ['up_property' => 'requested-closure', 'up_value' => 1, 'up_user IN (' . $subQuery . ')'], __METHOD__); $usersClosed = []; $closeReason = 'User requested account closure more than 30 days ago'; $wgUser = User::newFromName('Wikia'); foreach ($res as $row) { $userObj = User::newFromId($row->up_user); $daysRemaining = $closeAccountHelper->getDaysUntilClosure($userObj); if ($daysRemaining === 0) { $this->output("Closing account {$userObj->getName()}...\n"); $statusMsg1 = ''; $statusMsg2 = ''; $result = EditAccount::closeAccount($userObj, $closeReason, $statusMsg1, $statusMsg2, true); // Set an option that signifies this user was closed automatically $userObj->setGlobalFlag('disabled-by-user-request', true); // Cleanup $userObj->setGlobalFlag('requested-closure', null); $userObj->setGlobalAttribute('requested-closure-date', null); $userObj->saveSettings(); $closeAccountHelper->track($userObj, 'account-closed'); $usersClosed[] = $userObj->getName(); } } $this->output(count($usersClosed) . " user accounts closed.\n"); }