48 $userFactory = $services->getUserFactory();
49 $userGroupManager = $services->getUserGroupManager();
50 $this->
output(
"Remove unused accounts\n\n" );
52 # Do an initial scan for inactive accounts and report the result
53 $this->
output(
"Checking for unused user accounts...\n" );
57 $res = $dbr->newSelectQueryBuilder()
58 ->select( [
'user_id',
'user_name',
'user_touched',
'actor_id' ] )
60 ->leftJoin(
'actor',
null,
'user_id = actor_user' )
61 ->caller( __METHOD__ )->fetchResultSet();
62 if ( $this->
hasOption(
'ignore-groups' ) ) {
63 $excludedGroups = explode(
',', $this->
getOption(
'ignore-groups' ) );
67 $touched = $this->
getOption(
'ignore-touched',
"1" );
68 if ( !ctype_digit( $touched ) ) {
69 $this->
fatalError(
"Please put a valid positive integer on the --ignore-touched parameter." );
71 $touchedSeconds = 86400 * $touched;
72 foreach ( $res as $row ) {
73 # Check the account, but ignore it if it's within a $excludedGroups
74 # group or if it's touched within the $touchedSeconds seconds.
75 $instance = $userFactory->newFromId( $row->user_id );
77 array_intersect( $userGroupManager->getUserEffectiveGroups( $instance ), $excludedGroups ) ) == 0
78 && $this->isInactiveAccount( $instance, $row->actor_id ??
null,
true )
82 # Inactive; print out the name and flag it
83 $delUser[] = $row->user_id;
84 if ( isset( $row->actor_id ) && $row->actor_id ) {
85 $delActor[] = $row->actor_id;
87 $this->
output( $row->user_name .
"\n" );
90 $count = count( $delUser );
91 $this->
output(
"...found {$count}.\n" );
93 # If required, go back and delete each marked account
94 if ( $count > 0 && $this->
hasOption(
'delete' ) ) {
95 $this->
output(
"\nDeleting unused accounts..." );
97 $dbw->newDeleteQueryBuilder()
98 ->deleteFrom(
'user' )
99 ->where( [
'user_id' => $delUser ] )
100 ->caller( __METHOD__ )->execute();
101 # Keep actor rows referenced from block
102 $keep = $dbw->newSelectQueryBuilder()
103 ->select(
'bl_by_actor' )
105 ->where( [
'bl_by_actor' => $delActor ] )
106 ->caller( __METHOD__ )->fetchFieldValues();
107 $del = array_diff( $delActor, $keep );
109 $dbw->newDeleteQueryBuilder()
110 ->deleteFrom(
'actor' )
111 ->where( [
'actor_id' => $del ] )
112 ->caller( __METHOD__ )->execute();
115 $dbw->newUpdateQueryBuilder()
117 ->set( [
'actor_user' =>
null ] )
118 ->where( [
'actor_id' => $keep ] )
119 ->caller( __METHOD__ )
122 $dbw->newDeleteQueryBuilder()
123 ->deleteFrom(
'user_groups' )
124 ->where( [
'ug_user' => $delUser ] )
125 ->caller( __METHOD__ )->execute();
126 $dbw->newDeleteQueryBuilder()
127 ->deleteFrom(
'user_former_groups' )
128 ->where( [
'ufg_user' => $delUser ] )
129 ->caller( __METHOD__ )->execute();
130 $dbw->newDeleteQueryBuilder()
131 ->deleteFrom(
'user_properties' )
132 ->where( [
'up_user' => $delUser ] )
133 ->caller( __METHOD__ )->execute();
134 $dbw->newDeleteQueryBuilder()
135 ->deleteFrom(
'logging' )
136 ->where( [
'log_actor' => $delActor ] )
137 ->caller( __METHOD__ )->execute();
138 $dbw->newDeleteQueryBuilder()
139 ->deleteFrom(
'recentchanges' )
140 ->where( [
'rc_actor' => $delActor ] )
141 ->caller( __METHOD__ )->execute();
142 $this->
output(
"done.\n" );
143 # Update the site_stats.ss_users field
144 $users = $dbw->newSelectQueryBuilder()
145 ->select(
'COUNT(*)' )
147 ->caller( __METHOD__ )->fetchField();
148 $dbw->newUpdateQueryBuilder()
149 ->update(
'site_stats' )
150 ->set( [
'ss_users' => $users ] )
151 ->where( [
'ss_row_id' => 1 ] )
152 ->caller( __METHOD__ )
154 } elseif ( $count > 0 ) {
155 $this->
output(
"\nRun the script again with --delete to remove them from the database.\n" );