46 $userFactory = $services->getUserFactory();
47 $userGroupManager = $services->getUserGroupManager();
48 $this->
output(
"Remove unused accounts\n\n" );
50 # Do an initial scan for inactive accounts and report the result
51 $this->
output(
"Checking for unused user accounts...\n" );
55 $res = $dbr->newSelectQueryBuilder()
56 ->select( [
'user_id',
'user_name',
'user_touched',
'actor_id' ] )
58 ->leftJoin(
'actor',
null,
'user_id = actor_user' )
59 ->caller( __METHOD__ )->fetchResultSet();
60 if ( $this->
hasOption(
'ignore-groups' ) ) {
61 $excludedGroups = explode(
',', $this->
getOption(
'ignore-groups' ) );
65 $touched = $this->
getOption(
'ignore-touched',
"1" );
66 if ( !ctype_digit( $touched ) ) {
67 $this->
fatalError(
"Please put a valid positive integer on the --ignore-touched parameter." );
69 $touchedSeconds = 86400 * $touched;
70 foreach ( $res as $row ) {
71 # Check the account, but ignore it if it's within a $excludedGroups
72 # group or if it's touched within the $touchedSeconds seconds.
73 $instance = $userFactory->newFromId( $row->user_id );
75 array_intersect( $userGroupManager->getUserEffectiveGroups( $instance ), $excludedGroups ) ) == 0
76 && $this->isInactiveAccount( $instance, $row->actor_id ??
null,
true )
80 # Inactive; print out the name and flag it
81 $delUser[] = $row->user_id;
82 if ( isset( $row->actor_id ) && $row->actor_id ) {
83 $delActor[] = $row->actor_id;
85 $this->
output( $row->user_name .
"\n" );
88 $count = count( $delUser );
89 $this->
output(
"...found {$count}.\n" );
91 # If required, go back and delete each marked account
92 if ( $count > 0 && $this->
hasOption(
'delete' ) ) {
93 $this->
output(
"\nDeleting unused accounts..." );
95 $dbw->newDeleteQueryBuilder()
96 ->deleteFrom(
'user' )
97 ->where( [
'user_id' => $delUser ] )
98 ->caller( __METHOD__ )->execute();
99 # Keep actor rows referenced from ipblocks
101 ->get( MainConfigNames::BlockTargetMigrationStage );
103 $keep = $dbw->newSelectQueryBuilder()
104 ->select(
'ipb_by_actor' )
106 ->where( [
'ipb_by_actor' => $delActor ] )
107 ->caller( __METHOD__ )->fetchFieldValues();
109 $keep = $dbw->newSelectQueryBuilder()
110 ->select(
'bl_by_actor' )
112 ->where( [
'bl_by_actor' => $delActor ] )
113 ->caller( __METHOD__ )->fetchFieldValues();
115 $del = array_diff( $delActor, $keep );
117 $dbw->newDeleteQueryBuilder()
118 ->deleteFrom(
'actor' )
119 ->where( [
'actor_id' => $del ] )
120 ->caller( __METHOD__ )->execute();
123 $dbw->newUpdateQueryBuilder()
125 ->set( [
'actor_user' =>
null ] )
126 ->where( [
'actor_id' => $keep ] )
127 ->caller( __METHOD__ )
130 $dbw->newDeleteQueryBuilder()
131 ->deleteFrom(
'user_groups' )
132 ->where( [
'ug_user' => $delUser ] )
133 ->caller( __METHOD__ )->execute();
134 $dbw->newDeleteQueryBuilder()
135 ->deleteFrom(
'user_former_groups' )
136 ->where( [
'ufg_user' => $delUser ] )
137 ->caller( __METHOD__ )->execute();
138 $dbw->newDeleteQueryBuilder()
139 ->deleteFrom(
'user_properties' )
140 ->where( [
'up_user' => $delUser ] )
141 ->caller( __METHOD__ )->execute();
142 $dbw->newDeleteQueryBuilder()
143 ->deleteFrom(
'logging' )
144 ->where( [
'log_actor' => $delActor ] )
145 ->caller( __METHOD__ )->execute();
146 $dbw->newDeleteQueryBuilder()
147 ->deleteFrom(
'recentchanges' )
148 ->where( [
'rc_actor' => $delActor ] )
149 ->caller( __METHOD__ )->execute();
150 $this->
output(
"done.\n" );
151 # Update the site_stats.ss_users field
152 $users = $dbw->newSelectQueryBuilder()
153 ->select(
'COUNT(*)' )
155 ->caller( __METHOD__ )->fetchField();
156 $dbw->newUpdateQueryBuilder()
157 ->update(
'site_stats' )
158 ->set( [
'ss_users' => $users ] )
159 ->where( [
'ss_row_id' => 1 ] )
160 ->caller( __METHOD__ )
162 } elseif ( $count > 0 ) {
163 $this->
output(
"\nRun the script again with --delete to remove them from the database.\n" );