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