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");
}
