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